| Author |
 Topic  |
|
Carefree
Advanced Member
Philippines
4222 Posts |
 Posted - 22 July 2008 : 08:56:03
|
| Oversight on my part - but with that change, your problem should go away.< |
 |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 22 July 2008 : 09:29:42
|
| It has, and I thank you...< |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 25 July 2008 : 06:35:24
|
Andy,
Was trying to reply to a post, but was gone by the time I posted the SQL for the sorting of the Categories from A to Z=
strSql= "SELECT * FROM " & strTablePrefix & "GREETING_CATEGORIES ORDER BY CATNAME ASC"
set rsgreeting = my_conn.execute (strSql)
Or from Z to A=
strSql= "SELECT * FROM " & strTablePrefix & "GREETING_CATEGORIES ORDER BY CATNAME DESC"
set rsgreeting = my_conn.execute (strSql)
Replace Lines 33 and 34 in greeting_cards_gte.asp with the above.
< |
Cheers,
David Greening |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 25 July 2008 : 06:46:25
|
Thank you David, I thank you for your response, I received a PM on my forum with the exact answer you have provided. I have been endeavouring to learn these procedures and its coming..slowly.
I have added a few tweaks to the greeting cards mod, like links in the admin section which return you back to the admin page after carry out actions, focuses on imput fields, the next thing I am working on is if you click on a thumbnail image, you get a preview of the larger image, then return back to the main page. Thank you andy< |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 25 July 2008 : 09:37:24
|
This is not a bug, but a development idea, as mentioned above, I have now constructed an additional page to preview the thumbnail image in full image size. This is nearly completed, but I am trying to introduce an additional button next to the 'Preview e-Card' so that we can go to the new page, ie greeting_card_preimage.asp.
The slightly adjusted code from greeting_cards_cat.asp I have, when you click on either button it only triggers to greeing_card_preview.asp
Is there an easy way to separate the way each button functions ie open their associated page.
" <td width=""81%"" height=""25"" colspan=""8"" align=""left"">" & vbNewLine & _
" <input type=""submit"" value=""Preview e-Card"" name=""B1"">" & vbNewLine & _
" <form method=""post"" action=""greeting_cards_preimage.asp"" name=""B2"">" & vbNewLine &_
" <input type=""submit"" value=""Preview Image"">" & vbNewLine & _
" </form>" & vbNewLine & _
" </td>" & vbNewLine & _
Something that is on the original page code, when you select 'Preview e-Card' and forget to enter some of the input details, as correctly programmed, you get an appropriate prompt reminding you of the missing info. However when you step back, the image radio selector is not selected (thats if you have changed the first option). I was wondering if we could use a session or other code, so that any pre-selected image radio selector remains selected irrespective of transversing back and forward from the preview. If the radio image selector is not made, and you later send the card you get this error message:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'ID='.
/forum/greeting_cards_preview.asp, line 120
Thank you andy< |
|
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 25 July 2008 : 13:03:51
|
Andy:
I am at work now and you are reminding me my wife 
She likes every inch of the house to be spotless!
Don't get me wrong, I like what you do just slow down a bit. < |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 25 July 2008 : 18:12:20
|
Andy, updated the main download (Greeting_Cards_Mod_3.6.zip) to have the popup with a link. The form button does not want to work between another form. Only 1 file to change: greeting_cards_cat.asp
I have included a new file: pop_greeting_cards.asp
Texanman, *LOL*< |
Cheers,
David Greening |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 25 July 2008 : 18:42:42
|
Many thanks David as always, downloaded and will try it in morning, getting late (UK time)..
andy< |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 26 July 2008 : 03:46:50
|
David, many thanks for the new file, initially I had a few quirks, when selecting a category group I get the following error:
Microsoft VBScript compilation error '800a0411'
Name redefined
/forum/greeting_cards_cat.asp, line 10
dim i
I commented out line 10 dim i and the link works.
Yes the facility is there to view larger images. thank you.
Nothing touched, I also checked the greetings card with no member logged in and receive the following error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forum/greeting_cards_cat.asp, line 16
line 16
set rs = my_Conn.Execute (strSql)
strSenderMail = rs("M_EMAIL")
I don't know if you have been aware previous posts of mine that I have been attempting to come away from pop-ups as much as possible, firstly it reduces on screen clutter and moreso, with pop-ups open some users and webdesign forums have commented that pop-up give you the feeling that you are moving away from the main forum/website. With this in mind, I have been trying (as much as possible) to reduce the amount of pop-ups and as mentioned earlier on this thread been developing a preview panel tied into the forum greetings card mod. If you would like to see what I have so far, which seems to work, check the bottom link in my profile.
Changes worth noting:
1. Preview Button among the thumbnail images, I have searched the net far and wide, to find a solution to allow two submit buttons within one form and managed to wangle/compose this solution:
" <br><input type=""submit"" value=""Preview Large Image"" onClick=""action='greeting_cards_preimage.asp'"">" & vbNewLine &_
2. Image names have been moved on top of picture to clearly identify the image name.
3. 'Other Categories' link back to category names
4. Check routines/prompt messages for null radio buttons and empty fields
5. New file greeting_card_preimage.asp
6. Most of the other slight changes are associated in the admin section with navigation links to return you back to greeting card admin page, focus points for input fields and message alignments to centre.
Please feel free to browse my version, if your happy I can forward the new files across.
Thanking you for your patience and support
Andy
Change of Subject:
I like tex's comments lol, 'house to be spotless' your wife's maticulous approach, much be rubbing off across the pond onto to me, not house work mind, but the way I keep trimming and dusting the product. I must admit, I have always strived to get a website that our faithful 'dinosaurs' can use easily. I did work part time, years ago for a website evaluation company and the ideas they passed on must still be fresh in my mind. Apologies to all if it seems picky, but overall I think its worth it. Thanks all
< |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 26 July 2008 : 04:54:30
|
Andy, the only issue I have, is that you have altered the greeting card mod as I noticed that at one stage you had the 3 tables at Lyneham Village all joined with no gap between them, and the pages I have supplied are used at VN Commodore with no issues. No where do I redefine the "dim i" in my code, this again could be extra code left ftom altering the original code.
What I am trying to say is that I have supplied something that you have altered (and you have stated that you are not that good at asp) and I am not sure what you have altered as you have been trying to alter it to do other stuff it was not designed to do from the original concept.
The popup was put there as most people I have dealt with over the years I have been on the internet, do not like to go to a page, and then have to go back to send something just to see what it looks like. The simple way is to put in a popup and they can close it which saves them time. I know quite a few people that do not like popups, but for this type of application I beleive it is the way to go.< |
Cheers,
David Greening |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 26 July 2008 : 05:11:25
|
David, quote:
No where do I redefine the "dim i" in my code, this again could be extra code left ftom altering the original code.
this dim i is in the new greeting_card.cat.asp line 10
I assume you are using the downloadable zip files on VN Commodore because, this is where I first noticed the issue when a user is not logged in and selects a category group, you receive the following error: (it has only occurred on latest files)
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forum/greeting_cards_cat.asp, line 16
Re Quote: The popup was put there as most people I have dealt with over the years I have been on the internet, do not like to go to a page.
I must admit, I see both side of the coin, and the reason I have taken the reduced pop-up approach, is advise from a top UK webdesign mag who did a workshop study on a website I constructed some time ago, and one of the main judgements was to reduce open windows as they distract and some browsers are set to prohibit popups. That's why I have taken the 'page-in-page' approach. I hear what you say and it is sound too. Thank you again Andy< |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 26 July 2008 : 06:52:12
|
The dim is there and only there. I have not redifined (which means, I have not entered it anywhere else).
I have just tried the site again when not logged in, and when logged in and it works just fine on both the live site and a couple of test sites and do not get the "ADODB.Field error '800a0bcd'" error. Not sure where that is comming from.< |
Cheers,
David Greening |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 26 July 2008 : 06:57:58
|
Okay, I have removed the dim i as I could not spot another occurance in your files. I remember another issue a while ago where someone had used dim i and errors occurred so again we commented them out. Strange re 800a0bcd still at least we are all working now.
warmest regards andy< |
|
|
|
Carefree
Advanced Member
Philippines
4222 Posts |
Posted - 26 July 2008 : 12:20:29
|
I had a random ADODB error also in those first few lines of "greeting_card_cat.asp"; but I rewrote the first sql routine (just after the dimensioned values) & it hasn't happened since. Here's what my version says:
< |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 17 August 2008 : 08:02:11
|
This not a bug, but I am looking at allowing the visitor to either click on a greeting card thumbnail image or radio selector to make their choice of a Greeting Card. Currently, to make a card selection you click the radio selector. Is there a simple way to link the image to the radio selector?
I think this is the code which shws the image and radio selector:
" <td valign=""center"">" & vbNewLine & _
" <center><img border=""2"" width=""100"" src=""" & strimgsm & """><br />" & vbNewLine & _
" <input type=""radio"" value=""" & strid & """ name=""id"" checked></center>" & vbNewLine & _
" </td>" & vbNewLine & _< |
|
|
|
Topic |
|
Topic Locked
