Using SES Converter on CF Server

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default 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

  2. Similar Questions and Discussions

    1. 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...
    2. 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...
    3. .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...
    4. 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...
    5. 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';?...
  3. #2

    Default 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

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139