RE: Workstation name ?
Hi Dave, Thanks for your email. Yes, workstation means my desktop machine name.. thanks ramesh -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 7:01 PM To: CF-Talk Subject: RE: Workstation name ? How do i know my workstation name thru programatically? Can you be more specific? Are you looking for the name of the client or the web server? The Windows name or the DNS name? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Workstation name ?
Thanks Dave and Tom.. here i found cfx_systeminfo.zip from following link.. it works me fine.. http://www.intrafoundation.com/cfx_systeminfo.asp http://www.intrafoundation.com/coldfusion.html Thanks ramesh -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 9:22 AM To: CF-Talk Subject: Re: Workstation name ? On Tuesday 09 Mar 2004 15:03 pm, Dave Watts wrote: That isn't exposed to your web server, typically. I suppose you could get that information through an ActiveX control. Wasn't there a post recently ? :hunts Look for the subject Getting computer name via variables? in the archives, which refs: http://www.bertd.net/downloads/whatserveristhis.zip -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
read word(image) document and create new word document with message..
Hi, Here i have one document(source file) which is in RTF format (contains background image and size of the document is 3 MB) and reading this document and storing as a another RTF document with adding some message thru programatically. when i see created new document size is 3MB. but my requirement is to reduce the document size. so i changed source RTF file to Doc format and reduced 60 KB. once i read this document and created as new doc file with message, then it is creating properly. but i could n't able to open this document.. and saying following message. The document name orpath is not valid This is my code.. cfscript sStart = message; sEnd = /message; sCRLF = \par#chr(13)##chr(10)#; sMessage = \par \par \par Dear Doug,\par \par ramesh test\par \par Thank You\par Robert; nPlace = 1; /cfscript !--- take any image document as a sourcefile..for your example.. --- cffile action="" file=C:\devfolder\inc\sourcefile.doc variable=sFileContents cfloop condition=nPlace gt 0 cfset nStartPos=nPlace cfset nPlace=findNoCase(sStart,sFileContents,(nStartPos+1)) /cfloop cfset nEndPos=findNoCase(sEnd,sFileContents,(nStartPos+1)) cfset sFileContents=left(sFileContents,(nStartPos-1))sMessageright(sFileCont ents,(len(sFileContents)-nEndPos-len(sEnd)+1)) cffile action=""> file=C:\devfolder\doc\ramesh.doc output=#sFileContents# addnewline=Yes if i read RTF (3mb) document thru this code.. it is reading well and creating well with 3MB document.. but we need to reduce the size of the document.. Any ideas will be greatly appreciated.. Thanks Ramesh -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 9:18 AM To: CF-Talk Subject: Re: XML - structure - WDDX - JS On Thursday 04 Mar 2004 09:04 am, Taco Fleur wrote: I was under the impression that when I parse XML it is a CF structure? Only if you call XMLParse() Am I wrong, is it not a structure that can be converted to _javascript_ with WDDX? Once you have it as a CF structure, you can turn it into WDDX in the normal way. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
read word(image) document and create new word document with message..
Hi, Here i have one document(source file) which is in RTF format (contains background image and size of the document is 3 MB) and reading this document and storing as a another RTF document with adding some message thru programatically. when i see created new document size is 3MB. but my requirement is to reduce the document size. so i changed source RTF file to Doc format and reduced 60 KB. once i read this document and created as new doc file with message, then it is creating properly. but i could n't able to open this document.. and saying following message. The document name orpath is not valid This is my code.. cfscript sStart = message; sEnd = /message; sCRLF = \par#chr(13)##chr(10)#; sMessage = \par \par \par Dear Doug,\par \par ramesh test\par \par Thank You\par Robert; nPlace = 1; /cfscript !--- take any image document as a sourcefile..for your example.. --- cffile action="" file=C:\devfolder\inc\sourcefile.doc variable=sFileContents cfloop condition=nPlace gt 0 cfset nStartPos=nPlace cfset nPlace=findNoCase(sStart,sFileContents,(nStartPos+1)) /cfloop cfset nEndPos=findNoCase(sEnd,sFileContents,(nStartPos+1)) cfset sFileContents=left(sFileContents,(nStartPos-1))sMessageright(sFileCont ents,(len(sFileContents)-nEndPos-len(sEnd)+1)) cffile action=""> file=C:\devfolder\doc\ramesh.doc output=#sFileContents# addnewline=Yes if i read RTF (3mb) document thru this code.. it is reading well and creating well with 3MB document.. but we need to reduce the size of the document.. Any ideas will be greatly appreciated.. Thanks Ramesh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Workstation name ?
Hi, How do i know my workstation name thru programatically? Is there any custom tag is available ? Thanks Ramesh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF5.0 And CFMX date formats
Hi , This problems has not yet solved.. really appreciate if u have any ideas.. I have written following code to display date.. cfquery name=getDate datasource=DSN_Test select D_DATE from employee /cfquery cfoutput query=getDate #D_DATE# /cfoutput but in CFMX environment it shows : 2003-04-30 00:00:00.0 (milli seconds format.. Its java locale standard date format. Default format.) In CF5.0 Environment it shows : 04/30/2003 00:00:00 (normal format) So here my question is that can we change this default milliseconds format to normal format in CFMX environment with out writing the code.. I know that we can write the code to convert one format to another..but we have a lot of places in another files.. so is there any file where we can change default format to normal format in globally.. it should reflect in all cfm pages too.. Thanks in Advance.. Best regards Ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF5.0 And CFMX date formats
Hi I have written following code to display date.. cfquery name=getDate datasource=DSN_Test select D_DATE from employee /cfquery cfoutput query=getDate #D_DATE# /cfoutput but in CFMX environment it shows : 2003-04-30 00:00:00.0 (milli seconds format.. Its java locale standard date format. Default format.) In CF5.0 Environment it shows : 04/30/2003 00:00:00 (normal format) So here my question is that can we change this default milliseconds format to normal format in CFMX environment with out writing the code.. I know that we can write the code to convert one format to another..but we have a lot of places in another files.. so is there any file where we can change default format to normal format in globally.. it should reflect in all cfm pages too.. Thanks in Advance.. Best regards Ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF5.0 And CFMX date formats
Hi I have written following code to display date.. cfquery name=getDate datasource=DSN_Test select D_DATE from employee /cfquery cfoutput query=getDate #D_DATE# /cfoutput but in CFMX environment it shows : 2003-04-30 00:00:00.0 (milli seconds format.. Its java locale standard date format. Default format.) In CF5.0 Environment it shows : 04/30/2003 00:00:00 (normal format) So here my question is that can we change this default milliseconds format to normal format in CFMX environment with out writing the code.. I know that we can write the code to convert one format to another..but we have a lot of places in another files.. so is there any file where we can change default format to normal format in globally.. it should reflect in all cfm pages too.. Thanks in Advance.. Best regards Ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FW: Address verification request
-Original Message- From: Deva, Ramesh Sent: Friday, December 20, 2002 6:15 PM To: '[EMAIL PROTECTED]' Subject: RE: Address verification request Hi This is my list and having following data.. EXPRID,EXPRNAME,EXPRSHORT,EVENTSOURCEID,ACTIONNAME,ACTION,BUILTINFUNCTION,DB FIELDNAMES,VALUESELECTION,EXPRESSION,EXPRCMTS EXPRID = '0' EXPRNAME = 'ra' EXPRSHORT = 'ra' EVENTSOURCEID = '1' ACTIONNAME ='new' ACTION = 'save' BUILTINFUNCTION ='Employee_Age()' DBFIELDNAMES = '' VALUESELECTION = '' EXPRESSION = 'Employee_Age() EQ 25' EXPRCMTS='dfdfdf' But here in following error showing list has 10 elements.. how come it showling like that.. Appreciated for any help.. == Error : In function ListGetAt(list, index [, delimiters]), the value of index, 11, is not a valid as the first argument (this list has 10 elements). Valid indexes are in the range 1 through the number of elements in the list. The error occurred in C:\WebSphere\AppServer\installedApps\cfusion.ear\cfusion.war\AtWorkOnline\ap p\admin\rule\exprSave.cfm: line 89 87 : cfloop from=1 to=#ListLen(fieldNames)# index=i 88 :cfparam name=#ListGetAt(fieldNames,i)# default=#trim(ListGetAt(fieldValues,i,|))# 89 : /cfloop == Thanks regards Ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
list Index error
-Original Message- From: Deva, Ramesh Sent: Friday, December 20, 2002 6:17 PM To: '[EMAIL PROTECTED]' Subject: FW: Address verification request -Original Message- From: Deva, Ramesh Sent: Friday, December 20, 2002 6:15 PM To: '[EMAIL PROTECTED]' Subject: RE: Address verification request Hi This is my list and having following data.. EXPRID,EXPRNAME,EXPRSHORT,EVENTSOURCEID,ACTIONNAME,ACTION,BUILTINFUNCTION,DB FIELDNAMES,VALUESELECTION,EXPRESSION,EXPRCMTS EXPRID = '0' EXPRNAME = 'ra' EXPRSHORT = 'ra' EVENTSOURCEID = '1' ACTIONNAME ='new' ACTION = 'save' BUILTINFUNCTION ='Employee_Age()' DBFIELDNAMES = '' VALUESELECTION = '' EXPRESSION = 'Employee_Age() EQ 25' EXPRCMTS='dfdfdf' But here in following error showing list has 10 elements.. how come it showling like that.. Appreciated for any help.. == Error : In function ListGetAt(list, index [, delimiters]), the value of index, 11, is not a valid as the first argument (this list has 10 elements). Valid indexes are in the range 1 through the number of elements in the list. The error occurred in C:\WebSphere\AppServer\installedApps\cfusion.ear\cfusion.war\AtWorkOnline\ap p\admin\rule\exprSave.cfm: line 89 87 : cfloop from=1 to=#ListLen(fieldNames)# index=i 88 :cfparam name=#ListGetAt(fieldNames,i)# default=#trim(ListGetAt(fieldValues,i,|))# 89 : /cfloop == Thanks regards Ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
unicode
Actually i want some info on unicode.(and i gone thru www.unicode.org also) can any body knows about how it works. In my form i have two fields one is combo. in that combo i have differenct languages are there ( i mean for english - EN, Chainease - CH like that ) if i choose chainease - CH then next text field accept chainease words from my key board. and when i display this one i want to see chainease words which i entered in that text field. how can i do this one. Thanx in advance Ramesh Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Quick Question - Size Limit?
HAHAHAH HAI RUDY SIZE LIMIT IS 255 CHARS FOR CLIENT V THANX RAMESH -Original Message- From: Rudy Rustam [mailto:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 2:34 PM To: CF-Talk Subject: Quick Question - Size Limit? is there a size limit for client, application and session? if yes, what's the limit line? i'm dying for the answer rgds, - rudy Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
urgent (Difference between two logics)
Hi All
Actually i have small doubt.
Can any one clarify which one is best logic and pls before justifying the
answer i want disadvantage for other one also..
Here i am trying to retrive query results into structure.
Developer A. written this logic
cfset Selstruct=structnew()
cfset arrfields = arraynew(1)
cfset a=#trim(ucase(query1.columnlist))#
cfset ln = ListLen(#a#)
cfif #attributes.fields# EQ "*"
CFLOOP From="1" To="#ln#" INDEX="i"
cfset
arrfields[i]=#ListGetAt(query1.columnlist, i)#
/CFLOOP
cfelseif #attributes.fields# NEQ "*"
CFLOOP From="1" To="#ln#" INDEX="i"
cfset
arrfields[i]=#ListGetAt(ATTRIBUTES.fields, i)#
/CFLOOP
/cfif
CFLOOP From="1" To="#ln#" INDEX="i"
cfscript
selstruct['#arrfields[i]#'] =
arraynew(1);
/cfscript
/cfloop
cfloop query="query1"
cfloop from="1" to = "#ln#" index="i"
cfscript
selstruct[#arrfields[i]#][query1.currentrow]=#evaluate(arrfields[i])#;
/cfscript
/cfloop
/cfloop
See here develop A logic also giveing correct results.
Retrurns results of query into Selstruct.
Example :
Selstruct.eno[1] -- eno is column name of table--
Selstruct.eno[2]
Here i noticed is for every column we will be creating array..
(Colmns of table : max 15 to 20)
Developer B. written this logic
cfloop query="qselect"--qselect is structure--
cfset RowCount = qselect.CurrentRow
cfset Selstruct[RowCount]=StructNew()
cfloop index="FieldName"
list="#qselect.ColumnList#"
cfset
tmp=StructInsert(Selstruct[RowCount],FieldName,Evaluate("qselect.#FieldName#
"))
/cfloop
/cfloop
See here develop B logic also working correctly
Retrurns results of query into Selstruct.
Example :
Selstruct[1].eno -- eno is column name of table--
Selstruct[2].eno
Here i noticed is for every row willbe creating one structred array..
So that if table may contain 10,000 rows.
Is there any disadvantage if i use this logic(Developer-B)..
if u prefer Developer A logic then pls tell me Developer B logic
disadvantage.
I am expecting answer from u.
I think u understood my cocern.
Thanx in advance.
Ramesh
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
uregent(difference between two logics)
Hi All
Actually i have small doubt.
Can any one clarify which one is best logic and pls before justifying the
answer i want disadvantage for other one also..
Here i am trying to retrive query results into structure.
Developer A. written this logic
cfset Selstruct=structnew()
cfset arrfields = arraynew(1)
cfset a=#trim(ucase(query1.columnlist))#
cfset ln = ListLen(#a#)
cfif #attributes.fields# EQ "*"
CFLOOP From="1" To="#ln#" INDEX="i"
cfset
arrfields[i]=#ListGetAt(query1.columnlist, i)#
/CFLOOP
cfelseif #attributes.fields# NEQ "*"
CFLOOP From="1" To="#ln#" INDEX="i"
cfset
arrfields[i]=#ListGetAt(ATTRIBUTES.fields, i)#
/CFLOOP
/cfif
CFLOOP From="1" To="#ln#" INDEX="i"
cfscript
selstruct['#arrfields[i]#'] =
arraynew(1);
/cfscript
/cfloop
cfloop query="query1"
cfloop from="1" to = "#ln#" index="i"
cfscript
selstruct[#arrfields[i]#][query1.currentrow]=#evaluate(arrfields[i])#;
/cfscript
/cfloop
/cfloop
See here develop A logic also giveing correct results.
Retrurns results of query into Selstruct.
Example :
Selstruct.eno[1] -- eno is column name of table--
Selstruct.eno[2]
Here i noticed is for every column we will be creating array..
(Colmns of table : max 15 to 20)
Developer B. written this logic
cfloop query="qselect"--qselect is structure--
cfset RowCount = qselect.CurrentRow
cfset Selstruct[RowCount]=StructNew()
cfloop index="FieldName"
list="#qselect.ColumnList#"
cfset
tmp=StructInsert(Selstruct[RowCount],FieldName,Evaluate("qselect.#FieldName#
"))
/cfloop
/cfloop
See here develop B logic also working correctly
Retrurns results of query into Selstruct.
Example :
Selstruct[1].eno -- eno is column name of table--
Selstruct[2].eno
Here i noticed is for every row willbe creating one structred array..
So that if table may contain 10,000 rows.
Is there any disadvantage if i use this logic(Developer-B)..
if u prefer Developer A logic then pls tell me Developer B logic
disadvantage.
I am expecting answer from u.
I think u understood my cocern.
Thanx in advance.
Ramesh
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: uregent(difference between two logics)
No James I think u r not understand my problem Actually I want to send query results into structure ( that is my program specs like that)( this is customtag) while creating structure of arrays i used two different logics. but i want answer from that which one is best one. Thanx Ramesh -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 22, 2000 5:44 PM To: CF-Talk Subject: Re: uregent(difference between two logics) ---Reply to mail from Deva Ramesh about uregent(difference between two logics) Hi All Actually i have small doubt. Can any one clarify which one is best logic and pls before justifying the answer i want disadvantage for other one also.. Here i am trying to retrive query results into structure. You DO realise that you can use access a query in the way you want already don't you ? For example... CFQUERY DATASOURCE="#ds#" NAME="Q_MyQuery" SELECT ClientName, ClientNumber FROM Clients /CFQUERY CFOUTPUT The first name from the query is #Q_MyQuery.ClientName[1]#, that clients number is #Q_MyQuery.ClientNumber[1]#. /CFOUTPUT --- James Sleeman [EMAIL PROTECTED] (home) [EMAIL PROTECTED] (work) Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
columnlist
hi all, To retrieve the columnlist from the table i'm using #queryname.columnlist# by doing this i'm getting all the columnnames, no problems, but itz not giving the output in the same way in which i created in the table. eg: in the database i've got the table, fields consists of eno,ename,phone Once i retrieved the columnlist i should get in the same order but i'm getting ename,eno,phone(may be itz giving in alphabetical order) how to solve this, any suggetions would be appreciated. thanx in advance ramesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
text field
Hi I have a text field that is pulling up content from a DB. This content will at times contain HTML statements. I'm having problems right now with the textarea stripping out the HTML command (non-breaking space, in case it doesn't show up here either) nbsp; I put it in through the textarea field, and I can see it in the DB, but when I pull it up again in the text field, they are gone. And as soon as I submit the text field again... they're gone for good. The other problem I'm having right now is with the /textarea command it sees that, and ends my textarea before its through putting out all the information into the textarea field. Thanx in advance Ramesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FW: cfapplet problem
-Original Message- From: Deva Ramesh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 6:01 PM To: '[EMAIL PROTECTED]' Subject: cfapplet problem Hi all Actually i am trying to place one java applet on my browser. so that i down loaded one applet from the net and saved that class file in /cfide/classes/allaire/controls path. after that i registred that class file in coldfusion administrator applet page also. And i have written following to code in cold fusion.. CFFORM ACTION="snow.cfm" CFAPPLET appletsource="snow" NAME="snow" /CFFORM when i am executing the progrom, i could n't see picture. but when i click on applet then it is going to site from where i down loaded. has any body faced this type of problem? Thanx in advance. ramesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfapplet problem
Hi all Actually i am trying to place one java applet on my browser. so that i down loaded one applet from the net and saved that class file in /cfide/classes/allaire/controls path. after that i registred that class file in coldfusion administrator applet page also. And i have written following to code in cold fusion.. CFFORM ACTION="snow.cfm" CFAPPLET appletsource="snow" NAME="snow" /CFFORM when i am executing the progrom, i could n't see picture. but when i click on applet then it is going to site from where i down loaded. has any body faced this type of problem? Thanx in advance. ramesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: (OT) SQL Server?
Hellow Akbar Use image data type to that field Thanx Ramesh -Original Message- From: Akbar [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 7:44 PM To: CF Talk (E-mail) Subject: (OT) SQL Server? hi all, how do we store .mpeg or .dat to be exact movies in SQL server?? wat would be the data type for it?? any ideas? thanx in advance akbar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
Hai Has anybody idea about cfapplet tag. Here i downloaded one applet file from the net and registered in to coldfusion administrator. After that follwing code i written to execute the file then it showing blank applet only. what is wrong in my code. And some of the files contains more than one class files. if it is that case then how should we represent these class files in my code. CFFORM ACTION="snow1.cfm" CFAPPLET appletsource="snow" NAME="snow" HEIGHT="200" WIDTH="400" /CFFORM Thanx - Ramesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfapplet tag problem
Hai Has anybody idea about cfapplet tag. Here i downloaded one applet file from the net and registered in to coldfusion administrator. After that follwing code i written to execute the file then it showing blank applet only. what is wrong in my code. And some of the files contains more than one class files. if it is that case then how should we represent these class files in my code. CFFORM ACTION="snow1.cfm" CFAPPLET appletsource="snow" NAME="snow" HEIGHT="200" WIDTH="400" /CFFORM Thanx - Ramesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: NEED HELP Encrypt Url ?
Hai
I am trying to open report with follwoing code. and i don't want show userid
and password of database in address location bar. then in my current system
it is working fine( i mean userid and password converting into encryption
format).
but problem is when i open an others system then it is
populating dialogbox and saying that "plese enter userid and password for
database" .
so i don't want to populate this dialogbox to users.
Plese can any one help me na.
This is my code.
cfset rep = CFUSION_ENCRYPT("user0=ianmedrptpassword0=ianmedrpt","2")
cflocation url="../report/hrall.rpt?init=actx#rep#"
Thanx
Ramesh
-Original Message-
From: Steve Bernard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 8:47 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: NEED HELP Encrypt Url ?
I know how to use cfencrypt/cfdecrypt. In the posting to which I responded,
Karl, the writer, stated, "I solved the problem by getting rid of the CF
encrypt/decrypt method and developing a custom encryption/decryption
algorithm to pass encrypted URLs, which has worked fine ever since." It was
to this that I was asking for more information.
Regards,
Steve
-Original Message-
From: Mirek Hryckowiak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 26, 1998 5:44 PM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP Encrypt Url ?
Steve,
the cfencrypt, cfdecrypt usage is:
!--- encrypt string ---
cfset encryptedVariable = CFUSION_ENCRYPT("InputString","yourKey")
!--- decrypt string ---
cfset decryptedVariable = CFUSION_DECRYPT("encryptedVariable","yourKey")
To encrypt/decrypt url (cgi.query_sring) use:
!--- test.cfm ---
!--- if your link should be: test2.cfm?a=1b=2c=n ---
cfset eV = CFUSION_ENCRYPT("a=1b=2c=n","yourKey")
a href="test.cfm?#eV#"check it/a
!--- test2.cfm ---
cfset cgiList = CFUSION_DECRYPT("eV","yourKey")
!--- ...write some code to get the variable/value pairs from
you eV (encrypted cgi string) variable ---
Have fun,
Miro
- Original Message -
From: "Steve Bernard" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 17, 2000 9:47 PM
Subject: RE: NEED HELP Encrypt Url ?
Could you share your solution with the class?
Steve
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
Hai
I am trying to open report with follwoing code. and i don't want show userid
and password of database in address location bar. then in my current system
it is working fine( i mean userid and password converting into encryption
format).
but problem is when i open an others system then it is
populating dialogbox and saying that "plese enter userid and password for
database" .
so i don't want to populate this dialogbox to users.
Plese can any one help me na.
This is my code.
cfset rep = CFUSION_ENCRYPT("user0=ianmedrptpassword0=ianmedrpt","2")
cflocation url="../report/hrall.rpt?init=actx#rep#"
Thanx
Ramesh
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
encrypt url
Hai
I am trying to open report with follwoing code. and i don't want show userid
and password of database in address location bar. then in my current system
it is working fine( i mean userid and password converting into encryption
format).
but problem is when i open an others system then it is
populating dialogbox and saying that "plese enter userid and password for
database" .
so i don't want to populate this dialogbox to users.
Plese can any one help me na.
This is my code.
cfset rep = CFUSION_ENCRYPT("user0=ianmedrptpassword0=ianmedrpt","2")
cflocation url="../report/hrall.rpt?init=actx#rep#"
Thanx
Ramesh
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
url encrypt
Hai
I am trying to open report with follwoing code. and i don't want show userid
and password of database in address location bar. then in my current system
it is working fine( i mean userid and password converting into encryption
format).
but problem is when i open an others system then it is
populating dialogbox and saying that "plese enter userid and password for
database" .
so i don't want to populate this dialogbox to users.
Plese can any one help me na.
This is my code.
cfset rep = CFUSION_ENCRYPT("user0=ianmedrptpassword0=ianmedrpt","2")
cflocation url="../report/hrall.rpt?init=actx#rep#"
Thanx
Ramesh
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
crysal report migration(7 to 8) problem
Hai We are facing the problem when we migrate crystal reports version7.0 to 8.0 by displaying the dialogbox saying "cannot open report in sqlserver" So after displying this dialog box when we press refresh buttton then report is coming. user doesn't face this kind of problem. Actually we didn't face this problem when we are used crystal reports 7.0 version. Plese can any body faced this kind of problem. if yes, then how u solved? Thanx Ramesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
update command
Hai
This is dynamic update statement
Actucally if i take only 3 text boxes then no problem. but when i take 3 one
is select box then getting problem
here i am getting value from this variable #Evaluate("FORM.selecta#i#")# .
problem is when executing the cfquery command at 3 rd time this select box
value is not passing
properly and giving the following error.
first two values are passing correctly. becos these are text boxes. and
output is coming like this. I think when control comes in 3 rd loop giving
the problem.
suppose if i give output as #Evaluate("FORM.selecta3")# , then i am seeing
value of this variable.
can anybody help na.
Update student set sno = 99 WHERE sno = 99
Update student set sname = 'ramesh1' WHERE sno = 99
Bottom of Form 0
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'WHERE'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (110:3) to (110:43).
Date/Time: 06/25/00 19:12:22
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 127.0.0.1
This is my code...
cfloop from ="1" to ="#ln#" index="i"
cfif
#Evaluate("ATTRIBUTES.listfields.field_chara[#i#]")# EQ "0"
cfif
#Evaluate("ATTRIBUTES.listfields.fieldoptionsa[#i#]")# NEQ ""
CFSET values = values
#Evaluate("FORM.selecta#i#")# ","
cfelse
CFSET values = #evaluate("FORM.txt#i#")#
/cfif
cfelse
cfif
#Evaluate("ATTRIBUTES.listfields.fieldoptionsa[#i#]")# NEQ ""
CFSET values = values "'"
#Evaluate("FORM.selecta#i#")# "',"
cfelse
CFSET values = "'"
#evaluate("FORM.txt#i#")# "'"
/cfif
/cfif
cfset
fieldv=#Evaluate("ATTRIBUTES.listfields.fielda[#i#]")#
cfquery name="queryu" datasource ="#ds#"
Update #ATTRIBUTES.listfields.tablename#
set #fieldv# = #preservesinglequotes(values)#
WHERE
#ATTRIBUTES.listfields.uniquefield# =
#attributes.id1#
/cfquery
/cfloop
Thanx
Ramesh
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
update command syntax
Hai
This is dynamic update statement
Actucally if i take only 3 text boxes then no problem. but when i take 3rd
one is select box then getting problem.
here i am getting value from this variable #Evaluate("FORM.selecta#i#")# .
problem is when executing the cfquery command at 3 rd time, this select box
value is not passing in to update statement and giving the following error.
first two values are passing correctly. becos these are text boxes. and
output is coming like this. I think when control comes in 3 rd loop giving
the problem.
even i am seeing value of this variable if i give output as
#Evaluate("FORM.selecta3")# ,
can anybody help na.
Update student set sno = 99 WHERE sno = 99
Update student set sname = 'ramesh1' WHERE sno = 99
Bottom of Form 0
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'WHERE'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (110:3) to (110:43).
Date/Time: 06/25/00 19:12:22
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 127.0.0.1
This is my code...
cfloop from ="1" to ="#ln#" index="i"
cfif
#Evaluate("ATTRIBUTES.listfields.field_chara[#i#]")# EQ "0"
cfif
#Evaluate("ATTRIBUTES.listfields.fieldoptionsa[#i#]")# NEQ ""
CFSET values = values
#Evaluate("FORM.selecta#i#")# ","
cfelse
CFSET values = #evaluate("FORM.txt#i#")#
/cfif
cfelse
cfif
#Evaluate("ATTRIBUTES.listfields.fieldoptionsa[#i#]")# NEQ ""
CFSET values = values "'"
#Evaluate("FORM.selecta#i#")# "',"
cfelse
CFSET values = "'"
#evaluate("FORM.txt#i#")# "'"
/cfif
/cfif
cfset
fieldv=#Evaluate("ATTRIBUTES.listfields.fielda[#i#]")#
cfquery name="queryu" datasource ="#ds#"
Update #ATTRIBUTES.listfields.tablename#
set #fieldv# = #preservesinglequotes(values)#
WHERE
#ATTRIBUTES.listfields.uniquefield# =
#attributes.id1#
/cfquery
/cfloop
Thanx
Ramesh
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
combo box problem
Hellow every body I want to populate the list values into combo box. so i written two types of codes. but populating only first list value. ( i means i am seeing only first value of the list in to combo box) First i converted list to array and i used that array values thru loop in to combo box. Then i find only one value in combo box. And i used directly list thru loop also. Eventhough not populating with all list values. See following code i written. CFSET temp = "nagesh,akbar,ramesh" CFOUTPUT#ListLen(temp)#/CFOUTPUT users./H3 CFLOOP From="1" To="#ListLen(temp)#" INDEX="i" CFOUTPUTLIUsername # i #: #ListGetAt(temp, i)# /CFOUTPUT /CFLOOP cfset option = arraynew(1) CFLOOP From="1" To="#ListLen(temp)#" INDEX="i" cfset option[i] = #ListGetAt(temp, i)# /CFLOOP !--- tdselect name ="sselect" CFLOOP From="1" To="#ListLen(temp)#" INDEX="i" option value = #ListGetAt(temp, i)# cfoutput#ListGetAt(temp, i)#/cfoutput/option /select/td/tr /CFLOOP /td /tr --- 2nd code tdselect name ="sselect" CFLOOP INDEX="j" LIST="John,Paul,George,Ringo" option value = #j# cfoutput#j#/cfoutput/option /select/td/tr /CFLOOP /td /tr /table Thanx Ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Quickstore
Hai It work if u change just bit of code like modifying the query. I mean that u remove order by clause in the query.And he specified columnnames with quotes in the query. So just remove the quotes. Ya for me also i face same problem. but after chnagng the code then it is working fine. -Original Message- From: Jay Sener, CPCM [mailto:[EMAIL PROTECTED]] Sent: Monday, June 19, 2000 10:07 AM To: [EMAIL PROTECTED] Subject: Quickstore I know this is basic, but I am attempting to build a store using the Quickstore code from the Cold Fusion Web Application (by Ben Forta) and can't seem to get it to work properly. Is anyone familiar with this or any of the challenges related to this cart? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFINPUT required??
hi all, i have a very simple problem here. my CFINPUT tag doesnt work properly. when i want it to be required it does not pop up the Dialog box. am i missing something here? thanx in advance ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfinput Tag problem
Hai every body
Actually this is custom tag related problem. i am inserting the values
dynamically. but problem is in add form when i blank with filling any data
in to text boxes then i want show pop up message like " plese enter the
values " . and same i don't want execute action of form (---inserting the
values code). means after entering the all values only i want to go to
action. so for that one i written following code. here i gave for every
attirbute requirefield is "yes" . i know in cfinput command, message
property is not there.
plese can any body help me ???
thanx
ramesh
cfif isdefined('form.add')
inserting the values code-
cfelseif isdefined('form.abort')
--- aborting code
cfelse
CFFORM ACTION="#cgi.http_script#" METHOD="post"
cfquery name= "querya"
datasource="#ATTRIBUTES.datasource#"
select * from #ATTRIBUTES.tablename#
/cfquery
cfset a=#trim(querya.columnlist)#
cfset ln = ListLen(#a#)
cfoutput
cfloop from ="1" to ="#ln#" index="i"
TABLE align="center"
cfset
fieldv=#Evaluate("ATTRIBUTES.heading" i)#
TR
TD width=#ATTRIBUTES.tdhwidth#font
face=#ATTRIBUTES.fontface# size=#ATTRIBUTES.fontsize##fieldv#/font/TD
TD align="center"
width=#ATTRIBUTES.tdwidth#
CFINPUT TYPE="Text"
NAME="txta#i#"
cfif
"#Evaluate("ATTRIBUTES.requiredfield" i)#" EQ "yes"
required="yes"
/cfif
/td
/cfloop
/TABLE
br
table align="center"
trtd align="left"
input type = "submit" name= "add" value =
"Add"/td
tdinput type = "submit" name= "Abort"
value = "Abort"/td/tr
/table
/cfoutput
/CFFORM
/cfif
Employee Id ...
Name ...
City ...
Salary ...
Address ...
... Add Abort
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfinput Tag problem
-Original Message-
From: Deva Ramesh
Sent: Monday, May 29, 2000 12:35 PM
To: '[EMAIL PROTECTED]'
Subject: cfinput Tag problem
Hai every body
Actually this is custom tag related problem. i am inserting the values
dynamically. but problem is in add form when i blank with filling any data
in to text boxes then i want show pop up message like " plese enter the
values " . and same i don't want execute action of form (---inserting the
values code). means after entering the all values only i want to go
to action. so for that one i written following code. here i gave for every
attirbute requirefield is "yes" . i know in cfinput command, message
property is not there.
plese can any body help me ???
thanx
ramesh
cfif isdefined('form.add')
inserting the values code-
cfelseif isdefined('form.abort')
--- aborting code
cfelse
CFFORM ACTION="#cgi.http_script#" METHOD="post"
cfquery name= "querya"
datasource="#ATTRIBUTES.datasource#"
select * from #ATTRIBUTES.tablename#
/cfquery
cfset a=#trim(querya.columnlist)#
cfset ln = ListLen(#a#)
cfoutput
cfloop from ="1" to ="#ln#" index="i"
TABLE align="center"
cfset
fieldv=#Evaluate("ATTRIBUTES.heading" i)#
TR
TD width=#ATTRIBUTES.tdhwidth#font
face=#ATTRIBUTES.fontface#
size=#ATTRIBUTES.fontsize##fieldv#/font/TD
TD align="center"
width=#ATTRIBUTES.tdwidth#
CFINPUT TYPE="Text"
NAME="txta#i#"
cfif
"#Evaluate("ATTRIBUTES.requiredfield" i)#" EQ "yes"
required="yes"
/cfif
/td
/cfloop
/TABLE
br
table align="center"
trtd align="left"
input type = "submit" name= "add" value =
"Add"/td
tdinput type = "submit" name= "Abort"
value = "Abort"/td/tr
/table
/cfoutput
/CFFORM
/cfif
Employee Id...
Name ...
City ...
Salary ...
Address...
... Add Abort
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
insert command with attributes
hai everybody
this is customtag related problem. i am trying to insert values from
attributes. so i have written following code.
here 1 st question is can i use loop with in the insert command? and
when u r passing the value can i check the condition whether
attributes.field_char#i# is char or numeric. (here 0 means numeric, 0 is
char)
based on that one i am filtering with cfif condition.
but problem is while executing error is coming. that error i am pasting here
here we can use any alternative way to run this one.
cfquery name="queryac" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
cfloop from ="1" to ="#ln#" index="i"
(#evaluate("ATTRIBUTES.field#i#")#)
VALUES(
cfif #Evaluate("attributes.field_char#i#")# EQ "0"
#FORM.txta#i#,
cfelse
'#FORM.txta#i#',
/cfif
)
/cfloop
/cfquery
ERROR here:
Error Diagnostic Information
Just in time compilation error
Invalid parser construct found on line 9 at position 17. ColdFusion was
looking at the following text:
,
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was dynamic text (a CFML
expression) occupying document position (9:4) to (9:14).
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\CUSTOMTAGS\LISTADDF.CFM
C:\CFUSION\CUSTOMTAGS\LISTADD.CFM Custom Tag
The error occurred while processing an element with a general identifier
of (CFMODULE), occupying document position (4:3) to (29:5) in the template
file C:\InetPub\wwwroot \customtags\listaddf.cfm.
Date/Time: 05/25/00 11:33:20
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 127.0.0.1
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: insert command with attributes
hai mike
yr idea is really excellent. but while executing the program again it s
giving Error.
that i specified here.
thanx
Ramesh
CFSET fields = ""
CFSET values = ""
cfloop from ="1" to ="#ln#" index="i"
CFSET fields = fields evaluate("ATTRIBUTES.field#i#") ","
CFSET values = values cfif Evaluate("attributes.field_char#i#") EQ
"0"
CFSET values = values
evaluate(FORM.txta#i#) ","
cfelse
CFSET values = values "'"
evaluate(FORM.txta#i#) "',"
/cfif
/cfloop
CFSET fields = left(fields, len(fields) - 1)
CFSET values = left(values, len(values) - 1)
cfquery name="queryac" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
(#fields#)
VALUES
(#preservesinglequotes(values)#)
/cfquery
ERROR
Just in time compilation error
Invalid token found on line 55 at position 30.
ColdFusion was looking at the following text:
cInvalid expression element. The usual cause of this error is a misspelling
in the expression text.
The last successfully parsed CFML construct was a CFSET tag occupying
document position (55:5) to (55:10).
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\CUSTOMTAGS\LISTADDF.CFM
C:\CFUSION\CUSTOMTAGS\LISTADD.CFM Custom Tag
The error occurred while processing an element with a general identifier of
(CFMODULE), occupying document position (4:3) to (29:5) in the template file
C:\InetPub\wwwroot\customtags\listaddf.cfm.
_
-Original Message-
From: Mike Sheldon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 4:00 PM
To: [EMAIL PROTECTED]
Subject: RE: insert command with attributes
You end up with too many commas
Your query ends up looking like this:
INSERT INTO yada
(field1,field2,field3,)
VALUES
(value1,value2,value3,)
You can't have extraneous punctuation in the query. I'd suggest you build
the field and value strings BEFORE the query, so you have an opportunity to
hack off that last comma from the strings.
CFSET fields = ""
CFSET values = ""
cfloop from ="1" to ="#ln#" index="i"
CFSET fields = fields evaluate("ATTRIBUTES.field#i#") ","
CFSET values = values
cfif Evaluate("attributes.field_char#i#") EQ "0"
CFSET values = values evaluate("FORM.txta#i#") ","
cfelse
CFSET values = values "'" evaluate("FORM.txta#i#")
"',"
/cfif
/cfloop
CFSET fields = left(fields, len(fields) - 1)
CFSET values = left(values, len(values) - 1)
cfquery name="queryac" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
(#fields#)
VALUES
(#preservesinglequotes(values)#)
/cfquery
Michael J. Sheldon
Internet Applications Developer
Phone: 480.699.1084
http://www.desertraven.com/
PGP Key Available on Request
-Original Message-
From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 00:38
To: '[EMAIL PROTECTED]'
Subject: insert command with attributes
hai everybody
this is customtag related problem. i am trying to insert values from
attributes. so i have written following code.
here 1 st question is can i use loop with in the insert command? and
when u r passing the value can i check the condition whether
attributes.field_char#i# is char or numeric. (here 0 means numeric, 0 is
char)
based on that one i am filtering with cfif condition.
but problem is while executing error is coming. that error i am pasting here
here we can use any alternative way to run this one.
cfquery name="queryac" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
cfloop from ="1" to ="#ln#" index="i"
(#evaluate("ATTRIBUTES.field#i#")#)
VALUES(
cfif #Evaluate("attributes.field_char#i#")# EQ "0"
#FORM.txta#i#,
cfelse
'#FORM.txta#i#',
/cfif
)
/cfloop
/cfquery
ERROR here:
Error Diagnostic Information
Just in time compilation error
Invalid parser construct found on line 9 at position 17. ColdFusion was
looking at the following text:
,
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was dynamic text (a CFML
expression) occupying document position (9:4) to (9:14).
The specific sequence of files in
RE: insert command with attributes
hellow mike
i am getting error in this line cfif
Evaluate("attributes.field_char#i#") EQ "0" --
i think u r opend cfset tag but where u r ending whether after /cfif na or
?
i used here and tried. still not coming.
one more thing mike i think u can find where is the getting problem na.
help me.
thanx
ramesh
Error Diagnostic Information
Just in time compilation error
Invalid token found on line 55 at position 30. ColdFusion was looking at the
following text:
c
Invalid expression element. The usual cause of this error is a misspelling
in the expression text.
The last successfully parsed CFML construct was a CFSET tag occupying
document position (55:5) to (55:10).
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\CUSTOMTAGS\LISTADDF.CFM
C:\CFUSION\CUSTOMTAGS\LISTADD.CFM Custom Tag
The error occurred while processing an element with a general identifier of
(CFMODULE), occupying document position (4:3) to (29:5) in the template file
C:\InetPub\wwwroot\customtags\listaddf.cfm.
-Original Message-
From: Mike Sheldon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 4:00 PM
To: [EMAIL PROTECTED]
Subject: RE: insert command with attributes
You end up with too many commas
Your query ends up looking like this:
INSERT INTO yada
(field1,field2,field3,)
VALUES
(value1,value2,value3,)
You can't have extraneous punctuation in the query. I'd suggest you build
the field and value strings BEFORE the query, so you have an opportunity to
hack off that last comma from the strings.
CFSET fields = ""
CFSET values = ""
cfloop from ="1" to ="#ln#" index="i"
CFSET fields = fields evaluate("ATTRIBUTES.field#i#") ","
CFSET values = values
cfif Evaluate("attributes.field_char#i#") EQ "0"
CFSET values = values evaluate("FORM.txta#i#") ","
cfelse
CFSET values = values "'" evaluate("FORM.txta#i#")
"',"
/cfif
/cfloop
CFSET fields = left(fields, len(fields) - 1)
CFSET values = left(values, len(values) - 1)
cfquery name="queryac" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
(#fields#)
VALUES
(#preservesinglequotes(values)#)
/cfquery
Michael J. Sheldon
Internet Applications Developer
Phone: 480.699.1084
http://www.desertraven.com/
PGP Key Available on Request
-Original Message-
From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 00:38
To: '[EMAIL PROTECTED]'
Subject: insert command with attributes
hai everybody
this is customtag related problem. i am trying to insert values from
attributes. so i have written following code.
here 1 st question is can i use loop with in the insert command? and
when u r passing the value can i check the condition whether
attributes.field_char#i# is char or numeric. (here 0 means numeric, 0 is
char)
based on that one i am filtering with cfif condition.
but problem is while executing error is coming. that error i am pasting here
here we can use any alternative way to run this one.
cfquery name="queryac" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
cfloop from ="1" to ="#ln#" index="i"
(#evaluate("ATTRIBUTES.field#i#")#)
VALUES(
cfif #Evaluate("attributes.field_char#i#")# EQ "0"
#FORM.txta#i#,
cfelse
'#FORM.txta#i#',
/cfif
)
/cfloop
/cfquery
ERROR here:
Error Diagnostic Information
Just in time compilation error
Invalid parser construct found on line 9 at position 17. ColdFusion was
looking at the following text:
,
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was dynamic text (a CFML
expression) occupying document position (9:4) to (9:14).
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\CUSTOMTAGS\LISTADDF.CFM
C:\CFUSION\CUSTOMTAGS\LISTADD.CFM Custom Tag
The error occurred while processing an element with a general identifier
of (CFMODULE), occupying document position (4:3) to (29:5) in the template
file C:\InetPub\wwwroot \customtags\listaddf.cfm.
Date/Time: 05/25/00 11:33:20
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 127.0.0.1
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
---
RE: insert command with attributes
hai mike
thanx lot now it is working fine. just i removed one line code from u. (that
is --- CFSET values = values-).
after removing the code then executing properly.
any how this credits goes especially for u only.
bai
Thanx
ramesh
-Original Message-
From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 6:23 PM
To: '[EMAIL PROTECTED]'
Subject: RE: insert command with attributes
hellow mike
i am getting error in this line cfif
Evaluate("attributes.field_char#i#") EQ "0" --
i think u r opend cfset tag but where u r ending whether after /cfif na or
?
i used here and tried. still not coming.
one more thing mike i think u can find where is the getting problem na.
help me.
thanx
ramesh
Error Diagnostic Information
Just in time compilation error
Invalid token found on line 55 at position 30. ColdFusion was looking at the
following text:
c
Invalid expression element. The usual cause of this error is a misspelling
in the expression text.
The last successfully parsed CFML construct was a CFSET tag occupying
document position (55:5) to (55:10).
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\CUSTOMTAGS\LISTADDF.CFM
C:\CFUSION\CUSTOMTAGS\LISTADD.CFM Custom Tag
The error occurred while processing an element with a general identifier of
(CFMODULE), occupying document position (4:3) to (29:5) in the template file
C:\InetPub\wwwroot\customtags\listaddf.cfm.
-Original Message-
From: Mike Sheldon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 4:00 PM
To: [EMAIL PROTECTED]
Subject: RE: insert command with attributes
You end up with too many commas
Your query ends up looking like this:
INSERT INTO yada
(field1,field2,field3,)
VALUES
(value1,value2,value3,)
You can't have extraneous punctuation in the query. I'd suggest you build
the field and value strings BEFORE the query, so you have an opportunity to
hack off that last comma from the strings.
CFSET fields = ""
CFSET values = ""
cfloop from ="1" to ="#ln#" index="i"
CFSET fields = fields evaluate("ATTRIBUTES.field#i#") ","
CFSET values = values
cfif Evaluate("attributes.field_char#i#") EQ "0"
CFSET values = values evaluate("FORM.txta#i#") ","
cfelse
CFSET values = values "'" evaluate("FORM.txta#i#")
"',"
/cfif
/cfloop
CFSET fields = left(fields, len(fields) - 1)
CFSET values = left(values, len(values) - 1)
cfquery name="queryac" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
(#fields#)
VALUES
(#preservesinglequotes(values)#)
/cfquery
Michael J. Sheldon
Internet Applications Developer
Phone: 480.699.1084
http://www.desertraven.com/
PGP Key Available on Request
-Original Message-
From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 00:38
To: '[EMAIL PROTECTED]'
Subject: insert command with attributes
hai everybody
this is customtag related problem. i am trying to insert values from
attributes. so i have written following code.
here 1 st question is can i use loop with in the insert command? and
when u r passing the value can i check the condition whether
attributes.field_char#i# is char or numeric. (here 0 means numeric, 0 is
char)
based on that one i am filtering with cfif condition.
but problem is while executing error is coming. that error i am pasting here
here we can use any alternative way to run this one.
cfquery name="queryac" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
cfloop from ="1" to ="#ln#" index="i"
(#evaluate("ATTRIBUTES.field#i#")#)
VALUES(
cfif #Evaluate("attributes.field_char#i#")# EQ "0"
#FORM.txta#i#,
cfelse
'#FORM.txta#i#',
/cfif
)
/cfloop
/cfquery
ERROR here:
Error Diagnostic Information
Just in time compilation error
Invalid parser construct found on line 9 at position 17. ColdFusion was
looking at the following text:
,
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was dynamic text (a CFML
expression) occupying document position (9:4) to (9:14).
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\CUSTOMTAGS\LISTADDF.CFM
C:\CFUSION\CUSTOMTAGS\LISTADD.CFM Custom Tag
The error occurred while processing an element with a general identifier
of (CFMODULE), occupying document position (4:3) to (29:5) in the template
file C:\InetPub\wwwroot \customtags\listaddf.cfm.
Date/Time: 05/25/00 11:33:20
Browser
No Subject
hai all
the first commented code will work fine. but here i am trying to insert the
values into table thru loop(because here, dynamically passing the field
values into tables) so i used 2 nd code to implement to my aim. and here one
problem is raising for me that i donno whether perticular field is numeric
or character. so based on that one i have to give
condition. (see here in 1 st code, #form.txta1 is numeric and rest of the
fields are character types).
how can i check the condition. because if it is character type then i have
to specify the variable's value with in the single quotes and vice versa for
if it is numeric.
i am sure that my 2 nd code won't execute right now.
and can i specify the loop in the insert command?( i am not sure whether it
execute or not?)
plese can any body help me
thanx
Ramesh
1 st code
!--- cfquery name="querya" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
(#ATTRIBUTES.field1#,#ATTRIBUTES.field2#,
#ATTRIBUTES.field3#,#ATTRIBUTES.field4#,
#ATTRIBUTES.field5# )
VALUES
(#FORM.txta1#, '#FORM.txta2#', '#FORM.txta3#',
'#FORM.txta4#','#FORM.txta5#')
/cfquery ---
2 nd code
cfquery name="queryac" datasource="#attributes.datasource#"
cfloop from ="1" to ="#ln#" index="i"
Insert into #ATTRIBUTES.tablename#
(#evaluate("ATTRIBUTES.heading#i#")#)
VALUES
cfif condition-
("#FORM.txta#i#")
cfelse
('"#FORM.txta#i#"')
/cfif
/cfloop
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
insert command with loop
hai all
the first commented code will work fine. but here i am trying to insert the
values into table thru loop(because here, dynamically passing the field
values into tables) so i used 2 nd code to implement to my aim. and here one
problem is raising for me that i donno whether perticular field is numeric
or character. so based on that one i have to give
condition. (see here in 1 st code, #form.txta1 is numeric and rest of the
fields are character types).
how can i check the condition. because if it is character type then i have
to specify the variable's value with in the single quotes and vice versa for
if it is numeric.
i am sure that my 2 nd code won't execute right now.
and can i specify the loop in the insert command?( i am not sure whether it
execute or not?)
plese can any body help me
thanx
Ramesh
1 st code
!--- cfquery name="querya" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
(#ATTRIBUTES.field1#,#ATTRIBUTES.field2#,
#ATTRIBUTES.field3#,#ATTRIBUTES.field4#,
#ATTRIBUTES.field5# )
VALUES
(#FORM.txta1#, '#FORM.txta2#', '#FORM.txta3#',
'#FORM.txta4#','#FORM.txta5#')
/cfquery ---
2 nd code
cfquery name="queryac" datasource="#attributes.datasource#"
cfloop from ="1" to ="#ln#" index="i"
Insert into #ATTRIBUTES.tablename#
(#evaluate("ATTRIBUTES.heading#i#")#)
VALUES
cfif condition-
("#FORM.txta#i#")
cfelse
('"#FORM.txta#i#"')
/cfif
/cfloop
/cfquery
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
insert command with loop
hai all
the first commented code will work fine. but here i am trying to insert the
values into table thru loop(because here, dynamically passing the field
values into tables) so i used 2 nd code to implement to my aim. and here one
problem is raising for me that i donno whether perticular field is numeric
or character. so based on that one i have to give
condition. (see here in 1 st code, #form.txta1 is numeric and rest of the
fields are character types).
how can i check the condition. because if it is character type then i have
to specify the variable's value with in the single quotes and vice versa for
if it is numeric.
i am sure that my 2 nd code won't execute right now.
and can i specify the loop in the insert command?( i am not sure whether it
execute or not?)
plese can any body help me
thanx
Ramesh
1 st code
!--- cfquery name="querya" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
(#ATTRIBUTES.field1#,#ATTRIBUTES.field2#,
#ATTRIBUTES.field3#,#ATTRIBUTES.field4#,
#ATTRIBUTES.field5# )
VALUES
(#FORM.txta1#, '#FORM.txta2#', '#FORM.txta3#',
'#FORM.txta4#','#FORM.txta5#')
/cfquery ---
2 nd code
cfquery name="queryac" datasource="#attributes.datasource#"
cfloop from ="1" to ="#ln#" index="i"
Insert into #ATTRIBUTES.tablename#
(#evaluate("ATTRIBUTES.heading#i#")#)
VALUES
cfif condition-
("#FORM.txta#i#")
cfelse
('"#FORM.txta#i#"')
/cfif
/cfloop
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
insert command with loop
hai all
the first commented code will work fine. but here i am trying to insert the
values into table thru loop(because here, dynamically passing the field
values into tables) so i used 2 nd code to implement to my aim. and here one
problem is raising for me that i donno whether perticular field is numeric
or character. so based on that one i have to give
condition. (see here in 1 st code, #form.txta1 is numeric and rest of the
fields are character types).
how can i check the condition. because if it is character type then i have
to specify the variable's value with in the single quotes and vice versa for
if it is numeric.
i am sure that my 2 nd code won't execute right now.
and can i specify the loop in the insert command?( i am not sure whether it
execute or not?)
plese can any body help me
thanx
Ramesh
1 st code
!--- cfquery name="querya" datasource="#attributes.datasource#"
Insert into #ATTRIBUTES.tablename#
(#ATTRIBUTES.field1#,#ATTRIBUTES.field2#,
#ATTRIBUTES.field3#,#ATTRIBUTES.field4#,
#ATTRIBUTES.field5# )
VALUES
(#FORM.txta1#, '#FORM.txta2#', '#FORM.txta3#',
'#FORM.txta4#','#FORM.txta5#')
/cfquery ---
2 nd code
cfquery name="queryac" datasource="#attributes.datasource#"
cfloop from ="1" to ="#ln#" index="i"
Insert into #ATTRIBUTES.tablename#
(#evaluate("ATTRIBUTES.heading#i#")#)
VALUES
cfif condition-
("#FORM.txta#i#")
cfelse
('"#FORM.txta#i#"')
/cfif
/cfloop
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
hai all
i already posted one question related with this problem. later executed fine
with following code. but here problem is in second line i have written
input command in that i specified value like this. so when i am executing
this code, in second line also giving variable name. but i want to value of
that variable, i mean that i want to evaluate that variable
can any body help me.
thanx steven yr code is also working fine.
cfoutput query="query2"
table
cfloop from ="1" to ="#ln#" index="i"
TRTD#evaluate("ATTRIBUTES.heading#i#")#/TD
--firstline--
TDINPUT TYPE="Text" NAME="txt#i#"
VALUE="#evaluate("ATTRIBUTES.field#i#")#"/TD /TR --2nd ine--
/cfloop
/table
/cfoutput
variable = attributes.field1
variable name = ename (now i am getting the one only but not "abc")
variable value = "abc"
thanx
ramesh
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
hai all
i already posted one question related with this problem. later executed fine
with following code. but here problem is in second line i have written
input command in that i specified value like this. so when i am executing
this code, in second line also giving variable name. but i want to value of
that variable, i mean that i want to evaluate that variable
can any body help me.
thanx steven yr code is also working fine.
cfoutput query="query2"
table
cfloop from ="1" to ="#ln#" index="i"
TRTD#evaluate("ATTRIBUTES.heading#i#")#/TD
--firstline--
TDINPUT TYPE="Text" NAME="txt#i#"
VALUE="#evaluate("ATTRIBUTES.field#i#")#"/TD /TR --2nd ine--
/cfloop
/table
/cfoutput
variable = attributes.field1
variable name = ename (now i am getting the one only but not "abc")
variable value = "abc"
thanx
ramesh
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
nested tags problem??
hello all, my collegue has already posted this Q. but it seems that the question was not so clear. ok our problem is. we have the following files in webroot directory: 1) showtable.cfm--which invokes the custom tag "listtable.cfm" which inturn is in "cfusion/cutomtag/" directory. 2) edit.cfm-- which invokes the custom tag "edittable.cfm" which inturn is in "cfusion/cutomtag/" directory. now the thing is that i have a link in the custom tag "listtable.cfm" which redirects to editable.cfm for invoking the "edittable.cfm" cutom tag. but when i click on the link i get this following error. Error Diagnostic Information Cannot open CFML file The requested file "C:\INETPUB\WWWROOT\CUSTTAGS\EDITABLE.cfm" cannot be found. The specific sequence of files included or processed is: C:\INETPUB\WWWROOT\CUSTTAGS\EDIT.CFM C:\INETPUB\WWWROOT\CUSTTAGS\EDITABLE.cfm Custom Tag The error occurred while processing an element with a general identifier of (CF_EDITTABLE), occupying document position (2:1) to (9:22) in the template file C:\InetPub\wwwroot\custtags\edit.cfm. Date/Time: 05/16/00 12:07:57 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address: 127.0.0.1 HTTP Referer: http://127.0.0.1/custtags/showtable.cfm Query String: ID=11 someone has answered it by asking us to use "CFASSOCIATE" but the thing is that, a cfassociate tag can only be used when we place the "child tag" inside the "parent tag". but here in our case the edittable tag is not the child tag but an independent tag. however if i place the "edittable.cfm" file under the webroot, i am able to use it. but i want to keep all the custom tags un the cfusion directory. not scattered. sorry for being so long. but i hope u ppl understand me and help us out. thanx in advance ramesh _ __ | | | | |form page | | | | | -- | | | | | | | | | | | | | | ~~ |_ | | -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
hai all can we display the textboxes dynamically thanx ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
displays the textboxes dynamically
is there any way to display the text boxes dynamically, i mean if user wants 4 means 4 text boxes or 5 means 5 text boxes like that. Ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
i am developing one custom tag. here i am passing the values from calling page to custom tag but after that i want to pass those values from that custom tag to another calling page is there any way to pass like that.( i used session variables also ). and one more doubt can i invoke from one custom tag to another custom tag. Ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
display the textboxes dynamically
hai all can we display the textboxes dynamically thanx ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
custom tag problem
i am developing one custom tag. here i am passing the values from calling page to custom tag but after that i want to pass those values from that custom tag to another calling page is there any way to pass like that.( i used session variables also ). and one more doubt can i invoke from one custom tag to another custom tag. Ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
how to retrieve the column names
hi all, i want to retrieve the column names of the table using coldfusion. The database we r using is SQL server 7. i know how to get column names from query analyzer. but thru coldfusion is it possible to get them. thanx in advance ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RDS server security
hai every body can any body knows about RDS server security. because while debugging the page it is asking "enter RDS security information" i tried in all ways. but still it is coming actually lastday it was fine. i donno why it is coming. suppose if i want to see the usename and password of RDS then what should i do. bai ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RDS server username and password?
hai every body can any body knows about RDS server security. because while debugging the page it is asking "enter RDS security information" i tried in all ways. but still it is coming actually lastday it was fine. i donno why it is coming. suppose if i want to see the usename and password of RDS then what should i do. bai ramesh -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to debug a CF program
open debug tool from tool bar and press start/continue then gives the window which contains debug and mapping. then u shold set correctpath which u need to debug the file. after continue the process. but u should remember that before starting this process u should dblclick on the line which u want to start the debug from. then automatically it line turns to red colour. after that u can use step in and step out and so.on.. Ramesh -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 04, 2000 4:14 AM To: [EMAIL PROTECTED] Subject: How to debug a CF program Can someone let me know how to debug the program, so that I can see each step in the program flow. I know how to do it in Microsoft Visual Studio. Is there a utility in CF? Appreciate. A.B. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problem in search form
hai just try with this action page code ACTION FORM HTMLHEADCFQUERY NAME="GetResults" DATASOURCE="PRJreq" SELECT Req_No,Clt_Code FROM Requirement WHERE Req_Descript LIKE '%#Form.Criteria#%' /CFQUERY ramesh -Original Message- From: Denny dd [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 11:29 PM To: [EMAIL PROTECTED] Subject: Problem in search form Hi! Every one Here I have a Search form but its not working properly.The problem is that when ever I submit exact keywords as stored in my database,for example say "Java,C++" is stored in my database. So where ever there is "Java,C++" the search engine will work but if I submit keywords in different way like "C++,Java" ,then it shows no records available. And can any one tell me that can I use radio button for options like 1)Exact words 2)Any words 3)Exact phrase for the search engine. CODE SEARCH FORM /HEAD BODY h3font color="#00"Please enter keywords to search for./font/h3 FORM ACTION="srchtest2.cfm" METHOD="POST" Keywords: INPUT TYPE="text" NAME="Criteria"BR P INPUT TYPE="submit" VALUE="Search" /FORM /BODY /HTML ACTION FORM HTMLHEADCFQUERY NAME="GetResults" DATASOURCE="PRJreq" SELECT Req_No,Clt_Code FROM Requirement WHERE (Req_Descript LIKE '%#Form.Criteria#%') /CFQUERY TITLESearch Results/TITLE /HEAD BODY h3CFOUTPUT#GetResults.RecordCount# Requirements found for "#Form.Criteria#"./CFOUTPUT/h3 table width="52%" border="0" tr td width="29%"Requirment no/td td width="71%"Client code/td /tr tr td width="29%" height="35" h3cfoutput query="GetResults" /cfoutput/h3 ul cfoutput query="GetResults"li#Req_No# /cfoutput /ul/td td width="29%" height="35" h3cfoutput query="GetResults" /cfoutput/h3 ul cfoutput query="GetResults"li#Clt_Code# /cfoutput /ul /td /tr /table /BODY /HTML Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Creating SQL tables from queries
cfquery name = "qry1" datasource="name" create table tablename(eno char(10), ename varchar(30), doj date) /cfquery ramesh -Original Message- From: Robert Flesher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 2:30 AM To: [EMAIL PROTECTED] Subject: Creating SQL tables from queries Could someone please give me an example of how to create a table from a cfquery using CREATE TABLE. Thanx -Rob __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Working with dates
ya it is possible but u should specify dates with inthe quotes ramesh -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 02, 2000 11:38 PM To: [EMAIL PROTECTED] Subject: RE: Working with dates I want to be able to search my DB by anything added since mm/dd/ date. So, I am hoping I can say in my query ... WHERE Personal.DateEntered=04/28/2000, for example. Is this possible? Tim Bahlke Graphica www.thinkcreate.com P: 336.230.0575 F: 336.230.0083 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
