|
|
 |
| Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0 |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Basics section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
|
April 17th, 2007, 11:35 AM
|
|
Wrox Author
Points: 12,827, Level: 49 |
|
|
Join Date: Oct 2005
Location: Akron, Ohio, USA.
Posts: 4,029
Thanks: 1
Thanked 42 Times in 42 Posts
|
|
'' 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
================================================== ========= |
April 17th, 2007, 12:25 PM
|
|
Authorized User
|
|
Join Date: Jun 2006
Location: Colorado Springs, CO
Posts: 36
Thanks: 1
Thanked 0 Times in 0 Posts
|
|
Thanks for all the help, I do appreciate it!
|
April 17th, 2007, 12:28 PM
|
|
Wrox Author
Points: 12,827, Level: 49 |
|
|
Join Date: Oct 2005
Location: Akron, Ohio, USA.
Posts: 4,029
Thanks: 1
Thanked 42 Times in 42 Posts
|
|
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
================================================== ========= |
May 5th, 2007, 06:52 AM
|
|
Authorized User
|
|
Join Date: May 2007
Location: Bangalore, Karnataka, India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
May 16th, 2007, 05:09 AM
|
|
Authorized User
|
|
Join Date: Jan 2006
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
May 16th, 2007, 08:00 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,666
Thanks: 6
Thanked 9 Times in 9 Posts
|
|
Mr Parsons - you are a very patient man... This post in particular has a most interesting end to it.
Wind is your friend
Matt
|
May 16th, 2007, 09:22 PM
|
|
Wrox Author
Points: 12,827, Level: 49 |
|
|
Join Date: Oct 2005
Location: Akron, Ohio, USA.
Posts: 4,029
Thanks: 1
Thanked 42 Times in 42 Posts
|
|
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
================================================== ========= |
June 20th, 2007, 02:31 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi
I guess this is just because 'User' is a keyword!!!
|
June 20th, 2007, 02:34 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi
i guess this is just because u r using 'User' which is a keyword...
|
June 20th, 2007, 07:50 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,666
Thanks: 6
Thanked 9 Times in 9 Posts
|
|
Its the ghost post...lol..
now its entertained me twice on two different days - until next time...
Wind is your friend
Matt
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
