Replace String
I need to be able to search a string and make multiple replacements in it. For example, I have a string that is coming out of the database with weird characters token1410-333-1234/token1token2410-333-4321/token2 I want to replace token1 with Phone number changed from And I want to replace /token1token2 with to And simply delete /token2 Any help is much appreciated. Thank you ## In accordance with Internal Revenue Service rules, any federal tax advice provided in this communication is not intended or written by the author to be used, and cannot be used by the recipient, for the purpose of avoiding penalties which may be imposed on the recipient by the IRS. Please contact the author if you would like to receive written advice in a format which complies with IRS rules and may be relied upon to avoid penalties. ## Attention: This e-mail, including any attachment(s), is intended for receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited, and requested to delete this communication and its attachment(s) without making any copies thereof and to contact the sender of this e-mail immediately. Nothing contained in the body and/or header of this e-mail is intended as a signature or intended to bind the addressor or any person represented by the addressor to the terms of any agreement that may be the subject of this e-mail or its attachment(s), except where such intent is expressly indicated. ## ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218205 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Setting Default Printer
Does anyone know how to set a default printer from a list of prints shown in a webpage? im using the tag CFX_EnumPrinters to enumerate the printers, but im not sure how to allow the user to pick the default. i found a script do this with vbscript, but i want to do it in a webpage: any help is appreciated! thank you in advance. :) Sub DefaultPrinter Dim Text, Title, i, j, tmp, printer Dim Network, oDevices ' Create a new Network object to access Network properties Set Network = CreateObject(WScript.Network) ' Read all printers Set oDevices = Network.EnumPrinterConnections Text = Available printers vbCRLF For i = 0 To oDevices.Count-1 Step 2 j = i Text = Text (i / 2) vbTab Text = Text oDevices(i) vbTab oDevices(i+1) vbCRLF Next ' Show all available printers and allow a user selection tmp = InputBox (Text,Set default printer,0) printer = oDevices(tmp * 2) ' select printer name ' Set the default printer Network.SetDefaultPrinter printer MsgBox Set Default printer to printer, _ vbOkonly + vbInformation, Title Set Network = Nothing End Sub DefaultPrinter ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188924 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Setting Default Printer
Im trying to do this on the client. I want to present them with a list of their printers and have them select which one they want as a default. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 29, 2004 1:21 PM To: CF-Talk Subject: RE: Setting Default Printer Does anyone know how to set a default printer from a list of prints shown in a webpage? im using the tag CFX_EnumPrinters to enumerate the printers, but im not sure how to allow the user to pick the default. Are you trying to set a default printer on the server or on the client? Presumably, your CFX custom tag lists printers on the server, not the client. You could run the VBScript code you posted from a command shell using CFEXECUTE, or adapt the code somewhat to make it available as a WSH COM object, although I've had limited success in using Windows Script from CFMX to control printers and would try to avoid doing that if I could. Instead, you could simply track the printer choice that the user made and force server print jobs to use that printer within your own code. Finally, keep in mind that the server will only be able to have one default printer, so if one user changes it to printer A and another changes it to printer B, someone's going to be disappointed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188946 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
dynamic forms
i want to have a textbox show up on my form for data to be entered, only a checkbox is checked. what is the easiest way to code this? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Print to PDF
Im getting an error messege: Timeout period expired without completion of c:\Program Files\HTMLDOC\htmldoc.exe my code is: cf_html2pdf3 myHTMLDOC=c:\Program Files\HTMLDOC\htmldoc.exe mySTATPATH=C:\inetpub\wwwroot\test\pdf mySTATFILE=static.html myPDFPath=C:\Inetpub\wwwroot\TEST\PDF any ideas?when i run this on my local website (im running cf server 4.5 it works fine.but when i put it on my production one (has cfmx) it bombs. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 2:21 PM To: CF-Talk Subject: Re: Print to PDF if on Windows...hands down custom tag HTML2PDF3 (requires the install of HTMLDoc.exe) Works GREAT!! If you need something really fancy, there are a couple of us on list right now heavy into the iText.jar approach (very low level control of PDF layout and properties) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Jones, Becky To: CF-Talk Sent: Thursday, February 12, 2004 11:17 AM Subject: Print to PDF Does anyone know of any shareware or freeware plug in where i can print my pages to pdf? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Print to PDF
Does anyone know of any shareware or freeware plug in where i can print my pages to pdf? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: printing from web
this is sort of off topic but i hope u can help. does anyone know how to programmatically remove the header and footer from a web page when you print? thanks for your help bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: printing from web
Yea i mean removing the url at the bottom and the page number.from searching the web, there doesnt seem to be a way to do it. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 3:00 PM To: CF-Talk Subject: RE: printing from web You mean the HTML header and footer? Like navigation and stuff or do you mean the part where IE prints out the URL that you are printing and the page number and stuff?I believe all of that has to be turned off at the client.I've fought this problem before and without using some kind of downloadable program to accomplish this, I don't think through standard code you're allowed to access that part of the browser and just change it on the fly and I don't think there's a way to do it just for one page.I hope someone proves me wrong though because that is very annoying. John -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 3:01 PM To: CF-Talk Subject: OT: printing from web this is sort of off topic but i hope u can help. does anyone know how to programmatically remove the header and footer from a web page when you print? thanks for your help bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Vbscript and Coldfusion
i have this vbscript that gets me all the computer names in active directory. is there a way i can incorporate this in cf and output the results to a select drop down box?? thanks for your help! bec. sDomain= ms Set oDomain= GetObject(WinNT:// sDomain) oDomain.Filter= Array(Computer) For Each oADobject In oDomain WScript.Echo oADobject.Name Next * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Vbscript and Coldfusion
do u have an example? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 12:29 PM To: CF-Talk Subject: RE: Vbscript and Coldfusion why not use CFLDAP against your AD? Doug -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 11:58 AM To: CF-Talk Subject: Vbscript and Coldfusion i have this vbscript that gets me all the computer names in active directory. is there a way i can incorporate this in cf and output the results to a select drop down box?? thanks for your help! bec. sDomain= ms Set oDomain= GetObject(WinNT:// sDomain) oDomain.Filter= Array(Computer) For Each oADobject In oDomain WScript.Echo oADobject.Name Next * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Vbscript and Coldfusion
thank you!!! this sitehttp://www.ldapbrowser.com/ http://www.ldapbrowser.com/ helped alot.thanks for the reference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 12:51 PM To: CF-Talk Subject: RE: Vbscript and Coldfusion nope, it was just a thought.Perhpas someone around here has done this.If its in the AD, and teh LDAP stuff is 'on' of course, you should be able to query it.Here is an example of query user data cfldap action=""> name=empl attributes= employeeID, mail, memberOf, st, name, sn, initials, mobile, givenName, displayName, userPrincipalName, department, streetAddress, facsimileTelephoneNumber, countryCode, mailNickname, l, distinguishedName, manager, sAMAccountName, extensionAttribute1 start= dc=fooey, dc=gooey sort=sn ASC server=foo.goo.com port=389 filter=sn=johnson Check out the LDAP browser from http://www.ldapbrowser.com/ it rawks and should help you build your query.For example, in our AD I see CN=Computers listing all teh computers participating in the AD. Note, if your AD admin has not turned on anonymous reads, you will need a UID/PWD. HTH Doug -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 12:35 PM To: CF-Talk Subject: RE: Vbscript and Coldfusion do u have an example? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 12:29 PM To: CF-Talk Subject: RE: Vbscript and Coldfusion why not use CFLDAP against your AD? Doug -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 11:58 AM To: CF-Talk Subject: Vbscript and Coldfusion i have this vbscript that gets me all the computer names in active directory. is there a way i can incorporate this in cf and output the results to a select drop down box?? thanks for your help! bec. sDomain= ms Set oDomain= GetObject(WinNT:// sDomain) oDomain.Filter= Array(Computer) For Each oADobject In oDomain WScript.Echo oADobject.Name Next * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
List with commas
Hi, I want to do something that seems like it should be easy, but i cant figure it out. i want to take my query results and output it with double quotes around each item with a comma seperated inbetween. Any help would be appreciated.My query returns a bunch of tiles.i want it to output like so: Test 1, Test 2, Test 3 Thanks in advance for your help. :) bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: List with commas
that did it! thank u so much! -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:33 PM To: CF-Talk Subject: Re: List with commas At 10:25 AM 10/9/2003, you wrote: Hi, I want to do something that seems like it should be easy, but i cant figure it out. i want to take my query results and output it with double quotes around each item with a comma seperated inbetween. Any help would be appreciated.My query returns a bunch of tiles.i want it to output like so: Test 1, Test 2, Test 3 cfset NewList = cfloop query=yourquery cfset NewList = ListAppend(NewList, '' variablename '') /cfloop In case it's tough to read, that's singlequote-doublequote-singlequote around variablename. Or, you could do a normal NewList = ValueList(queryname.variablename), then Replace(NewList, ',', ',', 'all') then cfset NewList = '' NewList '' _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
vbscript
hey guys, i wrote a vbscript that has enviornment variables declared in it. can i incorporate that in a cf page and pass the variables from the script to my cf code? is this possible? thanks for your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~| 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
list of groups
is there a way to get a list of groups that a user belongs to? i know that you can use AUTH_USER to get the domain\username. but i want to know what NT groups that user belongs to. for example, administrators, backup operators, etc is there a variable for this? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~| 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
Grouping
in my sql query, i have attorneys and secretaries that output. an attorney can have multiple secretaries. so i want to be able to group by the attorney's id at the top level so he only appears once. and that works fine. but in the same row, im outputting the secretary and her name could appear 2 or 3 times. i tried doing a second group on the secretary id and it isnt working. does anyone have ideas? i enclosed a snippet of the code. thanks! CFOUTPUT query=qrySResults group=Listing_ID cfparam name=Switch default= cfif switch EQ TRUE tr bgcolor=99 cfset switch = False cfelse tr bgcolor= cfset switch = True /cfif td class=BIOS width=25% align=left valign=top nowrap a class=BIOS href=biography.cfm?LID=#Listing_ID# #FIRST_NM# #MIDDLE_NM# #LAST_NM# #SUFFIX#/abr#POSITION_NM# /td td class=BIOS width=10% align=left valign=middle#city#/td td class=BIOS width=25% valign=top#PHONE_NUM# br a class=BIOS href=mailto:#email_addr#;#email_addr#/a /td td valign=middle class=BIOS cfoutput group=relid#SECYFIRST# #SECYLAST#br/cfoutput/td/tr /cfoutput Becky Jones Web/Applications Specialist Miles Stockbridge 10 Light Street Baltimore, MD 21202 410.385.3739 office, 410.385.3700 fax 443.324.8648 cell ~| 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
RE: Grouping
no the relid is the same as the name. that is why i thought it was wierd it wouldnt group on it. the secy name shows multiple time in the sql query tho. but i would think it would still group by that id in the web code. -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 11:18 AM To: CF-Talk Subject: Re: Grouping If the Secretaries name appears multiple times, since your secondary group is on: relid try outputting that along with the name and see if the relid changes. If the name appears multiple times then I am sure the relID also changes. Could be something with the database. It appears that in the query, the secretary is in the table multiple times with a different relID each time. [EMAIL PROTECTED] 12/23/02 11:11AM in my sql query, i have attorneys and secretaries that output. an attorney can have multiple secretaries. so i want to be able to group by the attorney's id at the top level so he only appears once. and that works fine. but in the same row, im outputting the secretary and her name could appear 2 or 3 times. i tried doing a second group on the secretary id and it isnt working. does anyone have ideas? i enclosed a snippet of the code. thanks! CFOUTPUT query=qrySResults group=Listing_ID cfparam name=Switch default= cfif switch EQ TRUE tr bgcolor=99 cfset switch = False cfelse tr bgcolor= cfset switch = True /cfif td class=BIOS width=25% align=left valign=top nowrap a class=BIOS href=biography.cfm?LID=#Listing_ID# #FIRST_NM# #MIDDLE_NM# #LAST_NM# #SUFFIX#/abr#POSITION_NM# /td td class=BIOS width=10% align=left valign=middle#city# /td td class=BIOS width=25% valign=top#PHONE_NUM# bra class=BIOS href=mailto:#email_addr#;#email_addr#/a /td td valign=middle class=BIOS cfoutput group=relid#SECYFIRST# #SECYLAST#br/cfoutput/td/tr /cfoutput Becky Jones Web/Applications Specialist Miles Stockbridge 10 Light Street Baltimore, MD 21202 410.385.3739 office, 410.385.3700 fax 443.324.8648 cell ~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
OT importing excel spreadsheet into access Database with web form
does anyone have an example of code that would allow you to import an excel spreadsheet into an access database? thanks! bec. ~| 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.
combo box
is there any way to do a reverse combo box? so say i have two fields, one is applications the other is companies. say i choose the application: outlook 2000, then the company would automatically change to microsoft. but lets say i knew the company was microsoft. how could i get the top box to change to every app that is associated with microsoft? ~| 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
auth_user
i want only users that are apart of an Admin group that i created to be a ble to access a template i built. i know that i can use AUTH_USER and sa y if u are this list of people...you can access the template. but is there a way to say if you are apart of this GROUP u can access thi s template? i hope i am being clear. right not i declare a variable and set it to AU TH_USER. but can i set this variable equal to the Admin group somehow? thanks for your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: auth_user
what is an ACL list? -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 6:16 PM To: CF-Talk Subject: RE: auth_user Just put the group into your ACL list. Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 5:12 PM To: CF-Talk Subject: auth_user i want only users that are apart of an Admin group that i created to be a ble to access a template i built. i know that i can use AUTH_USER and sa y if u are this list of people...you can access the template. but is there a way to say if you are apart of this GROUP u can access thi s template? i hope i am being clear. right not i declare a variable and set it to AU TH_USER. but can i set this variable equal to the Admin group somehow? thanks for your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT- security
i had a question about security and uploading files i have a form that admins fill out to upload articles to a web page it goes to a directory on my web server that is in inetpub\wwwroot\admin\fil e directory now when i click on the article and then try to click on the link to the stored file inside this article, i can see it just fine but when the av erage user tries to click on the link to the article, they get a page can not be displayed i have full rights to all web directories the avg us er might have read could this be a rights issue or something wrong wi th the page?? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Refresh Window
Is there a way to Automatically refresh a window? I have a page that has a pop-up window. When you make changes on that fo rm (in the pop-up windown) when i click submit...i want the window undern eath to reflect the changes. the only way it does right now is if i hit the refresh button. is there a way to do this without hitting the refres h button? thanks for your help. bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfgrid
is there a way to force a browser to download the java2 controls inorder for an enduse to see cfgrid pages? bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFGRID
I sent this in early, but i am not sure it made it so i am re-submitting. anyways, is there a way to automatically download the java2 controls if t he user doesnt already have it on their pc? because without it...u cant see the grid. thanks for your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
combo boxes
i like the tag cf_twoselectsrelated. but i want to be able to choose fro m either the first or the second drop-down. i have two different selects to be filled. one for companies, the other for applications. if i choose the first select for company and i choose macromedia...in the second select i would see coldfusion, flash, etc... but what if i wanted to do the reverse? i want to be able to choose the application then have the company change to the correct one. has anyone done this before? any help appreciated. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
word wrap in text area
this seems like a simple question, but does anyone know how to make what you enter into a text area come out the same way when you redisplay it. so if in my text box i had a sentence with 2 hard returns in between, when i redisplay this data outsid of the textarea, i want it to have those same 2 hard returns. i tried wrap=hard and that didnt work. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: word wrap in text area
yes that would be it. :) thank you so much, bec. -Original Message- From: Michel Gallant [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 5:11 PM To: CF-Talk Subject: RE: word wrap in text area Carriage returns don't display in HTML :) I usually do a cfoutput#replace( myText, #chr(10)#, br, ALL )#/cfoutput -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 28 novembre, 2001 18:07 To: CF-Talk Subject: word wrap in text area this seems like a simple question, but does anyone know how to make what you enter into a text area come out the same way when you redisplay it. so if in my text box i had a sentence with 2 hard returns in between, when i redisplay this data outsid of the textarea, i want it to have those same 2 hard returns. i tried wrap=hard and that didnt work. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
insert question
i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
it will overlook user a (he is already in the dbase) but it wont insert user b (he is not in dbase and should get put in) -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:00 AM To: CF-Talk Subject: RE: insert question are you getting an error? is the user just not getting inserted? christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 8:29 AM To: CF-Talk Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
this looks like it is for one user at a time. i want to be able to deal with multiple users and insert only the ones that arent already in the database. -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 11:33 AM To: CF-Talk Subject: Re: insert question It looks just like my create user account, take a look and hope it helps. CFQUERY DATASOURCE=#application.dsn# NAME=check_login SELECT email, password FROM cust_contacts WHERE email = '#email#' AND password = '#password#' /CFQUERY !--- CHECK TO SEE IF THE USER EXISTS IN THE DB AND IF THEY DO, REDIRECT THEM TO THE ERROR PAGE AND NOTIFY THEM TO LOGIN NORMALLY. //--- CFIF CHECK_LOGIN.RECORDCOUNT GT 0 CFLOCATION URL=/index.cfm?fuseaction=errormessage=1 CFELSE !--- IF THE USER DOES NOT EXIST, INSERT THEM INTO THE DATABASE//--- CFTRANSACTION CFQUERY DATASOURCE=#application.dsn# NAME=insert_cust_login DECLARE @maxid int BEGIN SELECT @maxid = MAX(ID) FROM cust_contacts IF@maxid IS NULL SELECT @maxid = 1 ELSE SELECT @maxid = @maxid + 1 END INSERT INTO cust_contacts VALUES ( '#custNum#', @maxid, '#f_name#', '#l_name#', '#email#', '#password#' ) /CFQUERY /CFTRANSACTION /CFIF Doug - Original Message - From: Jones, Becky [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:28 AM Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: insert question
pascal, this works great. thank u. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 12:03 PM To: CF-Talk Subject: RE: insert question I think your approach is a bit too simple. I don't know what your form looks like, or what this test USERS NEQ No Users means, but it should probably look like this. === CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT UserID, AppID FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) ORDER BY UserID /cfquery !--- Create a structure with a list of appIDs for each UserID found. --- cfset stUserApps = StructNew() cfoutput query=qryPeople group=UserID cfset stUserApps[qryPeople.UserID] = cfoutput cfset stUserApps[qryPeople.UserID]= ListAppend(stUserApps[qryPeople.UserID],AppID) /cfoutput /cfoutput cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfif NOT(StructKeyExists(stUserApps,i) AND ListFind(stUserApps[i],p)) !--- Only insert if the appID is not in the list for that user --- cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfif /cfloop /cfloop /cfif Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: vrijdag 16 november 2001 14:29 To: CF-Talk Subject: insert question i have a list of users that you can choose from on a form to assign to an application(s). if the user is already assigned to a certain app however, i dont want that user to re-insert into the database. (infact, the dbase wont let that happen because of duplicate indexes) but if the second user isnt already assigned to the app...i do want him to insert. but it doesnt seem to be working out. any ideas? my qryPeople is this: CFIF USERS NEQ No Users cfquery name=qryPeople datasource=#dsn# SELECT * FROM qryAppToEmp2 WHERE UserID IN (#form.Users#) AND AppID IN (#form.appID#) /cfquery /cfif my insert: cfif isdefined(qryPeople.recordcount) AND qryPeople.RecordCount IS 0 OR qryPeople.UserID neq No Users cfloop list=#form.Users# index=i delimiters=, cfloop list=#form.appid# index=p delimiters=, cfquery datasource=#dsn# name=addUser INSERT INTO tblAppIAUsers ( AppID, Listing_ID ) VALUES ( #p#, #i# ) /cfquery /cfloop /cfloop /cfif * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
related selects
im interested in doing 4 related selects. i see that there is an example at http://www.pengoworks.com/qForms/docs/examples/n-related_selectboxes.htm but i was wondering if cf could mix with the js code? ive tried before with not much sucess. has anyone used this form in conjunction with cold fusion code. and if so, would you mind sharing an example? thanks so much, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Popup calendar
Has anyone seen a good script that pops up a calendar and fills in not only a date in the text field but also a time? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
pop up windows
i have a template that i want to be able to have a link that you would click on that would launch a popup window. the contents of that popup window when changed will effect the template underneath. my problem is that the window doesnt automatically close after i click on submit (an alert box asks me if i really want to close the window) i click on yes, but it doesnt refresh the template. how can i get the template to automatically refresh with the new changes and the popup window to just close after the submit button is clicked? i used window.close() but that still gives me that alert box. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfgrid
i created a grid on my test server. i am running cf server 4.0. i moved it over to the main webserver (running cf server 5.0) and now i get the error messege below. it looks like it is an error with my browser..i run ie 5.0. but i viewed the grid in the same browser just pointing to the other server just fine. any ideas? Custom control could not be displayed because this browser does not suppport Java2. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
formatting question
does anyone know how to put a date/time format on this field? cfgridcolumn name=OpenDate header=Opened right now it displays like...2001-08-22 19:37:51 i want it to be 08/22/2001 7:37pm * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
database connections
i have a complex problem. i basically have 3 databases. one access, one sql 6.5 and one sql 7.0. i do most of my connecting and querying in the access database. my problem is that i wrote a query in access that is using linked tables to the sql6.5 database and also to the 7.0. my query runs perfectly inside my access database...no errors. but in cf when i try to run this query using: cfquery name=qryWork datasource=ITDATA this ITDATA is my access datasource''' SELECT * FROM qryWO /cfquery i get an error that says: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL ServerBALTMGMT01' failed. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:2) to (10:45) in the template file C:\INETPUB\WWWROOT\HELPDESK\FRMOPENWO.CFM. the error seems to be in connecting to the sql7.0 dbase. has anyone run into this problem before? is there an easier way to do a connection to tables from 2 seperate databases??? thanks for your help. bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
database connections
-Original Message- From: Jones, Becky Sent: Monday, September 17, 2001 11:19 AM To: '[EMAIL PROTECTED]' Subject: database connections i have a complex problem. i basically have 3 databases. one access, one sql 6.5 and one sql 7.0. i do most of my connecting and querying in the access database. my problem is that i wrote a query in access that is using linked tables to the sql6.5 database and also to the 7.0. my query runs perfectly inside my access database...no errors. but in cf when i try to run this query using: cfquery name=qryWork datasource=ITDATA this ITDATA is my access datasource''' SELECT * FROM qryWO /cfquery i get an error that says: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL ServerBALTMGMT01' failed. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:2) to (10:45) in the template file C:\INETPUB\WWWROOT\HELPDESK\FRMOPENWO.CFM. the error seems to be in connecting to the sql7.0 dbase. has anyone run into this problem before? is there an easier way to do a connection to tables from 2 seperate databases??? thanks for your help. bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database connections
it does. i can connect to all the databases alone just fine. it is when i try to join them is where i get the error. -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 5:03 PM To: CF-Talk Subject: RE: database connections Check to make sure the Cold Fusion service account has access to the SQL database. Or maybe use the User and Password attributes of the CFQuery tag. Good luck. Shawn Grover -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 1:58 PM To: CF-Talk Subject: database connections -Original Message- From: Jones, Becky Sent: Monday, September 17, 2001 11:19 AM To: '[EMAIL PROTECTED]' Subject: database connections i have a complex problem. i basically have 3 databases. one access, one sql 6.5 and one sql 7.0. i do most of my connecting and querying in the access database. my problem is that i wrote a query in access that is using linked tables to the sql6.5 database and also to the 7.0. my query runs perfectly inside my access database...no errors. but in cf when i try to run this query using: cfquery name=qryWork datasource=ITDATA this ITDATA is my access datasource''' SELECT * FROM qryWO /cfquery i get an error that says: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL ServerBALTMGMT01' failed. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:2) to (10:45) in the template file C:\INETPUB\WWWROOT\HELPDESK\FRMOPENWO.CFM. the error seems to be in connecting to the sql7.0 dbase. has anyone run into this problem before? is there an easier way to do a connection to tables from 2 seperate databases??? thanks for your help. bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
grids
does anyone know if the fields in the cf grid can be moved? like if say i had the columns like: Cat Dog Mouse can i put mouse before dog to look like Cat Mouse Dog or is this another scripting language that i would need to use? thanks so much, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
subtracting quantity
i have a form for users to check out an application. most of my applications are a quantity of 1, so once it is checked out, it will not show up in the drop down list of apps to check out until it is checked back in. (i automatically set the checkout field to be yes). but for the few apps that have a quantity of greater than one, how can i make it so that it still shows up in the list until every single one has been checked out? right now my code just does this for every app checked out regardless of the quantity cfloop list=#form.appID# index=a delimiters=, cfquery datasource=ITData UPDATE tblApplications set InOut = 1 WHERE appID = (#a#) /cfquery /cfloop * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
loop question
my query below keeps putting an OR after the last appid. how can i fix that? thanks, bec. cfquery name=qryGetApp datasource=ITDATA SELECT * FROMqryCHECKOUT WHERE cfloop list=#form.appid# index=h AppID = #h# cfif qryDetails.recordcount is not qryDetails.currentrow cfoutputor /cfoutput /cfif /cfloop AND CheckIn IS NULL ORDER BY AppName, AppVersion DESC /cfquery * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: loop question
this works. thank u. bec. -Original Message- From: Nate Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 5:17 PM To: CF-Talk Subject: RE: loop question It seems that you be better off using this: cfquery name=qryGetApp datasource=ITDATA SELECT * FROMqryCHECKOUT WHERE AppID IN (#form.appid#) AND CheckIn IS NULL ORDER BY AppName, AppVersion DESC /cfquery -Nate -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 5:00 PM To: CF-Talk Subject: loop question my query below keeps putting an OR after the last appid. how can i fix that? thanks, bec. cfquery name=qryGetApp datasource=ITDATA SELECT * FROMqryCHECKOUT WHERE cfloop list=#form.appid# index=h AppID = #h# cfif qryDetails.recordcount is not qryDetails.currentrow cfoutputor /cfoutput /cfif /cfloop AND CheckIn IS NULL ORDER BY AppName, AppVersion DESC /cfquery * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
pdf's
i have pdf form that i want to put on my website. i want users to be able to fill out this form using form fields that lay over top of this form. then i want to print the form w/the info from the form fields printed in the correct places. has anyone done this before and what way should i go about it? thanks in advance for your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
using cf_combo box
if the company that the person entered in the combo box doesnt exist in the database... how would the insert statement look to insert the new company in tblCompany? because the value=#CompanyID# works for my passthru table if the company already exists. but if it doesnt, i need to insert the name in tblCompany and then the new CompanyID in tblCompEquip. cf_combobox name=CompanyNM value= cfoutput query=qryComp group=CompanyNM option value=#CompanyID# class=BIOS#CompanyNM#/cfoutput /cf_combobox * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
drop down lists
is there a way to have a select list that drops down a specific list from a query, but it is also able to add new items to this drop down list on the fly. in other words..if i have a list of apples oranges pears but i dont see grapes...and that is what i want to use.. can i just start typing grapes in this select drop down? so i want it to be a drop down AND a text field at the same time. ive seen many applications do this, but i am not sure of how i would go about it. thanks everyone bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: drop down lists
thank u so much. i will give that a shot. -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 10:30 AM To: CF-Talk Subject: RE: drop down lists yup we got a free tag that works like a select, but allows you to also type in. Its called CF_ComboBox http://www.cfdev.com/products/index.cfm?ref=126 + Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developers Resources http://www.cfdev.com/ -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 9:53 AM To: CF-Talk Subject: drop down lists is there a way to have a select list that drops down a specific list from a query, but it is also able to add new items to this drop down list on the fly. in other words..if i have a list of apples oranges pears but i dont see grapes...and that is what i want to use.. can i just start typing grapes in this select drop down? so i want it to be a drop down AND a text field at the same time. ive seen many applications do this, but i am not sure of how i would go about it. thanks everyone bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
enviornment variables
does anyone know of a good news group or have examples of setting enviornment variables using vbscript or javascript? i can use winbatch but i would prefer using the above. thanks guys bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
enviornment variables
does anyone know of a good news group or have examples of setting enviornment variables using vbscript or javascript? i can use winbatch but i would prefer using the above. thanks guys bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmail
is there a way to put td tags in the cfmail tag to make the formatting prettier? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
word forms
i work alot with forms in word. is there a way to replicate some of the features that i can do in word to coldfusion? for example, i can have a form that when u double click on the link to the form..the first thing u see i a pop-up where u can fill in the form fields from this popup box. then when u click submit...it automatically pre-fills the form for u. so u can print it or email it. does anyone have an example of this for the web? thanks so much, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: query headache
hey kevan, that didnt seem to work either. i think it may have to do w/the listing_id not the appid. but i am not sure how to get it to loop thru a list of listing ids. i tried this...but obviously, it adds the extra AND at the end...therefore making my statement invalid. WHERE cfloop query=qryappdetails cfoutputqryIAPeople.Listing_ID #listing_id# AND /cfoutput /cfloop when i use hard code...this works. for example: WHERE qryIAPeople.Listing_ID 105747 AND qryIAPeople.Listing_ID 102364 any ideas? thanks for your help, bec. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 8:05 AM To: CF-Talk Subject: RE: query headache If you don't have an outer join you won't get people who are not assigned to any application and If you are trying to select against an application shouldn't it be more like this. cfquery name=qryEmp datasource=ITData SELECT tblAppIAUsers.AppID, tblAppIAUsers.Listing_ID, qryIAPeople.LISTING_ID, qryIAPeople.LAST_NM, qryIAPeople.MIDDLE_NM, qryIAPeople.FIRST_NM, qryIAPeople.SUFFIX, qryIAPeople.CITY, qryIAPeople.LABEL, qryIAPeople.PHONE_NUM, qryIAPeople.PHONE_TYP_ID, qryIAPeople.CLASSIFICATION_ID, qryIAPeople.INTERNAL_ADDR, qryIAPeople.OWN_DIR_ID, qryIAPeople.OWN_LIST_ID FROM qryIAPeople LEFT Outer JOIN tblAppIAUsers ON qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID WHERE tblAppIAUsers.AppID #appvar# ORDER BY qryIAPeople.Last_NM /cfquery -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 20 July 2001 23:25 To: CF-Talk Subject: RE: query headache this is what works. but i obviously need to output the listing id's dynamically. any ideas? !--- Query to get all employees not assigned to app. --- cfquery name=qryEmp datasource=ITData SELECT tblAppIAUsers.AppID, tblAppIAUsers.Listing_ID, qryIAPeople.LISTING_ID, qryIAPeople.LAST_NM, qryIAPeople.MIDDLE_NM, qryIAPeople.FIRST_NM, qryIAPeople.SUFFIX, qryIAPeople.CITY, qryIAPeople.LABEL, qryIAPeople.PHONE_NUM, qryIAPeople.PHONE_TYP_ID, qryIAPeople.CLASSIFICATION_ID, qryIAPeople.INTERNAL_ADDR, qryIAPeople.OWN_DIR_ID, qryIAPeople.OWN_LIST_ID FROM qryIAPeople LEFT JOIN tblAppIAUsers ON qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID WHERE qryIAPeople.Listing_ID 105655 AND qryIAPeople.Listing_ID 105683 ORDER BY qryIAPeople.Last_NM /cfquery !--- End Query --- -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:50 PM To: CF-Talk Subject: RE: query headache Becky, Without your schemas I can't give you the exact syntax, but ... Use NOT IN, kind of like this: SELECT people FROM table WHERE NOT userid IN (SELECT assigned userids) --- Ben -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:42 PM To: CF-Talk Subject: query headache hey, i am trying to write a query where i would get an output of all employees except for those that are already assigned to the chosen application. this works as far as it doesnt show me the users assignedbut it doesnt give me a complete listing of everyone else. for example, say i chose office 2000. and i have joe and tim assigned to it. well, this query doesnt bring up joe or tim. that's fine. but it doesnt give me everyone else. like if say sue is assigned to another application...she wont show up in this list even though she isnt assigned to office 2000. get it? i should probably post this to a sql or access group...but maybe someone out here can help. thanks, bec. !--- Query to get all employees not assigned to app. --- cfquery name=qryEmp datasource=ITData SELECT qryIAPeople.*, tblAppIAUsers.AppID, tblAppIAUsers.Listing_ID FROMqryIAPeople LEFT JOIN tblAppIAUsers ON qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID WHERE (((tblAppIAUsers.AppID) Is Null Or (tblAppIAUsers.AppID)=#url.aid#) AND ((tblAppIAUsers.Listing_ID) Is Null)) ORDER BY qryIAPeople.Last_NM /cfquery !--- End Query --- * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited
query headache
hey, i am trying to write a query where i would get an output of all employees except for those that are already assigned to the chosen application. this works as far as it doesnt show me the users assignedbut it doesnt give me a complete listing of everyone else. for example, say i chose office 2000. and i have joe and tim assigned to it. well, this query doesnt bring up joe or tim. that's fine. but it doesnt give me everyone else. like if say sue is assigned to another application...she wont show up in this list even though she isnt assigned to office 2000. get it? i should probably post this to a sql or access group...but maybe someone out here can help. thanks, bec. !--- Query to get all employees not assigned to app. --- cfquery name=qryEmp datasource=ITData SELECT qryIAPeople.*, tblAppIAUsers.AppID, tblAppIAUsers.Listing_ID FROMqryIAPeople LEFT JOIN tblAppIAUsers ON qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID WHERE (((tblAppIAUsers.AppID) Is Null Or (tblAppIAUsers.AppID)=#url.aid#) AND ((tblAppIAUsers.Listing_ID) Is Null)) ORDER BY qryIAPeople.Last_NM /cfquery !--- End Query --- * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: query headache
this is what works. but i obviously need to output the listing id's dynamically. any ideas? !--- Query to get all employees not assigned to app. --- cfquery name=qryEmp datasource=ITData SELECT tblAppIAUsers.AppID, tblAppIAUsers.Listing_ID, qryIAPeople.LISTING_ID, qryIAPeople.LAST_NM, qryIAPeople.MIDDLE_NM, qryIAPeople.FIRST_NM, qryIAPeople.SUFFIX, qryIAPeople.CITY, qryIAPeople.LABEL, qryIAPeople.PHONE_NUM, qryIAPeople.PHONE_TYP_ID, qryIAPeople.CLASSIFICATION_ID, qryIAPeople.INTERNAL_ADDR, qryIAPeople.OWN_DIR_ID, qryIAPeople.OWN_LIST_ID FROM qryIAPeople LEFT JOIN tblAppIAUsers ON qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID WHERE qryIAPeople.Listing_ID 105655 AND qryIAPeople.Listing_ID 105683 ORDER BY qryIAPeople.Last_NM /cfquery !--- End Query --- -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:50 PM To: CF-Talk Subject: RE: query headache Becky, Without your schemas I can't give you the exact syntax, but ... Use NOT IN, kind of like this: SELECT people FROM table WHERE NOT userid IN (SELECT assigned userids) --- Ben -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:42 PM To: CF-Talk Subject: query headache hey, i am trying to write a query where i would get an output of all employees except for those that are already assigned to the chosen application. this works as far as it doesnt show me the users assignedbut it doesnt give me a complete listing of everyone else. for example, say i chose office 2000. and i have joe and tim assigned to it. well, this query doesnt bring up joe or tim. that's fine. but it doesnt give me everyone else. like if say sue is assigned to another application...she wont show up in this list even though she isnt assigned to office 2000. get it? i should probably post this to a sql or access group...but maybe someone out here can help. thanks, bec. !--- Query to get all employees not assigned to app. --- cfquery name=qryEmp datasource=ITData SELECT qryIAPeople.*, tblAppIAUsers.AppID, tblAppIAUsers.Listing_ID FROMqryIAPeople LEFT JOIN tblAppIAUsers ON qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID WHERE (((tblAppIAUsers.AppID) Is Null Or (tblAppIAUsers.AppID)=#url.aid#) AND ((tblAppIAUsers.Listing_ID) Is Null)) ORDER BY qryIAPeople.Last_NM /cfquery !--- End Query --- * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
execute programs
is there a cutsom tag or a cf tag that would allow me to execute a program from a web browser? like could i run notepad or word thru the web browser? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
cffile
when i use cffile to upload a file to a directory on my webserver, it seems
to rename the file when i try to insert that same file into my database.
so if i upload say text.html it shows up in my database as a .tmp file.
what am i doing wrong?
cffile action=UPLOAD filefield=Files
destination=c:\inetpub\wwwroot\admin\files nameconflict=MAKEUNIQUE
my insert statment is just
insert into tblarticles
(files)
values
('#GetFileFromPath(form.Files)#')
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~
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
checkboxes
i have a form that has a list of articles. and next to each article there is a checkbox. and it displays that it is checked like so: input type=Checkbox name=Status cfif #status# eq 1checked/cfif value=1 if the article is live does anyone know how i would write the update statement? ive tried everything, and i cant get it to work. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
query
the query i wrote below gives me a list of users that are assigned to an application. my question is, how do i get the list of 400 or so users that ARE NOT assigned to that application to display somewhere else on the page so i could then check a box to add them? i quess i could write a second query that would show me all users, but how would i get it on the page that i would just display everyone but those users from the first query? thanks for your help, bec. cfquery name=qryAppDetails datasource=ITData SELECT qryIAPeople.*, tblLicense.Password, tblLicense.FileSrvr, tblLicense.Expiration, tblLicense.Quantity, tblLicense.SerialNum, tblLicense.LicenseKey, tblLicense.LicenseID, tblLicense.LAddInfo, tblApplications.AppName, tblApplications.AppVersion, tblApplications.AppDesc, tblApplications.AppQuantity, tblApplications.AddInfo, tblCompanyInfo.CompanyNm, tblCompanyInfo.CompanyPhone FROM qryIAPeople INNER JOIN ((tblCompanyInfo INNER JOIN ((tblAppIAUsers INNER JOIN tblApplications ON tblAppIAUsers.AppID = tblApplications.AppID) INNER JOIN tblCompApps ON tblApplications.AppID = tblCompApps.AppID) ON tblCompanyInfo.CompanyID = tblCompApps.CompanyID) INNER JOIN tblLicense ON tblApplications.AppID = tblLicense.AppID) ON qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID WHERE tblApplications.AppID = #url.AID# ORDER by qryIAPeople.LAST_NM, qryIAPeople.FIRST_NM /cfquery * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
pass-thru queries
I created a pass-thru query in my access database that connects to a sql server database. i saved that query as qryPassthrough for now. my question is...how do i call this query in cold fusion? would i use the regular cfquery? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
case
is there a cf command that would allow me to force a word to output in all lowercase? thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
dynamic looping
is there anyway to make this javascript code more dynamic? i dont want to
have to type in each individual picture name. i want to go thru my employee
directory and that is over 400 people! plus if someone leaves, i will have
to maintain this. instead i have all these peoples pics in a database. i
want to incorporate a little bit of javascript with my cf. is this possible
and how would i start. here is the javascript below that i found at dynamic
drive:
html
head
script language=JavaScript1.2
/*
Blending Image Slide Show Script-
© Dynamic Drive (www.dynamicdrive.com)
For full source code, 100's more DHTML scripts, and Terms Of Use, visit
dynamicdrive.com
*/
function reapply(){
setTimeout(slideit(),2000)
return true
}
window.onerror=reapply
/script
script language=JavaScript1.1
!--
var image1=new Image()
image1.src=firstimage.gif
var image2=new Image()
image2.src=second.gif
var image3=new Image()
image3.src=third.gif
//--
/script
/head
!---If you want more than three images, add the below code to the above:
var image4=new Image()
image4.src=fourthimage.gif
where 4 represents the fourth image. If you have a fifth image, add even
more of those two lines, with 4 changed to 5.
Step 2: Insert the below into the body section of your page ---
body onLoad=slideit()
a href=javascript:slidelink() onMouseover=window.status='Click on the
image to learn more about it!';return true
onMouseout=window.status=''img src=firstimage.gif name=slide
border=0 style=filter:blendTrans(duration=3)/a
script
!--
change number of images below
var number_of_images=3
//change speed below (in seconds)
var speed=3
var step=1
var whichimage=1
function slideit(){
if (!document.images)
return
if (document.all)
slide.filters.blendTrans.apply()
document.images.slide.src=eval(image+step+.src)
if (document.all)
slide.filters.blendTrans.play()
whichimage=step
if (stepnumber_of_images)
step++
else
step=1
if (document.all)
setTimeout(slideit(),speed*1000+3000)
else
setTimeout(slideit(),speed*1000)
}
function slidelink(){
if (whichimage==1)
window.location=link1.htm
else if (whichimage==2)
window.location=link2.htm
else if (whichimage==3)
window.location=link3.htm
}
//--
/script
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~
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
cf administrator
when setting up a new connection to a database i go thru these steps: 1. launch ie and type the cf admin page into the url. 2. then i get a security box asking me to login 3. then i see the admin page and i log into the administrator. 4. then i click on odbc 5. i name my database and choose mdb and add here is where the problem is at. my database that i want to connect to is not on my webserver. i do have a dedicated drive, say G mapped to the server where the database is at. however, when i click on browse, i only see the webservers drives: A-floppy, C and D drive, and the E drive for disks. do you think it could be a rights issue that i cannot see the other drive mappings? has anyone run into this problem? thanks for your help. bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
addText
does anyone have an example of using addText()? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
connections
hey does anyone know how to set up the database connection on the webserver if your database is not located on your webserver?? i can do this if the database is a SQL server...but i dont see how if the database is Access. right now..i have to always have a specific drive letter mapped to my filer in order for the applications that use the access database on that server to run properly. any ideas are appreciated. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: connections
that's my problem. i want to use a vnc path, but i cant if it is an access database. unless i am missing something...when it comes up to choose the path, it always selects a drive to map the connection to. and that's what i dont want to do. i know u can do what i want to do if the database is SQL. like i said, not sure for access. thanks, bec. -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 7:02 PM To: CF-Talk Subject: RE: connections -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 6:28 PM To: CF-Talk Subject: connections hey does anyone know how to set up the database connection on the webserver if your database is not located on your webserver?? i can do this if the database is a SQL server...but i dont see how if the database is Access. right now..i have to always have a specific drive letter mapped to my filer in order for the applications that use the access database on that server to run properly. any ideas are appreciated. thanks, bec. Bec, You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map a network drive and use that when selecting your .mdb file on the other server. You set this up on the computer running ColdFusion, under the machine's Datasources. Also to make this work you must have the ColdFusion Application Server service log on as a user with the appropriate permissions. While ColdFusion normally runs under the LocalSystem account, the drawback to this is that it cannot access network drives--it has no network access rights. So you can log on the service as a specific user with admin rights, say, and the service will be able to access the network drives (as long as they are set with the proper permissions, as well). -Andy ~~ 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
cfreport
does anyone have any examples using the cfreport tag? i have a few cf books and none of them go into any detail how to use it. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
crystal
will the cfreport tag not work with reports created in crystal reports 8.0? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
sql update
i want to update a field for a record in my database, but i dont want to overwrite what is already there. is there a way i could do this? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
add new record
i have a drop down list of peoples names. on the same page right next to that drop down list i want to put an "add" button to add a new person, if the person isnt already in the list. any easy way to go about getting this done? thanks for the help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
validation
i want to have a form where i can insert a new user into my database. and i have that form but i want to be able to validate it before it submits this new user into my database. i want to check to make sure the person doesnt already exist. (it wont be me entering the data, so i dont want to have user input errors if they dont search thru the drop down list before adding a new person...resulting in duplicate people). someone told me to look thru the custom tags and i did...but i really dont see what i am looking for. can anyone give me any ideas or some direction? thanks for all your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
minihelp
i get the following error when i try to use the custom tag minihelp: Cannot find CFML template for custom tag MAX_ID. ColdFusion attempted looking in the tree of installed custom tags but did not find a custom tag with this name. The error occurred while processing an element with a general identifier of (CF_MAX_ID), occupying document position (20:5) to (23:20). am i supposed to also down load cf_max_id?? and do i just install this in the custom tags directory? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
multiple select
how would the insert statement look if i had a select box that allowed the user to select multiple people to assign to a product? it would be the same product id each time...just different empid's. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: multiple select
thank you so much. that worked great. -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 5:49 PM To: CF-Talk Subject: RE: multiple select It would be passed as a comma separated list e.g., form.assignedEmps = "23,45,123,533,2" So, CFLOOP list="#form.assignedEmps#" index="i" delimiters="," CFQUERY datasource="yourdsn" INSERT INTO yourtable (ProductID, EmpID) VALUES (#form.ProductID#, #i#) /CFQUERY /CFLOOP Assuming that you want a different row for each employeeid... HTH, Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 1:45 PM To: CF-Talk Subject: multiple select how would the insert statement look if i had a select box that allowed the user to select multiple people to assign to a product? it would be the same product id each time...just different empid's. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
cf grid
is there any special code to print data from a grid? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
update
is there anyway to output the last primary key number in a table after an insert statement? i need to capture that number on the same action page so i can pass it to another table. in other words, on my insertApp.cfm i have the query to update my apps table. but on this same page at the bottom, i have another form...a form to update the licensing. when i submit this form, i need that primary key from my apps table to pass thru to my licensing table. so i need a way to capture that value. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: update
thanks. but it is going to an access database. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:06 AM To: CF-Talk Subject: RE: update If it's SQL SERVER use: SELECT @@IDENTITY immediately after inserting -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 15:02 To: CF-Talk Subject: update is there anyway to output the last primary key number in a table after an insert statement? i need to capture that number on the same action page so i can pass it to another table. in other words, on my insertApp.cfm i have the query to update my apps table. but on this same page at the bottom, i have another form...a form to update the licensing. when i submit this form, i need that primary key from my apps table to pass thru to my licensing table. so i need a way to capture that value. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: update
that worked. thank you so so much for your help bec. -Original Message- From: Bill Davies [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:10 AM To: CF-Talk Subject: RE: update Becky see http://www.allaire.com/Handlers/index.cfm?ID=1463Method=Full -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 15:02 To: CF-Talk Subject: update is there anyway to output the last primary key number in a table after an insert statement? i need to capture that number on the same action page so i can pass it to another table. in other words, on my insertApp.cfm i have the query to update my apps table. but on this same page at the bottom, i have another form...a form to update the licensing. when i submit this form, i need that primary key from my apps table to pass thru to my licensing table. so i need a way to capture that value. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: update
an access. but bill davies was kind enough to give me this link http://www.allaire.com/Handlers/index.cfm?ID=1463Method=Full, at which i found an answer. thank you, bec. :) -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:21 AM To: CF-Talk Subject: RE: update What db you using??? -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 15:02 To: CF-Talk Subject: update is there anyway to output the last primary key number in a table after an insert statement? i need to capture that number on the same action page so i can pass it to another table. in other words, on my insertApp.cfm i have the query to update my apps table. but on this same page at the bottom, i have another form...a form to update the licensing. when i submit this form, i need that primary key from my apps table to pass thru to my licensing table. so i need a way to capture that value. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
adding records
hey again, i have a form which allows a user to add a new application to my apps database. i want to have a drop down list of companies. (that i can do) but i want the phone number field to automatically populate if when the user selects say "microsoft" from the list. that phone number will show up in the phone number field because "microsoft" has a phone number in my database. otherwise, the person inputting the data will have to retype the phone number in each time (and remember the number in order to input it!) is this possible to do on the same form? thanks for the info.. b * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
FW: adding records
hey again, i have a form which allows a user to add a new application to my apps database. i want to have a drop down list of companies. (that i can do) but i want the phone number field to automatically populate if when the user selects say "microsoft" from the list. that phone number will show up in the phone number field because "microsoft" has a phone number in my database. otherwise, the person inputting the data will have to retype the phone number in each time (and remember the number in order to input it!) is this possible to do on the same form? thanks for the info.. b * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
insert
is it possible to insert data into a database from a form field that would insert the same data into 2 separate tables in the database? can i do this with one insert statement? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
cfgrid
is there anyway using cfgrid that i can make a field not display in the grid, yet still use that field as a gridkey? i have my last name field as an href field. i only want to display like 4 or 5 fields to the grid...but i want to be able to display all the fields on the details page when you click the hyperlink. and it will not display the other fields unless i make them visable. (apparently they dont get assigned gridkey numbers because they dont display.) any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
output
i want to insert equipment data into my equipment database based on my employee id. but i cant have a drop down list of just id numbers because people wont know who the number belongs to. is there a way i can show the names, but when the data gets inserted into my equipment table that the corresponding employee id goes in, not the full name? i have this as my select box: select name="lname" option cfoutput query="qryUsers" group="lname" cfif lname NEQ "" cfif Inactive NEQ 1 option value="#lname#, #fname#"#lname#, #fname# /cfif /cfif /cfoutput /select but when i submit this form...i want the employee id to go over, not the name thanks for your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: output
thanks for everyones help. :)
-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 11:57 AM
To: CF-Talk
Subject: RE: output
Use the Value="" attribute of the select tag. I modified your code below.
select name="lname"
option
cfoutput query="qryUsers" group="lname"
cfif lname NEQ "" and Inactive NEQ 1
option value="#id#"#lname#, #fname#"#lname#,
#fname#/option
/cfif
/cfoutput
/select
|-Original Message-
|From: Jones, Becky [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 27, 2001 11:43 AM
|To: CF-Talk
|Subject: output
|
|
|i want to insert equipment data into my equipment database based on my
|employee id. but i cant have a drop down list of just id
|numbers because
|people wont know who the number belongs to.
|is there a way i can show the names, but when the data gets
|inserted into my
|equipment table that the corresponding employee id goes in,
|not the full
|name?
|i have this as my select box:
|select name="lname"
| option
| cfoutput query="qryUsers" group="lname"
| cfif lname NEQ ""
| cfif Inactive NEQ 1
| option value="#lname#, #fname#"#lname#, #fname#
| /cfif
| /cfif
| /cfoutput
|/select
|but when i submit this form...i want the employee id to go
|over, not the
|name
|thanks for your help,
|bec.
|
|
|*
|This e-mail, including any attachments, is intended for the
|receipt and use by the intended addressee(s), and may contain
|confidential and privileged information. If you are not an intended
|recipient of this e-mail, you are hereby notified that any
|unauthorized
|use or distribution of this e-mail is strictly prohibited.
|
|
|
|
~~
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
output
i have an update form. and i want to be able to have a select box of all users. but i want the user that i am currently updating to be "selected" but i want to have the ability to select someone else. is this possible? right now i have this: tr tdUser Name:/td tdselect name="empid" cfoutput query="qryUpEquip" option value="#empID#"#lname# #fname# /cfoutput /select /td /tr and it shows up the correct selected user, but i want to be able to choose someone else from the list and it is only showing this particular user. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: output
cfquery datasource="ITData" name="qryUpEquip"
Select
tblEquipment.EquipID,
tblEquipment.CompanyNM,
tblEquipment.ModelNo,
tblEquipment.OS,
tblEquipment.HardDrive,
tblEquipment.RAM,
tblEquipment.Leased,
tblEquipment.LeaseTerm,
tblEquipment.LeaseDate,
tblEquipment.LeaseMods,
tblEquipment.AddInfo,
tblEquipment.Description,
tblEquipment.SerialNo,
tblEquipment.EquipType,
tblEquipment.LeaseScheduleNumber,
tblEquipment.Location,
tblEquipment.ServiceAgree,
tblEquipment.ServiceExp,
tblEquipment.ServiceCert,
tblEquipment.ServicePhone,
tblEmployees.EmpID,
tblEmployees.LName,
tblEmployees.FName,
tblEmployees.MI,
tblEmployees.Dept,
tblEmployees.Office,
tblEmployees.Floor,
tblEmployees.Phone,
tblEmployees.Inactive
FROM {oj tblEquipment RIGHT OUTER JOIN tblEmployees ON tblEquipment.EmpId
= tblEmployees.EmpId }
Where tblEquipment.SerialNo LIKE '%#SerialNo#%'
cfif EquipType NEQ ""
OR tblEQuipment.EquipType LIKE '#EquipType#'
/cfif
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 7:28 PM
To: CF-Talk
Subject: Re: output
what does your query look like? (qryUpEquip)
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Jones, Becky" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 27, 2001 5:16 PM
Subject: output
i have an update form. and i want to be able to have a select box of all
users. but i want the user that i am currently updating to be "selected"
but i want to have the ability to select someone else. is this possible?
right now i have this:
tr
tdUser Name:/td
tdselect name="empid"
cfoutput query="qryUpEquip"
option value="#empID#"#lname# #fname#
/cfoutput
/select /td
/tr
and it shows up the correct selected user, but i want to be able to choose
someone else from the list and it is only showing this particular user.
thanks,
bec.
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~
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
sortable grid
does anyone know if there is a custom tag out there that i could use the data from my query to be put into a grid-like table where i could just click on column names and be able to sort or drag and drop a column into a new position? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
nesting queries
I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. !--- Query to get all User's info. --- cfquery name="qryAllEmp" datasource="ITData" SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' cfif office eq "All Offices" AND tblEmployees.Office LIKE '%' cfelse AND tblEmployees.Office LIKE '#office#%' /cfif ORDER BY tblEmployees.lname /cfquery !--- Query to get the users Equipment info. Setting iEquipID eq the previous query's results. --- cfset iEquipID = qryAllEmp.EmpID cfquery name="qryEquipment" datasource="ITData" SELECT * from tblEquipment WHERE EquipID = #iEquipID# /cfquery I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: nesting queries
i tried that and i only get results from the first query... cfoutput cfloop query="qryAllEmp" tr td colspan="2" bgcolor="E0" b#qryAllEmp.FName# #strSpace# #qryAllEmp.MI# #StrSpace# #qryAllEmp.LName#/b br #qryAllEmp.Dept# /td /tr tr td colspan="2" bgcolor="E0"br/td /tr tr td colspan="2" bgcolor="E0" #qryAllEmp.Office#br#qryAllEmp.Floor#br#qryAllEmp.Phone# /td /tr tr td colspan="2" bgcolor="E0"br /td /tr !--- Variable to output Label Equipment once. --- cfset iEqcnt = 1 cfloop query="qryEquipment" tr td width="10%" bgcolor="E0" cfif iEqcnt eq 1b Equipment: /b cfset iEqcnt=0 /cfif /td td bgcolor="E0"#qryEquipment.Description#/td /tr /cfloop /cfloop /cfoutput -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: RE: nesting queries You can place a CFOUTPUT at the very top of the Queries and instead of using CFOUTPUT QUERY, use a CFLOOP Query just make sure when you are outputing the query results you use the prefix for the given query Example: CFOUPUT CFLOOP QUERY=Query1 #Query1.MYFIELD# CFLOOP Query=Query2 #Query2.MyField# CFLOOP Query=Query3 #Query3.MyField# Also make sure you close the loops when needed to reduce the looping through unneeded records. HTH -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: nesting queries I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. !--- Query to get all User's info. --- cfquery name="qryAllEmp" datasource="ITData" SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' cfif office eq "All Offices" AND tblEmployees.Office LIKE '%' cfelse AND tblEmployees.Office LIKE '#office#%' /cfif ORDER BY tblEmployees.lname /cfquery !--- Query to get the users Equipment info. Setting iEquipID eq the previous query's results. --- cfset iEquipID = qryAllEmp.EmpID cfquery name="qryEquipment" datasource="ITData" SELECT * from tblEquipment WHERE EquipID = #iEquipID# /cfquery I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: nesting queries
sure,
i checked the database for one specific person that i know has information
in the equipment table so the info is there..i just cant get it out! :)
qry one:
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif
ORDER BY tblEmployees.lname
/cfquery
qry two:
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous
query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:49 AM
To: CF-Talk
Subject: RE: nesting queries
Then it is possible that the 2nd Query returns no records,
Can you show me both queries
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:45 AM
To: CF-Talk
Subject: RE: nesting queries
i tried that and i only get results from the first query...
cfoutput
cfloop query="qryAllEmp"
tr
td colspan="2" bgcolor="E0" b#qryAllEmp.FName#
#strSpace# #qryAllEmp.MI# #StrSpace#
#qryAllEmp.LName#/b br
#qryAllEmp.Dept#
/td
/tr
tr
td colspan="2" bgcolor="E0"br/td
/tr
tr
td colspan="2" bgcolor="E0"
#qryAllEmp.Office#br#qryAllEmp.Floor#br#qryAllEmp.Phone#
/td
/tr
tr
td colspan="2" bgcolor="E0"br /td
/tr
!--- Variable to output Label Equipment once. ---
cfset iEqcnt = 1
cfloop query="qryEquipment"
tr
td width="10%" bgcolor="E0"
cfif iEqcnt eq 1b Equipment: /b cfset
iEqcnt=0 /cfif
/td
td bgcolor="E0"#qryEquipment.Description#/td
/tr
/cfloop
/cfloop
/cfoutput
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: RE: nesting queries
You can place a CFOUTPUT at the very top
of the Queries and instead of using CFOUTPUT QUERY,
use a CFLOOP Query just make sure when you are
outputing the query results you use the prefix
for the given query
Example:
CFOUPUT
CFLOOP QUERY=Query1
#Query1.MYFIELD#
CFLOOP Query=Query2
#Query2.MyField#
CFLOOP Query=Query3
#Query3.MyField#
Also make sure you close the loops when needed
to reduce the looping through unneeded records.
HTH
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: nesting queries
I have 3 queries. But when i try to nest the cfoutput tags i get an error
that says this in to allowed.
how do you use the cfoutput tags to output your information if the data to
your second and third query is dependent upon the info from the first?
here are my first 2 queries.
!--- Query to get all User's info. ---
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif
ORDER BY tblEmployees.lname
/cfquery
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery
I want to be able to have one table that i can put the information all
together. any ideas?
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~
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: nesting queries
i tried doing that first. but the problem i run into is that i want to have Prev/next buttons. and when i loop thru, it minuses one of the applications/equipment for an indivual person each time it loops. inotherwords...say for me i have 3 pieces of equipment. my record count shows that i have 3 records not one. and if i click on the next button it will have my name minus a piece of equipment. and so on. so i thought maybe doing seperate queries would help with the record counting. but i guess that is another issue. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:03 AM To: CF-Talk Subject: RE: nesting queries Considering that do a simple join on the two tables to obtain results in one recordset. Thus: One Query: cfouput query=qyrAllEmp All variables would be: qryAllEmp.fieldnames Then you only need one CFOUTPUT and No CFLOOPS Also considering that within the Equipment table that EquipID is actually the Employee ID from the Employee Table. By what you showed in this statement is is. cfset iEquipID = qryAllEmp.EmpID Somewhat odd, I would think that the EquipID would be the indtifier for the Equipment not the employee. cfquery name="qryAllEmp" datasource="ITData" SELECT tblEmployees.FieldOne,tblEmployees.FieldTwo,tblEquipment.Description FROM tblEmployees, tblEquipment WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' cfif office eq "All Offices" AND tblEmployees.Office LIKE '%' cfelse AND tblEmployees.Office LIKE '#office#%' /cfif AND tblEmployees.EMPID = tblEquipment.EquipID ORDER BY tblEmployees.lname /cfquery -----Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:01 AM To: CF-Talk Subject: RE: nesting queries sure, i checked the database for one specific person that i know has information in the equipment table so the info is there..i just cant get it out! :) qry one: cfquery name="qryAllEmp" datasource="ITData" SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' cfif office eq "All Offices" AND tblEmployees.Office LIKE '%' cfelse AND tblEmployees.Office LIKE '#office#%' /cfif ORDER BY tblEmployees.lname /cfquery qry two: !--- Query to get the users Equipment info. Setting iEquipID eq the previous query's results. --- cfset iEquipID = qryAllEmp.EmpID cfquery name="qryEquipment" datasource="ITData" SELECT * from tblEquipment WHERE EquipID = #iEquipID# /cfquery -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:49 AM To: CF-Talk Subject: RE: nesting queries Then it is possible that the 2nd Query returns no records, Can you show me both queries -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:45 AM To: CF-Talk Subject: RE: nesting queries i tried that and i only get results from the first query... cfoutput cfloop query="qryAllEmp" tr td colspan="2" bgcolor="E0" b#qryAllEmp.FName# #strSpace# #qryAllEmp.MI# #StrSpace# #qryAllEmp.LName#/b br #qryAllEmp.Dept# /td /tr tr td colspan="2" bgcolor="E0"br/td /tr tr td colspan="2" bgcolor="E0" #qryAllEmp.Office#br#qryAllEmp.Floor#br#qryAllEmp.Phone# /td /tr tr td colspan="2" bgcolor="E0"br /td /tr !--- Variable to output Label Equipment once. --- cfset iEqcnt = 1 cfloop query="qryEquipment" tr td width="10%" bgcolor="E0" cfif iEqcnt eq 1b Equipment: /b cfset iEqcnt=0 /cfif /td td bgcolor="E0"#qryEquipment.Description#/td /tr /cfloop /cfloop /cfoutput -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: RE: nesting queries You can place a CFOUTPUT at the very top of the Queries and instead of using CFOUTPUT QUERY, use a CFLOOP Query just make sure when you are outputing the query results you use the prefix for the given query Example: CFOUPUT CFLOOP QUERY=Query1 #Query1.MYFIELD# CFLOOP Query=Query2 #Query2.MyField# C
RE: looping recordsets
but it really doesnt work if i already have a form set up that passes data to the action page. the action page is where i want to loop thru the recordsets based on the information entered from the search form. -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 8:34 AM To: CF-Talk Subject: RE: looping recordsets Studio has a built in Wizard for this. File New.. CFML Record Viewer Wizard Tristram Charnley - [EMAIL PROTECTED] "If something is hard to do, its not worth doing!" Homer Simpson. -Original Message----- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 12 March 2001 00:40 To: CF-Talk Subject: looping recordsets i want to be able to have next and previous buttons on a page where the first page would show all the information about employee one. then at the bottom of the page there would be a button called "next" and when i clicked on it, it would show employee two's info plus have a "prev"/"next" button at the bottom of the page. is there a special tag for this? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
looping recordsets
i want to be able to have next and previous buttons on a page where the first page would show all the information about employee one. then at the bottom of the page there would be a button called "next" and when i clicked on it, it would show employee two's info plus have a "prev"/"next" button at the bottom of the page. is there a special tag for this? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: drop down form
do you have any examples?? -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 10, 2001 4:31 AM To: CF-Talk Subject: Re: drop down form Can be done with Flash, DHTML, Java HTH Dick At 7:50 PM -0500 3/9/01, Jones, Becky wrote: this may not be the right forum for this...but everyone seems to be pretty knowledgable here... i have a form on a page. i want to be able to have like a "minimize" "maximize" button on the form. so say the the the tH was my form. like off to the side it coul have an icon maybe a down arrow or something. so when i clicked on that error, it would show the entire form and when i clicked on it again it would hide the form. kinda like menus My menu (closed) My menu +sub menu (opened) i want to have my form just show the header...and then when you clicked on this icon it would show the entire form. any ideas where to look for this? thanks alot. bec. ~~ 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 form
this may not be the right forum for this...but everyone seems to be pretty knowledgable here... i have a form on a page. i want to be able to have like a "minimize" "maximize" button on the form. so say the the the tH was my form. like off to the side it coul have an icon maybe a down arrow or something. so when i clicked on that error, it would show the entire form and when i clicked on it again it would hide the form. kinda like menus My menu (closed) My menu +sub menu (opened) i want to have my form just show the header...and then when you clicked on this icon it would show the entire form. any ideas where to look for this? thanks alot. bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
LEVEL 8 Systems Corporate Website
would anyone know what type of package this company used to make this image? something like photoshop or dreamweaver? http://www.level8.com/ * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. LEVEL 8 Systems Corporate Website.url ~~ 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
cfmail
is there a way to attach a cf template to an email with the cfmail tag? and what exactly is a MIME attachment? i have a form that a user fills out...and i want the info in that form to go to an email address but i want the layout of the form to go also. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: cfmail
but wouldnt the user that recieves the form need to have cf? i want them to be able to open it like a word or text document. but how would i get the cf variables to right to that doc? -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 5:42 PM To: CF-Talk Subject: Re: cfmail - Original Message - From: "Jones, Becky" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 5:23 PM Subject: cfmail is there a way to attach a cf template to an email with the cfmail tag? Sure: cfmail ... mimeattach="sometemplate.cfm" blah /cfmail -OR- cfmail ... CFMAILPARAM FILE="sometemplate.cfm" blah /cfmail The first method can be used in any version of cf and allows for a single attachment. The second method is for cf 4.5 and allows for multiple attachments. and what exactly is a MIME attachment? MIME means "Multipurpose Internet Mail Extensions " and is an encoding method for mail attachments or special character sets. Traditionally, emails can only contain 7-bit characters (although some mail servers support 8-bit). Using MIME allows for 8-bit binary attachments to be converted into a 7-bit representation that can be decoded by the recipient. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! i have a form that a user fills out...and i want the info in that form to go to an email address but i want the layout of the form to go also. thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
is there a way to have a form that when a user types in data, it gets submitted to a database and an email of the data goes to a specific person or persons? thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
