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/Code)
 Greeting Card Mod 3.6 (RC1)
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 6

texanman
Junior Member

United States
410 Posts

Posted - 16 July 2008 :  16:29:17  Show Profile  Reply with Quote
I am using the same files and it is showing what cards to delete.<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 16 July 2008 :  16:34:27  Show Profile  Reply with Quote
Apologies, mine works now, Thank you Dave,(and Tex) I had a spelling mistake ooops..<

Edited by - Andy Humm on 16 July 2008 16:40:40
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 16 July 2008 :  17:05:21  Show Profile  Reply with Quote
Something you might want to consider:
1. If a message is added to the greeting card which is more than 255 charactors, you will receive the following error:

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/forum/greeting_cards_send.asp, line 106


To fix this you need to amend the database properties.
Table: FORUM_GREETING_SENT
Field: MESSAGE
Properties change data type from text to memo

2. When you are compiling a message and whenready select preview, if you go back to edit the greeting, then do not reselect an image for use, you will receive the following error:

Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'ID='.
/forum/greeting_cards_preview.asp, line 115


Could there be a solution to keep the selected picture on the radio box in 'session' so that you don't have to reselect an image again, all the added text in the other fields remain.<
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 18 July 2008 :  06:46:30  Show Profile  Reply with Quote
I have fixed the dbs file to have a memo field, so that should be right now.

I have put a "checked" to select the image as a quick fix, but if you are going back, you are obviously fixing something and most users will look to make sure that the right image is selected.

It is all updated in the original download for 3.6 RC1.<

Cheers,

David Greening
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 18 July 2008 :  07:45:01  Show Profile  Reply with Quote
Thank you David, which file did you amend for "I have put a "checked" to select the image as a quick fix"
Rgds Andy<

Edited by - Andy Humm on 18 July 2008 07:47:45
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 18 July 2008 :  08:03:20  Show Profile  Reply with Quote
I updated greeting_cards_cat.asp

<

Cheers,

David Greening
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 18 July 2008 :  09:28:45  Show Profile  Reply with Quote
I get 3 columns when the default categories are listed; however, when I add a few categories, I get an 80020009 error at line 84 (which is obviously an error itself).

I re-ran the dbs file (recreating the default categories), looks fine. Added categories and the error was back.<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 18 July 2008 :  09:33:59  Show Profile  Reply with Quote
Interesting note: if the number of categories is divisible by 3, the error disappears again.<
Go to Top of Page

texanman
Junior Member

United States
410 Posts

Posted - 18 July 2008 :  10:45:31  Show Profile  Reply with Quote
Carefree
Where do you get the error? I mean at what page?
I have 13 categories and no error. I have the original files. I did not make the new updates
Thanks<
Go to Top of Page

Maxime
Average Member

France
521 Posts

Posted - 18 July 2008 :  11:35:14  Show Profile  Visit Maxime's Homepage  Reply with Quote
Page greeting_cards_clean.asp to line 86-92

strSQL = "DELETE FROM " & strTablePrefix & "GREETING_SENT WHERE SENTDATE< '" & rev & "'"
set rs = conn.execute (strsql)
if rs.EOF or rs.BOF then ' Not Found
Response.Write "Deleted"
end if
rs.Close
set rs = Nothing

Here is the code error when I try to delete expired cards

Removing card sent before the deadline expiry

ADODB.Recordset error '800a0e78'

This operation is not permitted if the subject is closed.

/forum/greeting_cards_clean.asp, line 88<

Cordially,
Maxime

Taxation consists in so plucking the goose to get the most out of feathers with the least possible cries.(Jean-Baptiste Colbert)

Go to Top of Page

texanman
Junior Member

United States
410 Posts

Posted - 18 July 2008 :  12:15:57  Show Profile  Reply with Quote
If you read pages 1 and 2, you will get the answer.

Opps this looks like a new error.<

Edited by - texanman on 18 July 2008 12:17:23
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 18 July 2008 :  12:32:29  Show Profile  Reply with Quote
quote:
Originally posted by Carefree

I get 3 columns when the default categories are listed; however, when I add a few categories, I get an 80020009 error at line 84 (which is obviously an error itself).

Carefree did you get these errors post greeting_cards_cat.asp file edited by Classicmotorcycling 18 July 2008 : 08:03:20
<
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 18 July 2008 :  15:50:17  Show Profile  Reply with Quote
I do not have the issue. I have the Greeting Cards added here: http://www.vncommodore.com/forum/greeting_cards.asp

This has the extra column in there and works fine. I have tested on Access and MS SQL and the system works fine from the download.

Andy, the only thing added to greeting_cards_cat.asp was at line 95, the word "checked" for the extra columns the file updated was in greeting_cards_gte.asp so there was 3 columns of categories.<

Cheers,

David Greening
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 18 July 2008 :  15:57:06  Show Profile  Reply with Quote
The error appears in greeting_cards.asp; I first discovered it with 10 categories; deleted, rebuilt the table; gone. Added to 11 categories, checked again, error back. Added 12th, error gone again.<
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts

Posted - 18 July 2008 :  16:04:52  Show Profile  Reply with Quote
Hi Dave, Just uploaded new greeting_cards_gte.asp file and view three columns but underneath have
error '80020009'
/forum/greeting_cards_gte.asp, line 84
I have eight categories to start off with. However, if I add an additional category the error disappears and the Greeting Card Collection Centre and Top5 Category Tables show.
Also adding another category ok, but when delete these two added categories, ie go back to my original eight, then the error above reappears? and the Greeting Card Collection Centre and Top5 Category Tables do not show

Further testing if I have either 8, 11 or 14 categories ie the latest cat is in middle column, the error occurs,. I tested the initial start with by deleteing the eighth cat and the error goes. It appears to work okay if the last or latest cat does not appear in centre column????<

Edited by - Andy Humm on 18 July 2008 16:13:18
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07