check my sql insert into statement

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

check my sql insert into statement

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> check my sql insert into statement

Page: [1]


washurjosh Posts: 66 Joined: 1/18/2006 Status: offline	check my sql insert into statement - 6/1/2006 2:32:26 INSERT INTO Results (first, last, email, Sex, Eye, height, website, age, vocal, accent, password, resbig, ressmall, headbig, headsmall, thedate) VALUES ('::first::', '::last::', '::email::', '::Sex::', '::Eye::', '::height::', '::website::', '::age::', '::vocal::', '::accent::', '::password::', '::resbig::', '::ressmall::', '::headbig::', '::headsmall::', '::thedate::') i dont get why i keep getting an error. It was working until 3 or 4 days ago and i dont understand whats wrong, the drw doesnt even accept it anymore. I dont know what is wrong!!! Please help. THANKS


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: online	RE: check my sql insert into statement - 6/1/2006 4:09:58 You have to be careful with your choice of words - some are reserved and cannot be used without [] http://www.aspfaq.com/show.asp?id=2080 eg : INSERT INTO Results ([first], [last],....etc _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to washurjosh)


washurjosh Posts: 66 Joined: 1/18/2006 Status: offline	RE: check my sql insert into statement - 6/1/2006 4:20:05 Sorry i used to have brackets on some of them, i just uploaded the sql i was testing.... here is what i have found after checking all of them against your sql reserved word list. INSERT INTO Results ([first], [last], email, Sex, Eye, height, [website], age, vocal, accent, [password], resbig, ressmall, headbig, headsmall, [thedate]) VALUES ('::first::', '::last::', '::email::', '::Sex::', '::Eye::', '::height::', '::website::', '::age::', '::vocal::', '::accent::', '::password::', '::resbig::', '::ressmall::', '::headbig::', '::headsmall::', '::thedate::') still not working, the drw wont let me go on :( (in reply to Spooky)


washurjosh Posts: 66 Joined: 1/18/2006 Status: offline	RE: check my sql insert into statement - 6/1/2006 4:20:39 i did just update my server to asp.net 2.0 would that have something to do with it? (in reply to washurjosh)


washurjosh Posts: 66 Joined: 1/18/2006 Status: offline	RE: check my sql insert into statement - 6/1/2006 5:20:17 You know, we should just crack down on the bigger problem. The problem above was an issue i was having with a "fix" i was trying to create for a bigger problem. Ok, so the bigger problem is i have this form for people to fill out and submit, this sends to an asp page which does three things 1) uses a drw to insert their email address to my email address database 2) create an ado object to filesystemobject to create a folder using their first and last name. 3)uses a drw to insert their information to my main database which hold the majority of the forms fields. they are on my page in that order, now this has been working for what seems like months before it stopped, and my errors i am getting are strange, i suspect something has changed about my sites permissions... anyways i have attached the picture of the result when you press submit on my form. i cannot figure it out, i am using xp home and have recently upgraded my server's packadge to asp.net 2.0 and also i am using microsofts beta 2 version of access 2007. i just dont knwo what is going on. and this is not the only form/database issue i am having on my site. can anyone help a poor guy out? Thumbnail Image Attachment (1) (in reply to washurjosh)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: online	RE: check my sql insert into statement - 6/1/2006 5:42:40 I would suggest #2 is the problem. You may have changed the permissions for that file / folder. Remove that part of the code (for FSO) and try again? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to washurjosh)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: check my sql insert into statement - 6/1/2006 9:13:47 quote: i am using xp home Not for the server are you? Spooky, I know it's dangerous but I think I have to disagree. To me it looks like a permissions issue on the fpdb folder or whatever folder the db file is in. You need both read and write permissions. Unfortunately, I see those far too often. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to Spooky)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: online	RE: check my sql insert into statement - 6/1/2006 14:24:09 Im thinking both a problem with permissions for the DB and folder - its not often you get both of those errors generated. The first one yes, but that would be dispayed using ON ERROR RESUME NEXT and allows you to trouble shoot the second. The second is script related and final. As it was working 3-4 days ago, I assume a server update has taken out the permissions on one or more folders _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: check my sql insert into statement - 6/1/2006 15:01:05 quote: its not often you get both of those errors generated. Ah. Completely understand now. You are correct of course. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to Spooky)


washurjosh Posts: 66 Joined: 1/18/2006 Status: offline	RE: check my sql insert into statement - 6/2/2006 1:52:49 Ok, so i opened the web "http://www.mywebsite.com" and went to Tools>Server>Permissions is this where i change the permission? < Message edited by washurjosh -- 6/2/2006 1:58:31 > (in reply to rdouglass)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: online	RE: check my sql insert into statement - 6/2/2006 4:10:44 No - usually youll do that directly from Windows explorer. Make sure the anonymous IUSR account has w/r access _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to washurjosh)


washurjosh Posts: 66 Joined: 1/18/2006 Status: offline	RE: check my sql insert into statement - 6/2/2006 5:37:17 i fixed the problem. My folders changed their permissions i guess when i upgraded to the different web service. (im using godaddy, urgg) But when i opened my live server from frontpage and then right clicked on the folders i needed to have write permissions and checked the box "allow anonymous upload to this directory" this gives it write permissions. it worked like a charm...well like a really bad, difficult to understand, charm. :) thanks for all your help guys! (in reply to Spooky)