Author |
Topic |
texanman
Junior Member
United States
410 Posts |
Posted - 16 July 2008 : 16:29:17
|
I am using the same files and it is showing what cards to delete.< |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 16 July 2008 : 16:34:27
|
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 |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 16 July 2008 : 17:05:21
|
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.< |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 18 July 2008 : 06:46:30
|
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 |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 18 July 2008 : 07:45:01
|
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 |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 18 July 2008 : 08:03:20
|
I updated greeting_cards_cat.asp
< |
Cheers, David Greening |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 18 July 2008 : 09:28:45
|
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.< |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 18 July 2008 : 09:33:59
|
Interesting note: if the number of categories is divisible by 3, the error disappears again.< |
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 18 July 2008 : 10:45:31
|
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< |
|
|
Maxime
Average Member
France
521 Posts |
Posted - 18 July 2008 : 11:35:14
|
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)
|
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 18 July 2008 : 12:15:57
|
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 |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 18 July 2008 : 12:32:29
|
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 < |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 18 July 2008 : 15:50:17
|
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 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 18 July 2008 : 15:57:06
|
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.< |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 18 July 2008 : 16:04:52
|
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 |
|
|
Topic |
|