Previous date
Hi ! Can any one please tell me how can I display the previous date. For example if today is '03/21/01' then I have to display '03/20/01'. Is there any function which I can use. Shally ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Report
I have an access table where my webmaster has made tables as well as queries. Please tell me can I use these queries of Access Database in my ColdFusion program --in the tag CFQUERY the way the tables are used. Thanks in advance. Shally ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report
Hi, Thanks for your reply. I have already tried using the query of Access database in the tag CFQuery which is as follows cfquery name="report1" datasource="ShoppingCart" dbtype="ODBC" SELECT Date, Total Orders, Average Per Order, Total Items Sold, Total Dollar Amount Of Sales FROM 'Sales Totals By Day' /cfquery But this gives me the following error: +++ Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression 'Average Per Order'. SQL = "SELECT Date, 'Total Orders', Average Per Order, Total Items Sold, Total Dollar Amount Of Sales FROM 'Sales Totals By Day'" Data Source = "SHOPPINGCART" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (6:2) to (8:23) in the template file F:\Www\industrial\report\report1.cfm. Date/Time: 03/16/01 14:25:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 10.10.6.184 +++ I EVEN ADDED SINGLE CODE AROUND EACH FIELD BUT STILL THAT GIVES ME ERROR .PLEASE HELP!!! Thanks Shally. --- Dave Watts [EMAIL PROTECTED] wrote: I have an access table where my webmaster has made tables as well as queries. Please tell me can I use these queries of Access Database in my ColdFusion program --in the tag CFQUERY the way the tables are used. You can call Access queries from CF. If they're not parameter queries, you can reference them as if they were tables in your CFQUERY. If they are parameter queries, you can use CFSTOREDPROC to call them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report
Hi, Thanks for your reply. I have already tried using the query of Access database in the tag CFQuery which is as follows cfquery name="report1" datasource="ShoppingCart" dbtype="ODBC" SELECT Date, Total Orders, Average Per Order, Total Items Sold, Total Dollar Amount Of Sales FROM 'Sales Totals By Day' /cfquery But this gives me the following error: +++ Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression 'Average Per Order'. SQL = "SELECT Date, 'Total Orders', Average Per Order, Total Items Sold, Total Dollar Amount Of Sales FROM 'Sales Totals By Day'" Data Source = "SHOPPINGCART" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (6:2) to (8:23) in the template file F:\Www\industrial\report\report1.cfm. Date/Time: 03/16/01 14:25:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 10.10.6.184 +++ I EVEN ADDED SINGLE CODE AROUND EACH FIELD BUT STILL THAT GIVES ME ERROR .PLEASE HELP!!! Thanks Shally. --- Dave Watts [EMAIL PROTECTED] wrote: I have an access table where my webmaster has made tables as well as queries. Please tell me can I use these queries of Access Database in my ColdFusion program --in the tag CFQUERY the way the tables are used. You can call Access queries from CF. If they're not parameter queries, you can reference them as if they were tables in your CFQUERY. If they are parameter queries, you can use CFSTOREDPROC to call them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: You should hire this guy!!
WHICH GUY R U TALKING ABOUT --- Nathan Stanford [EMAIL PROTECTED] wrote: employment wanted.jpg ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report
Than you very much. YOU SOLVED MY PROBLEM --- Jann VanOver [EMAIL PROTECTED] wrote: Use square brackets around field and table names with spaces and see if that helps. For example: SELECT Date, [Total Orders], [Average Per Order], [Total Items Sold], [Total Dollar Amount Of Sales] FROM [Sales Totals By Day] -Original Message- From: monika kon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 11:28 AM To: CF-Talk Subject: RE: Report Hi, Thanks for your reply. I have already tried using the query of Access database in the tag CFQuery which is as follows cfquery name="report1" datasource="ShoppingCart" dbtype="ODBC" SELECT Date, Total Orders, Average Per Order, Total Items Sold, Total Dollar Amount Of Sales FROM 'Sales Totals By Day' /cfquery But this gives me the following error: +++ Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression 'Average Per Order'. SQL = "SELECT Date, 'Total Orders', Average Per Order, Total Items Sold, Total Dollar Amount Of Sales FROM 'Sales Totals By Day'" Data Source = "SHOPPINGCART" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (6:2) to (8:23) in the template file F:\Www\industrial\report\report1.cfm. Date/Time: 03/16/01 14:25:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 10.10.6.184 +++ I EVEN ADDED SINGLE CODE AROUND EACH FIELD BUT STILL THAT GIVES ME ERROR .PLEASE HELP!!! Thanks Shally. --- Dave Watts [EMAIL PROTECTED] wrote: I have an access table where my webmaster has made tables as well as queries. Please tell me can I use these queries of Access Database in my ColdFusion program --in the tag CFQUERY the way the tables are used. You can call Access queries from CF. If they're not parameter queries, you can reference them as if they were tables in your CFQUERY. If they are parameter queries, you can use CFSTOREDPROC to call them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Search engine
Hi Every one, I have to incorporate my search(which is a textfield on one of my CF templates) with other search engines so that if a user types in the textfield then all the search results showed come from other search engines such as Altavista or Excite. Can any one Please tell me the logic so as to how should I proceed. Thanks in advance Shally ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Automatic repair and compact
Thanks Adrian Cesana and Pan for all of your mails ..Its has been really helpful to me. I have a question ,Pan you have written in one of your mails that its better to compact and repair the database manually rather then using CF programm.Can you please tell me why yoyu said so. Shally --- pan [EMAIL PROTECTED] wrote: Thanks for the code you sent But as I am new to all this I would like to know that do I have to cfset the "objectMDB" and "tempmdb".I am failing to understand your programm please help/. O.K. I'll try to be more helpful. objectMDB is the access .mdb file you wish to compact and repair. The value of the variable is the full path to the .mdb file, e.g. c:\db\thisAccessFile.mdb tempMDB is likewise a full path for the DAO code to use when creating the compacted and repaired copy of objectMDB, e.g. c:\db\tempFile.mdb tempFile.mdb doesn't exist until the DAO call and will be renamed later by your code. The method the DAO call follows is to create a new copy of the file you wish to compact and repair. It is up to you to rename the tempMDB to your original filename after deleting the objectMDB. The call to the CF function cfset dropConnections = CFUSION_DBCONNECTIONS_FLUSH() is necessary as the cffile delete and rename actions will fail if the the .mdb is locked (i.e in use). In order to correctly assign the value of daoClass, look in c:\Program Files\Common Files\Microsoft Shared\DAO\ You should see either dao360.dll or dao350.dll depending on if you have Access2k or Access97 respectively. Advice: If you are going to schedule this, pick a time when it is less likely the db is going to be in use as CFUSION_DBCONNECTIONS_FLUSH() call might interrupt a user session. I prefer to use a tool I built to manually compress and repair any .mdb files I happen to be using. If you have any more questions, please feel free to ask. Pan From: "monika kon" [EMAIL PROTECTED] Subject: Automatic repair and compact Hi everyone, Is it possible to compact and repair Access databbase every day automatically through Coldfusion code.Please help!! Shally.. Yes. Acc97 DAO 3.5 Acc2k DAO 3.6 DAO needs to be on the server - there are ADO calls, but DAO seems better to me. The below script is the safest way I use. You should wrap the below in a cftry/cfcatch trap. core script: modfy to your needs cfset daoClass="DAO.DBEngine.36" or, cfset daoClass="DAO.DBEngine.35" CFOBJECT Action="create" name="DBEngine" Class="#daoClass#" CFSET dummy= DBEngine.CompactDatabase("#objectMDB#","#tempMDB#") cfset dropConnections = CFUSION_DBCONNECTIONS_FLUSH() cffile action="delete" file="#objectMDB#" cffile action="rename" source="#tempMDB#" destination="#objectMDB#" Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Automatic repair and compact
Thanks for the code you sent But as I am new to all this I would like to know that do I have to cfset the "objectMDB" and "tempmdb".I am failing to understand your programm please help/. --- pan [EMAIL PROTECTED] wrote: From: "monika kon" [EMAIL PROTECTED] Subject: Automatic repair and compact Hi everyone, Is it possible to compact and repair Access databbase every day automatically through Coldfusion code.Please help!! Shally.. Yes. Acc97 DAO 3.5 Acc2k DAO 3.6 DAO needs to be on the server - there are ADO calls, but DAO seems better to me. The below script is the safest way I use. You should wrap the below in a cftry/cfcatch trap. core script: modfy to your needs cfset daoClass="DAO.DBEngine.36" or, cfset daoClass="DAO.DBEngine.35" CFOBJECT Action="create" name="DBEngine" Class="#daoClass#" CFSET dummy= DBEngine.CompactDatabase("#objectMDB#","#tempMDB#") cfset dropConnections = CFUSION_DBCONNECTIONS_FLUSH() cffile action="delete" file="#objectMDB#" cffile action="rename" source="#tempMDB#" destination="#objectMDB#" Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Automatic repair and compact
Hi, I don't have DAO installed.I was going to install Access on my server.Can you please guide me how to use CF_EXECUTE or CFX_CONSOLECOMMAND.So that I won't have to install Access. Thanks in advance Shally --- Adrian Cesana [EMAIL PROTECTED] wrote: An alternate method if you dont have DAO/ADO available is to CF_EXECUTE (or CFX_CONSOLECOMMAND) a batch file with this in it: d:\path_to_msaccess\msaccess e:\data\mydata.mdb /repair d:\path_to_msaccess\msaccess e:\data\mydata.mdb /compact You could also easily schedule this as well using AT. I think in Access 2000 the compact also does the repair as well. There are other command line options as well like /exlu (I think thats it) that opens in Exclusive mode etc...Do a search in Access help on "Command Line" for more. Hope it helps, Adrian -Original Message- From: pan [mailto:[EMAIL PROTECTED]] From: "monika kon" [EMAIL PROTECTED] Subject: Automatic repair and compact Hi everyone, Is it possible to compact and repair Access databbase every day automatically through Coldfusion code.Please help!! Shally.. Yes. Acc97 DAO 3.5 Acc2k DAO 3.6 DAO needs to be on the server - there are ADO calls, but DAO seems better to me. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Drop down list
Hi every one, I am using CF_ThreeSelectsRelated to populate 3 drop down lists from the database.But I am facing a wierd problem.I am unable to add a textfield in the form where CF_ThreeSelectsRelated is present.Its giving me a javascript error. Thanks in advance: The code is as follows: +++ !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleUntitled/title /head cfquery name="getdata" datasource="catalog" dbtype="ODBC" SELECT MnGrp, MnGrp_Desc, ProductType, ProductType_Desc, Publisher, Publisher_Desc FROMglobalkeys_flat /cfquery body FORM ACTION="/action/result.cfm" METHOD="POST" onSubmit="return require_Sel1AndSel2AndSel3()" NAME="FormX" CF_ThreeSelectsRelated QUERY="GetData" HTMLAFTEREACHRADIO1="BR" HTMLAFTER1="br" HTMLAFTER2="BR" NAME1="Sel1" NAME2="Sel2" NAME3="sel3" DEFAULT1="1" DISPLAY1="Mngrp_desc" DISPLAY2="Producttype_Desc" DISPLAY3="Publisher_Desc" VALUE1="mngrp" VALUE2="producttype" VALUE3="Publisher" SIZE2="1" SIZE3="1" EXTRAOPTIONS2="1" EXTRAOPTIONS3="5" WIDTH2="250" WIDTH3="250" FORCEWIDTH2="80" FORCEWIDTH3="80" AUTOSELECTFIRST="Yes" FORM="FormX" br input type="Text" name="text1" size="30" BRINPUT TYPE="Submit" /FORM /body /html +++ __ Do You Yahoo!? Yahoo! Calendar - Get organized for the holidays! http://calendar.yahoo.com/ 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: Drop down List (Solved)
I got it it right James with the 3 drop down lists. Thanks +++== --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --49B842EC9410C3D199900F0E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit No, I have not used the Three Selects Related, but it should work on the same principle as Two Selects Related. monika kon wrote: Thank you very much, i am really very sorry for bothering you. It was my fault not putting the Form tag.. I have got it right. Thanks a lot for your patience. Please tell me if you have used "CF_Threeselectsrelated". I was trying this and I wanted all the 3 to be dropdown list.The example there on the site "http://nateweiss.com/taggallery/" is of Radio buttons and 2 dropdown list .As I said I want all the 3 to be drop down list. Can you please help me. Thanks a lot. Shally ++ --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --4A576A0EB0C5055670C186FA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit um, i dont see the opening form tag? can you cut and paste the entire file as you have it please? monika kon wrote: I am sending the code again, CODE: html head titleUntitled Document/title meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /head cfquery name="getresult" datasource="Catalog" dbtype="ODBC" SELECT Distinct MnGrp, MnGrp_Desc, ProductType, ProductType_Desc FROM globalkeys_FLAT /cfquery body bgcolor="#FF" CF_TwoSelectsRelated QUERY="getresult" NAME1="select1" NAME2="Select2" DISPLAY1="Mngrp_desc" DISPLAY2="Producttype_Desc" value1="mngrp" value2="producttype" FORCEWIDTH1="70" FORCEWIDTH2="70" SIZE1="1" SIZE2="1" HTMLBETWEEN="BR" AUTOSELECTFIRST="Yes" EMPTYTEXT1="(choose a category)" EMPTYTEXT2="(now choose a subcategory)" ONCHANGE="Submit!" FORMNAME="MyOtherForm" /form /body /html I AM UNABLE TO UNDERSTAND WHICH CFFORM YOU ARE TALKING ABOUT ,THANKS FOR YOUR REPLY AND PATIENCE +++ --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --7E483AE1B1188D700B230AAD Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit what does your CFFORM tag look like? monika kon wrote: Hi James, I am able to see only the First dropdown list with unique MnGrp_Desc.The second dropdown list is showing up nothing even if I select any thing from the first drop down list. Did you see the database I have sen in the previous mail? Shally --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. ------79EE260D231C723574DB0849 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit What exactly are youe seeing? How is the list different from your database? monika kon wrote: --0-2049339050-973275290=:67150 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi James and Vaughan Evans! Thanks a lot for ur reply. I am now stuck in the query.Please help me.I am sending the code as well as the database in excel as an attachment.I have placed TwoSelectsRelated.cfm in the folder CFUSION.But my query is not giving me the proper values. ++ CFQUERY NAME="getresult" datasource="global" select MnGrp, MnGrp_Desc,ProductType,ProductType_Desc, from Global where MnGrp=Left([ProductType],1) /CFQUERY Calling Cusstom Tag below (I have mine in a table) tr valign="top" tdfont face="arial" size="2"bName:brbrbrEmail:/b/td td CF_TwoSelectsRel
Re: Drop down List
Thank you very much, i am really very sorry for bothering you. It was my fault not putting the Form tag.. I have got it right. Thanks a lot for your patience. Please tell me if you have used "CF_Threeselectsrelated". I was trying this and I wanted all the 3 to be dropdown list.The example there on the site "http://nateweiss.com/taggallery/" is of Radio buttons and 2 dropdown list .As I said I want all the 3 to be drop down list. Can you please help me. Thanks a lot. Shally ++ --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --4A576A0EB0C5055670C186FA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit um, i dont see the opening form tag? can you cut and paste the entire file as you have it please? monika kon wrote: I am sending the code again, CODE: html head titleUntitled Document/title meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /head cfquery name="getresult" datasource="Catalog" dbtype="ODBC" SELECT Distinct MnGrp, MnGrp_Desc, ProductType, ProductType_Desc FROM globalkeys_FLAT /cfquery body bgcolor="#FF" CF_TwoSelectsRelated QUERY="getresult" NAME1="select1" NAME2="Select2" DISPLAY1="Mngrp_desc" DISPLAY2="Producttype_Desc" value1="mngrp" value2="producttype" FORCEWIDTH1="70" FORCEWIDTH2="70" SIZE1="1" SIZE2="1" HTMLBETWEEN="BR" AUTOSELECTFIRST="Yes" EMPTYTEXT1="(choose a category)" EMPTYTEXT2="(now choose a subcategory)" ONCHANGE="Submit!" FORMNAME="MyOtherForm" /form /body /html I AM UNABLE TO UNDERSTAND WHICH CFFORM YOU ARE TALKING ABOUT ,THANKS FOR YOUR REPLY AND PATIENCE +++ --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --7E483AE1B1188D700B230AAD Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit what does your CFFORM tag look like? monika kon wrote: Hi James, I am able to see only the First dropdown list with unique MnGrp_Desc.The second dropdown list is showing up nothing even if I select any thing from the first drop down list. Did you see the database I have sen in the previous mail? Shally --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --79EE260D231C723574DB0849 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit What exactly are youe seeing? How is the list different from your database? monika kon wrote: --0-2049339050-973275290=:67150 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi James and Vaughan Evans! Thanks a lot for ur reply. I am now stuck in the query.Please help me.I am sending the code as well as the database in excel as an attachment.I have placed TwoSelectsRelated.cfm in the folder CFUSION.But my query is not giving me the proper values. ++ CFQUERY NAME="getresult" datasource="global" select MnGrp, MnGrp_Desc,ProductType,ProductType_Desc, from Global where MnGrp=Left([ProductType],1) /CFQUERY Calling Cusstom Tag below (I have mine in a table) tr valign="top" tdfont face="arial" size="2"bName:brbrbrEmail:/b/td td CF_TwoSelectsRelated query="GetResult" name1="Select1" name2="selet2" display1="MnGrp_Desc" display2="ProductType_Desc" size1="1" size2="1" HtmlBetwwen="BR" AutoSelectFirst="Yes" EmptyText1="(choose a category)" EmptyText2="(now choose a subcategory)" Onchange="Submit!" Formname="MyOtherForm"/font/td /tr +++ --- James Taavon [EMAIL PROTECTED] wrote: This is a mult
Re: Drop down List
I am sending the code again, CODE: html head titleUntitled Document/title meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /head cfquery name="getresult" datasource="Catalog" dbtype="ODBC" SELECT Distinct MnGrp, MnGrp_Desc, ProductType, ProductType_Desc FROM globalkeys_FLAT /cfquery body bgcolor="#FF" CF_TwoSelectsRelated QUERY="getresult" NAME1="select1" NAME2="Select2" DISPLAY1="Mngrp_desc" DISPLAY2="Producttype_Desc" value1="mngrp" value2="producttype" FORCEWIDTH1="70" FORCEWIDTH2="70" SIZE1="1" SIZE2="1" HTMLBETWEEN="BR" AUTOSELECTFIRST="Yes" EMPTYTEXT1="(choose a category)" EMPTYTEXT2="(now choose a subcategory)" ONCHANGE="Submit!" FORMNAME="MyOtherForm" /form /body /html I AM UNABLE TO UNDERSTAND WHICH CFFORM YOU ARE TALKING ABOUT ,THANKS FOR YOUR REPLY AND PATIENCE +++ --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --7E483AE1B1188D700B230AAD Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit what does your CFFORM tag look like? monika kon wrote: Hi James, I am able to see only the First dropdown list with unique MnGrp_Desc.The second dropdown list is showing up nothing even if I select any thing from the first drop down list. Did you see the database I have sen in the previous mail? Shally --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --79EE260D231C723574DB0849 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit What exactly are youe seeing? How is the list different from your database? monika kon wrote: --0-2049339050-973275290=:67150 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi James and Vaughan Evans! Thanks a lot for ur reply. I am now stuck in the query.Please help me.I am sending the code as well as the database in excel as an attachment.I have placed TwoSelectsRelated.cfm in the folder CFUSION.But my query is not giving me the proper values. ++ CFQUERY NAME="getresult" datasource="global" select MnGrp, MnGrp_Desc,ProductType,ProductType_Desc, from Global where MnGrp=Left([ProductType],1) /CFQUERY Calling Cusstom Tag below (I have mine in a table) tr valign="top" tdfont face="arial" size="2"bName:brbrbrEmail:/b/td td CF_TwoSelectsRelated query="GetResult" name1="Select1" name2="selet2" display1="MnGrp_Desc" display2="ProductType_Desc" size1="1" size2="1" HtmlBetwwen="BR" AutoSelectFirst="Yes" EmptyText1="(choose a category)" EmptyText2="(now choose a subcategory)" Onchange="Submit!" Formname="MyOtherForm"/font/td /tr +++ --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --E6147946B6907CB6F06EC99E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You place the Tag in your Custom Tag folder under CFUSION and then call the tag from your cfm file. My QUERY: CFQUERY NAME="GetPerson" datasource="OIMDBADM" select name, address from oimdbadm.assignee where manager = 'Hub' /CFQUERY Calling Cusstom Tag below (I have mine in a table) tr valign="top" tdfont face="arial" size="2"bName:brbrbrEmail:/b/td td CF_TwoSelectsRelated query="GetPerson" name1="assigned" name2="address" display1="name" display2="address" htmlbetween="p" size1="1" size2="1"/font/td td align="right"font face="arial" size="2"bDate:/b/td tdf
Re: Drop down List
--0-2049339050-973275290=:67150 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi James and Vaughan Evans! Thanks a lot for ur reply. I am now stuck in the query.Please help me.I am sending the code as well as the database in excel as an attachment.I have placed TwoSelectsRelated.cfm in the folder CFUSION.But my query is not giving me the proper values. ++ CFQUERY NAME="getresult" datasource="global" select MnGrp, MnGrp_Desc,ProductType,ProductType_Desc, from Global where MnGrp=Left([ProductType],1) /CFQUERY Calling Cusstom Tag below (I have mine in a table) tr valign="top" tdfont face="arial" size="2"bName:brbrbrEmail:/b/td td CF_TwoSelectsRelated query="GetResult" name1="Select1" name2="selet2" display1="MnGrp_Desc" display2="ProductType_Desc" size1="1" size2="1" HtmlBetwwen="BR" AutoSelectFirst="Yes" EmptyText1="(choose a category)" EmptyText2="(now choose a subcategory)" Onchange="Submit!" Formname="MyOtherForm"/font/td /tr +++ --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --E6147946B6907CB6F06EC99E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You place the Tag in your Custom Tag folder under CFUSION and then call the tag from your cfm file. My QUERY: CFQUERY NAME="GetPerson" datasource="OIMDBADM" select name, address from oimdbadm.assignee where manager = 'Hub' /CFQUERY Calling Cusstom Tag below (I have mine in a table) tr valign="top" tdfont face="arial" size="2"bName:brbrbrEmail:/b/td td CF_TwoSelectsRelated query="GetPerson" name1="assigned" name2="address" display1="name" display2="address" htmlbetween="p" size1="1" size2="1"/font/td td align="right"font face="arial" size="2"bDate:/b/td tdfont face="arial" size="2"cfoutput#DateFormat(getassignment.date, "mm/dd/")#/cfoutput/td /tr tr monika kon wrote: Thanks a lot for considering my problem. I found CF_ThreeSelectsRelated on the site http://nateweiss.com/taggallery/ but one more question where do I run the query.I went through the CF program but no where CFQUERY has been run.Please explain.. --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --79B146EDDC6C8F75FF1B27F5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You can find the custom tag at monika kon wrote: Please tell me where I can find this custom tag. Secondly how am I suppose to use Java script ,as I don't know much of it. If I use onchange() of javascript ,I will have to call javascript coe in it. Please help.. --- Vaughan Evans [EMAIL PROTECTED] wrote: There is a custom tag called twoSelectsRelated that may be of help. Hi every one, I have 2 drop down lists ,the first one has options which are hard coded. When the user selects one of these options from the first dropdown list then the second dropdown list gets populated from the database accordingly.I want this to happen in the same template. Please help Shally __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ --- - 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] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf!
Re: Drop down List
--0-1917798803-973295411=:37303 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi James an Vaughan, Thanks for your reply. This is the second time I am sending the message as I didn't see it on the list. I am sending the database in excel format as an attachment and the code as I am not able to do the query .Please help.. ___ THE CODE: CFQUERY NAME="GetResults" datasource="Global" select MnGrp, MnGrp_Desc, ProductType,ProductType_Desc from Global where MnGrp=(Left[ProductType],1) /CFQUERY CF_TwoSelectsRelated query="GetResult" name1="Select1" name2="Select2" display1="MnGrp_Desc" display2="ProductType_Desc" FORCEWIDTH1="70" FORCEWIDTH2="70" SIZE1="1" SIZE2="1" HTMLBETWEEN="BR" AUTOSELECTFIRST="Yes" EMPTYTEXT1="(choose a category)" EMPTYTEXT2="(now choose a subcategory)" ONCHANGE="Submit!" FORMNAME="MyOtherForm"/font/td /tr tr +++ --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --E6147946B6907CB6F06EC99E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You place the Tag in your Custom Tag folder under CFUSION and then call the tag from your cfm file. My QUERY: CFQUERY NAME="GetPerson" datasource="OIMDBADM" select name, address from oimdbadm.assignee where manager = 'Hub' /CFQUERY Calling Cusstom Tag below (I have mine in a table) tr valign="top" tdfont face="arial" size="2"bName:brbrbrEmail:/b/td td CF_TwoSelectsRelated query="GetPerson" name1="assigned" name2="address" display1="name" display2="address" htmlbetween="p" size1="1" size2="1"/font/td td align="right"font face="arial" size="2"bDate:/b/td tdfont face="arial" size="2"cfoutput#DateFormat(getassignment.date, "mm/dd/")#/cfoutput/td /tr tr monika kon wrote: Thanks a lot for considering my problem. I found CF_ThreeSelectsRelated on the site http://nateweiss.com/taggallery/ but one more question where do I run the query.I went through the CF program but no where CFQUERY has been run.Please explain.. --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --79B146EDDC6C8F75FF1B27F5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You can find the custom tag at monika kon wrote: Please tell me where I can find this custom tag. Secondly how am I suppose to use Java script ,as I don't know much of it. If I use onchange() of javascript ,I will have to call javascript coe in it. Please help.. --- Vaughan Evans [EMAIL PROTECTED] wrote: There is a custom tag called twoSelectsRelated that may be of help. Hi every one, I have 2 drop down lists ,the first one has options which are hard coded. When the user selects one of these options from the first dropdown list then the second dropdown list gets populated from the database accordingly.I want this to happen in the same template. Please help Shally __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ --- - 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] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/
Re: Drop down List
Please tell me where I can find this custom tag. Secondly how am I suppose to use Java script ,as I don't know much of it. If I use onchange() of javascript ,I will have to call javascript coe in it. Please help.. --- Vaughan Evans [EMAIL PROTECTED] wrote: There is a custom tag called twoSelectsRelated that may be of help. Hi every one, I have 2 drop down lists ,the first one has options which are hard coded. When the user selects one of these options from the first dropdown list then the second dropdown list gets populated from the database accordingly.I want this to happen in the same template. Please help Shally __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ --- - 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] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ 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: Drop down List
Thanks a lot for considering my problem. I found CF_ThreeSelectsRelated on the site http://nateweiss.com/taggallery/ but one more question where do I run the query.I went through the CF program but no where CFQUERY has been run.Please explain.. --- James Taavon [EMAIL PROTECTED] wrote: This is a multi-part message in MIME format. --79B146EDDC6C8F75FF1B27F5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You can find the custom tag at monika kon wrote: Please tell me where I can find this custom tag. Secondly how am I suppose to use Java script ,as I don't know much of it. If I use onchange() of javascript ,I will have to call javascript coe in it. Please help.. --- Vaughan Evans [EMAIL PROTECTED] wrote: There is a custom tag called twoSelectsRelated that may be of help. Hi every one, I have 2 drop down lists ,the first one has options which are hard coded. When the user selects one of these options from the first dropdown list then the second dropdown list gets populated from the database accordingly.I want this to happen in the same template. Please help Shally __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ --- - 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] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ 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] --79B146EDDC6C8F75FF1B27F5 Content-Type: text/x-vcard; charset=us-ascii; name="jtaavon.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for James Taavon Content-Disposition: attachment; filename="jtaavon.vcf" begin:vcard n:Taavon;James tel;cell:(443) 506-2117 tel;fax:(410) 333-5203 tel;work:(410) 767-3415 x-mozilla-html:FALSE org:Department of Labor, Licensing and Regulation;Office of Information and Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Senior Web Developer adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201; fn:James Taavon end:vcard --79B146EDDC6C8F75FF1B27F5-- 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] __ Do You Yahoo!? From homework help to love advice, Yahoo! Experts has your answer. http://experts.yahoo.com/ 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]
Drop down List
Hi every one, I have 2 drop down lists ,the first one has options which are hard coded. When the user selects one of these options from the first dropdown list then the second dropdown list gets populated from the database accordingly.I want this to happen in the same template. Please help Shally __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ 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]
How to view textfiles
Hello everyone, I have text files present in the directory.I have a form which has a textfield and a submit button labeled as "view". I want if any one types the name of the textfield and presses "view" button then should be able to view the contents of the text file as well able to save it. Please help. Thanks in advance Shally __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- 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.
Getting data from the list-please help
Hello everyone, I have a scrolling list on my CF template.I have a field in the database named "Product Numbers",I want that the "product numbers" (in my case) should come from the database to the List.So if I add another product number to the database ,it should be automatically reflected in the scrolling list.Please help. Thanks in advance Shally __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- 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.
Getting data from the list
Hello everyone, I have a scrolling list on my CF template.I have a field in the database named "Product Numbers",I want that the "product numbers" (in my case) should come from the database to the List.So if I add another product number to the database ,it should be automatically reflected in the scrolling list.Please help. Thanks in advance Shally __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- 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.
Mappinf on Cf server
Hi, Can any one explain me the concept of mapping on CF server for using it on CFINCLUDE tag. thanks in advance Shally __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- 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.
Please help-Search engine
Hello Everyone. Please help me I am stuck. I have to make a search on the basis of model number which is present in Access database. If I write model number suppose"ABC" or "AB" then it should show me the same result. That means while searching the alphabets should be truncated automatically. Please tell me how to do this. Please help!!! Thanks in advance. Shally __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- 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.
Please help-Search engine
Hello Everyone. Please help me I am stuck. I have to make a search on the basis of model number which is present in Access database. If I write model number suppose"ABC" or "AB" then it should show me the same result. That means while searching the alphabets should be truncated automatically. Please tell me how to do this. Please help!!! Thanks in advance. Shally __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- 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.
Please help!!!!!!
Hi! I have got to work on some one elses code . Where I have 2 Problems. 1.One is that a tag called CF_getitems is being used and I haven't heard of it. 2.Second is that I want that £30.00 but in the output its showing £30.0 ,I have tried hard by fixing it by changing the datatype but enable to do it.I am using Access97. Please help me its URGENT. Shally. __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ -- 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: Validating Phone Numbers
Hi! I don't really get what exactly you want but what I know is that if you are using CFINPUT tag to validate phone numbers.You will have to use the attribute "Validate" for it and specify Telephone there,but this is valide foe only US phone numbers. Best of Luck. Shally --- Chuck Hergenroeder [EMAIL PROTECTED] wrote: Does any one know of a custom tag that will validate US and International Phone Numbers? If not do you know how I could accomplish this? -- 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. __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ -- 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.