|
| |
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
 |
Can you - and how - check a database connection online? - 1/27/2004 17:13:20
I have a site with a search (beneath a Spooky login) using FP2000, Access2000 & built using the DRW. It was working great a week ago. I haven't changed the search or result pages at all, but I update the database daily. Apparently something went wrong in my database updates because now I get the following message:
quote:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
Is there a way to check my database connection live to see if it's the connection? If it's not the connection, can you offer any suggestions? The only thing I can think of is that I inadvertently changed one of the database field properties. (when I update the database, I simply delete the old data and import the new data using the same structure.)
should you wish to look at it, login here using outfront as both the username and password. None of the searches work.  They all pull from the same database.
Thanks for any help/suggestions you can offer!
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
|
|
|
|
BeTheBall
Posts: 6354
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/27/2004 18:11:55
Post your SQL. I know you said you didn't change anything, but that error means your SQL cannot find a value for one of the parameters in the SQL statement.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/27/2004 18:30:50
I haven't put it on a Spooky diet yet - wanted to make sure it was stable first. <arghh..>
Is this what you're looking for? Too much or too little?
quote:
<!--webbot bot="DatabaseRegionStart"
startspan
s-columnnames="ID,ML_Number,Listing Price,Address,Address - City,Address - Zip Code,Area Number,Area Desc,Bedrooms,Bathrooms,Square Footage,Lot Size - Acres,Marketing Remarks,Style Desc,Property Type Desc,Address - Street Name,Address - Street Number,Age,directory,urlpath"
s-columntypes="3,202,6,202,202,202,202,202,3,3,3,3,203,202,202,202,202,3,202,202"
s-dataconnection="homes" b-tableformat="FALSE"
b-menuformat="FALSE" s-menuchoice="ML_Number" s-menuvalue="ML_Number"
b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="FALSE" i-ListFormat="1"
b-makeform="FALSE" s-recordsource
s-displaycolumns="ML_Number,Listing Price,Address,Area Desc,Bedrooms,Bathrooms,Square Footage,Lot Size - Acres,Marketing Remarks,Style Desc,urlpath"
s-criteria s-order
s-sql="SELECT * FROM homes WHERE ("Listing Price" >= ::From:: AND "Listing Price" <= ::To:: AND Bathrooms >= ::Bathrooms:: AND Bedrooms >= ::Bedrooms:: AND "Area Desc" = '::Area::' AND "Property Type Desc" = 'Condo/Cluster Coop') ORDER BY "Listing Price" DESC"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="From=75000&To=5000000&Bathrooms=1&Bedrooms=2&Area=1"
s-NoRecordsFound="Sorry - no condos or lofts match your criteria today. Please try another search or request a Custom Home Search."
i-MaxRecords="256" i-GroupSize="5" BOTID="0"
u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY"
local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server using a web browser. The section of the page from here to the end of the Database Results region will repeat once for each record returned by the query.</font></td></tr></table>"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" b-WasTableFormat="FALSE" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM homes WHERE (""Listing Price"" >= ::From:: AND ""Listing Price"" <= ::To:: AND Bathrooms >= ::Bathrooms:: AND Bedrooms >= ::Bedrooms:: AND ""Area Desc"" = '::Area::' AND ""Property Type Desc"" = 'Condo/Cluster Coop') ORDER BY ""Listing Price"" DESC"
fp_sDefault="From=75000&To=5000000&Bathrooms=1&Bedrooms=2&Area=1"
fp_sNoRecords="Sorry - no condos or lofts match your criteria today. Please try another search or request a Custom Home Search."
fp_sDataConn="homes"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ML_Number"
fp_sMenuValue="ML_Number"
fp_iDisplayCols=11
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="3358" endspan -->
I generally focus on the red, since once we do the diet, most of the rest 'goes away.' I thought my problem might be in the 'Area' -- It's a text field and I have it equalling the description. I tried changing it to LIKE, but that didn't work either.
The choices pull from another form - quote:
<form BOTID="0" METHOD="POST" ACTION="condosfound.asp" onsubmit="return FrontPage_Form2_Validator(this)" name="FrontPage_Form2">
<table BORDER="0">
<tr>
<td colspan="2"><font color="#333300"><b>Create
Your Search:</b></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">From</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" S-Data-Type="Number"
S-Number-Separators=",." --><input NAME="From" VALUE="75000" size="20"></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">To</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" S-Data-Type="Number"
S-Number-Separators=",." --><input NAME="To" VALUE="5000000" size="20"></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">Bathrooms</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" B-Value-Required="TRUE" --><select size="1" NAME="Bathrooms" VALUE="<%=Request("Bathrooms")%>">
<option value="1" selected>1 or more</option>
<option value="1.5">1.5 or more</option>
<option value="2">2 or more</option>
<option value="2.5">2.5 or more</option>
<option value="3">3 or more</option>
</select></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">Bedrooms</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" B-Value-Required="TRUE" --><select size="1" NAME="Bedrooms" VALUE="<%=Request("Bedrooms")%>">
<option value="1">1 or more</option>
<option value="2" selected>2 or more</option>
<option value="3">3 or more</option>
<option value="4">4 or more</option>
<option value="5">5 or more</option>
</select></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">Area</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" B-Value-Required="TRUE" --><select size="1" NAME="Area" VALUE="<%=Request("Area")%>">
<option value="Affton">Affton</option>
<option value="Bayless">Bayless</option>
<option value="Brentwood">Brentwood</option>
<option value="Clayton">Clayton</option>
<option value="Crystal City">Crystal City</option>
<option value="Desoto">Desoto</option>
<option value="Eureka">Eureka</option>
<option value="Ferguson-Florissant">Ferguson-Florissant</option>
<option value="Festus">Festus</option>
<option value="Fort Zumwalt North">Fort Zumwalt
North</option>
<option value="Fort Zumwalt South">Fort Zumwalt
South</option>
<option value="Fort Zumwalt West">Fort Zumwalt
West</option>
<option value="Fox C-6">Fox C-6</option>
<option value="Francis Howell">Francis Howell</option>
<option value="Francis Howell Cntrl">Francis
Howell Central</option>
<option value="Francis Howell North">Francis
Howell North</option>
<option value="Grandview">Grandview</option>
<option value="Hancock Place">Hancock Place</option>
<option value="Hazelwood Central">Hazelwood
Central</option>
<option value="Hazelwood East">Hazelwood East</option>
<option value="Hazelwood West">Hazelwood West</option>
<option value="Herculaneum">Herculaneum</option>
<option value="Hillsboro">Hillsboro</option>
<option value="Jennings">Jennings</option>
<option value="Kirkwood">Kirkwood</option>
<option value="Ladue">Ladue</option>
<option value="Lafayette">Lafayette</option>
<option value="Lindbergh">Lindbergh</option>
<option value="Maplewood-Rchmnd Hts">Maplewood-Rchmnd
Hts</option>
<option value="Marquette">Marquette</option>
<option value="Mehlville">Mehlville</option>
<option value="Normandy">Normandy</option>
<option value="Northwest">Northwest</option>
<option value="Oakville">Oakville</option>
<option value="Orchard Farm">Orchard Farm</option>
<option value="Pacific/Meramec R-3">Pacific/Meramec
R-3</option>
<option value="Parkway Central">Parkway Central</option>
<option value="Parkway North">Parkway North</option>
<option value="Parkway South">Parkway South</option>
<option value="Parkway West">Parkway West</option>
<option value="Pattonville">Pattonville</option>
<option value="Ritenour">Ritenour</option>
<option value="Riverview Gardens">Riverview
Gardens</option>
<option value="Rockwood Summit">Rockwood Summit</option>
<option value="Seckman">Seckman</option>
<option value="St. Charles">St. Charles</option>
<option value="St. Charles West">St. Charles West</option>
<option value="St. Genevieve County">St. Genevieve
County</option>
<option value="St. Louis E of Grand">St. Louis E
of Grand</option>
<option value="St. Louis, North">St. Louis, North</option>
<option value="St. Louis, SW">St. Louis, SW</option>
<option value="St. Louis, W-Central">St. Louis,
W-Central</option>
<option value="University City">University City</option>
<option value="Valley Park">Valley Park</option>
<option value="Washington (St. Charles)">Washington
(St. Charles)</option>
<option value="Webster Groves">Webster Groves</option>
<option value="Wellston">Wellston</option>
<option value="Wentzville">Wentzville</option>
<option value="Windsor">Windsor</option>
</select></font></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot
bot="SaveAsASP" CLIENTSIDE SuggestedExt="asp"
PREVIEW=" " -->
<p> </p>
<input type="hidden" name="Property_Type" value="RESI">
</form>
Sorry about the length here. Thanks for your help!!
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
BeTheBall
Posts: 6354
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/27/2004 18:42:32
I had this problem of FP putting in the two sets of double quotes, but can't remember if it threw the missing parameter error or not. I would begin by dieting the page and changing the SQL to:
fp_sQry="SELECT * FROM homes WHERE ([Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND Bathrooms >= ::Bathrooms:: AND Bedrooms >= ::Bedrooms:: AND [Area Desc] = '::Area::' AND [Property Type Desc] = 'Condo/Cluster Coop') ORDER BY [Listing Price] DESC"
Also, verify that Listing Price, Bathrooms, Bedrooms, Area Desc and Propery Type Desc match exactly what the field names are called in your db. For example, I noticed your form has a hidden field titled Property_Type. Make sure your db field isn't named similarly.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
hzarabet
Posts: 1539
From: New Milford CT USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/27/2004 19:31:34
Are any of these fields NULL in the table? It may be trying to read a NULL value.
_____________________________
http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/27/2004 20:12:49
No, I don't have any NULL values.
Here's what's coming from the form on the search page:
quote:
<form BOTID="0" METHOD="POST" ACTION="condosfound.asp" onsubmit="return FrontPage_Form2_Validator(this)" name="FrontPage_Form2">
<table BORDER="0">
<tr>
<td colspan="2"><font color="#333300"><b>Create
Your Search:</b></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">From</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" S-Data-Type="Number"
S-Number-Separators=",." --><input NAME="From" VALUE="75000" size="20"></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">To</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" S-Data-Type="Number"
S-Number-Separators=",." --><input NAME="To" VALUE="5000000" size="20"></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">Bathrooms</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" B-Value-Required="TRUE" --><select size="1" NAME="Bathrooms" VALUE="<%=Request("Bathrooms")%>">
<option value="1" selected>1 or more</option>
<option value="1.5">1.5 or more</option>
<option value="2">2 or more</option>
<option value="2.5">2.5 or more</option>
<option value="3">3 or more</option>
</select></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">Bedrooms</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" B-Value-Required="TRUE" --><select size="1" NAME="Bedrooms" VALUE="<%=Request("Bedrooms")%>">
<option value="1">1 or more</option>
<option value="2" selected>2 or more</option>
<option value="3">3 or more</option>
<option value="4">4 or more</option>
<option value="5">5 or more</option>
</select></font></td>
</tr>
<tr>
<td><font face="Verdana" size="3">Area</font></td>
<td><font face="Verdana" size="3"><!--webbot
bot="Validation" B-Value-Required="TRUE" --><select size="1" NAME="Area" VALUE="<%=Request("Area")%>">
<option selected value="%">All Areas</option>
<option value="Affton">Affton</option>
<option value="Bayless">Bayless</option>
<option value="Brentwood">Brentwood</option>
... lots of values deleted for the sake of brevity ....
<option value="Wentzville">Wentzville</option>
<option value="Windsor">Windsor</option>
</select>
Side thought ***Is there significance that the Bedrooms, Bathrooms & Area have the VALUE statements (see red above) or is it simply because those are pull-downs whereas the others are just text boxes? ****
The fields (and types) in my database and the query (it pulls from the query rather than the table, but all the field names are the same - I double-checked) are:
Area Desc - text (yes, there's a space in there, but to change it makes my daily import difficult, so I'd rather keep the space if I can)
Bedrooms - number
Bathrooms - number
Property Type Desc - text
Listing Price - currency
I did the Spooky diet. Here's my most recent results page code:
quote:
<!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM homes WHERE ([Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND Bathrooms >= ::Bathrooms:: AND Bedrooms >= ::Bedrooms:: AND [Area Desc] LIKE '%::Area::%' AND [Property Type Desc] = 'Condo/Cluster Coop') ORDER BY [Listing Price] DESC"
fp_sDefault="From=75000&To=5000000&Bathrooms=1&Bedrooms=2&Area=%"
fp_sNoRecords="Sorry - no condos or lofts match your criteria today. Please try another search or request a Custom Home Search."
fp_sDataConn="homes"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ML_Number"
fp_sMenuValue="ML_Number"
fp_iDisplayCols=11
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<p><b>Listing Number:</b> <%=FP_FieldVal(fp_rs,"ML_Number")%>
<br>
<b>Listing Price:</b> <%=FormatCurrency(FP_FieldVal(fp_rs,"Listing Price"),0)%>
<br>
<b>Address:</b> <%=FP_FieldVal(fp_rs,"Address")%>
<br>
<b>School District/Area:</b> <%=FP_FieldVal(fp_rs,"Area Desc")%>
<br>
<b>Bedrooms:</b> <%=FP_FieldVal(fp_rs,"Bedrooms")%>
<br>
<b>Bathrooms:</b> <%=FP_FieldVal(fp_rs,"Bathrooms")%>
<br>
<b>Square Footage:</b> <%=FP_FieldVal(fp_rs,"Square Footage")%>
<br>
<b>Lot Size - Acres:</b> <%=FP_FieldVal(fp_rs,"Lot Size - Acres")%>
<br>
<b>Description:</b> <%=FP_FieldVal(fp_rs,"Marketing Remarks")%>
<br>
<b>Style:</b> <%=FP_FieldVal(fp_rs,"Style Desc")%>
<br>
<a href="images/p_nophoto.jpg">
<img border="0" src="<%=FP_FieldLink(fp_rs,"urlpath")%>">
</a>
<p style="margin: 0"><font face="Verdana" size="2"><a href="mailto:homes@marksellsstlouis.net?subject=Listing Number <%=FP_FieldLink(fp_rs,"ML_Number")%>"><b>Request
More Information</b></a></font></p>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
I changed the comparison for Area to LIKE rather than = and added a choice of All Areas - value %. I have another set of searches that work off different databases (they're still working - knock on wood) that use the LIKE comparison for the Area.
It continues to give me the same error message... clearly I haven't spotted the problem.  It's most frustrating because this is one of the most popular parts of my site and it's down now. 
Thank you all for all your help and your continued support!!!
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
BeTheBall
Posts: 6354
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/27/2004 22:05:28
I can't seem to see it either. You may want to eliminate one segment of your WHERE clause at a time to see which is causing the problem. For example, try without the Bathroom portion like this:
fp_sQry="SELECT * FROM homes WHERE ([Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND Bedrooms >= ::Bedrooms:: AND [Area Desc] LIKE '%::Area::%' AND [Property Type Desc] = 'Condo/Cluster Coop') ORDER BY [Listing Price] DESC"
If the error persists, then try taking out a different portion, such as Bedrooms and continue until you have tried them all. Also, try writing out your SQL to see if that reveals anything about the error. You do this by changing the red code to something like this:
<%
fp_sQry="SELECT * FROM homes WHERE ([Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND Bathrooms >= ::Bathrooms:: AND Bedrooms >= ::Bedrooms:: AND [Area Desc] LIKE '%::Area::%' AND [Property Type Desc] = 'Condo/Cluster Coop') ORDER BY [Listing Price] DESC"
fp_sDefault="From=75000&To=5000000&Bathrooms=1&Bedrooms=2&Area=%"
fp_sNoRecords="Sorry - no condos or lofts match your criteria today. Please try another search or request a Custom Home Search."
fp_sDataConn="homes"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ML_Number"
fp_sMenuValue="ML_Number"
fp_iDisplayCols=11
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
Response.write fp_sQry
Response.End
%>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Larry M.
Posts: 2686
Joined: 2/20/2003
From: Greenville, South Carolina, USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/28/2004 10:14:40
<<I would begin by dieting the page>>
Duane,
Trying to come onboard re: FP DRW. Would you explain above and point me in the right direction to buy? Gather this is something our esteemed Spooky offers or otherwise is knowledgeable about.
Thanks!
_____________________________
Larry M.
He Who Hesitates .... is Probably Rght
| |
|
|
|
Mike54
Posts: 4782
Joined: 3/26/2001
From: Way Up Over
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/28/2004 10:29:18
Larry
Here's a link to the Spooky tutorial on dieting
_____________________________
Who was the first guy that looked at a cow and said, "I think that I'll drink whatever comes out of those things when I squeeze them"?
New photogalleries, stop by sometime.
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: online
|
RE: Can you - and how - check a database connection onl... - 1/28/2004 11:04:14
quote:
Listing Price - currency
Could this be an issue? I never have any luck using currency field types in Access - I always make 'em just a number field and worry 'bout the formatting stuff using the FormatCurrency VBScript function. That way if all my numbers are just that - numbers - I don't have to worry 'bout that stuff.
That particular error I see when the field types are mismatched or you have blank form fields. It doesn't really look like your form fields are blank, but you may want to Response.write them all out somewhere before the DWR just to see if they're valid.
</$.02>
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/28/2004 21:06:51
Cool! I didn't know I had that checked! Thanks Spooky!
Here's what I get, but I must admit, I don't know how to fix it....
quote:
Microsoft VBScript compilation error '800a0400'
Expected statement
/condosfound.asp, line 124
<p><b>Listing Number:</b> <%=FP_FieldVal(fp_rs,"ML_Number")
^
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/28/2004 21:43:37
Here's what it reads now:
quote:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/condosfound.asp, line 120
fp_sQry="SELECT * FROM homes WHERE ([Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND Bathrooms >= ::Bathrooms:: AND Bedrooms >= ::Bedrooms:: AND [Area Desc] LIKE '%::Area::%' AND [Property Type Desc] = 'Condo/Cluster Coop') ORDER BY [Listing Price] DESC" fp_sDefault="From=75000&To=5000000&Bathrooms=1&Bedrooms=2&Area=%"
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^
I don't see the statement that isn't ended..... or do I just misunderstand?
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/28/2004 22:36:19
hmmmm... the homes query adds a couple of fields that I couldn't figure out how to do in the database itself.
The database that I download from changed their fields and no longer gives me a link to pictures. But I can figure out where the link is. For a listing with ML#400376, the picture is at http://maris.rapmls.com/listingpics/tmbphoto/76/400376.jpg The directory 76 changes - it's always the last 2 digits of the ML number.
So I have one field in the query that figures out the directory quote:
directory: Right([ML_Number],2) and the other figures out the url for the picture.quote:
urlpath: "http://maris.rapmls.com/listingpics/bigphoto/" & [directory] & "/" & [ML_Number] & ".jpg"
I couldn't figure out how to have the table calculate the contents of a field, so I have the query doing that....
What strikes me as odd is that it worked until a couple of days ago (I made these major changes about 10 days ago.) No matter, though....
< Message edited by pmagas -- 1/28/2004 21:41:08 >
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/28/2004 22:49:20
I fear not, but I'll look around. Generally speaking, I keep the original database and just delete the old records and insert the new ones.
There is one strange thing that's been happening, though and its occurence may have caused me to overlook some unintentional change. I mentioned the fields changed in the original database I export from. When they did, they changed the name of the Area Number field for the Condos to Area; but it's still Area Number for Residential & New Constr. (For each type, I have to do a separate download but until this last change, they all had common field names.) Now, when I import the data, I have to change the field name in the database before I do the import. If I got into one of the other fields & changed it - even a little - I might not have noticed and then saved the changes to the structure.
I think I'll have to break out the condos to a separate database to avoid this happening again.
I'll hunt around for an old version....
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Can you - and how - check a database connection onl... - 1/28/2004 23:01:14
Spooky - you are just too good. I'm embarrassed it didn't occur to me to do it that way - duh!! I can't tell you the hours I spent messing around with Access to get it in the table or the query. Thank you!! I'll change my SQL to query cityres and put in the statement above..... will let you know when I have it fixed.
Can you recommend a good ASP book - seems I'm in serious need of learning some basics. The book I bought a while back turned out to be insubstantial. And clearly I'm not doing a good job of learning along the way.
I'm forever indebted to you!
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
Have you checked the error in the KB at 
k¥ 
I certainly trust your judgment.... I'll poke around for some sites with basic asp 'stuff' and who knows - maybe the local library will have some ASP books. And I'll start looking into the asp.net since that's where we're headed. Maybe I'll start with the basics this time. 