Auto fill form fields using coldfusion

bonneylake · #1 August 15th, 2008, 03:24 PM

Hey Everyone,

Well i don't know if my question should be in javascript/ajax or coldfusion, i figure this is more of a coldfusion question. But if this is in the wrong section let me know an all gladly delete my question an put it in the correct section.

Well what i am trying to do is pretty simple. I have a input field and someone starts typing in a customer number. As they type in the customer number the drop down box is populated. They then click on the drop down box an the rest of the form is populated (it gets all the information from a database).

I found a script online that does almost exactly what i want to do except it is in php. I have found an example of this in every language except coldfusion and well i must admit i am not good at converting code from one language to another.

But anyway i was wondering if anyone could provide me with an example on how i would do this in coldfusion instead of php? or if you know of a tutorial,forum, or example online i could look at?

Here is the example page
http://www.dhtmlgoodies.com/scripts/...nt-lookup.html

an here is the code
http://www.dhtmlgoodies.com/index.ht..._client_lookup

i already created the drop down box part of this (since it is missing in the
the example above), but like i said i just can't figure out how i would populate it using my coldfusion database. Here is what i got for the drop down box

here is coldfusion/html

Expand|Select|Wrap|Line Numbers

 <cfquery name="getcustnum" datasource="CustomerSupport">

usp_CS_Getcontacts

</cfquery>

<HTML>

<HEAD>

    <TITLE>JavaScript Toolbox - Auto-Complete</TITLE>

<SCRIPT LANGUAGE="JavaScript" SRC="autocomplete.js"></SCRIPT>

</HEAD>

<BODY BGCOLOR=#FFFFFF LINK="#00615F" VLINK="#00615F" ALINK="#00615F">

<FORM>

Customer Number*

<INPUT TYPE="text" NAME="input1" VALUE="" ONKEYUP="autoComplete(this,this.form.options,'value',true)" onChange="validate(this.form.custnum,'Customer Number')">

<SELECT NAME="options" 

onChange="this.form.input1.value=this.options[this.selectedIndex].value" onclick="">

<cfoutput query="getcustnum">

<option value="#fk_custNum#">#fk_custNum#</option>

</cfoutput>

</SELECT>

Company Name:<input type="text" name="compname"  size="20" id="compname"/>

First Name:<input type="text" name="fname"  size="20" id="fname"/>

Last Name:<input type="text" name="lname"size="20" id="lname"/>

</FORM>

</BODY>

</HTML>

here is the javascript

Expand|Select|Wrap|Line Numbers

 function autoComplete (field, select, property, forcematch) {

    var found = false;

    for (var i = 0; i < select.options.length; i++) {

    if (select.options[i][property].toUpperCase().indexOf(field.value.toUpperCase()) == 0) {

        found=true; break;

        }

    }

    if (found) { select.selectedIndex = i; }

    else { select.selectedIndex = -1; }

    if (field.createTextRange) {

        if (forcematch && !found) {

            field.value=field.value.substring(0,field.value.length-1); 

            return;

            }

        var cursorKeys ="8;46;37;38;39;40;33;34;35;36;45;";

        if (cursorKeys.indexOf(event.keyCode+";") == -1) {

            var r1 = field.createTextRange();

            var oldValue = r1.text;

            var newValue = found ? select.options[i][property] : oldValue;

            if (newValue != field.value) {

                field.value = newValue;

                var rNew = field.createTextRange();

                rNew.moveStart('character', oldValue.length) ;

                rNew.select();

                }

            }

        }

    }

But thank you in advance :),
Rach

acoder · #2 August 15th, 2008, 04:20 PM

For the populating of the dropdown box and the text boxes, you will need JavaScript. If you're having problems with that part, start a new thread in the JavaScript forum.

For getting the values from the database, you will obviously need Coldfusion. If you want to convert that PHP file to Coldfusion, it's not that difficult, though I don't like how it's done. There's a better way if you're interested.

bonneylake · #3 August 15th, 2008, 04:56 PM

Hey Acoder,

definately interested if you have a better way to go about getting the values from the database. I think i can figure out the javascript part, just very lost on the coldfusion part.

Thanks in advance,
Rach

acoder · #4 August 15th, 2008, 05:09 PM

The better way would involve not outputting JavaScript to be eval-ed as in the example you linked to. You can output HTML to be inserted directly, or XML or JSON to be parsed.

From what you've described, it seems you're going to make two requests. One to populate the drop down and the second one to populate the fields. Are the options from a database too?

bonneylake · #5 August 15th, 2008, 05:17 PM

yes the options come from the database as well.

acoder · #6 August 15th, 2008, 07:19 PM

You'll need to files then. Let's deal with populating the drop down first.

You have a simple query which gets the values for the options, then you use cfloop to loop over and display the options, e.g.

Expand|Select|Wrap|Line Numbers

 <cfloop ...>

<option value="<cfoutput>#val#</cfoutput>"><cfoutput>#opttext#</cfoutput>

</cfloop>

then in your client-side code, you just set the innerHTML of the select element. An alternative is to output XML or JSON which you can parse.

bonneylake · #7 August 15th, 2008, 08:14 PM

Acoder,

Well i sorta understand what your saying. But wanted to ask would this drop down i had already created work? because this gets the information from the table for the drop down the way i have it, just kinda curious what the difference is.

Expand|Select|Wrap|Line Numbers

 <cfquery name="getcustnum" datasource="CustomerSupport">

usp_CS_Getcontacts

</cfquery>
 
<SELECT NAME="options" >

<cfoutput query="getcustnum">

<option value="#fk_custNum#">#fk_custNum#</option>

</cfoutput>

</SELECT>

an with the innerHTML i am a bit baffled on how i would go about that. But i am going to do some research on what you have said :).

But thank you for all the help you have given me :)
Rach

acoder · #8 August 16th, 2008, 01:29 PM

Oh I see. So you already have that working. In that case, you only need to make one request onchange. Now what you output in the Coldfusion file depends on how you're going to code the client-side JavaScript part. You could use XML or JSON, or you could just output a string delimited by a special character and use the split() method in JavaScript to split the string into an array to fill the separate fields.

bonneylake · #9 August 18th, 2008, 03:29 PM

Hey Acoder,

Sorry for the slow response. Well the only thing i am not understanding is the coldfusion side of this. I am pretty sure i could figure out the javascript side if i understood the coldfusion side.

What i am confused on is how would i get that information from the database? Like the only stored procedures i have created so far is a insert and a update. An i am use to having my form on one page an click submit an takes me to another page to insert (i am still very new to coldfusion as you can tell).I don't know if this would help but this is my cfquery for inserting the contact which shows the felds i am dealing with

Expand|Select|Wrap|Line Numbers

 <cfquery name="insertcontacts" datasource="CustomerSupport">

exec usp_CS_Insertcontacts  '#Form.custnum#','#Form.compname#','#Form.fname#',

'#Form.lname#','#Form.address#','#Form.city#','

#Form.state#','#Form.zip#','#Form.email#','#Form.priphone#',

'#Form.secphone#','#Form.custnotes#'

</cfquery>

but sorry if this don't make much since, been a long weekend. If you need me to explain anymore just ask an all gladely try to.

Thank you very much for all the help,
Rach

acoder · #10 August 18th, 2008, 07:25 PM

You need a select query and pass in the customer number, e.g. #url.custnum#, so when you make an Ajax request, say getCustDetails.cfm?custnum=123, the code would output the values.

bonneylake · #11 August 18th, 2008, 08:13 PM

Hey Acoder,

I am trying. but i must admit this is way over my head. I am pretty new to coldfusion an javascript combined an i must admit i am really lost.This is what i have done, which i know it don't work or is right. But this is how much i am understanding.

Expand|Select|Wrap|Line Numbers

 <script type="text/javascript">

function add(){

<cfquery name="custnum" datasource="CustomerSupport">

select * from tbl_CS_contacts

where fk_custNum=fk_custnum

</cfquery>

}

</script>

<SELECT NAME="options" onclick="javascript:add();">

<cfoutput query="getcustnum">

<option value="#fk_custNum#">#fk_custNum#</option>

</cfoutput>

</SELECT>

Company Name:<input type="text" name="compname"  size="20" id="compname"/>

First Name:<input type="text" name="fname"  size="20" id="fname"/>

Last Name:<input type="text" name="lname"size="20" id="lname"/>

but wanted to ask if you knew of a website that could explain select query better to me? or even a suggested way i could search for my problem online? because i must admit i am very lost.

Thanks again,
Rach

acoder · #12 August 19th, 2008, 11:21 AM

Let's start at the beginning then. You've got something that works, so let's use that instead. Coldfusion can only run while the page is loading, not afterwards (unless you use Ajax to call a separate Coldfusion page). Let's get that working first, then you can worry about the JavaScript later.

The "custnum" query is fine except that it should be on a separate page (rather like the PHP file) and you need to use ## signs to refer to the passed value, e.g.

Expand|Select|Wrap|Line Numbers

 <cfquery name="custnum" datasource="CustomerSupport">

select * from tbl_CS_contacts

where fk_custNum=#url.custnum#

</cfquery>

Then use cfoutput to loop over the query to output the values. This file you can call getClient.cfm to replace getClient.php.

bonneylake · #13 August 19th, 2008, 07:12 PM

Acoder,

First off thank you for all the patience you are having with me, really appreciate it :).

Ok so i tried to do what you said (not at work today so i can't test it). But here is what i came up with, this is on my getClient.cfm page

Expand|Select|Wrap|Line Numbers

  <cfquery name="custnum" datasource="CustomerSupport">

select * from tbl_CS_contacts

where fk_custNum=#url.custnum#

</cfquery>
 
<cfoutput query = "CustomerSupport">

#compname#

#fname#

#lname#

#add1#

#city#

#state#

#zip#

#email#

#pri_phone#

#sec_phone#

#notes#

</cfoutput>

I am not sure if i did this right (if i didn't i am sorry in advance). But i was wondering when i do the cfoutput query inbetween like where i have #fname# is that suppose to be the name of the column in the database or is it suppose to be the name of the field in the form? because when i do a stored procedure an i do an insert i am use to doing #Form.(name i gave the input)#.

An also wanted to ask do i need to put fk_custNum in the cfoutput as well? An well not sure if i did the loop part right, use to doing it a very different way. But i looked up what you said an it said this loops through the query. This is the example of the website i found http://livedocs.adobe.com/coldfusion...s/tags-b12.htm

But wanted to also mention this one part, probably should of mentioned it earlyer. but i been trying to do it by myself before asking for help.what i am trying to do is create a stored procedure for the contacts table that if the customer number already exists it wont create a record in the table, but if it doesn't exist it will create a record in the table (trying to prevent duplicates). But wanted to ask if what we are doing on will affect this or if i need the stored procedure before this? an also wanted to ask if you knew of an example that does something similar to what i am doing, was thinking about trying if exists, an looked up if exists. but most of the examples show if exists create other wise update an don't need it to update.

But thank you in advance for all the help an the patience you are having with me you have no idea how much i appreciate this :) Thank you
Rach

Quote:

Originally Posted by acoder

Let's start at the beginning then. You've got something that works, so let's use that instead. Coldfusion can only run while the page is loading, not afterwards (unless you use Ajax to call a separate Coldfusion page). Let's get that working first, then you can worry about the JavaScript later.

The "custnum" query is fine except that it should be on a separate page (rather like the PHP file) and you need to use ## signs to refer to the passed value, e.g.

Expand|Select|Wrap|Line Numbers

 <cfquery name="custnum" datasource="CustomerSupport">

select * from tbl_CS_contacts

where fk_custNum=#url.custnum#

</cfquery>

Then use cfoutput to loop over the query to output the values. This file you can call getClient.cfm to replace getClient.php.

bonneylake · #14 August 19th, 2008, 10:32 PM

Acoder,

First off thank you for all the patience you are having with me, really appreciate it :).

Ok so i tried to do what you said (not at work today so i can't test it). But here is what i came up with, this is on my getClient.cfm page

Expand|Select|Wrap|Line Numbers

  <cfquery name="custnum" datasource="CustomerSupport">

select * from tbl_CS_contacts

where fk_custNum=#url.custnum#

</cfquery>
 
<cfoutput query = "CustomerSupport">

#compname#

#fname#

#lname#

#add1#

#city#

#state#

#zip#

#email#

#pri_phone#

#sec_phone#

#notes#

</cfoutput>

I am not sure if i did this right (if i didn't i am sorry in advance). But i was wondering when i do the cfoutput query inbetween like where i have #fname# is that suppose to be the name of the column in the database or is it suppose to be the name of the field in the form? because when i do a stored procedure an i do an insert i am use to doing #Form.(name i gave the input)#.

An also wanted to ask do i need to put fk_custNum in the cfoutput as well? An well not sure if i did the loop part right, use to doing it a very different way. But i looked up what you said an it said this loops through the query. This is the example of the website i found http://livedocs.adobe.com/coldfusion...s/tags-b12.htm

But wanted to also mention this one part, probably should of mentioned it earlyer. but i been trying to do it by myself before asking for help.what i am trying to do is create a stored procedure for the contacts table that if the customer number already exists it wont create a record in the table, but if it doesn't exist it will create a record in the table (trying to prevent duplicates). But wanted to ask if what we are doing on will affect this or if i need the stored procedure before this? an also wanted to ask if you knew of an example that does something similar to what i am doing, was thinking about trying if exists, an looked up if exists. but most of the examples show if exists create other wise update an don't need it to update.

But thank you in advance for all the help an the patience you are having with me you have no idea how much i appreciate this :) Thank you
Rach

Quote:

Originally Posted by acoder

Let's start at the beginning then. You've got something that works, so let's use that instead. Coldfusion can only run while the page is loading, not afterwards (unless you use Ajax to call a separate Coldfusion page). Let's get that working first, then you can worry about the JavaScript later.

The "custnum" query is fine except that it should be on a separate page (rather like the PHP file) and you need to use ## signs to refer to the passed value, e.g.

Expand|Select|Wrap|Line Numbers

 <cfquery name="custnum" datasource="CustomerSupport">

select * from tbl_CS_contacts

where fk_custNum=#url.custnum#

</cfquery>

Then use cfoutput to loop over the query to output the values. This file you can call getClient.cfm to replace getClient.php.

acoder · #15 August 19th, 2008, 10:37 PM

Quote:

Originally Posted by bonneylake

But i was wondering when i do the cfoutput query inbetween like where i have #fname# is that suppose to be the name of the column in the database or is it suppose to be the name of the field in the form?

The name of the column in the table.

Quote:

Originally Posted by bonneylake

An also wanted to ask do i need to put fk_custNum in the cfoutput as well?

The loop looks OK, but will need to be modified for use in the JavaScript. Try this page on its own without Ajax with example input (custnum=***) and see what you get.

Quote:

Originally Posted by bonneylake

But wanted to also mention this one part...

For this question, ask in the relevant database forum. Which db are you using?

bonneylake · #16 August 20th, 2008, 02:30 PM

Acoder,

i just got one question about the try to do this without ajax. Ok so am i suppose to be using the dropdown i created or am i suppose to be using the link i had put at the beginning of my question http://www.dhtmlgoodies.com/scripts/...nt-lookup.html ?

i tried to do it using my dropdown but i really don't know how i would do this.

here is what i tried

Expand|Select|Wrap|Line Numbers

 <cfquery name="getcustnum" datasource="CustomerSupport">

usp_CS_Getcontacts

</cfquery>
 
<HTML>

<HEAD>

    <TITLE>JavaScript Toolbox - Auto-Complete</TITLE>

<SCRIPT LANGUAGE="JavaScript" SRC="autocomplete.js"></SCRIPT>

<script type="text/javascript">
 
</script>

</HEAD>

<BODY BGCOLOR=#FFFFFF LINK="#00615F" VLINK="#00615F" ALINK="#00615F">

<FORM action="getClient.cfm" method="POST">

Customer Number*

<INPUT TYPE="text" NAME="input1" VALUE="" ONKEYUP="autoComplete(this,this.form.options,'value',true)" onChange="validate(this.form.custnum,'Customer Number')">

<SELECT NAME="options" 

onChange="this.form.input1.value=this.options[this.selectedIndex].value" onclick="javascript:add();">

<cfoutput query="getcustnum">

<option value="#fk_custNum#">#fk_custNum#</option>

</cfoutput>

</SELECT>

Company Name:<input type="text" name="compname"  size="20" id="compname"/>

First Name:<input type="text" name="fname"  size="20" id="fname"/>

Last Name:<input type="text" name="lname"size="20" id="lname"/>

</FORM>

</BODY>

</HTML>

an the table i am using is dbo.tbl_CS_contacts. I mean i created a stored procedure that inserts i just can't figure out how to make it where if the customer id already exist don't insert. This is what i got so far

Expand|Select|Wrap|Line Numbers

 set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go
 
-- =============================================

-- Author:        <Author,,Name>

-- Create date: <Create Date,,>

-- Description:    <Description,,>

-- =============================================

ALTER PROCEDURE [dbo].[usp_CS_Insertcontacts]

    -- Add the parameters for the stored procedure here

      (@fk_custNum nvarchar(50),

       @cust_company nvarchar(75),

       @fname nvarchar(50),

       @lname nvarchar(50),

       @add1 nvarchar(50),

       @city nvarchar(50),

       @state nvarchar(5),

       @zip nvarchar(15),

       @email nvarchar(100),

       @pri_phone nvarchar(15),

       @sec_phone nvarchar(15),

       @notes nvarchar(500)

)

AS

declare @pk_contactID nvarchar(55)

set @pk_contactID = (select max_num from tbl_CS_ID_HELPER where table_name='tbl_CS_contacts')

update tbl_CS_ID_helper set max_num=max_num+1 where table_name='tbl_CS_contacts'

BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    SET NOCOUNT ON;
 
    -- Insert statements for procedure here
 
insert into tbl_CS_contacts

(pk_contactID,fk_custNum,cust_company,fname,lname,add1,city,state,

zip,email,pri_phone,sec_phone,notes)
 
values

(@pk_contactID,@fk_custNum,@cust_company,@fname,@lname,@add1,@city,@state,

@zip,@email,@pri_phone,@sec_phone,@notes)
 
select @pk_contactID as contactID

END

Thanks in advance,
Rach

acoder · #17 August 20th, 2008, 04:28 PM

You can test by just typing into your address bar, e.g. say a valid custnum is 123, then you'd test by typing http://pathtosite/getClient.cfm?custnum=123.

bonneylake · #18 August 20th, 2008, 04:56 PM

Acoder,

Ok i tested it. An well i get this.

QUERY

The QUERY attribute of the tag does not specify the name of an available query

The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (5:7) to (5:42) in the template file C:\Inetpub\Development\WWWRoot\RachelB\footprints\ form\getClient.cfm.

but here is the code i got in the getClient.cfm file.

Expand|Select|Wrap|Line Numbers

 <cfquery name="custnum" datasource="CustomerSupport">

      select * from tbl_CS_contacts

      where fk_custNum=#url.custnum#

      </cfquery>

      <cfoutput query = "CustomerSupport">

      #cust_company#

      #fname#

      #lname#

      #add1#

      #city#

      #state#

      #zip#

      #email#

      #pri_phone#

      #sec_phone#

      #notes#

      </cfoutput>

which does fk_custNum need to be in the cfoutput?but where to go from here?

Thank you,
Rach

acoder · #19 August 20th, 2008, 06:00 PM

You used the data source name instead of the query name in the cfoutput tag.

bonneylake · #20 August 20th, 2008, 06:58 PM

Acoder,

All i can say is wow that is impressive!!! I have tried so many times to just use cfoutput query (for other projects) an never had any luck an surely thought it would never work but its awesome to see it work!!! No errors an worked like a charm. but that is pretty cool i never thought you could do that wow! But ok what is next??? i am so excited now lol.

Thank you for all the help i am learning so much :)
Rach

acoder · #21 August 20th, 2008, 09:11 PM

The next step is to output what the Ajax/JavaScript code expects, e.g. in the PHP file:

Expand|Select|Wrap|Line Numbers

echo "formObj.firstname.value = '".$inf["firstname"]."';\n";

would become

Expand|Select|Wrap|Line Numbers

formObj.firstname.value = "#firstname#";

and so on.

bonneylake · #22 August 20th, 2008, 09:33 PM

Acoder

ok so this is what i got in getClient.cfm

Expand|Select|Wrap|Line Numbers

 <cfquery name="custnum" datasource="CustomerSupport">

      select * from dbo.tbl_CS_contacts

      where fk_custNum=#url.custnum#

      </cfquery>

      <cfoutput query = "custnum">

      #cust_company#

      #fname#

      #lname#

      #add1#

      #city#

      #state#

      #zip#

      #email#

      #pri_phone#

      #sec_phone#

      #notes#

      </cfoutput>
 
      if {

      formObj.custnum.value = "#custnum#";

      formObj.compname.value = "#compname#";

      formObj.fname.value = "#fname#";

      formObj.lname.value = "#lname#";

      formObj.address.value = "#address#";

      formObj.city.value = "#city#";

      formObj.state.value = "#state#";

      formObj.zip.value = "#zip#";

      formObj.email.value = "#email#";

      formObj.priphone.value = "#priphone#";

      formObj.secphone.value = "#secphone#";

      formObj.custnotes.value = "#custnotes#";

      custnotes

      }

       else {

      formObj.custnum.value = "";

      formObj.compname.value = "";

      formObj.fname.value = "";

      formObj.lname.value = "";

      formObj.address.value = "";

      formObj.city.value = "";

      formObj.state.value = "";

      formObj.zip.value = "";

      formObj.email.value = "";

      formObj.priphone.value = "";

      formObj.secphone.value = "";

      formObj.custnotes.value = "";

      }

i know theres still something missing to it. i was trying to figure it out look at the php. the only thing i think i am missing is this.

Expand|Select|Wrap|Line Numbers

 if(isset($_GET['getClientId'])){  

  $res = mysql_query("select * from ajax_client where clientID='".$_GET['getClientId']."'") or die(mysql_error());

  if($inf = mysql_fetch_array($res)){

but not sure how to convert this part to coldfusion. like everything past mysql_error is what i feel like i am missing because i see select an know i got select in what i have now. But is there anything else that needs to be added to this.

Thank you,
Rach

acoder · #23 August 20th, 2008, 09:48 PM

Not quite like that. The code that you have in if { ...} needs to replace the cfoutput query code. The rest (setting empty string) is when custnum is not set or the query returns no records.

bonneylake · #24 August 21st, 2008, 03:11 PM

Acoder,

alright so does that me the empty strings need to be in the cfoutput query as well?this is what i got. anything else it needs?

Expand|Select|Wrap|Line Numbers

 <cfquery name="custnum" datasource="CustomerSupport">

      select * from dbo.tbl_CS_contacts

      where fk_custNum=#url.custnum#

      </cfquery>

      <cfoutput query = "custnum">

      if {

      formObj.custnum.value = "#custnum#";

      formObj.compname.value = "#compname#";

      formObj.fname.value = "#fname#";

      formObj.lname.value = "#lname#";

      formObj.address.value = "#address#";

      formObj.city.value = "#city#";

      formObj.state.value = "#state#";

      formObj.zip.value = "#zip#";

      formObj.email.value = "#email#";

      formObj.priphone.value = "#priphone#";

      formObj.secphone.value = "#secphone#";

      formObj.custnotes.value = "#custnotes#";

      custnotes

      }

       else {

      formObj.custnum.value = "";

      formObj.compname.value = "";

      formObj.fname.value = "";

      formObj.lname.value = "";

      formObj.address.value = "";

      formObj.city.value = "";

      formObj.state.value = "";

      formObj.zip.value = "";

      formObj.email.value = "";

      formObj.priphone.value = "";

      formObj.secphone.value = "";

      formObj.custnotes.value = "";

      }

      </cfoutput>

Thank you again,
Rach

acoder · #25 August 21st, 2008, 03:24 PM

No, there's no "if { ... } else {..." in Coldfusion unless using cfscript. In Coldfusion you have <cfif> and <cfelse>. Also don't forget that you need conditions.

Use cfparam to default to the empty string on url.custnum. In the cfif you need to check that url.custnum is not empty and also that the query recordcount is not 0. If both those conditions are met, then you can output the values from the query, otherwise set all the form fields to empty in the cfelse part.

Note: some of this stuff is basic. It might be a good idea to go through some tutorials, e.g. the ones on the Adobe website.

bonneylake · #26 August 21st, 2008, 04:49 PM

Acoder,

I have a coldfusion book that i have been using. An i have read most of the book . I have only been doing coldfusion (and javascript) for a few months an only know the extreme basics. An i have been trying my best to understand an do everything best i can based on what i got. I have dealt with both cfif and cfparam before but i must admit i am stuck on how to do it as you are describing.

This is what i tried with cfparam

Expand|Select|Wrap|Line Numbers

<cfparam name="custnum" default="?url.custnum">

with the cfif i am going to do some more research. i believe i know how to check if custnum is empty but completely baffled on how to check the recordcount with it.

but thank you for the help,
Rach

acoder · #27 August 21st, 2008, 05:53 PM

The cfparam would be something like:

Expand|Select|Wrap|Line Numbers

<cfparam name="url.custnum" default="">

For checking the recordcount, just use queryname.RecordCount (see link for CF8).

bonneylake · #28 August 21st, 2008, 07:11 PM

Acoder,

Ok i thought of a few ways i thought this could be done but unsure which way would be correct (or if any correct). Also was not sure if i was suppose to use isDefined or if i was suppose to use cfif custnum eq "". But here is a few ways i thought of.

way 1

Expand|Select|Wrap|Line Numbers

  <cfoutput = "custnum">

      <cfif isDefined("custnum")> 

*fields*

      <cfelse>

*fields*

      </cfif>

      </cfoutput>

way 2

Expand|Select|Wrap|Line Numbers

 <cfoutput = "custnum">

      <cfif custnum.recordcount IS 0> 

*fields*

      <cfelse>

*fields*

      </cfif>

      </cfoutput>

way 3

Expand|Select|Wrap|Line Numbers

 <cfoutput = "custnum">

      <cfif isDefined("custnum")> 

*fields*

      <cfelse custnum.recordcount IS 0>

*fields*

      </cfif>

      </cfoutput>

way4

Expand|Select|Wrap|Line Numbers

  <cfoutput = "custnum">

      <cfif> 

*fields*

      <cfelse custnum eq "">

*fields*

      </cfif>

      </cfoutput>

i even thought of maybe i could do something like