| Author |
 Topic  |
|
lschafroth
Starting Member
USA
33 Posts |
 Posted - 17 October 2005 : 17:49:31
|
Does anyone have the code to change the FAQ admin to work with an Access Database forum?
I tried it and it errors on the strSQL commands.
Thanks |
Lannie Schafroth
Computer Troubleshooters
515 263-9200 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
lschafroth
Starting Member
USA
33 Posts |
Posted - 18 October 2005 : 09:13:30
|
No value given for one or more required parameters.
/admin_faq.asp, line 482
Line 482:
Set frs = my_conn.execute(strsql)
|
Lannie Schafroth
Computer Troubleshooters
515 263-9200 |
 |
|
|
lschafroth
Starting Member
USA
33 Posts |
Posted - 18 October 2005 : 09:18:10
|
If you click on the FAQ link itself you get a similar error on line 82.
Line 82:
Set rsFaq = my_conn.Execute(strSql2)
|
Lannie Schafroth
Computer Troubleshooters
515 263-9200 |
|
|
|
Nertz
Junior Member
Canada
341 Posts |
Posted - 18 October 2005 : 09:31:24
|
It would be easier to help you if you could provide a url, guest or test account, and a link to a text version of admin_faq.asp.
Is the error in your lasp post in the same file? if not, please provide link to text version of that file as well.
cheers |
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.
www.fathers-4-justice-canada.ca |
|
|
|
lschafroth
Starting Member
USA
33 Posts |
Posted - 18 October 2005 : 10:50:34
|
The first post was in admin_faq.asp, the second post was in the faq.asp.
The verison is in the subject line.
http://www.iowarctracks.com is the site. Feel free to use it.
|
Lannie Schafroth
Computer Troubleshooters
515 263-9200 |
|
|
|
Nertz
Junior Member
Canada
341 Posts |
Posted - 18 October 2005 : 11:02:37
|
| When I click on faqs I don't get any of the errors you mention. I get a properly formatted page with "no categories found" in the FAQ TOC. |
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.
www.fathers-4-justice-canada.ca |
|
|
|
lschafroth
Starting Member
USA
33 Posts |
Posted - 18 October 2005 : 11:14:20
|
This is a text copy of what I get. Tried it on three different machines and two different ISP's.
FAQ Table of Contents
General
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/faq.asp, line 82
|
Lannie Schafroth
Computer Troubleshooters
515 263-9200 |
|
|
|
Nertz
Junior Member
Canada
341 Posts |
Posted - 18 October 2005 : 11:31:25
|
| As I asked earlier, please post a link to a text version of faq.asp and admin_faq.asp |
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.
www.fathers-4-justice-canada.ca |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
lschafroth
Starting Member
USA
33 Posts |
Posted - 18 October 2005 : 12:11:04
|
I will download that one and give it a try.
The one I'm using is from SnitzBlitz.
|
Lannie Schafroth
Computer Troubleshooters
515 263-9200 |
|
|
|
lschafroth
Starting Member
USA
33 Posts |
Posted - 18 October 2005 : 12:16:31
|
Does the same thing. When I ran the dbs update to add the default categories I got the following error:
-2147217900 | The INSERT INTO statement contains the following unknown field name: 'F_FAQ_ORDER'. Make sure you have typed the name correctly, and try the operation again.
|
Lannie Schafroth
Computer Troubleshooters
515 263-9200 |
|
|
|
lschafroth
Starting Member
USA
33 Posts |
Posted - 18 October 2005 : 12:18:55
|
I used the FAQ uninstall dbs file and readded the tables into the database and it works fine now!!
I don't know if it was related to the dbs update from the SnitzBlitz file or if it failed the first time and I did not notice it. I REALLY appreciate the help!
This forum is terrific.
|
Lannie Schafroth
Computer Troubleshooters
515 263-9200 |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
vynsane
New Member
73 Posts |
Posted - 18 October 2005 : 12:29:37
|
hey, OWM... i went to your site, because i'm thinking of adding the FAQ and forum rules mods, and your "rules" page can't be found...
http://www.onewaymule.org/onewayscripts/rules.asp |
why do you not have something to drink... choose one making you better feeling...
my snitz's:
www.vynsane.com/forum - l:guest p:guest (limited access account...)
www.WallCrawlersWeb.com/forum - The Spidey Database |
Edited by - vynsane on 18 October 2005 12:31:06 |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Topic |
|
Topic Locked
