 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. 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 Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
December 10th, 2004, 05:17 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
|
|
You could also get the query to work by surrounding reserved word table names with square brackets e.g. [User]
HTH,
Chris
|
|
December 10th, 2004, 08:26 AM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Sorry guys for troubling you alll..
I Still go on with same error eventhough i have changed my table name to "UserTabble" the error i get is the same "Syntax error in INSERT INTO statement..
isql=Insert Into ......
but the line number it is pointing to contains
Conn.Execute isql
so guys plz help me i could'nt move further b'cos of this problem
bye for now..
MuthuKumar.AL
|
|
December 10th, 2004, 08:30 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Can you Response.Write isql before executing it & post that please.
Thanks,
Chris
|
|
December 11th, 2004, 01:50 AM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
according to your querry i had posted my Response.write(isql) below
INSERT INTO UserTabble(User_Name,MonthOfBirth,DayOfBith,YearOf Birth,Address,City,State,Pincode,************,Exp\Fre\Final yr,Yr Of Exp,Walk-In,Telephone,eMail,Details/ClarificationsAskedFor,Person Contacted,IsDoubtsClarified)values('fdgf','decembe r','20','2000','gfdsgrd','rtet','rtfe', '234', 'Male', '', '2 Years','','','',' hgrhghgujhjkh','fjfghfhjg','Complete')
'Your Form Has Been Inserted Into Database
but here certain terms does'nt contain values but just " say me the reason and the solution plz..
bye for now
MuthuKumar.AL
|
|
December 11th, 2004, 02:41 AM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
sorry guys again and again to disturb ...
i have got every values in response.Write And none with "
as i posted in my previous thing with response.Write(isql)
every values has been coming but showing the same error "Syntax error in Insert Into statement and the line number pointing to contains Conn.Execute isql
plz nothing strikes me if strikes for you then plz ,,,
bye for now
MuthuKumar.AL
|
|
December 11th, 2004, 07:28 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Could be the (back)slashes and/or the fieldnames containing spaces - try renaming the fields:
Exp\Fre\Finalyr
Details/ClarificationsAskedFor
Yr Of Exp
Person Contacted
|
|
December 11th, 2004, 08:21 AM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
i tried out with that optin too and my error found to retain....
wat next?
help me...
bye for now
MuthuKumar.AL
|
|
December 13th, 2004, 11:27 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Hi Muthukumar,
Can you post your changed query and the error that you see exactly here.
_________________________
- Vijay G
Strive for Perfection
|
|
December 14th, 2004, 01:38 AM
|
|
Friend of Wrox
|
|
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
|
|
In your insert query try giving field name in brackets where slash is used in the field name.
example:
[Exp\Fre\Finalyr] instead of Exp\Fre\Finalyr
Om Prakash
|
|
December 16th, 2004, 03:54 AM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi guys ! My Data Got Inserted..It is Inserted only when I remove the field Student_id In My Access database Which I have Declared As AutoNumber.
if in Access A field Declared As Autonumber then we can't insert Leaving that Field .
After removing the Autonumber field my data has been inserted.
Thanx For your Help guys..
Bye For Now.
MuthuKumar.AL
|
|
|
