Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Postcard mod
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

serritzlev
Junior Member

Denmark
291 Posts

Posted - 12 June 2003 :  13:33:59  Show Profile  Visit serritzlev's Homepage
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  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message
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
Go to Top of Page

serritzlev
Junior Member

Denmark
291 Posts

Posted - 12 June 2003 :  15:37:51  Show Profile  Visit serritzlev's Homepage
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)

Go to Top of Page

savva
Starting Member

Australia
18 Posts

Posted - 12 June 2003 :  18:45:49  Show Profile  Visit savva's Homepage
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
Go to Top of Page

serritzlev
Junior Member

Denmark
291 Posts

Posted - 12 June 2003 :  20:24:09  Show Profile  Visit serritzlev's Homepage
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 ?

Go to Top of Page

savva
Starting Member

Australia
18 Posts

Posted - 13 June 2003 :  01:40:28  Show Profile  Visit savva's Homepage
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
Go to Top of Page

serritzlev
Junior Member

Denmark
291 Posts

Posted - 13 June 2003 :  06:05:39  Show Profile  Visit serritzlev's Homepage
sory i can find validation code in it?.

Go to Top of Page

savva
Starting Member

Australia
18 Posts

Posted - 13 June 2003 :  07:15:02  Show Profile  Visit savva's Homepage
Ok, Ill look into it this weekend when I've got a bit of xtra time...

savva.com.au - photoshop tutorials
Go to Top of Page

serritzlev
Junior Member

Denmark
291 Posts

Posted - 13 June 2003 :  14:39:12  Show Profile  Visit serritzlev's Homepage
Ok i wait to sen what you have to done or start to make an new design to header and footer.

Go to Top of Page

golfmann
Junior Member

United States
450 Posts

Posted - 09 July 2003 :  21:39:43  Show Profile  Visit golfmann's Homepage
"say "Display_Image" and then change all the references to that field to match"
Where?
Go to Top of Page

serritzlev
Junior Member

Denmark
291 Posts

Posted - 10 July 2003 :  03:46:43  Show Profile  Visit serritzlev's Homepage
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

Go to Top of Page

golfmann
Junior Member

United States
450 Posts

Posted - 10 July 2003 :  09:36:46  Show Profile  Visit golfmann's Homepage
hmmmmmmmmmmmmmmmmmmmmm
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 10 July 2003 :  10:39:07  Show Profile  Visit HuwR's Homepage
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.
Go to Top of Page

serritzlev
Junior Member

Denmark
291 Posts

Posted - 10 July 2003 :  11:42:19  Show Profile  Visit serritzlev's Homepage
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.

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 10 July 2003 :  11:49:44  Show Profile  Visit HuwR's Homepage
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.
Go to Top of Page

serritzlev
Junior Member

Denmark
291 Posts

Posted - 10 July 2003 :  15:00:28  Show Profile  Visit serritzlev's Homepage
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.

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07