| Author |
 Topic  |
|
serritzlev
Junior Member
Denmark
291 Posts |
 Posted - 12 June 2003 : 13:33:59
|
What is wrong whit this mod from huwr 3.4 in this code here.
select case crdType
case "image"
my_conn.execute ("INSERT INTO " & strTablePrefix & "CARD_CARDS (CATID, IMAGE, TOTALCARDSSENT, VALIDATED) VALUES ( " & CatID & ", '" & request.form("ImageURL") & "',0,0) ")
The fault is this.
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/test/forum/postcard_addcard.asp, line 15
Or i can add greetings but not cards. |
|
|
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 12 June 2003 : 14:15:01
|
try putting the statement into a variable first then displaying it.
strSql = "INSERT INTO " & strTablePrefix & "CARD_CARDS (CATID, IMAGE, TOTALCARDSSENT, VALIDATED) VALUES ( " & CatID & ", '" & request.form("ImageURL") & "',0,0) "
response.write strSql
|
The Internet ClubHouse
www.internet-clubhouse.com
|
 |
|
|
serritzlev
Junior Member
Denmark
291 Posts |
Posted - 12 June 2003 : 15:37:51
|
If i set your statement into a variable first then displaying.
INSERT INTO FORUM_CARD_CARDS (CARDID, CATID, IMAGE, TOTALCARDSSENT, VALIDATED) VALUES (2,'i51.gif',0,0) |
|
|
|
|
savva
Starting Member
Australia
18 Posts |
Posted - 12 June 2003 : 18:45:49
|
It will work if you change the Field name "IMAGE" to something else, say "Display_Image" and then change all the references to that field to match.
GL |
savva.com.au - photoshop tutorials |
|
|
|
serritzlev
Junior Member
Denmark
291 Posts |
Posted - 12 June 2003 : 20:24:09
|
Thanks savva now is there that big quest to this how to validate card, if i click on it in bootom there is this text
Validate Photo?
Yes or No
but yes or no is not active ? |
|
|
|
|
savva
Starting Member
Australia
18 Posts |
Posted - 13 June 2003 : 01:40:28
|
| This will sound obvious but did you check the validation code, and replace the field name references with the new field name? |
savva.com.au - photoshop tutorials |
Edited by - savva on 13 June 2003 01:41:09 |
|
|
|
serritzlev
Junior Member
Denmark
291 Posts |
Posted - 13 June 2003 : 06:05:39
|
| sory i can find validation code in it?. |
|
|
|
|
savva
Starting Member
Australia
18 Posts |
|
|
serritzlev
Junior Member
Denmark
291 Posts |
Posted - 13 June 2003 : 14:39:12
|
| Ok i wait to sen what you have to done or start to make an new design to header and footer. |
|
|
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 09 July 2003 : 21:39:43
|
"say "Display_Image" and then change all the references to that field to match"
Where? |
|
|
|
serritzlev
Junior Member
Denmark
291 Posts |
Posted - 10 July 2003 : 03:46:43
|
| I have try to chang all to Display_image or to Pcard i can make card or send card but i can pick it up there is coming white this fault there mish something in db feild M_VALUE |
|
|
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 10 July 2003 : 09:36:46
|
| hmmmmmmmmmmmmmmmmmmmmm |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 July 2003 : 10:39:07
|
quote:
If i set your statement into a variable first then displaying.
INSERT INTO FORUM_CARD_CARDS (CARDID, CATID, IMAGE, TOTALCARDSSENT, VALIDATED) VALUES (2,'i51.gif',0,0)
There are not enough values being passed in this query, the insert is expecting 5 fields, yet the (2,'i51.gif',0,0) only has 4, I'm pretty sure that (CARDID, CATID, IMAGE, TOTALCARDSSENT, VALIDATED) should only be (CATID, IMAGE, TOTALCARDSSENT, VALIDATED) as CARDID should be autogenerated. |
|
|
|
serritzlev
Junior Member
Denmark
291 Posts |
Posted - 10 July 2003 : 11:42:19
|
| Thanks huwr i try to nigth again. Yes the cardide is auto generate i am comming so long i can create an card or send this from my hotel but not pick it up they have some mising in my tabel to that. Or write to you later what fault there is comming. |
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 July 2003 : 11:49:44
|
I need to know the exact error, without out I can not help
and just to make it clear, I did NOT write this mod. |
|
|
|
serritzlev
Junior Member
Denmark
291 Posts |
Posted - 10 July 2003 : 15:00:28
|
| Hi hurw can you make that file there uses to postcard or the dbs script to an zip file or post that to me [email removed by admin] I have try this mod on your page http://www.magicmushroom.org.uk/forum/portal_content.asp that works great or i ben hapy. |
|
|
|
|
Topic |
|
Topic Locked
