big_wasa
|
| posted on 22/6/05 at 10:43 PM |
|
|
Error message in my photo archive???
I tried to load a new folder into my archive,It loaded the heading but it wont let me delete it or put photo's in it and shows this error
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near
's' ' at line 1
So I tried to create a new folder and it has done the same?????????????????????????????????????????????????????????????/
What the hell can I do about it???????????????????????????
I can still use my archive for the photos init...................................
|
|
|
|
|
nicksertis
|
| posted on 23/6/05 at 08:35 AM |
|
|
I think its because the site isn't liking the quote you put in. Folders and photos won't work if you have a ' or a " or any
other non letter/number characters. try again but make sure you only use letters and numbers in the filenames and foldernames.
one for ChrisW: Is it possible to pass all user input through a function that will quote the metacharacters before going into the SQL statements? I
have the one we use at work (in asp) if you want it for reference?
Nick
|
|
|
big_wasa
|
| posted on 23/6/05 at 09:01 PM |
|
|
Ok that makes some sense as ive had that problem at work..Now I just want to delete that folder,but dont know how???????????????????????????//
|
|
|
nicksertis
|
| posted on 24/6/05 at 10:19 AM |
|
|
Don't think you'll be able to, as it will fail the same way when the page tries to delete something with a quote in it.
Maybe u2u ChrisW to ask if he will do it for you?
Nick
|
|
|
