|
Time:    US$10 per year - Save $100s!
The Fabulously Unfair WebX Auction Bar. For Ebay etc. Ro-Sham-Bo the opposition. Laugh like Eric Cartman when you win! CLICK HERE NOW! More information and sign-up. WebXpertz Hosting.
Custom fit from $5pm. PHP/MySQL You'll save money, we'll save money. Seems fair to me. Interested? If so Please PM me here and tell me what you need. Thanks! 
|
For continued disscussion on this topic : help with syntax error in insert statement AngelaFrench 04-26-2004, 10:53 PM Can anyone see anything wrong with this insert statement? I keep getting syntax error message. SQLstr = "INSERT INTO tblQuestions(Question,AreaID) VALUES('" & question & "'," & areaID & ")" I am using an Access database and an .asp page Thanks. fivesidecube 04-27-2004, 10:18 AM If you write the SQL statement to your web page, instead of trying to execute it, what does the statement produce? Does the statement look as you expect? If can appears as expected, can you describe the types of the Question and AreaID fields in the database and also post the created SQL statement. AngelaFrench 04-27-2004, 06:26 PM thank you for making me use my head! No, it did not look as expected. the areaID was not coming through as expected. All better now. Thanks. vBulletin® v3.6.4, Copyright ©2000-2009, Jelsoft Enterprises Ltd.
|