Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Problem with prices.asp		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ryan
Average Member

USA
858 Posts
Posted - 06 October 2003 :  20:26:52  Show Profile  Visit Ryan's Homepage
Even though this involves snitz code I thought it would best go here. I am making pages similiar to the Welcome Letter MOD but I cannot get it to work right. Please visit
http://www.ryans-site.com/snitz/prices.asp
and see the error.
Here is a txt of the prices.asp page:
http://www.ryans-site.com/txt/prices.txt
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 06 October 2003 :  20:32:52  Show Profile
that error usually indicates that you have a typo in the name of a field you are referencing in the sql statement.
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

Ryan
Average Member

USA
858 Posts
Posted - 06 October 2003 :  21:42:18  Show Profile  Visit Ryan's Homepage
Here is what the dbs file says:
MOD PRICES
[CREATE]
MOD_PRICES
MP_ID
MP_MODE#int#NOT NULL#
MP_CONTENT#memo#NULL#
[END]
[INSERT]
MOD_PRICES
(MP_MODE,MP_CONTENT)#(0,'YOUR PRICES HERE')
[END]
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 06 October 2003 :  21:55:03  Show Profile
and your sql statement is:
strsql = "SELECT MP_MODE, MP_CONTENT FROM " & strTablePrefix & "CUSTOM_WLETTER WHERE MP_ID=1"

where is CUSTOM_WLETTER coming from?
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

Ryan
Average Member

USA
858 Posts
Posted - 06 October 2003 :  22:56:58  Show Profile  Visit Ryan's Homepage
ehh....
I am modifying the welcome.asp file over to prices.asp so I missed that one I guess. Thanks alot I will let you know if it works.
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help
Go to Top of Page

Ryan
Average Member

USA
858 Posts
Posted - 06 October 2003 :  23:07:22  Show Profile  Visit Ryan's Homepage
Now I get this error:
ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/snitz/prices.asp, line 69
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 07 October 2003 :  10:20:26  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
How are you calling out CP_MODE and CP_CONTENT when your requesting from the database MP_MODE and MP_CONTENT?
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Ryan
Average Member

USA
858 Posts
Posted - 07 October 2003 :  12:14:58  Show Profile  Visit Ryan's Homepage
On what lines am I doing that?
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help
Go to Top of Page

n8pbm
Junior Member

USA
212 Posts
Posted - 07 October 2003 :  14:41:59  Show Profile  Visit n8pbm's Homepage
I noticed that you have MP_ID=1 in your txt file you posted. Are you sure you have records with MP_ID=1?

You do not have any error catching for no records returned that I could see. Just a thought. You may want to put a If rsp.EOF then statement for that error check.
Mike
Great Lakes Pop Up Club Camping
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 08 October 2003 :  03:45:07  Show Profile
You are doing it around this data:
strsql = "SELECT MP_MODE, MP_CONTENT FROM " & strTablePrefix & "CUSTOM_WLETTER WHERE MP_ID=1"
      Set rsp = my_conn.execute(strsql)
      strPolicyMode = rsp("CP_MODE")
      strPolicyContent = formatStr(rsp("CP_CONTENT"))
      strPolicyContent = Replace(strPolicyContent,"[adminemail]","<a href=""mailto:" & strSender & """>" & strSender & "</a>")
      rsp.close

quote:
Originally posted by reducks87

On what lines am I doing that?


Have a full look and see if there are any other typo's in the conversion.
Cheers,

David Greening
Go to Top of Page

Ryan
Average Member

USA
858 Posts
Posted - 08 October 2003 :  11:44:19  Show Profile  Visit Ryan's Homepage
K thanks.
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.46 seconds. Powered By: Snitz Forums 2000 Version 3.4.07