Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
backintimeintl #1
Using SES Converter on CF Server
Hello everyone-
I got Fusium's SES Converter to work on my Windows XP computer running CF's
built-in server. However, I am having a problem using some code that I made to
do paging correctly with SES. The code I have included at the bottom works
perfectly on my actual server, which is run by HostMySite and uses IIS.
The correct URL when you click on the "Next" button on this page should be:
[url]http://www.mywebsite.com/generateused.cfm/PageNum_qryUsedWatches/2/gender/1/bran[/url]
d/0/era/1
However, when I run this code on my testing server, the URL generated when
"Next" is clicked is:
[url]http://localhost:8501/generateused.cfm/PageNum_qryUsedWatches/2[/url]
This obviously does not work. The code I have attached produces the correct
result on the live server, but doesn't work on my CF built-in testing server. I
appreciate all help in this matter!
Thanks,
Chris
<cfparam name="URL.Brand" default="1">
<cfparam name="URL.Gender" default="1">
<cfparam name="URL.Era" default="1">
<cfparam name="Form.Brand" default="1">
<cfparam name="Form.Era" default="1">
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfparam name="PageNum_qryUsedWatches" default="1">
<cfquery name="qryUsedWatches" datasource="*****">
SELECT * FROM tblUsedBrands, tblUsedWatches, tblEra, tblGender WHERE
tblUsedBrands.pkUsedBrandID
= tblUsedWatches.tkUsedBrandID AND tblEra.pkEraID = tblUsedWatches.tkEraID AND
tblGender.pkGenderID = tblUsedWatches.tkGenderID
<cfif #URL.Brand# NEQ 0>
AND tblUsedWatches.tkUsedBrandID = #URL.Brand# AND tblUsedWatches.tkEraID =
#URL.Era#
<cfelse>
AND tblUsedWatches.tkEraID = #URL.Era# AND tblUsedWatches.tkGenderID IN
(#URL.Gender#)
</cfif>
ORDER BY tblUsedWatches.tkGenderID, tblUsedWatches.Date_entered
</cfquery>
<cfset MaxRows_qryUsedWatches=10>
<cfset
StartRow_qryUsedWatches=Min((PageNum_qryUsedWatche s-1)*MaxRows_qryUsedWatches+1,
Max(qryUsedWatches.RecordCount,1))>
<cfset
EndRow_qryUsedWatches=Min(StartRow_qryUsedWatches+ MaxRows_qryUsedWatches-1,qryUs
edWatches.RecordCount)>
<cfset
TotalPages_qryUsedWatches=Ceiling(qryUsedWatches.R ecordCount/MaxRows_qryUsedWatc
hes)>
<cfset QueryString_qryUsedWatches=Iif(CGI.QUERY_STRING NEQ
"",DE("/"&replace(replace((CGI.QUERY_STRING),"&","/","ALL"),"=","/","ALL")),DE("
"))>
<cfset
tempPos=ListContainsNoCase(QueryString_qryUsedWatc hes,"PageNum_qryUsedWatches/",
"&")>
<cfif tempPos NEQ 0>
<cfset
QueryString_qryUsedWatches=ListDeleteAt(ListDelete At(QueryString_qryUsedWatches,
tempPos,"/"),"1","/")>
</cfif>
backintimeintl Guest
-
asp 2 php converter
ASP to PHP Converter, is there such a thing? -- Thank you, Louie Miranda (louie@axishift.ath.cx) -- To UNSUBSCRIBE, email to... -
XSI-W3D converter 404
There used to be a XSI to W3D converter here: http://www.softimage.com/download/xsi/converters/shockwave/ But now it says page not found and I... -
.obj converter for OSX
Hi there I am a newbie at 3D Director so please forgive me if a silly Q, but I went to the download page to download the obj converter and there... -
DoB to age converter
hey everyone. I'd like to be able to convert a users date of birth (from data gathered from a form) into there age for use in my site, the member... -
3d converter
where can i find the converter for 3d max to a file that can be imported in to the directir? and where can i find the same for the MAYA software';?... -
MikerRoo #2
Re: Using SES Converter on CF Server
Are you sure that gender=1&brand=0&era=1 appears in your address bar when you
test at home?
(You're building the link using CGI.Query_String instead if your nicely
CFparam'd URL vars.)
What CF version are you running at home?
What is the rest of the code that generates the actual <a> tag?
MikerRoo Guest



Reply With Quote

