|
|
 |
| 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 Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
|
 |
|
|
 |
|
April 17th, 2007, 10:35 AM
|
|
Wrox Author
Points: 13,255, Level: 49 |
|
|
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 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, 11:25 AM
|
|
Authorized User
|
|
Join Date: Jun 2006
Location: Colorado Springs, CO
Posts: 60
Thanks: 1
Thanked 0 Times in 0 Posts
|
|
Thanks for all the help, I do appreciate it!
|
April 17th, 2007, 11:28 AM
|
|
Wrox Author
Points: 13,255, Level: 49 |
|
|
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 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, 05: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, 04: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, 07:00 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 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, 08:22 PM
|
|
Wrox Author
Points: 13,255, Level: 49 |
|
|
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 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, 01: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, 01: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, 06:50 PM
|
|
Friend of Wrox
|
|
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 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
|
|
|
|
|
