| Author |
 Topic  |
|
Davio
Development Team Member
Jamaica
12217 Posts |
 Posted - 02 April 2001 : 19:01:51
|
LoL, ok I'll go slower. 
|
 |
|
|
Giapai
New Member
92 Posts |
Posted - 02 April 2001 : 19:12:19
|
quote:
LoL, ok I'll go slower.
yes and get a nice cold beer, coke or what ever you like to drink (its on me) and sit back in your favourit chair cause you eliminated the bugs now 
and.. again i learned a lot thats what i like most about making webpages, every page gets better since i learn from everything i do (or other ppl do ) *grin*
thanks a zillion times
p.s. lol if you can't help yourself and have to create things lol i posted an idea in design catogory forum lol
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 April 2001 : 19:25:42
|
Thanks for the offer, but don't drink alcoholic drinks though.
And I'm glad you got it working. Just knew you could do it.
And I can't take anything more. I have too much on my plate right now. And I can't get any of it done because so many people crying for help, so I end up most of the day helping people instead of working on the mods. Something that would probably take me 2 days to code, ends up taking me a week and a half. *sigh*
Sure would be good if we could get some more help around this place. 
|
|
|
|
Giapai
New Member
92 Posts |
Posted - 02 April 2001 : 19:37:08
|
quote:
Thanks for the offer, but don't drink alcoholic drinks though.
Thats why i offered coke too (as in cola)
quote:
Something that would probably take me 2 days to code, ends up taking me a week and a half. *sigh*
well look at it this way.. what takes you a week and a half to code takes me a year and a half 
quote:
Sure would be good if we could get some more help around this place.
well when i get the time and the answers ill see what i can do think thats least what i can do for getting such a great forum for free and all the help i can wish for
you havent seen the last message from me yet
|
|
|
|
mama2000
Junior Member
Canada
100 Posts |
Posted - 05 April 2001 : 22:26:14
|
Hi!
I see this problem was posted in this string, but it was resolved by emailing files back and forth. Can you tell me what was done to correct this error?
I am getting this error...
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/club/register.asp, line 313
Which comes up as the My_Conn line here...
strSql = strSql & ")"
my_Conn.Execute (strSql)
docount
regHomepage = ""
Thanks
:)
Kelly
http://theparentsite.com/club/default.asp |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 April 2001 : 12:27:07
|
In the SQL statement, it first's tells the server what TABLE the following info should go in. So first, it names out all the tables it is gonna put data in, after that it gets all the data to put in the tables it just named.
The error you are getting means, that supposing you named 10 tables, you are trying to put it 11 data items. It means both sides of the SQL string doesn't match. If you name 10 tables, you need to put in 10 values.
After that explanation, can you post a .txt version of your register.asp file? And I will show you, you have an extra table field or data value, when you added the mod.
|
|
|
|
mama2000
Junior Member
Canada
100 Posts |
Posted - 06 April 2001 : 19:04:26
|
Good information to know why things are doing what thier doing, thanks..
Now, I looked and looked, compared my old register.asp (saved backups) to the one in the mod, and the one I modified.. trying so hard to figure it out on my own, but, just can't seem to see it...
Here's the .txt version of register as I have it modified. I am running my backup copies on the board, the normal way.
http://theparentsite.com/club/register.txt
Thanks!
:)
Kelly
http://theparentsite.com/club/default.asp |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 April 2001 : 20:06:45
|
Well, i thought instead of just giving you the answer to correct it, I might as well explain to you why it is giving you the problem. That way you learn how your forum functions, and in case it comes up again, you have an idea what might be causing it.
And as I suspected, I see your error. Notice this code you added:strSql = strSql & ", " & "'" & ChkString(Request.Form("Password"),"password") & "'"
' ####################### Email Password Mod ##################
strSql = strSql & ", " & "'" & ChkString(strPassword,"password") & "'"
' ####################################################################That code, inside the # pound symbols, should replace the one that is in blue. The one above the Email Password Mod code. You can either delete the code in blue, or comment it out, by putting a quote ' in front of it.
Edited by - Davio on 06 April 2001 20:07:43 |
|
|
|
mama2000
Junior Member
Canada
100 Posts |
Posted - 06 April 2001 : 23:12:07
|
Thank you very much, and I really appreciate you taking the time to explain to my the 'Why and whatfor".
I have learned everything I know about cgi, html, asp, etc... by trial and error. LOL
I tried removing that line, and got a different error,
Microsoft VBScript runtime error '800a01c9'
This key is already associated with an element of this collection
/club/register.asp, line 325
And it didn't send any emails with the password and welcome.
But it did create the user.
Now, I put back my old backups again... grr.. they aren't switching over right away either. :(
Anyhoo...
Any insight?
Sorry to be a pest.
:)
Kelly
http://theparentsite.com/club/default.asp |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 07 April 2001 : 12:41:15
|
Hmm, you might have deleted some extra code or something. Update the .txt version of the file and let me know what line is 325 is.
|
|
|
|
mama2000
Junior Member
Canada
100 Posts |
|
|
mama2000
Junior Member
Canada
100 Posts |
Posted - 08 April 2001 : 12:00:52
|
Just another quick thing..
Could this be because my pages don't seem to update automatically sometimes. I tried deleting the old asp pages and uloading the new ones, but sometimes I still get the old page, even after doing this.
thx
:)
Kelly
http://theparentsite.com/club/default.asp |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 08 April 2001 : 18:12:32
|
The error you are getting has nothing to do with the email random password mod. It's part of the "PM New Member" mod you added. This is line 325, the line you are getting the error on:
objDict.Add objRec.Fields.Item("m_code").Value, objRec.Fields.Item("m_value").Value
I didn't create that mod, so I don't know what the code does or should do. You would have to start a new topic to get help with that.
|
|
|
|
mama2000
Junior Member
Canada
100 Posts |
Posted - 08 April 2001 : 18:35:50
|
K thanks.. That feature never really worked, but it didn't interfere with anything before either.. oh well.. I guess maybe I'll have to take another look at the original code because I really want this email password to work!
Thanks again so much for your time
:)
Kelly
http://theparentsite.com/club/default.asp |
|
|
|
Topic |
|
Topic Locked
