oop's... i can see that i have not asked my question correctly. ((((  Ideally you shouldn't put more than one value in a field ))))) i need to insert many...

i need to insert a new user.....and then insert all of the areas that this user specialezes in...... so that is my userspecialty table and this is the one to...

ok i am lost here... what exactly is it that i should do?

thanks!

someone just pointed that out to me...

thanks alot for the help!

erik

ha ha....

Thanks.!! this well help out alot!!

pappy,,,,, jj

really,,, thanks...

I do not want to break the o'll arm... but a little demo.... would be a great thing...

?

erik

Maybe this needs to be a select... like select orders.orders as orderid=100.. i am not sure i have never done one like this

oops.

i would like to send data back to the client regardsless if the client has a order in the database.

I have a complex set of nested datagrids and datlist that...

Thank you for the reply. This is a classic case of no Data in the fields and so no records were being returned.

This has happened to me about ten times,...

no syntax error... just no rows back.

erik

That was a misstype.. It is Where Users.UserID = @user-id

This is not the actual data that i will use to pass to the columns in the where clause. I will be using @Userid

Parameters.

i have tried that and it does...

o ok... thank you very much!!

I will add this now..

thanks!