'' denotes a blank string. A row is probably being inserted just without data which means that the variable you are using in your sql statement is not being populated correctly.

Also make sure you are Executing the statement and not just writing the statement out to the screen.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Thanks for all the help, I do appreciate it!

You are welcome.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hi,

I don’t have patience to go through all the postings done here. But dude the answer is very single. The word user is a keyword so you need to put that with in square brackets.

Insert into [user] (column1, column2, …) values(value1, value2, …)


Ragards,
Akash - The Sky

Hii

I have not gone through the complete post, but just check out if the table name user exists. i guess 'user' is a predefined word in SQL. So try creating your tablename with user1. i tried to create a table with similar name and it gave me error saying 'invalid tablename'. Is your this insert stmt trying to insert into the predefined user table?

Thanks & Regards,
SM

Mr Parsons - you are a very patient man... This post in particular has a most interesting end to it.

Wind is your friend
Matt

LOL why, exactly, was this post resurrected? This problem has long been resolved! And thank you Matt ^^

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hi
I guess this is just because 'User' is a keyword!!!

Hi
i guess this is just because u r using 'User' which is a keyword...

Its the ghost post...lol..

now its entertained me twice on two different days - until next time...

Wind is your friend
Matt