Adobe Community : All Content - All Communities

Ordering data type varchar

forums_noreply@adobe.com — Wed, 12 Nov 2014 20:25:49 GMT

I keep forgetting on how to order a column with datatype varchar

One of my column for pricing has these values: 5,12,15,18,21,23,31 etc when I cfoutput my query result I got the list showing as: 12,15,18,21,23,31,5

It should be from less price to higher prices: 5,12,15,18,21,23,31 but I can't make this happening because the datatype for this column is varchar.

I know there is a way around but I can't remember, can someone help me?

My query is real simple:

select ranges, prices

from fees

order by prices and this doesn't work

Using NVL in Query of Query resulting in error

forums_noreply@adobe.com — Tue, 21 Oct 2014 21:46:43 GMT

I'm still using CF8 and Oracle 11G back-end.

When I use NVL in the query of query I got error....Can't I use NVL to check on null value? Please help

Here is my codes:

SELECT CamID2, rel2_2,p_ln2,p_fn2,ins,l_year

FROM prt_temp

WHERE Ins = 'CC'

AND l_year = '1481'

	AND NVL(Child_LN2,' ') <> ' '
	AND NVL(Child_FN2,' ') <> ' '

</cfquery>

	<cfif GetC2.Recordcount NEQ 0>
	<cfquery name="CheckRel2C2" dbtype="QUERY">
	SELECT CamID2, rel2_2
	FROM GetC2
	WHERE NVL(Rel2_2,' ') <> ' '
	AND NVL(p_ln2,' ') = ' '
	AND NVL(p_fn2,' ') = ' '
	AND Ins = 'CC'
	AND l_year = '1481'
	</cfquery>

</cfif>

The error:

Error Executing Database Query.

Query Of Queries syntax error.

Encountered "NVL ( Rel2_2 ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,

Purchased ColdFusion 10: Having problem with session variables

forums_noreply@adobe.com — Mon, 23 Jun 2014 17:43:40 GMT

My Dept. has just bought CF10 and I'm finally updating my existing web app to CF10 from CF8. My First Problem with CF10 is using session variables.

When using the lower version of CF (since CF 4 to 8) I have never had any problem setting up session variables and getting or using these variables in other pages after a successful login but with CF 10 it seems setting session variables and using them in other pages are a major problems. I'm not sure where have I done wrong in the codes.

First I'm setting the session in my Application.cfc This way:

	<cfset THIS.Name ="MyNewApp"/>
	<cfset THIS.ApplicationTimeout = CreateTimeSpan(0,0,20,0) />
	<cfset THIS.SessionManagement ="YES"/>
	<cfset THIS.SessionTimeout = CreateTimeSpan( 0, 0, 20, 0 ) />
	<cfset THIS.SetClientCookies = false />

</cffunction>

</cffunction>

		<cfset session.loggedin = "NO">
		<cfset session.username = "">
		<cfset session.userrights = "">
		<cfset session.usergroup = "">

</cffunction>

</cfcomponent>

After login, user is validated and set values to those session.variables:

........user validation codes here......................

<cfabort

	<CFSET qUserGroup = LoginObj.getUserGroup('#Trim(Form.username)#')>
	<cfloop query="qUserGroup">
	<cfset session.usergroup = user_group>
	<cfbreak>
	</cfloop>

<!--- ****************** ???????????????????????????????????????????????????????????????????????????

When I do cfdump in at this level, I can see that all of these session variables have been assigned to their values.

But these session variables are not accessible from other pages. Other pages still show these session variable without its value.

So, when I use these cfdumps in the index.cfm it is shown as they're not yet assigned with any values ****************** --->

</cfif>

In index.cfm, Before Login I got:

session.loggedin = NO

session.username = ["empty string"]

session.userrights = ["empty string"]

session.usergroup = ["empty string"]

After a successful Login:

session.loggedin = NO

session.username = ["empty string"]

session.userrights = ["empty string"]

session.usergroup = ["empty string"]

Have I done something wrong? These codes work on CF8. Please help.

I need to mentioned:

CF10 is in Linux and my web app is under https not http. But these session variables should be shared bentween http and https because some older application are still in http.

Moving to CF10, Need help with Application.cfc

forums_noreply@adobe.com — Wed, 23 Apr 2014 20:44:58 GMT

I've been googling about how to work with Application.cfc since last week but I still have some questions and I can't find the answers.

My application is under the root (in unix) and there are many subfolders underneath it. Each sub-folder is hosting a different web application.

From what I read, I can create 1 root Application.cfc and then on subsequent sub-folder, when I need to have another Application.cfc on that level, I can create ProxyApplication (see below) and then create a sub-folder level Applicatin.cfc

So, when I set an application.DSN on my root Application.cfc, using proxyApplication I don't have to reset this dsn again in my sub folder level Application.cfc

Since my loginform.cfm and loginaction.cfm is right under root directory too, I also set OnsessionStart in the root Application.cfc to handle user login. Then this means, I don't have to reset session variable again anywhere because session.username, etc has been set on the highest level.

Is this correct?

In addition, Am I correct when I do the following:

1. Since I have root level and sub-folder level Application.cfc, I should set this.name with a different name, am I right?

On the root Application.cfc I set this.name = "StudentServices" because this represent the global application

On the sub-folder level's Application.cfc, I set this.name to "StudentServices_stdLoad" becaus this sub-folder only handle student load application.

2. On the root Application.cfc, I set the DSN to the application scope. So on the sub-folder level Application.cfc I can check if a particular db is working or not

because as awhole, in the global sense, this web application uses more than one Databases. Each sub-folder may use a database that is dfferent than the other sub folder.

Am I doing the right thing? Please advice

Below is example of what I have, Thank you!

I created a root Application.cfc under the root directory:

</cffunction>

</cffunction>

</CFCOMPONENT>

Then, in this root directory I also created a ProxyApplication:

</cfcomponent>

Then in the Sub-Directory, I can create a sub-folder level Application.cfc extending the root Application.cfc:

<cftry>

SELECT Count(*)

FROM MyTable

cfquery>

</cfcatch>

</cftry>

</cffunction>

</CFCOMPONENT>

</cffunction>

</cffunction>

Accessing Login page from CF

forums_noreply@adobe.com — Fri, 24 Jan 2014 16:23:47 GMT

My dept is using one asp web app and one cf web app.

Both apps. kind of related, many people use both, sometimes at the same time.

To access these two apps, admin and users are using the same username and password.

I'm trying to build a login interface on the CF app. for users to login into the asp application, eliminating the need for users to open

another when they are already in the CF app.

So I use CF Hot Link technique (using cfhttp url="url for the asp login UI"> and I got the asp login screen show up on my CF web app.

How can I get this login "talk" to the action page on the asp side? is it even possible?

Thanks,

Alec

How to validate a series of 0s value

forums_noreply@adobe.com — Wed, 13 Nov 2013 15:39:43 GMT

I'm trying validate values such as 0 or 00 or 000 or 0000, or 000000 up to 10 digits.

I can use <cfif varId IS "0" OR varId IS "00" OR varId IS "000" etc> but I believed there should be a better and more elegant way to do this.

I need to reject anyone of these value from entering my database table.

Can anyone help?

Thank you!

StructIsEmpty function, help!

forums_noreply@adobe.com — Tue, 22 Oct 2013 16:55:43 GMT

I'm passing a structure to a function for req. fields validation but I first check whether or not my structure is empty.

If all element in my structure is empty I don't pass this structure to the validation function.

So I use StructIsEmpty to check my structure.

The problem is, when my Structure's elements contain only empty string, StructIsEmpty return "NO"

How can I have StructIsEmpty to return YES when all of the structure element is an empty string?

<CFINVOKE component="cfcomponents.ValidateFields" method="CheckReqFields"

st_MyStruct="#st_MyStruct#"

Inst="#arguments.Inst#" >

</cfif>

How to get date 30 days from existing date?

forums_noreply@adobe.com — Wed, 17 Jul 2013 01:51:22 GMT

I found this codes from this forum:

#dateformat(dateadd('d', 30, now()),'dd-mmm-yyyy h:mm:ss')# This code works but unfortunately I'm not using Now(). Instead I need to use a user entered Date such as Departure Date, something like 07/06/2013

When I use the above code with my DepartureDate instead of Now() I got a java.util.date error

#dateformat(dateadd( "d", 30, "DepartureDate" ),'dd-mmm-yyyy h:mm:ss')#

When I get rid of the double quotes in 3rd parameter, I did not get error but the result date is wrong:

When DepartureDate is 07/16/2013,I got 08/30/2013

How can I easily add 30 days to my DepartureDate?

Thanks

#dateformat(dateadd( "d", 30, DepartureDate ),'dd-mmm-yyyy h:mm:ss')#

Advice and code sample

forums_noreply@adobe.com — Tue, 04 Jun 2013 15:31:22 GMT

I need some help with my task, hopefully someone out there had done this before and don't mind sharing.

My department is using a Visual Basic app (this app is here since before I came) and a CF web app (I'm responsible for this one).

The CF app is a supplement to the VB app. Any functionality that is not in VB app. is created in CF so user can go back and forth between the two app. This VB app is maintain by sunggard and it's quite complicated.

Now Sunggard is changing it into dot net web app, the VB need to retire. We'll end up with 2 web apps, one dot net and one CF

Both apps use the same tables/DB.

User use the same username and password to login to both apps.,The password is hashed.

Is it possible to combine both application in the login process level? meaning, when users log in to either one app they can access both app without having to login twice at 2 different places like now? how can I achieve this goal? some sample codes is really helpful. I'm not a dot net developer, I'm hired to do CF so I'm not familiar with dot net.

Connecting CF8 to Oracle 11g with JDBC

forums_noreply@adobe.com — Wed, 10 Apr 2013 15:18:59 GMT

I created a datasource from my CF admin using JDBC/Oracle Thin Client. The datasource creation was successful.

When Oracle encryption is configured as "Requested" I can browse my CF app. and ran many functionalities with no problem

But when the Oracle encryption is configured as "Required" the connection failed.

The way I tested and know that it was failed was when I login in to my web app. It won't log me in. But when the Oracle is switched back as "Requested"

I can login successfully and ran may tasks.

I have CF8 Enterprise version in Unix

From the network dept, I was told they have the correct JAR file in place but did not tell me what is the correct JAR file

Currently my web apps are running with datasource created using Oracle Thin Clint but the Oracle encryption needs to be switched back to "Requested" otherwise my users are complaining that they can't login.

Where should I go from here???? has anyone ever experienced this situation and found a solution? What is going on with my situation, what should I do to fix Please help.

Please help with getting the result back from a procedure

forums_noreply@adobe.com — Tue, 13 Nov 2012 15:23:56 GMT

I'm using CF8 and Oracle 11g

I've been calling Oracle procedure many manyy times from CF <cfstoreproc with no problem.

I even get the result back from calling an Oracle Package. But since yesterday I can't get the result back from calling this str. procedure. I even get an error that says:

Error Executing Database Query.

[Macromedia][Oracle JDBC Driver]Unhandled sql type

The error occurred in /space/users/www/mywebdir/test/cbiorpt.cfm: line 22

20 : <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="#Trim(Form.Year)#"> 21 :

22 : <cfprocresult name="q_bio">

23 :

24 : </cfstoredproc>

This is how I call the procedure and try to capture the result back:

--------------------------------------------------------------------------
   <cfstoredproc procedure="SP_STRpt" datasource="#Application.DSN#" returncode="yes">
     <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="#Trim(FORM.Inst)#">
     <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="#Trim(Form.Year)#">

   </cfstoredproc>

   <cfdump var="#q_bio#">

This is the top part of my procedure:

--------------------------------------------

create or replace PROCEDURE "SP_STRpt" (

Inst IN VARCHAR2,

year IN VARCHAR2,

q_bio OUT SYS_REFCURSOR)

BEGIN

sql script here ...

RETURN;

END;

When I called this procedure right from SQLDeveloper using this call (see below), it works & I got all the results I wanted but when I use cfstoreproc tag I got that error even when I hardcoded the IN values:

This script works on SQL Developer:

------------------------------------------

variable x refcursor;

execute SP_STRpt (year => '1291', Inst => 'PP', q_bio => :x)

print x;

This doesn't and produce the unhandled error:

--------------------------------------------------

</cfstoredproc>

Where is the best place to set the path with Application.cfc?

forums_noreply@adobe.com — Thu, 04 Oct 2012 18:37:00 GMT

Hi!

When I used Application.cfm, I set many path variables here so I don't have to keep writing a full path on many of the templates repeatedly.

So I did:

etc...

Later on I only need to refer it as: #FileArchives# in the codes instead of a full path name.

Now that I'm using Application.cfc can I also do the same thing???? should I do it within OnApplicationStart function? am I doing it correctly? (see below)

</cffunction>

Money datatype

forums_noreply@adobe.com — Mon, 10 Sep 2012 15:25:12 GMT

I'm having a very hard time doing a simple insert and update for columns with NUMBER(38,2) and NUMBER(10,0) datatypes on Oracle.

These columns represent Cash/Donation and they used to be set as MONEY datatype and TINYINT datatype respectively (When it was on non-Oracle DB)

I used ColdFusion cf_sql_numeric, cf_sql_decimal and cf_sql_money but all gave me error such as:

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Invalid data 7,261.00 for CFSQLTYPE CF_SQL_NUMERIC.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Invalid data 7,261.00 for CFSQLTYPE CF_SQL_Double.

When I run the following:

UPDATE Tbl_Gift

SET FiscalYear =

<cfqueryparam cfsqltype="cf_sql_varchar" value="#Form.FYR#">,

CashAmount =

<cfqueryparam cfsqltype="cf_sql_numeric" value="#Cash#"> ,

DonationAmount =

etc.

I ran out of datatype to use. What else can I use for Oracle datatype NUMBER(38,2) and NUMBER(10,0) ? Please help

CFFILE COPY in ColdFusion 8

forums_noreply@adobe.com — Wed, 15 Aug 2012 18:18:21 GMT

I tried using cffile to copy a file but it doesn't work

It works when I changed the action into rename and move but when I changed back to action="copy", nothing happened. I did not get error either. It's just the file did not get copied.

The very strange thing about this is, when I use cffile action="copy" on my dev server, it works.

The problem is not on permission issues since I have the same exact permission on both servers.

Is there issues with ColdFusion 8 cffile action="copy"????? but why it works on my dev server but not on my prod. server?

I've googled since this morning and I found a few people who had the same complaint but no respond on how to solve them.

Does anyone from this community have ever had similar problem and has solution?

I'm using ColdFusion 8

My web server is in Unix

my back end is Oracle 11g

My code is pretty simp

<cffile action = "copy" destination = "C:\scratch\DEVProd1\"

source ="C:\scratch\FinProd1\" />

cfexecute and sqlldr problem

forums_noreply@adobe.com — Tue, 06 Mar 2012 12:59:55 GMT

I use cfexecute to run sqlldr in windows seccessfully. I use the same technique to do it in unix and it failed. Have debugged the problem for almost one week with no result

Oracle client has been installed on the server, path to the control file, source file have been checked and all are good but once cfexecute is run, the error pop up. I don't know what else to do

Found similar problem on the web, followed it and still did not work:

http://www.justskins.com/forums/cfexecute-and-sqlldr-run-56805.html

Here is the only code to run sqlldr that's been giving me a headache:

Here is the error I got:

The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request

An exception occurred when invoking an external process.
The cause of this exception was that: java.io.IOException: Cannot run program "sqlldr": error=2, No such file or directory.


30 : <CFFUNCTION name="RunSQLLDR"> 31 : 32 : <cfexecute name="sqlldr" arguments="DEMO@DEMO/pwd2011 control=/opt/coldfusion8/runtime/bin/my_ControlFile.ctl" timeout="500"></cfexecute> 33 : 34 : </CFFUNCTION>

Can anyone who have successfully use cfexecute for running sql loader on Oracle 11 help me?

Help with CF & Oracle

forums_noreply@adobe.com — Tue, 17 Jan 2012 18:05:41 GMT

Hi! I'm getting error on my query, I don't know why I got this error, been searching on the net and did not find any answer.

Has any of you been working with Oracle? This query runs fine on MSSQL:

DELETE EmpTbl

FROM EmpTbl, BioDataTbl

WHERE BioDataTbl.BioId = EmpTbl.EmpId

AND BioDataTbl.RegYear = EmpTbl.RegYear

AND BioDataTbl.Loc = EmpTbl.Loc

AND BioDataTbl.RegYear = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Trim(arguments.HRYear)#">

AND BioDataTbl.Loc = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Trim(session.groupLoc)#">

AND Status IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="0">,<cfqueryparam cfsqltype="cf_sql_varchar" value="x">)

</cfquery>

The error I got was:

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended

The error occurred in C:\Inetpub\wwwroot\HREmp\components\HRNot.cfc: line 13 Called from C:\Inetpub\wwwroot\HREmp\components\HRNot.cfc: line 87 Called from C:\Inetpub\wwwroot\HREmp\emptab.cfm: line 67 Called from C:\Inetpub\wwwroot\HREmp\components\HRNot.cfc: line 13 Called from C:\Inetpub\wwwroot\HREmp\components\HRNot.cfc: line 87 Called from C:\Inetpub\wwwroot\HREmp\emptab.cfm: line 67
<cfquery name="X" datasource="#Trim(arguments.DBSource)#"> 14 : DELETE EmpTbl 15 : FROM EmpTbl, BioDataTbl

How to find a carriage return and Line feed?

forums_noreply@adobe.com — Fri, 11 Nov 2011 14:04:53 GMT

I need to detect if a crriage retunr and line feed present on each row in my text file before allowing user to upload the text file

I know how to remove them from each line but what I need is to detect them no removing them from file.

Our concern is when the a row does not have carriage return and line feed.

Is there a way to find this using CF? Please help

thanks

forums_noreply@adobe.com — Mon, 27 Jun 2011 13:58:31 GMT

Hi All!
From what I learned, cfqueryparam's null attribute should be very useful for this scenario:
<CFIF IsDefined("Form.Name") AND Form.Name NEQ "">
Do this
<CFELSE>
Do That
</CFIF>

With the null attribute from cfqueryparam, we can write a clean and more elegant code like this:

<CFIF IsDefined("Form.Name") AND Form.Name NEQ "">
<CFQUERYPARAM cfsqltype="cf_sql_varchar" value="#Trim(Form.Name)#" null="#NOT Len(Trim(Form.Name))#">
</CFIF>

But when I tried it on my INSERT statement, I got error message saying that the amount of columns don't match it's values. I counted more than once
they exactly matched up.
I modified the same insert statement with values changed to use cfiif cfelse method, it worked. When I changed it back to use cfqueryparam and its null attribute, it did not work again because when form.name is blank/null, cfqueryparam did not insert the NULL value the way cfif Isdefined expression does
I also tried using yesNoFormat and still did not work.
Is this a bug?

Please help with dynamic form field names in cfloop

forums_noreply@adobe.com — Thu, 19 May 2011 16:40:29 GMT

Hi,

I need to create a form with day, date, month, year and time for 12 months

Instead of coding them 12 times, I create day,date,month,year and time fileds in my form 1 time and then I use cfloop from="1" to="12" index="i" to loop these form fields 12 times.

I gave each form field name such as: <input type="text" name="ScheduleDate_# i #" value=" "> this way each of those field will be named differently such as:

ScheduleDate_1, ScheduleDate_2,ScheduleDate_3, ScheduleTime_1,ScheduleTime_2, etc

I'm facing problem when this form is submitted, I think the error has something to do with the pound sign (##) when it comes to updating the back end

I use MS SQL

It doesn like this:

UPDATE TableSchedule

SET SchedDay = <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.SchedDay_#k##">,

SchedMonth =

<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.SchedMonth_#k##">,

SchedDate =

<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.SchedDate_#k##">,

SchedYear =

<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.SchedYear_#k##">,

SchedTime =

Where SchedId = <cfqueryparam cfsqltype="cf_sql_numeric" value="#k#">

</cfquery>

</CFIF>

</CFLOOP>

Can anyone help please?

A better expression?

forums_noreply@adobe.com — Fri, 18 Mar 2011 14:08:48 GMT

I heard that there is a better way than doing this, can anyone tell me? Thanks you!

I got blamed for what I did not do!

forums_noreply@adobe.com — Tue, 15 Feb 2011 20:11:51 GMT

I only made simple changes after a successfull test, The changes I made were on static texts only but then user reported an error and I got blamed for it because I was the last person to touch the codes.

The error do not point me to anything that I can understand and start making correction. Can someone help me, what this is all about?

Error message:

The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.

Null pointers are another name for undefined values.

that's it nothing else. No code or anything that point me to where should I make a correction.

Please help if any of you out there has ever faced this issue.

Thanks

Read a schedule task log, please help!

forums_noreply@adobe.com — Wed, 26 Jan 2011 15:42:24 GMT

The shcedule task I a few months ago work nicely

however this morning I noticed the task was completed only at the beginning and the process seems to stop.

I went to the application log, no error was listed from this process then I went to the schedule task log and see this:

(screen shot attached)

This process is scheduled to run at 5:45AM every morning once.

I noticed in column ThreadID, the task is listed as Scheduler-2

Looking at other ThreadIDs from yesterday or the day before, I see Scheduler-0, Scheduler-1 and from last Sunday it showed as Scheduler-3

What does it means???? I don't see any error at all, anywhere. What can I do to find out what's the problem was, any advice?

CFStoredproc syntax help, please?

forums_noreply@adobe.com — Fri, 21 Jan 2011 14:23:47 GMT

I need to use cfstoredproc tags to call a str. proc. written in Sybase. This str. proc. requires 4 parameters to be passed in and will returns 4 variables back

So I wrote this (see the cfstoresproc script below )

I need to use the return results in my SQL insert statement. Please help!

The following is the declaration on the Sybase str. proc. site, just to show you the relation between the two:

CREATE PROC EmpStat

@FName   VARCHAR(10) ,
@LName   VARCHAR(15) ,
@MName   VARCHAR(15) ,
@Gender   VARCHAR(1) ,

@Data1 VARCHAR(40) out,

@Data2    VARCHAR(40) out,
@Data3    VARCHAR(40) out,
@Data4    VARCHAR(6) out

AS .......etc

<cfprocresult name="Data1"

<cfprocresult name="Data2"

<cfprocresult name="Data3"

<cfprocresult name="Data4"

</cfstoredproc>

Or should I write it this way, what are the differences?

<cfprocresult name="Data1"

<cfprocresult name="Data2"

<cfprocresult name="Data3"

<cfprocresult name="Data4"

</cfstoredproc>

Help with CF schedule task

forums_noreply@adobe.com — Mon, 15 Nov 2010 14:19:45 GMT

Hi, this is my first time trying to schedule my app to be run using cf schedule task. And I just want to be certain before I create this task.

This task should be run automatically every night at certain time. If I missed one night there will be hundreds of records un-verified and skipped, this is no good.

My application has been tested manually several times and gave good and satisfactory results. Tonight I need to start let it run by itself using Cf schedule task and I'm a little nervous.

I just want to make sure if the username and password listed in CF schedule task meant for the database access? am I right?

Thanks

How to populate a table with array loop

forums_noreply@adobe.com — Tue, 26 Oct 2010 15:32:14 GMT

I'm looping an array object and as I loop, I'm calling a function and this function returns 6 items

</CFLOOP >

The above cfdump will return something like:

[empty string]

street name1

[empty string]

city1

state1

zip1

[empty string]

street name2

Apartment AA

[empty string]

city2

state2

zip2

street name 3

Margenthaller Hall

Suite 202

city2

state2

zip2

etc

I need to insert these results into my address table while looping.

When I did the following (see below), each record got repeated 12 times (not sure why)

INSERT INTO MyAddr (street1,street2,street3,city,state,zip)

VALUES ('#zz[1].getLine()#', '#zz[2].getLine()#', '#zz[3].getLine()#', '#zz[4].getLine()#','#zz[5].getLine()#', '#zz[6].getLine()#')

</cfquery>

</CFLOOP >

Is there a way? to do insert as I already got the address correctly while looping but not sure how can I use the return result in insert statement.

Can anyone help?

content attribute on CFMAILPARAM

forums_noreply@adobe.com — Thu, 02 Sep 2010 18:57:46 GMT

I thought with CF 8 we could generate email and attach a PDF on the fly but mine got an error saying (see below)

Did I miss something???

Please help!

Attribute validation error for tag CFMAILPARAM.
The tag does not allow the attribute(s) CONTENT. The valid attribute(s) are CONTENTID,DISPOSITION,FILE,NAME,TYPE,VALUE.

The error occurred in C:\Inetpub\wwwroot\scratch\QAS_Web\badaddressReport.cfm: line 177
175 : outgoing email. 176 : ---> 177 : <cfmailparam file="certificiate.pdf" type="application/pdf" content="#certificate#"/> 178 : 179 :

here is my simple codes:

<cfdocument

name="certificate" format="PDF" pagetype="custom" pageheight="5" pagewidth="6.5" margintop="0" marginbottom="0"

marginright="0" marginleft="0" unit="in" fontembed="true" backgroundvisible="true" localurl="true">

Select FN,LN,Dept,Ph,Eml from emp_table

</cfquery>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

</head>

<body>

<tr>

<td>Employee First Name</td>

<td>Employee Last Name</td>

<td>Department</td>

<td>Phone</td>

<td>Email</td>

</tr>

<tr>

</tr>

</cfloop>

</table>

</body>

</html>

</cfoutput>

</cfdocument>

<cfmail

to=alk@yahoo.com from="info@certificiates.com" subject="Contacts Information" type="html">

Here is the new employee contact info

<cfmailparam file="certificiate.pdf" type="application/pdf" content="#certificate#"/> ---->????

</cfmail>

cfcomponent & cfscript

forums_noreply@adobe.com — Tue, 10 Aug 2010 16:31:41 GMT

I found a UDF that is very useful for my web app. But the UDF is written in cfscript

I want to create a component and put this UDF inside since I'm sure in the future I will be using a lot of this function. So anytime I need this function I can just call using cfinvoke

Usually I use cfinvoke to call my component this way:

Then in the CFComponent I have something like:

<cfcomponent

displayname="NameCheckSystem" hint="">

<CFFUNCTION

name="CheckAddresses">

.....etc

</CFFUNCTION>

</cfcomponent>

Since this UDF is written in cfscript, I'm not sure how is the right syntax to pass the arguments.

<cfcomponent

displayname="NameCheckSystem" hint="">

function ListUnion(List1, List2)

{

var TempList = "";

var CombinedList = "";

Var SortType="text";

Var SortOrder="asc";

var Delim1 = ",";

var Delim2 = ",";

var Delim3 = ",";

var i = 0;

// Handle optional arguments

switch(ArrayLen(arguments)) {

case 3:

{

Delim1 = Arguments[

3];

break;

}

case 4:

{

Delim1 = Arguments[

3];

Delim2 = Arguments[

4];

break;

}

case 5:

{

Delim1 = Arguments[

3];

Delim2 = Arguments[

4];

Delim3 = Arguments[

5];

break;

}

case 6:

{

Delim1 = Arguments[

3];

Delim2 = Arguments[

4];

Delim3 = Arguments[

5];

SortType = Arguments[

6];

break;

}

case 7:

{

Delim1 = Arguments[

3];

Delim2 = Arguments[

4];

Delim3 = Arguments[

5];

SortType = Arguments[

6];

SortOrder = Arguments[

7];

break;

}

// Combine list 1 and list 2 with the proper delimiter

CombinedList =

ListChangeDelims(List1, Delim3, Delim1) & Delim3 & ListChangeDelims(List2, Delim3, Delim2);

// Strip duplicates if indicated

for (i=1; i LTE ListLen(CombinedList, Delim3); i=i+1) {

if (NOT ListFindNoCase(TempList, ListGetAt(CombinedList, i, Delim3), Delim3)){

TempList =

ListAppend(TempList, ListGetAt(CombinedList, i, Delim3), Delim3);

}

Return ListSort(TempList, SortType, SortOrder, Delim3);

}

</cfscript>

</cfcomponent>

help! How to view my work in pdf

forums_noreply@adobe.com — Wed, 28 Jul 2010 19:10:13 GMT

I haven't had the chance to work with PDF with CF 8 and I'm not sure where to start.

I'm currently producing a report from a DB and I'm showing it in a table but I was just told to add a link where our user can click and get that same report in PDF. Users may want to share the report, keep the report, etc

I did some reading and a brief testing but still confuse. Should I use CFDOCUMENT tags with format attribute set to "pdf"? and what other attributes do I need for this task? When I ran mypdftest.cfm with the following codes, I got my pdf:

Hello this is a test

</cfdocument>

but when I added a query on my second test and try to out put the result, I got my pdf but instead of showing the query result, I got strange characters

everywhere.

Select * from some table where LastName = 'Allen'

</cfquery>

<table>

<tr>

<td>First Name</td>

</tr>

<tr>

<td>#FName#</td>

<td>#LName#</td>

</tr>

</cfoutput>

</table>

</cfdocument>

Can anyone help????

How to run CFLOOP in a batch of 100

forums_noreply@adobe.com — Tue, 15 Jun 2010 18:08:29 GMT

I need to loop over a logic for each record I queried from a table once a day

Each day our dept. may receive a different number of records. Today we may get 100 new records, tomorrow may be 5000 and the next day again may be none.

My application crashes whenever we get 5000 or more records; so, I plan to loop in a batch of 100, for example, if today I get 5000 records, I want to run my app. 50 times, each process is looping 100 records. Is there a way to do this?

None of the support people speak CF, please help!

forums_noreply@adobe.com — Fri, 07 May 2010 13:33:24 GMT

I'm about to write a web service web app. for the 2nd time. I'm new to this but my first app. was a success so I plan to do it again.

In both cases, the web services weren't written with CF. Not sure what language they used but this shouldn't be a problem as far as I understand because I'm just consuming and CF should be able to do that.

This time I'm facing an address manipulation software called QAS. This software should be able to do some formating to the input address. For example, if we pass in an address with a mix of lower and uppper case street name, without state and 5 digits zip, after being processed by this software, we'll get a nice formatted address back as a result where the first letter of the street name is capitalized, added the city, state and 9 digits zip with a dash in between. That's briefly what this software can do (it can do more than this but since this software is already there and has this capability, I'm going to use this particular functionality without having to re-invent the wheel).

In Production env., we should install this software in prod. web server but in dev. stage I can install the software in my local machine, as it is written in its manual. The url to the wsdl file when it is installed in local machine is referred to as http://localhost:2021/Proweb.wsdl The 2021 is the port where this software is installed. I open up in the browser and I can see the wsdl file display nicely.

Now the problem is, I'm using cfinvoke to invoke this web service as I did in the pass but I got error saying :Web service operation DoBulkSearch with parameters {DoSearch={3300 metzerott rd | adelphi | maryland | 20783},Country={Structure},Engine={Structure},Layout={Database layout}} cannot be found.

I communicated to the support, even they're helpful but since they don't speak ColdFusion they're not that helpful to me. My last question to them was asking them to comment on my approach, in a plain english, if the steps I currently use is wrong. Here is my question to them:

1. I’m trying to consume (invoke) a web service and reference the WSDL file through http://localhost;2021/Proweb.wsdl

2. The method that I’m using to invoke this web service is called: DoBulkSearch

3. I also pass a few parameters when invoking this web service and they are:

· Country, which has a value = USA

· Engine , which has a value = Verification

· Layout , which has a value = Database layout

· Search, which has a value = 1 riverside rd|new york|ny|blank zip

4. The end result expected from calling this web service is a formatted address, which steps from this is/are considered in correct. Please

advice

This is their answer:

Engine has to be the structure defined in the wsdl, Verification alone is not enough of a value to pass to it. I don’t know how to pass the

structure in coldfusion though.

Search has to be a structure as well. If you were to use the DoSearch method, then this string would be enough to pass, it might be easier to

start with this method.

In ColdFusion, I tried a couple of approach but unfortunately both are not working and gave the same error:

</cfinvoke>

<cfdump

var="#retVal#">

My Question is:

How can I pass Country, Engine, Search parameters and tell the remote site that these are structure paramater. In cfinvokeargument there is no "Type" attribute where I can write Type= "Structure"

OR this one is also not working:

Post / HTTP.1.0

Content-Type:text/xml

Content-Length:614

SOAPAction: "http://www.qas.com/web-2007-08/DoBulkSearch"

<?xml version="1.0" encoding="utf-8"?>

<cfsavecontent

variable="soap">

<soapenv:Envelope

xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<qas:QABulkSearch xmlns:qas="http://www.qas.com/web-2007-08">

<qas:Country>USA</qas:Country>

<qas:Layout>Database layout</qas:Layout>

<qas:Engine Flatten="1" PromptSet="Default" Intensity="Close">Verification</qas:Engine>

<qas:BulkSearchTerm>

<qas:Search>3223 st. paul street | | | 21218</qas:Search>

</qas:BulkSearchTerm>

</qas:QABulkSearch>

</soapenv:Body>

</soapenv:Envelope>

</cfoutput>

</cfsavecontent>

<cfhttp

url="http://localhost:2021/proweb.wsdl/" method="post">

</cfhttp>

<cfdump

var="#soap#">

(screen shot of the wsdl file in text file)

Inserting structure to table

forums_noreply@adobe.com — Thu, 21 Jan 2010 17:59:18 GMT

I'm getting this value through a loop of a structure:

#key# - #st_datachanged[key]#<br>

</cfoutput>

</cfloop>

Gender - F
LastName - Smith
FirstName - Adrienne
Addr1 - 9721 Willow Lane
City - Potomac
Zip - 20854-2053
State - MD

How can I insert this value into a row in my table?

My table row has these columns: FirstName,LastName,Gender,Addr1,City,State,Zip,Gender

I'm using CF8 and Sybase

Can I get some help with CF8 and Unix from this forum?

forums_noreply@adobe.com — Wed, 04 Nov 2009 21:14:45 GMT

I did my dev in my local machine running windowsXP and CF8

In prod. environment, my CF8 runs in Unix and I'm not familiar with Unix at all.

My manager is out for awhile and I want to do this if I could without waiting for him because in windows it is very simple.

Here is what I did in windows and I think I should do the same in unix but unfortunately I don't know how:

In Windows environment I have done the following successfully and easy:

1. installed/moved a .exe file in 2 folders: 1. in cfx folder under Coldfusion8 folder and

2. and again in CFClasses folder under WEB-INF folder

2. Then in CF8 administrator I went to SERVER SETTINGS >> Java and JVM >> under ColdFusion Class Path, I put: c:\Coldfusion8\cfx\cfx_myexe.jar >> submit

3. Under CFX Tags >> clicked REGISTER Java CFX >> I put: cfx_myexe in Tag Name and the same in Class Name >>submit

Then when I go to my application, everything work as a charm!

How can I do these things in Unix?

When I logged into CF server in unix using my FTP FileZilla, I immediately see /space/users/www , so I'm in the root directory. I can't see anything above this directory

In windows, CFX is found under ColdFusion8 folder AND cfclasses is found under WEB-INF folder like this:

C:/ColdFusion8/www/WEB-INF/cfclasses

All my CF files for the application are on C:/Inetpub/www/myfolder/

So my questions are:

1. How can I access point 1 using my FTP to move my exe file to the right folders

2. Since I don't have CF administrator interface with Unix, how can I do point 2 and 3 above????

I have searched on this forum if someone had this problem in the past and also googled it but I got no result.

Can we count tabs?

forums_noreply@adobe.com — Tue, 20 Oct 2009 19:31:52 GMT

I'm writing CF application where my user is upoading a tab delimited text file.

From past experience, many times users uploaded a text file with less tabs and causing chaos.

The first thing that came to my mind was to count the tabs, if they don't match the total tabs requirements than I should write to reject this file being uploaded.

I'm not sure how can I count tabs, does anyone has some code example?

Thank you!

Can't find answer to Query Of Queries runtime error

forums_noreply@adobe.com — Thu, 27 Aug 2009 19:22:36 GMT

Not only I browsed this forum but also googled this problem but unfortunnately I have no luck in finding the answer.

All I did was writing this simple query:

select SSN,BirthDate from myquery where SSN <> '' OR BirthDate <> ''

</cfquery>

and I got this error:

Query Of Queries runtime error.
Comparison exception while executing <>. Unsupported Type Comparison Exception: The <> operator does not support comparison between the following types: Left hand side expression type = "DOUBLE". Right hand side expression type = "STRING".

I tried the following and did not work either, still got the same error.

select SSN,BirthDate from myquery

where SSN <> <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value=""/>

OR BirthDate <> <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value=""/></cfquery>

Has someone ever encountered the same problem and know how to solve it?

cfx_Text2Query, need Help please!

forums_noreply@adobe.com — Thu, 06 Aug 2009 16:05:57 GMT

I'm installing cfx_Text2Query from http://www.emerle.net/programming/help/installing_cfx.aspx and I'm trying to follow the step by step instruction

But I'm stuck at step 3 where it says: Class Name is CASE SENSITIVE so "you must enter the name EXACTLY as it appears on the file system."

How do I know the name of this Class file in the file system???????? Can anyone offer help please?

I'm on CF 8 server

My codes run VERY SLOW.....

forums_noreply@adobe.com — Tue, 21 Jul 2009 19:04:24 GMT

I'm parsing a fixed length text file with around 1200 columns in length. The feed may contain up to 2500 records or sometimes more.

I'm facing a big problem with the processing time. My application run extremely slow for only getting the records into a table.

If I can put all the records into a table I still need to do more processing, such as checking each column for a correct value.

I've been trying many ways but I always stuck with a slow process, nothing I did seem to help my application to run faster.

I'm using CF 8, Sybase and Unix

Is there more efficient ways to parse fixed length text file and insert them into a table?

Here are what I just tried:

I'm looping each records to create structures. I tried both of this methods successfully (see attachment, I can only post 1 structure in this forum since there are too many elements within 1 structure)

Once I have them all in structures, then I insert each value to a table.

When the feed only contain a few hundred records, I'm OK but when the feed start to get bigger, for example 2500 records, my loop takes too long to create these structures. Sometimes I got a timed-out error. This is my 1st problem.

1. <cffile action="READ" file="#FilePath##FileName#" variable="FileLine">

etc.......

calling a function inside a component to insert into table or calling a str proc to do insert into table

</cfloop>

2. <cfset st_Rec=StructNew()>

etc.......

calling a function inside a component to insert into table or calling a str proc to do insert into table

</CFLOOP>

As you can see from my structure (attached), there are many empty elements within my structures.

This empty elements may contribute to the lengthy looping process.

At first I thought I could do a collection loop within each structure to just get the non empty column and then process them, this will probably cut the proccessing time but I'm facing other problem and that is, the next feed may not have the same exact column with empty value. I'm not sure how can I write the insert into column names if the column are changing every time.

3. <cfset st_Rec=StructNew()>

etc.......

</cfif>

</cfloop>

</CFLOOP>

My show error

forums_noreply@adobe.com — Wed, 27 May 2009 18:53:39 GMT

I'm calling a stor. proc. (in Sybase). If I don't cfdump the resultset, my application run without showing me any problem but when I put cfdump I got the error message saying: CF does not know what q_RptResult is

My code below:

</cfstoredproc>

<cfdump var="#q_RptResult#"> <--- this causing error. Eliminate cfdump eliminate the error message

Help with Structure in array

forums_noreply@adobe.com — Thu, 04 Jun 2009 18:50:10 GMT

I need to process a tab delimited list and I'm able to put the data into an array. See the image of the array below:

Now that the list is separated into 5 array elements, each element is a list by itself.

How can I create a structure for the list within each array element so I will have an Array with 5 element and each element contain a structure with keys and values???

To create the above array I simply use :

Please help!

What is the better and faster way to get the results

forums_noreply@adobe.com — Mon, 11 May 2009 19:48:10 GMT

I'm looking for suggestion for my application.

I need to write an application where in certain section I need to do some checking for the SSN, I need to find if the SSN in table A is a duplicate in Table B.

Table B consist of more than 1 million SSN and table A may have a couple of thousands SSNs.

The SSN in table B consist of good and invalid SSN,such as, SSN with 000 on the first 3 digits or 00 on the second 2 digits or 0000 the the 4 last digits or even all 9 digits consist of 000 00 0000

If I do the regular select SSN from table B where SSN = 'SSN_from_table_A" for 3 to 5 thousands records in a cf loop than it may takes awhile before I can see the result.

Is there a better way to do this?

My cfstoredproc is there but nothing happen on the db

forums_noreply@adobe.com — Thu, 12 Mar 2009 17:00:02 GMT

I created a temp. error log, what I did, I wrote a detele statement to clear up all the old error records in the begining and after that, I'm inserting new error(s) if they become available.
I use stored procedure and the reason for doing this is just to practise with <cfstoredproc tag.
The funny thing is, I can see the stored proc was run from the debug view but the record did not get deleted? Have I done something wrong with the code? no error on the screen.
I use CF8, DB Sybase & windows


<cfstoredproc procedure="sp_deletedOldError" datasource="#mydb#">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@user1" value="#Trim(session.user)#">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@user2" value="">

</cfstoredproc>

Here is my simple procedures:
CREATE PROCEDURE dbo.sp_deletedOldError

@user1 varchar (2),
@user2 varchar (2)

AS
BEGIN
Delete from tbl_error
Where users IN ('@user1','@user2')
END

My cfstoredproc is there but nothing happen on the db

forums_noreply@adobe.com — Thu, 12 Mar 2009 17:00:04 GMT

My cfstoredproc is there but nothing happen on the db

forums_noreply@adobe.com — Thu, 12 Mar 2009 16:57:23 GMT

CFSWITCH

forums_noreply@adobe.com — Fri, 27 Feb 2009 19:55:51 GMT

I know I can do <CFCASE value="1,2,3,4,5,6"> do something </cfcase>
But if I'm evaluation 2 variable values, Can I do :
<cfswitch expression="#variable1# , #variable2#">
<cfcase value="a">
do 1 + 1 = 2
</cfcase>
</cfswitch>

Instead of
<cfif #Variable1# IS "abcd" OR #Variable2# IS "xyz">>
do 1 + 1 =2
</cfic>

So basically if Variable1 IS "ABCD" OR Variable2 IS "xyz" do the same thing
I guess nothing is wrong with using cfif instead of cfswitch but in my application there are too mane nested cfif already.

ColdFusion Structure

forums_noreply@adobe.com — Fri, 13 Feb 2009 17:30:13 GMT

I'm looping an array of records (from a fixed length feed) and creating a structure for each required field. Then for every loop, I'm passing this structure to a function to check if certain required field in the structure's element is left empty.
The structure should look something like this:
<cfloop from="1" to="#ArrayLen(MyFile)#" index="i">
<cfset aEachLine =StructNew()>
<cfset aEachLine["LastName"]="#Mid(MyFile ,17,40)#">
<cfset aEachLine["FirstName"]="#Mid(MyFile ,57,20)#">
<cfset aEachLine["Address"]="#Mid(MyFile ,140,38)#">
<cfset aEachLine["City"]="#Mid(MyFile ,254,19)#">
<cfset aEachLine["State"]="#Mid(MyFile ,273,2)#">
<cfset aEachLine["Country"]="#Mid(MyFile ,284,4)#">

In this example I'm assuming that my structure is this short

<CFSET CheckStructValue=CheckThisStruc(aEachLine)>
</cfloop>

How do I check if any of those struct. value is empty?

CFGRID, please help

forums_noreply@adobe.com — Thu, 08 Jan 2009 19:42:45 GMT

I tried to use cfgrip to show the records but I got an error saying Cf can't find the function within my component
I have my component inside a folder called cfcomps, here is the dir structure:
folder www
folder sct
folder cfcomps

What have I done wrong?
Here is my codes and on the most bottom is the error I got:

CODE:
<cfform>
<cfgrid name="ads" format="html" bind="cfc:cfcomps.gcheck.getrecords({cfgridpage}, {cfgridpagesize}, {cfgridsortcolumn}, {cfgridsortdirection})">
<cfgridcolumn name="cp" header="CPrefix" width="100"/>
<cfgridcolumn name="afix" header="APrefix" width="100"/>
<cfgridcolumn name="pid" header="PrefixID" width="300"/>
</cfgrid>
</cfform>

ERROR:

The specified remote function getrecords was not found on the CFC cfcomps.gcheck.

The error occurred in /sp/ourusers/dt/G/checkDt2.cfm: line 58

56 : <cfgridcolumn name="cp" header="CPrefix" width="100"/>
57 : <cfgridcolumn name="afix" header="APrefix" width="100"/>
58 : <cfgridcolumn name="pid" header="PrefixID" width="300"/>
59 : </cfgrid>
60 : </cfform>

Javascript help.

forums_noreply@adobe.com — Thu, 18 Dec 2008 21:07:31 GMT

I know this is not a javascript forum but many cf developers are good with javascript and I'm not one of them.
I need to fix a javascript bug inside my CF application and I've spent sometimes looking at it unfortunately I'm not sure how to fix it. It looks simple, had this one be in CF I should've been able to fix it myself but this is javascript which I will need some help if possible.

This script is created for a dynamic generation of a pair of textboxes on a form.
In the form there are 2 texboxes side by side.
The left texbox is labelled: Name and the right textbox is labelled: Salary
When user needs an additional pair of textboxes, user will click on this link to add a pair of textboxes. User can add pair of texboxes as many as he/she like. He/she just need to click on:


<tr>
<td><p id="FirstGroup"></td>
</tr>
<tr>
<td><a href="javascript:addInput()">Click here to add more input field(s)</a></td>
</tr>
<tr>

And this is the complete script: (see below)

<script type="text/javascript">

// declare a dynamic Array in javascript
var arrInput = new Array(0);
var arrInputValue = new Array(0);

function addInput() {
//arrInput.push(createInput(arrInput.length));
arrInput.push(arrInput.length);
//arrInputValue.push(arrInputValue.length);
arrInputValue.push("");
display();
}

function display() {
document.getElementById('FirstGroup').innerHTML="";
for (intI=0;intI<arrInput.length;intI++) {
document.getElementById('FirstGroup').innerHTML+=createInput(arrInput[intI], arrInputValue[intI]);
}
}

function saveValue(intId,strValue) {
arrInputValue[intId]=strValue;
}

function createInput(id,value) {
return " <table border='0' width='526' cellpadding='1' cellspacing='1'><tr>
<td>
<input name='emp_name' type='text' id='emp_name "+ id +"' onChange='javascript:saveValue("+ id +",this.value)' value='"+ value +"' size='40'>
</td>
<td>
<input name='salary' type='text' id='salary "+ id +"' onChange='javascript:saveValue("+ id +",this.value)' value='"+ value +"' size='50'>
</td>
</tr></table>";

}

//End
</script>

The bug is:
When Tony Smith is typed in to the name textbox on the left, $60.000 is typed into the salary textbox and then user click on to add a pair of textboxes link :<a href="javascript:addInput()">add a pair of texboxes</a>
The name field with Tony Smith got changed into $60.000
In other words, once the user click on :<a href="javascript:addInput()">add a pair of texboxes</a> the name field is populated with salary info.
It looks like the array only recognizes 1 element value, the salary.

Please help!

Form vaidation question

forums_noreply@adobe.com — Fri, 05 Dec 2008 18:59:00 GMT

This is suppose to be a simple task and I have some idea of how to do it but I'm not sure if my way is the best way.
I have a form and many fields are required fields. The previous programmer had applied the client side form validation using javascript but did not apply server side validation.
Many of our users don't have their browser javascript enabled so we have some problem with our data in our DB.

I need to work on server validation but I don't know if there is a better technique out there especially for situation where user has filled out most of the fields but left one or two required field blank.
Once the form is submitted server side validation is doing its work and throw a message back to user to filled out the 2 required fields but still keep the information on other fields filled out previously.

What can I do to the already filled out form fields to keep what user already entered? this way user doesn't have to re-type the whole thing from start.
If I'm the user I will be furious if I have to start from scratch again.

Do I have to do insert first, then get the data to populate all the fields but show message to user those empty one need to be fill out and once they do that I do an update?
it sound to much work on the server side if I have to do it this way, am I right?

Store Procedure Help!

forums_noreply@adobe.com — Thu, 20 Nov 2008 16:37:33 GMT

I did stor proc before and they're working just fine but this time for some reason I did not get any error and did not get any result as well. When I tested the query in analyzer I got records.
I'm using CF8 and Sybase

I tested it with a simple select and still not working:

CREATE PROCEDURE sp_GetRpt
@code1 varchar (10),
@code2 varchar (10)

AS
BEGIN

SELECT *
FROM a_table
WHERE code IN ('@code1', '@code2')

END

I'm calling it from my cf application:

<cfstoredproc procedure="sp_GetRpt" datasource="xxxx">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="ADA">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="TADA">

OR I also tried it with dbvarname, I still got no records but no error:

<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="code1" value="ADA">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="code2" value="TADA">

<cfprocresult name="q_Rpt">
</cfstoredproc>

<cfdump var="#q_Rpt#">

Is there something wrong with my codes?

CFARGUMENT help!

forums_noreply@adobe.com — Tue, 11 Nov 2008 21:12:26 GMT

I'd like to use the existing function within a component. Since that function is exactly what I need it would be great if I don't have to rewrite the same query again and again.
The problem is, that existing CFFUNCTION accept 3 arguments, while my calling page only passing 2 parameters. See the code below:

This is the existing cffunction that I need to use:

<CFFUNCTION Name="getCOF" >
<cfargument name="Type" required="true">
<cfargument name="Client" required="true">
<cfargument name="FiscalYear" required="true">

<cfquery name="getInfo" datasource="#Application.datasource#">
select id ,ins,year,seq,type,name,title
from cfname
where type = <cfqueryparam cfsqltype="CF_SQL_CHAR" value="#Type#" />
and ins = <cfqueryparam cfsqltype="CF_SQL_CHAR" value="#Client#" />
and year=<cfqueryparam cfsqltype="CF_SQL_CHAR" value="#FiscalYear#" />
</cfquery>

<cfreturn getInfo>
</CFFUNCTION>

This is how I call this function within a component:

<cfinvoke component="com.COF" method="getCOF"
Type="U" Client="#u.group#" returnvariable="q_FNInfo">

So, I'm not passing Fiscal Year to the function that is ecpecting argument for FiscalYear.
This function is used by other page where the calling page passing Type, Client and FiscalYear

If I do not pass FiscalYear to this Function I will get error saying the function has an argument called FiscalYear
that is set as required but not passed.
How can I still use the same function when I only passing 2 parameters instead of three, can it be done?
I'm on CF8,Sybase and Unix
Please help, thanks.

How can I use it in CFQueryparam?

forums_noreply@adobe.com — Thu, 06 Nov 2008 17:09:26 GMT

I'm not experience in Sybase but one of my application has Sybase as the back end. I'm using CF 8 as the front end. I need to use cfqueryparam but one of the column call Author_number is set to id_dt data type in Sybase
I have never heard about this data type so how can I use this data type in CFQueryparam's cfsqltype attribute?

The cfsqltype I'm familiar with are:
CF_SQL_BIGINT
CF_SQL_BIT
CF_SQL_CHAR
CF_SQL_BLOB
CF_SQL_CLOB
CF_SQL_DATE
CF_SQL_DECIMAL
CF_SQL_DOUBLE
CF_SQL_FLOAT
CF_SQL_IDSTAMP
CF_SQL_INTEGER
CF_SQL_LONGVARCHAR
CF_SQL_MONEY
CF_SQL_MONEY4
CF_SQL_NUMERIC
CF_SQL_REAL
CF_SQL_REFCURSOR
CF_SQL_SMALLINT
CF_SQL_TIME
CF_SQL_TIMESTAMP
CF_SQL_TINYINT
CF_SQL_VARCHAR

Please help!

Adobe Community : All Content - All Communities

Ordering data type varchar

Using NVL in Query of Query resulting in error

Purchased ColdFusion 10: Having problem with session variables

Moving to CF10, Need help with Application.cfc

Accessing Login page from CF

How to validate a series of 0s value

StructIsEmpty function, help!

How to get date 30 days from existing date?

Advice and code sample

Connecting CF8 to Oracle 11g with JDBC

Please help with getting the result back from a procedure

Where is the best place to set the path with Application.cfc?

Money datatype

Invalid data 7,261.00 for CFSQLTYPE CF_SQL_NUMERIC.

Invalid data 7,261.00 for CFSQLTYPE CF_SQL_Double.

CFFILE COPY in ColdFusion 8

cfexecute and sqlldr problem

An exception occurred when invoking an external process.

Help with CF & Oracle

Error Executing Database Query.

How to find a carriage return and Line feed?

Please help with dynamic form field names in cfloop

A better expression?

I got blamed for what I did not do!

Read a schedule task log, please help!

CFStoredproc syntax help, please?

Help with CF schedule task

How to populate a table with array loop

content attribute on CFMAILPARAM

Attribute validation error for tag CFMAILPARAM.

cfcomponent & cfscript

help! How to view my work in pdf

How to run CFLOOP in a batch of 100

None of the support people speak CF, please help!

Inserting structure to table

Can I get some help with CF8 and Unix from this forum?

Can we count tabs?

Can't find answer to Query Of Queries runtime error

Query Of Queries runtime error.

cfx_Text2Query, need Help please!

My codes run VERY SLOW.....

My show error

Help with Structure in array

What is the better and faster way to get the results

My cfstoredproc is there but nothing happen on the db

My cfstoredproc is there but nothing happen on the db

My cfstoredproc is there but nothing happen on the db

CFSWITCH

ColdFusion Structure

CFGRID, please help

Javascript help.

Form vaidation question

Store Procedure Help!

CFARGUMENT help!

How can I use it in CFQueryparam?