Adobe Community : All Content - All Communities

Error Executing Database Query

forums_noreply@adobe.com — Thu, 16 Oct 2014 18:29:45 GMT

I have a web application written in CF8 with Oracle 11g as the back end. This application has been used very often for more than 6 years. Currently I am moving to CF10 and did only a little modification to the CF codes. When I ran the new application in my test server, everything seems to be working just fine except when it calls an Oracle Package. This action produces an error: Error Executing Database Query The strange thing is everything work before and after calling the procedure, I tested using cfabort This Oracle Package is still working in production server (CF8) but not when it is called by CF10. My question is: Is there any changes for CF10 when calling a procedures? or is there any hotfix that I'm not aware of? The code is as follow: SELECT case trim(to_char(SYSDATE, 'DAY')) WHEN 'MONDAY' then '1' else '2' end AS TodaysDate from dual

SELECT Count(other_id) AS NoRecFound FROM gl_dup_ids_ssns WHERE Trim(create_date) =

SELECT Count(other_id) AS NoRecFound FROM gl_dup_ids_ssns WHERE Trim(create_date) = CF codes to Stop the process and email admin

Error Executing Database Query shows up when it hit to run cfstoredproc. The codes are exactly the same as in CF8, this template was not modified. Exceptions 14:03:53.053 - Database Exception - in /home/space/users/www/GL/glproc.cfm : line 93 Error Executing Database Query.

Created a Global UDF but don't know how to call it, please assist

forums_noreply@adobe.com — Wed, 06 Aug 2014 19:01:25 GMT

I created a cfcomponent and a bunch functions inside it. One of the function needs to call a process that is also needed by other part of the application. Since this "process" is needed in a different parts of the application, I decided to make this "process" a global function that can be called from any part of the application. I found a blog from Ben Nadel that explained exactly what I need. But the problem is I don't quite understand how to call the globa UDF, his explanation is not clear to me. Ben created UDF.cfc:

cfcomponent output="false" hint="I define the application settings and event handlers.

cffunction name="getMessage" access="public" returntype="string" output="false" hint="I return a test message."

     -- Here is where I wrote the process needed by different parts of the application --

        cfreturn "I am defined in the UDF component"
       cffunction

cfcomponent

On the Application.cfc he created a URL scope: cfcomponent output="false" hint="I define the application settings and event handlers."

Define the application:

cfset this.name = hash( getCurrentTemplatePath() )
cfset this.applicationTimeout = createTimeSpan( 0, 0, 5, 0 )

        Add all of our "global" methods to the URL scope. Since
        ColdFusion will automatically seach the URL scope for
        non-scoped variables, it will find our non-scoped method
        names:

cfset structAppend(url,createObject( "component", "UDF" ))

cfcomponent

The part that I don't understand is, how to call getMessage method? Is it: application.cfc.UDF.getMessage(parameter1,parameter2) ??

Installing ColdFusion 11 in Windows 8.1

forums_noreply@adobe.com — Sat, 12 Jul 2014 22:45:10 GMT

I can't no longer download the 30 days trial for CF 10, all I can see is CF 11 when I go to http://www.adobe.com/go/trycoldfusion/ It is OK for me to try CF 11, it is not a problem because I have not submitted a purchase request to my department. I have no difficulties installing CF 11 on my Windows 8, the problem is on how to configure CF to work with IIS or vice versa. I found some suggestion to modify IIS8 into IIS7, I did it but I still can't get it to work with CF11. Now I already have IIS 7 instead of 8 and I still can't open my website nor CF administrator. I got internal server error message 500. Is this because I have to install some CF hot fixes or something else? there are not too many tutorials out there with CF 10 or 111 and Windows 8 IIS. Is there any easy step by step instruction either from Adobe or someone who has successfully install CF10 or 11 and don't mind sharing it with me?

Strange behavior on a simple Delete/Truncate Statements

forums_noreply@adobe.com — Fri, 14 Dec 2012 18:13:30 GMT

Hello!

I'm using CF8 and Oracle 11g and In one of my app., I applied 4 simple delete/truncate statements.

These statements are used to clean up 4 temporary tables everytime this app. starts.

For a few weeks I have not seen anything wrong with it until one day the result produced by this app show duplicates data.

On my investigation I found out that 4 of my Truncate statements did not truncate the data, so previous data were process again and again...

Then I made some changes:

FROM:

Truncate table temp_table1

Truncate table temp_table2

Truncate table temp_table3

Truncate table temp_table4

</cfquery>

INTO:

Truncate table temp_table1

</cfquery>

Truncate table temp_table2

</cfquery>

Truncate table temp_table3

</cfquery>

Truncate table temp_table4

</cfquery>

Then I got the correct result again but only for a few weeks before the same problem coming back again.

Obviously, my statements are correct because I got the right data for weeks before it stopped working.

When I did delete statement directly in Oracle SQL Developer, I need to apply COMMIT;

such as:

Delete from Table A;

commit;

But when using Truncate I was told I don't need to use commit.

I changed the 4 statements in my CF application from truncate to delete and I got the same result.

In the first few weeks, I got the right result but it comes back.

Has anyone experience this? please help!

Where to set key to be used with Encrypt function

forums_noreply@adobe.com — Wed, 17 Oct 2012 19:58:53 GMT

I'm about to use CF Encrypt function because I need to pass a var via url.

In order to use Encrypt () I need to create a KEY but I don't want to keep setting this key on the page where I need to use Encrypt()

Can anyone point me to the right direction on where is the best place to set this key so I can just refer to this key anytime I need it?

Can I do <cfset session.MyEncyprteKey = ....>? and everytime I need this key I just use #session.MyEncryptedKey# ?

I'm using CF8 and Application.cfc

can't I call a function this way?

forums_noreply@adobe.com — Fri, 06 Apr 2012 14:01:16 GMT

I tried to get records from a table from server A (Sybase) and insert the records to server B (Oracle) using CF8

Both has the same exact table and datatype

When I do the following, I got this error and not sure where I did wrong

Missing argument name.
When using named parameters to a function, every parameter must have a name. The CFML compiler was processing:

My codes:

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

SELECT * FROM tbl_EP

</cfquery>

</CFLOOP>

INSERT INTO tblEP_Ora (Column_1, Column_2, DateColumn)

VALUES ('#arguments.col1#', '#arguments.col2#', #arguments.date_col#>

</CFFUNCTION>

application.cfc vs application.cfm

forums_noreply@adobe.com — Wed, 16 Nov 2011 19:38:43 GMT

My CF version is 8 but since I came to this company and inherrited the codes, it looks like previous programmer did not use much of CF8 features.

I started to take advantage of CF8 features including cfc. One thing that I notice is all the existing apps. are using application.cfm and none uses application.cfc

I have sort of a portal web application where under this app. there are a bunch of different applications

The portal application has application.cfm that is encrypted so whenever I create a new app, I created my own application.cfm each with a different name set on the cfapplication tag

So it sort of to look like this:

Portal app

application.cfm (encrypted)

application_1

application.cfm

application_2

application.cfm

application_3

application.cfm

I want to experience the CF8 application.cfc and from what I read, if I use application.cfc I can't use application.cfm because application.cfc replacing application.cfm and OnrequestEnd.cfm

when application.cfc is present both application.cfm and OnrequestEnd.cfm are going to be ignored.

My concern is, when I start creating application.cfc on my sub application, will the application.cfc ignoring Portal's application.cfm (the encrypted application.cfm) eventhough it is

on a much higher up in the directory tree?

So can i do the following without messing up the whole application?

Portal app

application.cfm (encrypted)

application_1

application.cfm

application_2

application.cfm

application_3

application.cfm

application_4

application.cfc <<< (?)

Please help with datatype mismatch on insert statement

forums_noreply@adobe.com — Mon, 20 Jun 2011 15:37:51 GMT

I'm trying to insert some values from my form into my Sybase.

Some columns datatype are set as Money datatype and the values from my CF form are varchar.

I tried to use LSCurrencyFormat or DollarFormat but unfortunately all of my attempt did not work and gave me this error:

Error Executing Database Query.
[Macromedia][Sybase JDBC Driver][Sybase]Implicit conversion from datatype 'CHAR' to 'MONEY' is not allowed. Use the CONVERT function to run this query.
21 : <cfqueryparam cfsqltype="cf_sql_varchar" value="#DollarFormat(Form.PGCash)#">, 22 : <cfqueryparam cfsqltype="cf_sql_varchar" value="#DollarFormat(Form.PGPL)#">, 23 : <cfqueryparam cfsqltype="cf_sql_varchar" value="#DollarFormat(Form.PGPLPMT)#">)

I'm using cfqueryparam on my sql statement on CF template such as:

Insert into (column1,column2,column3,....)

Values (<cfqueryparam cfsqltype="cf_cql_varchar" value="#DollarFormat(form.pgcash)#">, etc..

I also tried Convert function like this, it wasn't working either:

Insert into (column1,column2,column3,....)

Values (<cfqueryparam cfsqltype="cf_cql_varchar" value="#Convert(money(8), form.pgcash)#">, etc..

I ran out of knwledge on how to successfully make this insert from happening, please help!

working with rss

forums_noreply@adobe.com — Fri, 20 May 2011 13:41:37 GMT

I have this code in my page:

Is there a way to prevent error message from showing up in my page when the url from this site does not work?

When I access this other site this morning, I found:

A Database Error Occurred

Unable to connect to your database server using the provided settings.

Because of this, my page is showing this error:

Unable to read the source URL.
Status Code: 500. Try adding or changing UserAgent attribute in the CFFeed tag

It would be nice if I can prevent this message from showing up. Is there anything I can do from my CF side?

Need help with CF component call, please

forums_noreply@adobe.com — Thu, 07 Apr 2011 13:58:58 GMT

Hi!

I've been working with component lately but still learning. In one of my logic I need to use an existing component and I'm not sure how to correctly call the function and get the return result from that.

Can anyone help me please?

Basically I created a component:

within my logic, I need to call an existing function located at

in a different component And I need to use the result returned by this function.

(see below)

I'm not sure how to correctly call that function from here

Can I simply do:

</CFIF>

</CFFUNCTION>

</cfcomponent>

This is the existing componen that I need to use. It's located at the same directory:

some logic here

.......................

return return_struct;

</cfscript>

</CFFUNCTION>

</cfcomponent>

Please advice, thank you!

How to get rid of special char? Help please!

forums_noreply@adobe.com — Thu, 17 Feb 2011 20:04:35 GMT

I'm having a hard time creating a form field that only accepting number.

The ideal way would be using ajax or javascript but I don't know how so I tried to use form submit instead.

There are 2 text fields & one drop down where user can enter dollar amount, then select a fee from a drop down.

The 3rd textbox will then display the total amount from 1st field + 2nd field, real simple.

1. Enter amount, for example, user enter $10 on the 1st. field then

2 Select fee range : $1 to $200 : $20 <<<< for example user select this value

$201 to $500 : $30

etc

then,

3. Total : $10 + $20 = $30 <<< shown on 3rd text field

I need to filter 1st text field to only get the number. If user enter $10, I should get rid of the $ sign or if user enter any characters other then numbers (including

decimal) my program should be able to only extract the number (and decimal)

When user select the drop down, I submit the form to self, calculate this 2 numbers and show the result in the 3rd text field.

I tried to use ReplaceNoCase but it generates error since it doesn't like the empty value on the 2nd string attribute:

#ReplaceNoCase(Form.FirstTextBox, $, ,ALL)# >>>> this generates error because it is trying t replace it with a blank space..please help!

can I ignore a return result?

forums_noreply@adobe.com — Mon, 20 Dec 2010 14:02:52 GMT

Hi!

I'm not too sure what am I supposed to do with situation like this.

My CF application work just fine but suddenly the DB guy changed a stored Procedure that is used in my application.

The changes did not cause major effects but I noticed the cfmail tags and a delete statement right after this stored procedure, is not executed anymore.

The only different between old str. proc and new str. proc. is that the new str. proc. is now returning some result where my app. does not need.

So in other words, after that str. proc is executed, it returns a result and my CF ignore it and I expect CF should continue on running the rest of the codes which is a CFMAIL tags and a delete statement.

The DB guy can't do much since using the old str. proc. produced unexpected result and also according to him he doesn't have much choice since the db is set by a third party vendor where he doesn't have too much access to.

My question is:

I have tried to adjust my codes so that my CFMAIL and delete statement run regardless of how the new str. proc being set but I'm not so sure how to handle the return result by this str. proc.

Can I just ignore it?

The adjusment I made was to put all my CF codes above this str. proc. So after all my CF codes are run, I let the str proc. run and that's the end of the process. Is this acceptable? what can go wrong if I let this app running and ignoring the return result on every process? Please advice

ColdFusion 8 and Ajax

forums_noreply@adobe.com — Wed, 10 Nov 2010 14:25:57 GMT

Hi!

I have never used ajax with codlfusion, this would be my first try. I read some forum, those I need are described here, including the one written by

Ben Forta: http://www.forta.com/blog/index.cfm/2007/5/31/ColdFusion-Ajax-Tutorial-1-AutoSuggest

and also from Adobe site:

http://www.adobe.com/devnet/coldfusion/articles/cfajax_overview.html

At this moment I only need to use a couple of them such as, autosuggest, cflayout, cfmenu and cfwindow but I think I have not gotten the whole picture yet.

Something like: Do I need to do anything else before starting to use these tags? I tried using cfform cfinput and applied what these forum suggests and nothing work. For example, the autosuggest does not work.

I did my cfquery and then applied #ValueList(query.columnName)#, I got an error saying valuelist is not defined

Also,

I read about SPRY, do I need to download SPRY before I can work with ajax in ColdFusion 8?

Basically I just need some very basic gudance on how can I start. can anyone help???

Need help with setting up datasource

forums_noreply@adobe.com — Thu, 04 Nov 2010 13:04:21 GMT

Hi!

I'm working on a CF project on my local machine but the DB is located on the hosting site so I have no access to their CF administrator and can't set the datasource.

So I was suggested by the hosting company to work from my local but connect the datasource to their MySQL DB remotely. I was told that I need to use certain IP address they gave me and also the database name, user name and password but I'm not sure how to set this up from my code.

Have googled for awhile and did not get any result. Is there anyone in this forum know how and willing to send example for me so I can start working?

Thank you so much

Help with creating a list

forums_noreply@adobe.com — Wed, 11 Aug 2010 16:22:17 GMT

I query id values from one of my table.

I need to come up with a list that looks like:

id='123' OR id='234' OR id='002' OR id='345' OR id='435'

I came up with 123,234,002,345,435 and '123' , '234' , '002' , '435' and also '123' OR '234' OR '002' OR '435'

but very frustrated with putting id= on each list element to come up with id='123' OR id='234' OR id='002' OR id='345' OR id='435'

Can anyone think of a technique to create such a list dynamically from a query result?

Thanks!

Help with ListLen()

forums_noreply@adobe.com — Wed, 21 Jul 2010 15:01:24 GMT

I'm confused. In Adobe ColdFusion 8 documentation online it is said that ColdFusion ignores empty list elements; thus, the list "a,b,c,,,d" has four elements.

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_l_15.html

If I use ListLen on the following List:

a|b|c|d| | |g|h >> <CFSET TheList = "a|b|c|d| | |g|h">

<CFSET Total = "#ListLen(TheList, "|")#> I got: 7 instead of 6 as the result

So does ListLen function is counting my "Bar" as delimiter on that list OR ListLen function is counting the list elements (a,b,c,d,g,h)??????

I need a coldfusion function to count the "Bars" NOT the elements. Or is there CF function counting the elements but including empty elements.

On my test, ListLen is actually counting the Delimiter which is the "Bar" in my case, does it means the documentation is wrong?

if the documentation is correct and it s counting the element, I did not get that result. Please help!!!

How to set identity to the 1st record in cfquery

forums_noreply@adobe.com — Thu, 17 Jun 2010 18:52:46 GMT

Hi,

I need help with setting the identity to always start with 1 when new records are inserted.

My application is inserting records to Table A then at the end, all records in Table A are deleted.

When the next time this app. is ran, Table A is re-populated again and for certain reason the inserted record need to always start from 1.

The identity is set to automatic so I'm trying to find a way if I can reset the identity column before start inserting new records.

Is this doable?

This is not working:

'identity', ', 0, '0' //reset identity???

INSERT INTO Table

Select a,s,c from tableB where a='a'

</cfquery>

Problem with looping on some List

forums_noreply@adobe.com — Tue, 25 May 2010 19:20:37 GMT

More than 1 records are shown as result of a form search and from my debug screen I'm facing a comma delimited values from each fields as shown below. The requirement is for the user to be able to do an update to each record at once instead of one record at a time.

Users should be able to check on the checkboxes next to Diane, Suzane,Debbie's records and hit the Update button, those record will get updated.

I tried cfloop list, looping through PersonalId list but it did not help when I look at my database I got:

PersonalId = 1232

FirstName = Diane,Suzanne,Debbie

LastName = Smith,Boyle,Reynold

PersonalId = 3433

FirstName = Diane,Suzanne,Debbie

LastName = Smith,Boyle,Reynold

etc

Form Fields:
FirstName = Diane,Suzanne,Debbie,David,Mark,Ron

LastName = Smith,Boyle,Reynold,Tomang,Schulteis,Wong

PersonalId = 1232,3433,4532,234,678,65,77

DeptCode = ACC,FRNTD,DPRD,MRKT,BSNS,ACQUIS

Help with single quote please!

forums_noreply@adobe.com — Fri, 22 Jan 2010 19:59:33 GMT

I'm doing a simple varchar insert :

Insert into tablename (column1, column2, etc) Values (' #value1# ', ' #value2# ', etc)

How to avoid value with single quote such as: ' L'Enfant Plaza '

CFFILE in CF8

forums_noreply@adobe.com — Mon, 26 Oct 2009 15:45:54 GMT

Is it true that CFFILE in CF8 is now able to accomodate large file upload without any problem. In the following blog, it says the writer has tried to upload 5 GB file with ease. http://www.rupeshk.org/blog/index.php/2007/08/coldfusion-8-changes-with-file-upload/

If this is correct than I don't need to split my huge file into several smaller files to be processed. My file won't go beyond 2 GB, may be between 1 to 2 GB the most. I need some advice from the more experience programmers. Thanks.

Still not too clear with cfif NOT

forums_noreply@adobe.com — Thu, 10 Sep 2009 18:26:04 GMT

Someone told me long time ago that it is better not to use <CFIF SomeVariable NEQ ""> which I have used a lot in my codes

It is much better when using <CFIF NOT SomeVariable> instead

Am I remember this correctly?

available system memory

forums_noreply@adobe.com — Tue, 11 Aug 2009 15:06:22 GMT

How to check for available system memory on Coldfusion server and also when I use local host?

insert into within cfloop list

forums_noreply@adobe.com — Tue, 26 May 2009 20:05:51 GMT

I was trying to loop aover a list and do a simple insert and I failed!!!

Have I done something wrong with my simple code below? Please help!

The column years is varchar 4

<cfset

myList="2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024 ,2025">

<cfloop

list="#myList#" index="i">

Insert Into

Tblyears (years)

value('#i#')

</cfquery>

</cfloop>

The Error :

Error executing database query

[Macromedia][Sybase JDBC Driver][Sybase] Incorrect syntax near 'value'

CF Structure

forums_noreply@adobe.com — Thu, 14 May 2009 17:10:25 GMT

my structure element does not show all the values when I do the following:

<CFSET

client_address="#q_Info.street1# #q_Info.street2# #q_Info.street3# #q_Info.foreign_cityzip# #q_Info.country_code#">

All of these actually show values:

#q_Info.street1#

#q_Info.street2#

#q_Info.street3#

#q_Info.foreign_cityzip#

#q_Info.country_code#"

By doing this:

client_address only show the value of #q_Info.street1#

Is there some kind of rule that I can't assign more values as the value of this structure element?

Need help with upper case

forums_noreply@adobe.com — Wed, 25 Mar 2009 16:08:06 GMT

I'm stuck on my coding when I have to write a function to detect upper cases has been used in a sentence
For example if my array element has this:
2345
SAINT PAUL
STREET
APT 5
PHILADELPHIA

I need to be able to write a code to let me know that the 2nd OR 3rd OR 5th element is written in upper case letter

Or if I set the variable not as array, 2345 SAINT PAUL STREET APT 5 PHILADELPHIA

I need to be able to detect that at least one of the section on that street name is written with upper case

Can anyone help please?

How to break?

forums_noreply@adobe.com — Mon, 23 Feb 2009 20:51:18 GMT

I'm looping within my structure elements and doing either cfswitch or cfif cfelse conditions
if I found a bad record I need to send out email and this record should not be inserted into db while the loop should keep looping if the the next set of record is good records. How can I do this? please help. Thanks!!!

Why setting var in CFFUNCTION causes error

forums_noreply@adobe.com — Mon, 26 Jan 2009 19:51:54 GMT

As far as my knowledge goes, the BEST practise when setting local variable inside a CFFUNCTION is to use the word "var" in front of the variable name, for example: <CFSET var myVariable="whatever">
I'm doing it now and all I get is an error message saying:
Error invoking CFC name_of_cfc:local variable myVariable on line 60 must be grouped at the top of the function body!

I'm using CF8 and I need to use cfswitch within the cffunction, so when I do <cfcase value="SomeValue"><cfset var myVariable="TheValue"></cfcase> etc I got that error.
When I tested with just CFSET var MyVariable="TheVariable" with no cfswitch/cfcase I still get that error
when I took out the word "var" from cfset, I have no error, I put these variables directly after my cfarguments. Does anyone know why this is happening to me?

I thought if I don't use the "var" word for my variable set within cffunction there will be possibilities when later on setting up another variables outside this function and if the name happen to be the same, will override each other and causing disaster to my application.
Please help!!

How to create a varchar list?

forums_noreply@adobe.com — Tue, 20 Jan 2009 19:50:48 GMT

I need to create a list like this: '00','11','33','44'
When I use ValueList or ListAppend I got '00,11,22,33,44'
My simple codes are as follow:

query name="test" datasource="test">
select empID from Employers
</cfquery>

I tried: <CFSET EmpIDList=ValueList(test.EmpId)>
OR

<cfset MyList="">
<cfloop query="test">
<cfset MyList=#ListAppend(MyList, 'EmpID')>
</cfloop>

Both techniques creates a list that looks like : ' 00,11,22,33,44,55,66' which I can't use this list in the
select * from table where IDList IN ( '00,11,22,33,44,55,66')

Can anyone tell me how can I produce a list with each ID being surrounded by a single quote like ' 00 ', ' 22 ', ' etc so i can use the list on the select statement?

How to get something in return?

forums_noreply@adobe.com — Fri, 12 Dec 2008 19:08:17 GMT

I'm passing values to my component for an insert into db.
Since this is an insert, my function doesn't return anything, so I wrote <cfreturn true>
without putting cfreturn I would get an error.
This is fine except that I need my function to return something, just as an indication to the calling template that the inserting process is done.
How can i do that?

Help with Eclipse

forums_noreply@adobe.com — Fri, 07 Nov 2008 16:19:32 GMT

I've been searching for the answer for my problem and did not find any. Maybe some of you in this forum can help me?
I downloaded eclipse 3.4.1 and CFEclipse yesterday. Everything works except:
1. My line number is missing even after checking it in Preferences.
From other forum I found out a work around for it and that is to edit the org.cfeclipse.cfml.prefs found on
workspace folder but I don't even have this file.
workspace > .metadata >.pugin> .org.eclipse.core.runtime > .settings and edit org.cfeclipse.cfml.prefs to add
this line: LineNumberRuler=true

Again, I don't have the file called: org.cfeclipse.cfml.prefs
I'm wondering if anyone could point me to where I can download this file?

2. Auto complete is not working on this version.
In my previous version, when I typed in CFDump then an array of cfdum attribute will show up
How tos et this up?

Thanks for helping.
Mega_L

Help with eclipse installation, please!

forums_noreply@adobe.com — Tue, 21 Oct 2008 20:16:19 GMT

I usually use dreamweaver but now I have to use eclipse. I'm so confuse as where to start. I've googled for guide to eclipse installation but not sure what to do.
Here is what I found:
On this link http://www.cs.umd.edu/class/spring2006/cmsc132/EclipseTutorial/install.html it says I have to first install jdk-1_5_0_04-windows-i586-p.exe but I can't download this file because I'm not their student. I looked around everywhere and can't find this file for download.
Then I thought I may be just download eclipse from http://www.eclipse.org/downloads/
When I clicked download, I'm face with anothe confusing page, I'm not sure which one to choose.
Do I have to download : Eclipse Classic 3.4.1 (151 MB) ? how about JDK?
I searched for JDK on my machine and I did not see any jdk except jdk12utils folder, jdk118 folder, jdk122 folder and jaguar server (jdk1.2). There a re a bunch of other jdk such as JDK_JJ, JDK_VJ, etc

I need to use eclipse just to develop web application with coldfusion (locally) and databse Sybase and that is it. No java no nothing and I'm no java person so these things confuse me, please help!

Oh by the way, I also read somewhere that once I installed eclipse I need to install the CFEclipse.
Please help!!!!

How can I possibly get the state out?

forums_noreply@adobe.com — Fri, 26 Sep 2008 16:54:56 GMT

I'm facing with a strange records.
I need to get the state information out from 4 column NameAddresses.
Here is the scenario:
Column NameAdd1 is populated with records like:
1234 Smith Avenue TX 77581-5021,
3625 Cricket Creek DR,
555 RALPH MCGILL BLVD NE (NE is not Nebraska, NE stands for North East)

Column NameAdd2:
blank, >>>> because the State information for this person has been placed in NameAdd1 TX 77581-5021
DELTONA FL 32725, >>> this is the continuation from 3625 Cricket Creek Dr address on NameAdd1
RIO RANCHO NM 87144 >>is a continuation from 555 RALPH MCGILL BLVD NE

Column NameAdd3 :
blank,
blank,
blank,
MILWAUKEE WI 53202,
16 Pueblo Drive

Column NameAdd4:
blank,
blank,
blank,
blank,
Alhambra CA 91207

So, when Column NameAdd1 has contain State abbriviation and zip code (xxxxx-xxxx OR xxxxx) then other column NameAdds will be blank, when ColumnNameAdd1 only contain street name, then the state for that address is found on the next column which is NameAdd2, the same thing happen when NameAdd1 and nameAdd2 only contain person name and stree address then NameAdd3 or nameAdd4 will pick up the State information and zip code for this person address, etc

What technique could possibly I use to get only the state from each record from these 4 NameAdd columns? can anyone offer any thought?

How to create a text file from a query

forums_noreply@adobe.com — Thu, 31 Jul 2008 19:13:17 GMT

I need to generate a text file with CF. What I have is a query result with the values from 3 columns, OrderID, VersionID and Amount. I need to generate something like this:
0000123 | 002 | 1
0000124 | 002 | 2
0000125 | 002 | 5
0000126 | 002 | 1 and so on

I know I have to use <CFFILE action="write" file="#somepath#Invoice.txt .....>
but I'm not sure how can I output my query result into this text file??????
Please help....

Attributes of cfobject >> class

forums_noreply@adobe.com — Fri, 04 Aug 2006 17:19:28 GMT

I'm a newbie, learning to understand the concept of object oriented programming with cfobject. Can anyone help me with one of attribute of cfobject called : class?
In the documentation it says that: Class >> is required >> Enter the component ProgID for the object you want to invoke.
I'm embarass to say that I don't understand what it mean by : Enter the component ProgID for the object you want to invoke ?????

If I want to create a test template like the "hello world" using cfobject and class attribute (Note:I have to use class attributes of the cfobject because once I understand this attribute I will need to use it in my next assignment)
what am I supposed to write in my Hello World test template? is this one line enough? what should I write in class attribute and how do I know if the object has been instantiated? please help!

<cfobject type="COM" name="Testting" class="???????????" action="CREATE">

I'm using cfmx 6, and I'm testing out of my dev. server

Trying to generate 4 digit number

forums_noreply@adobe.com — Fri, 28 Mar 2008 14:32:49 GMT

Hi there, I'm trying to generate sequence of four digit number when looping my records
I have to come up with number like: 0001, 0002, 0003, 0004,.................,9999.
I know how to loop through 1,2,3,4,5,6 etc but how can I add 000 for the 1 digit, 00 for the 2 digits, 0 for the 3 digits and no 0 on the 4 digits.
Can someone show me the easy way to do this?
The script I wrote below did not work due to syntax and may be logic error?

<CFSCRIPT>

for ( i = 1; i LTE listLen( RecordContents, crlf ); i = i + 1 ) {

SeqNum=SeqNum + 1;
if Len(SeqNum) EQ 1{
SeqNum=("000" & SeqNum);
}
else if Len(SeqNum) EQ 2{
SeqNum=("00" & SeqNum);
}
else if Len(SeqNum) EQ 3{
SeqNum=("0" & SeqNum);
}
else if Len(SeqNum) EQ 4{
SeqNum=SeqNum;
}

}

</CFSCRIPT>

Help

forums_noreply@adobe.com — Thu, 13 Mar 2008 20:42:14 GMT

Our system is set so our client will be able to send in files (text file or word or pdf) to one specific folder in our server. How can I write in CF codes to check if new files have arrived each day o be fruther manipulated?
Is this possible?

Help with CreateObject()

forums_noreply@adobe.com — Tue, 04 Mar 2008 16:08:11 GMT

I have just learned to use CreateObject() with CF.
I understand this syntax:
request.initFnds = createObject("component","#application.cfcroot#.system.loadFndSettings")
However,
I don't understand this (especially the string start with .init....), what is this for, can someone explain to me?
request.initFnds = createObject("component","#application.cfcroot#.system.loadFndSettings") .init(dsn="#application.mainDSN#",pID="#attributes.pID#",tempSecID="#attributes.secID#",
DocID="#attributes.DocID#");

looping in SQL

forums_noreply@adobe.com — Thu, 14 Feb 2008 15:09:22 GMT

My CF need to call a store procedure. I'm done creating this part but I'm not sure with writing a loop in sql syntax
I can easily do this in CF but I have no choice but writing it in store procedure and I have not had experience in this area especialyy with sql syntax. I'm using MSSQL V.8.0
Can anyone help me?
Here is what I need to do, sound pretty simple when it is done in cf:

The CF will passes shipmentID, an integer value, to sp_GetShipType (which I have to create)

First I need to use the ShipmentID to obtain ShipmentNo and OrderID:

select shipmentNo, OrderID from Shipments where ShipmentID = ShipmentID then

This will generates many records (not just one) and I need to use these records to loop over another set of select statements (This is the part that I'm not sure how to write)

I googled to get some tutorials and so far I got a message that there is no loop in MSSQL except using While loop
(?) unlike cfloop we have loop list, query loop, while loop, etc.
Can anyone help me?
Thank you!
------------------------------------------------------------------------------------------ ---------------------
CREATE PROCEDURE sp_GetShipType

@ShipmentID,

AS

select ShipmentNo, OrderID from Shipments where ShipmentID=@ShipmentID

-- How to Loop over the query result above in here

many select statements here

-- end loop

GO

How to preview CF tags

forums_noreply@adobe.com — Mon, 28 Jan 2008 19:00:42 GMT

I need to build error report in CF. I have difficulty showing the CF codes (tag) in preview. I think because CF server filter out all the CF tag before showing the result in the browser. But in this forum, the preview screen is able to show cf tags/code. can someone tell me how to do that?

How to search through a list

forums_noreply@adobe.com — Wed, 09 Jan 2008 17:25:41 GMT

I have a query result for example:
FormName A B C D
FormID 1 10 5 6

I need to search either FormID 6 or 7 exist in this recordset, so I can do somethng like this:

if 6 is on the query <cfset MyID=6> else if 7 is on the query <cfset MyID=7>

What is the best way to do it considering the query result may contain either 6 or 7 or none?

How diffetent is it?

forums_noreply@adobe.com — Tue, 11 Dec 2007 18:51:47 GMT

I need to write a cfif conditional statement but I still have not gotten a firm understanding for the differences between the two.

if (PID NEQ 0 and ((EmpID NEQ 5) OR (EmpID NEQ 6))) in compared to

if (PID NEQ 0 and ((EmpID NEQ 5) AND (EmpID NEQ 6))), what is the difference?

My logic is:
if PID NEQ 0 AND either EmpID NEQ 5 or EmpID NEQ 6 then do something. So, I tralnslated this logic into:
(PID NEQ 0 and ((EmpID NEQ 5) OR (EmpID NEQ 6)))

This in fact did not show what I need to see

BUT if I did:

(PID NEQ 0 and ((EmpID NEQ 5) AND (EmpID NEQ 6))) , it gives me what I wanted.

My understanding is:
When I use ((EmpID NEQ 5) AND (EmpID NEQ 6)) in a parenthesis, this statement will be evaluated first before it evaluates PID EQ or NEQ 0
So this statement, if my understanding is correct, will only work if both EmpID is 5 AND 6. If only one EmpID is true then this statement return False. Am I wrong?

<CFIF NOT VariableName>

forums_noreply@adobe.com — Tue, 13 Nov 2007 18:40:19 GMT

Does <CFIF NOT VariableName> the same as <CFIF isDefined("VariableName")> Or it is checking if VariableName is 0 ?

How to pass diff. Values to the same function

forums_noreply@adobe.com — Thu, 25 Oct 2007 16:37:38 GMT

I'm calling an existing function called PLayout() from 2 different locations. PLayout function and the calling functions are all at the same page.
From the 1st location, on top of the page, I'm passing PID: <cfset PLayout(UserID,PID)>

From the 2nd Location, at the bottom of the page, I'm passing DocID : <cfset PLayout(UserID,DocID)>

This is the existing Function:

<cffunction name="PLayout" output="No">
<cfargument name="UserID" required="Yes">
<cfargument name="PID" required="Yes">
<cfargument name="DocID" required="No"> <<<<< I added this and required set to NO otherwise I got error
saying DocID is not passed.

<cfquery datasource="#application.maindsn#" name="doInsert">
DECLARE @LayoutID int;
SET @LayoutID = (SELECT SetVal FROM SysSet WHERE SetName = 'Layout' AND
PID = <cfif IsDefined ("DocID")> #DocID# <cfelse> #PID# </cfif>);

DELETE FROM J_P_L
WHERE UserID = #UserID#;

INSERT INTO J_P_L(UserID, PID, LayoutID)
VALUES(#UserID#,<cfif IsDefined ("DocID")> #DocID# <cfelse> #PID# </cfif>, @LayoutID);
</cfquery>

</cffunction>

The Problem with this is:
The value of PID is never used in the SQL, it is always using the Value of DocID...., Have I done something wrong? please advice.

Structure question, please help.

forums_noreply@adobe.com — Tue, 23 Oct 2007 16:34:47 GMT

I got an error saying:
The argument STLOCANDATTAHMENTIDS passed to function CheckExistance() is not of type structure.
Have I done something wrong? Please help!

Here is what I did:

<CFFUNCTION name="InsertPlanAttLocationAttachment">
<cfargument name="LocationName" required="true" type="string">

<cfquery name="getLocationID" datasource="#application.maindsn#">
Select AL.LocationID, JTAA.AttachmentID
From attachmentLocations AL
JOIN J_Templatesections_AttachmentLocations_Attachments JTAA
ON AL.LocationID = JTAA.LocationID
Where AL.LocationName='#LocationName#'
</cfquery>

<CFSET stLoc_and_AttachIDs=StructNew()>
<CFSET stLoc_and_AttachIDs["LocationID"]="#getLocationID.LocationID#">
<CFSET stLoc_and_AttachIDs["AttachmentID"]="#getLocationID.AttachmentID#">

<cfreturn stLoc_and_AttachIDs>
</CFFUNCTION>

<CFFUNCTION Name="CheckExistance">
<cfargument name="stLocAndAttahmentIDs" required="true" type="structure">

<cfquery name="IsRecordFound" datasource="#application.maindsn#">
Select * from j_plans_attachmentlocations_attachments
Where PlanID=#PlanID# and LocID=#stLocAndAttahmentIDs["LocationID"]# and attachID=#stLocAndAttahmentIDs
["AttachmentID"]#
</cfquery>

<CFRETURN #IsRecordFound.Recordcount#>
</CFFUNCTION>

<CFSET LocationName="Term Form (PDF)">
<CFSET stLocAndAttahmentIDs=InsertPlanAttLocationAttachment(LocationName)>

<CFSET RecordExist=CheckExistance(stLocAndAttahmentIDs)>
<cfif RecordExist EQ 0>
<cfquery name="AssociatingPlanAttachmentLocAndAttachment" datasource="#dsn#">
INSERT INTO j_p_attlocs_atts (PlanID, LocationID, AttachmentID, AttachmentStatusID)
VALUES (#PlanID#, #stLocAndAttahmentIDs["LocationID"]#, #stLocAndAttahmentIDs["AttachmentID"]#, 3)
</cfquery>
</cfif>

How to use the structure on my insert statement.

forums_noreply@adobe.com — Mon, 22 Oct 2007 15:58:03 GMT

I have a function and returning a structure:
<CFSET stLoc_and_AttIDs=StructNew(1)>
<CFSET stLoc_and_AttIDs["LocID"]="#getLocID.LocationID#">
<CFSET stLoc_and_AttIDs["AttID"]="#getLocID.AttachmentID#">

I call this function like this:
<CFSET LocAndAttIDs= MyFunction(LocName)>

I'm having difficulty in refering to the values of this structure in my insert statement:
I'm doing it this way and got error, I'm sure I didn't do it right, please help.

Insert Into MyTable (Column1, Column2, Column3, .....)
VALUES (#LocAndAttIDs.stLoc_and_AttIDs["LocID"]="#, #LocAndAttIDs.stLoc_and_AttIDs["AttID"], 23)

declaring a variable in CF

forums_noreply@adobe.com — Mon, 22 Oct 2007 13:41:57 GMT

I thought when a variable is needed, CF developer can just set it on the fly, <cfset var MyVar="assign a value here">
I'm writing a simple UDFs, and did not declare a variable. The error I got was Variable is undefined. Should I declared the variable when it is used within a function?

<cffunction name="InUser">
<cfargument name="EmpID" required="true" type="numeric">
<cfargument name="DeptArray" required="true" type="array">

<cfset NewUserID = 0> ----????????? If Omitted this, I got error saying NewUserID is Undefined.
.
.
.
<CFSET NewUserID = GetNewUser(UserName)>
.
.
Then I use the value of NewUserID for something else down here.
.
.

</cffunction>

<cffunction name="GetNewUser">
select statement to get userID based on userName

<CFRETURN #GetID.UserID#>
</cffunction>

help on CF Structure

forums_noreply@adobe.com — Fri, 12 Oct 2007 13:50:30 GMT

I like to use cfdump on a structure and I've been trying to get the value of this structure without any success. Can anyone help me please?

I start with this line of codes found on a .cfc
<cfif StructKeyExists(getUserAccessStruct(),"#PrivilegeType#.EditTextAttachment")>
<cfset lReturn=true>
</cfif>

I'm tracing what and where is getUserAccessStruct() coming from and I came to : (still within the same .cfc file)
<cffunction name="getUserAccessStruct" access="public" output="false" returntype="struct">
<cfreturn variables.instance.userAccessStruct />
</cffunction>

In order for me to know what is actually the value of this structure, how can I dump the value? and
where should I look for the return value of variables.instance.UserAccessStruct?
what variables.instance.UserAccessStruct represents?

How to get specific character from a string

forums_noreply@adobe.com — Mon, 01 Oct 2007 19:56:55 GMT

I have a value such as: 0-5 or 123-30. This is a combination from 2 different IDs.
All I need is to get the number on the right (5 from 0-5 OR 30 from 123), any number on the right of the "-" character not including
the "-"
I'm not sure what ColdFusion function can I use safely.
I said safely since all I can find is either Left or Right functions. With these 2 functions, I need to specify the number of character to extract while in my case the application is growing so the ID may currently be only 1 digit each (0-5) but later it may grow longer (123-5677).

If anyone know the function, please help me. Thank you!

Help in converting cfscript to cftag syntax

forums_noreply@adobe.com — Thu, 06 Sep 2007 12:50:24 GMT

Can I get some help on converting the following few lines of cfscript into cftag?

<cfscript>
planNumbers = StructKeyArray( S_New );
for ( planNumber IN S_New ) {
request.logger.debug("debug: planNumber: #planNumber#");
S_Funds[ planNumber ] = structNew();
.......................................
........................................
........................................
}
</cfscript>

How to search for a matching string

forums_noreply@adobe.com — Tue, 28 Aug 2007 16:23:30 GMT

<cfcatch>
<CFMAIL to="XY@yahoo.com" From="12@yahoo.com" Subject="Error message" Type="HTML">
#cfcatch.message#
</CFMAIL>
</cfcatch>

I need to create a condition based on the string in the message, if #cfcatch.message# is "The element at position 12 of dimension 3 can not be found" I need to deliver certain message through email BUT if #cfcatch.message# is matching other
sentence I need to deliver a different message.

I used the following condition (see below) but it somehow did not work, even when I know for sure the error message is saying the right think, for example, "The element at position 12...etc"
Is there a way to do this differently or have I done it wrong somewhere?

<cfif #cfcatch.message# EQ "The element at position 12 of dimension 3 can not be found">
Deliver message 1
cfelse>
Deliver message 2
</cfif>

Adobe Community : All Content - All Communities

Error Executing Database Query

Created a Global UDF but don't know how to call it, please assist

Installing ColdFusion 11 in Windows 8.1

Strange behavior on a simple Delete/Truncate Statements

Where to set key to be used with Encrypt function

can't I call a function this way?

Missing argument name.

application.cfc vs application.cfm

Please help with datatype mismatch on insert statement

Error Executing Database Query.

working with rss

A Database Error Occurred

Unable to read the source URL.

Need help with CF component call, please

How to get rid of special char? Help please!

can I ignore a return result?

ColdFusion 8 and Ajax

Need help with setting up datasource

Help with creating a list

Help with ListLen()

How to set identity to the 1st record in cfquery

Problem with looping on some List

Help with single quote please!

CFFILE in CF8

Still not too clear with cfif NOT

available system memory

insert into within cfloop list

CF Structure

Need help with upper case

How to break?

Why setting var in CFFUNCTION causes error

How to create a varchar list?

How to get something in return?

Help with Eclipse

Help with eclipse installation, please!

How can I possibly get the state out?

How to create a text file from a query

Attributes of cfobject >> class

Trying to generate 4 digit number

Help

Help with CreateObject()

looping in SQL

How to preview CF tags

How to search through a list

How diffetent is it?

<CFIF NOT VariableName>

How to pass diff. Values to the same function

Structure question, please help.

How to use the structure on my insert statement.

declaring a variable in CF

help on CF Structure

How to get specific character from a string

Help in converting cfscript to cftag syntax

How to search for a matching string