cf-talk@houseoffusion.com
Hi Ive the below code and im trying to get it to check first that the confirmation field in the comments table is equal to 1 before it send at the minute its sending anyway any tips Thanks Select * >From comments where confirmation = 1 Persons Name:#Name# Persons Email:#Email# Comments:#comments# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf-talk@houseoffusion.com
Hi Ive the below code and im trying to get it to check first that the confirmation field in the comments table is equal to 1 before it send at the minute its sending anyway any tips Thanks Select * >From comments where confirmation = 1 Persons Name:#Name# Persons Email:#Email# Comments:#comments# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332975 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf-talk@houseoffusion.com
Hi Ive the below code and im trying to get it to check first that the confirmation field in the comments table is equal to 1 before it send at the minute its sending anyway any tips Thanks Select * >From comments where confirmation = 1 Persons Name:#Name# Persons Email:#Email# Comments:#comments# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332974 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Searching a Date Range
Thanks alot for all your help, ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Searching a Date Range
Hi im having some bother trying to get a search by date range working on a form in coldfusion. does anyone have any tips on setting this up? It would be greatly appreciated ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329223 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending a Fax
Ok I'll try that Robert Thanks for your help >> Is there a way I can just simply move it down the page slightly, at the >minute its at the very top with no margins >> even if i could increase the margin, it would move down the page > >Sine there's no code samples I can really tell what you are doing, but in >print world the output is likely SGML. You should be able to output some >line breaks or page feeds to the printer controls prior to the text string - >in CF - that's #chr(10)# and #chr(13)#. > >Geez - tried to include some links but Adobe CF docs is all coming up >"broken links" right now. When they come back look up "carriage return" and >"line feed". Should be straight forward. > > >Robert B. Harrison >Director of Interactive Services >Austin & Williams >125 Kennedy Drive, Suite 100 >Hauppauge NY 11788 >P : 631.231.6600 Ext. 119 >F : 631.434.7022 >http://www.austin-williams.com > >Great advertising can't be either/or. It must be &. > >Plug in to our blog: A&W Unplugged >http://www.austin-williams.com/unplugged > > > > >__ Information from ESET Smart Security, version of virus signature >database 4673 (20091209) __ > >The message was checked by ESET Smart Security. > >http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending a Fax
Is there a way I can just simply move it down the page slightly, at the minute its at the very top with no margins even if i could increase the margin, it would move down the page >I think you could output it to HTML before you send it to the fax and use >the @media: print CSS to style the print format. That should work. > >Robert B. Harrison >Director of Interactive Services >Austin & Williams >125 Kennedy Drive, Suite 100 >Hauppauge NY 11788 >P : 631.231.6600 Ext. 119 >F : 631.434.7022 >http://www.austin-williams.com > >Great advertising can't be either/or. It must be &. > >Plug in to our blog: A&W Unplugged >http://www.austin-williams.com/unplugged > > > >Ive a text box on a fom and when I fill it in, and enter the Fax Number The >Info is sent to the fax machine, The Text which I entered on the form >appears on the 1st page of the Fax then the info follows, Im trying to move >this text about half way down the page and put a brder around it, >How do I do this using coldfusion? >Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending a Fax
Is there a way I can just simply move it down the page slightly, at the minute its at the very top with no margins even if i could increase the margin, it would move down the page >I think you could output it to HTML before you send it to the fax and use >the @media: print CSS to style the print format. That should work. > >Robert B. Harrison >Director of Interactive Services >Austin & Williams >125 Kennedy Drive, Suite 100 >Hauppauge NY 11788 >P : 631.231.6600 Ext. 119 >F : 631.434.7022 >http://www.austin-williams.com > >Great advertising can't be either/or. It must be &. > >Plug in to our blog: A&W Unplugged >http://www.austin-williams.com/unplugged > > > >Ive a text box on a fom and when I fill it in, and enter the Fax Number The >Info is sent to the fax machine, The Text which I entered on the form >appears on the 1st page of the Fax then the info follows, Im trying to move >this text about half way down the page and put a brder around it, >How do I do this using coldfusion? >Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sending a Fax
Ive a text box on a fom and when I fill it in, and enter the Fax Number The Info is sent to the fax machine, The Text which I entered on the form appears on the 1st page of the Fax then the info follows, Im trying to move this text about half way down the page and put a brder around it, How do I do this using coldfusion? Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
The company table represents the seller, and the Customer table represents the individual Buyers. Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Check Boxes
This was what i meant to put in instead of qgetcustomer query So am I still missing a join somewhere select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum from INVOICE where INVOICE_Key = #url.invoice# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
Heres the code im using SELECT invoice.*, customer.CUSTOMER_Name FROM invoice left join customer on invoice.CUSTOMER_AccNum = customer.CUSTOMER_AccNum; Invoice Number : Customer Number : Customer Name : Your Search has returned 0 results select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name from INVOICE I, COMPANY C, CUSTOMER CU where I.COMPANY_Number = C.COMPANY_Number AND I.COMPANY_Number = '#form.COMPANY_Number#' AND I.INVOICE_Number LIKE '%#form.INVOICE_Number#%' AND I.CUSTOMER_AccNum LIKE '%#form.CUSTOMER_AccNum#%' AND CU.CUSTOMER_Name LIKE '%#form.CUSTOMER_Name#%' AND I.INVOICE_PDFFile <> '' ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Check Boxes
Hi can someone help me out here, Im trying to have a check box for each invoice so when its ticked and you press submit all the ticked invoices will be sent to the revelant email address, I'm trying to have it so the check boxes will be defaulted to ticked if the customer Number for the invoice, is in the Customer Table, The next problem I have is for each Customer I add to the Customer Table its duplicating the Data and showing everything twice if theres 2 Customers. or 3 times if theres 3 Customers added and so on, I cant seem to figure out why its doing this any tips would be great ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pick up invoice number and Customer number from a text file
Can anyone help me out with the below: Im trying to pick up an invNumber and CustAccNum which is either on line 26 or 27, at the minute the below code seems to be doubling up, and not importing anything into the database any tips would be great Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Jpg as a Watermark
> > Hi > > Im using a JPG watermark in coldfusion to display as a background on > a > > PDF, but the problem is its taking up quict a bit of space as i need > > > it on every page. > > is there something else I could use instead of a watermark to reduce > > > the size of the file? > > heres the code im using at the moment: > > > > > > action = "addwatermark" > > > source = "#TEST#" > > > image = "#request.mainfilePath#Test2#" > > > foreground = "No" > > > overwrite = "yes" > > > pages = "#totalpages#" > > opacity = "10" > > Position = "10, -50" > > > showonprint = "YES" > > > destination = "#TEST3#"> > > We had the same need, when you use the watermark feature it is on TOP > of the image and sometimes you can not read the content below. What > we did was to create an image and then use it as a background image in > HTML as the watermark. This placed the image behind the content and > if you need, you can even customize the image by using the CFIMAGE tag. > > > > Matt Friedman > "life is too short to drink cheap beer" Heres another one i've tried which might work if it would do it automatically At the minute ive a PDF at 48kb before I add the Watermark. after ive the watermark added it jumps to 60MB but when I go to File save as Version 5 on Abobe it cuts the Size back to 99KB Im wondering can this be done automatically so i dont have to open the file and save it down each to to reduce the size of it. The version of Adobe Im using is 6 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Jpg as a Watermark
Hi Im using a JPG watermark in coldfusion to display as a background on a PDF, but the problem is its taking up quict a bit of space as i need it on every page. is there something else I could use instead of a watermark to reduce the size of the file? heres the code im using at the moment: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Deleting contents within a folder
Hi Im trying to delete all the contents within a folder using coldfusion, but its deleting the actual folder each time The contents of the folder contains be PDF's has anyone any tips on deleting the contents and not the actual folder Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking line 26 or 27
Just sent it to you now! nothings changing the invoice number >Yes, that is why my code set invoice = "". > >Then set invoicenumber = line 26. >Go to line 27 if invoicenumber has a length then continue on, if not set >the invoice number to the value on line 27. > >Ok, so my code didn't work... Is something else changing invoice number? > >Can I see the whole loop. If you don't want to share with everyone you >can send it directly to me at sd1985 (at) att (dot) com > >Steve > > > >No, I think im confusing you now :-) >in some cases the invoice number is on line 26, and it other cases the >invoice number is on line 27. all runs fine when the invoice number is >on line 27 because theres nothing on line 26 to print so therfore it >leaves it >but its messing up when the invoice is on line 26, becase its still >checking line 27 aswell. and brings in data from there. I tried your >below code but its still doing the same for me, and yes i have it in a >loop >hope thats makes sence to you ;-) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking line 26 or 27
No, I think im confusing you now :-) in some cases the invoice number is on line 26, and it other cases the invoice number is on line 27. all runs fine when the invoice number is on line 27 because theres nothing on line 26 to print so therfore it leaves it but its messing up when the invoice is on line 26, becase its still checking line 27 aswell. and brings in data from there. I tried your below code but its still doing the same for me, and yes i have it in a loop hope thats makes sence to you ;-) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking line 26 or 27
All i need it to do is, check if line 26 has text in it, and if so not to check line 27 this piece of code is doing part of that, only its checking Line 27 also and inputting whats in it also >>>The Invoice will not change > >This is absolutely true,... until the guy who said it will not change is >changed ;-) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking line 26 or 27
The Invoice will not change, its only ever going to be on line 26 or line 27 I tried your code but all i get is an error messag saying: You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. When i copy the invoice in here it goes all over the place > As I said, relying on line numbers doesn't seem like a robust method - > what happens if the top of the invoice is changed, and it suddenly > becomes line 15/16 or 32/33 or something else? > > Ideally you refer specifically to the location of the invoice number, > hence asking for a sample of the invoice to see what structure it uses. > > > > If you r*eally* want to deal with line numbers, then you can split the > content into an array and do something like this: > > > > > > > > > > (Or, if this is the only time you're looking at lines, use ListGetAt > with newlines as delimiters) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking line 26 or 27
Its simply looking at line 26 for the invoice number and inputting it in a table. but on some invoives line 26 is blank, so i need it to check line 27, but only if line 26 is blank. at the minute its checking both lines and inputting info from both lines ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checking line 26 or 27
Its simply looking at line 26 for the invoice number and inputting it in a table. but on some invoives line 26 is blank, so i need it to check line 27, but only if line 26 is blank. at the minute its checking both lines and inputting info from both lines >This doesn't sound like a very robust method. > >Are you able to provide sample invoice(s)? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Checking line 26 or 27
Hi Im uploading textfiles to a database, im using the below code, as the invoive number is either on line 26 or 27. can anyone help me out here as its using info from both lines. If the invoice is on line 26 I dont want it to check line 27, but if line 26 is blank, i want it to check line 27 if that makes sence Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Uploading Error
Thats great Rick works perfect Thanks >> > >+ is mathematical addition. > >I'm guessing that you're trying to do string concatenation, and need >to use & instead. > > > >Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Uploading Error
When I upload records im getting the below error Error (The Value 2F cannot be converted to number) But when i remove this piece of code it works fine, but then as for the other records (which had not this 2F value problem), its not uploading them correctly What can i change on this line of code so it will all work correctly Heres where that code is inserted: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326890 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error (The Value 2F cannot be converted to a number)
Thanks for Replying Barney, but im afraid that doesnt seem to work for me, im still getting the same error >val() will do that for you, but that's a rather course approach. If >you have a know format (e.g. one number then one letter), you'd be >better parsing it explicitly (e.g., left(value, 1)) rather than using >something like val(). > >cheers, >barneyb > > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Error (The Value 2F cannot be converted to a number)
HI, Im having a slight problem while importing text files to a database, Im using the below code, but it displaying an error (The Value 2F cannot be converted to a number) How do i get it to ignore the F and just look at the 2 using code? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Users access to a listbox
I dont quite get that For the user to be able to access this page I add their Windows User Profile to a table and from there they can access all the companies If that makes sence >If your user logs in, then when you do the login authenication you can hold >their userid in Session. Then use the Session variable in place of the 25, >#Session.YourUserVariable#. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326777 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Users access to a listbox
That works great Chuck, but is there any way i can change the #myUsersKey# which in my case I just replaced it with 25. if other users log on this will still hold 25, so id need it to change for every user, if that is possible >You need to filter your data for the User Key that is accessing the code. >You can either put a WHERE clause in your SQL Statement or you can put a >conditional statement around the options looking at the USERS_Key. > >Query: > >The is made up and you should use your information to set >that up. > > > select COMPANY_Number,USERS_Key > from USERSvCOMPANYACCESS > WHERE USERS_Key = value="#myUsersKey#" /> > ORDER BY COMPANY_Number > > >Conditional: > > > > COMPANY_Number)>selected> > [#COMPANY_Number#] > > > > >HTH >Chuck ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Users access to a listbox
Ive tried your code, but all its giving me now is a blank list box, with nothing to choose in it >It is going to list them all based on your code: > >1. Your query is returning ALL records >2. your displaying all OPTIONs in the SELECT dropdown but ONLY selecting the >ones that was populated in the FORM.COMPANY_NUMBER field. > >If you only want the SELECT dropdown to return the one in >FORM.COMPANY_NUMBER > >then this would work: > > >COMPANY_Number)> >[#COMPANY_Number#] > > >*** Now this is true if FORM.COMPANY_NUMBER is a SINGLE VALUE not a list. > >If you FORM.COMPANY_NUMBER is a LIST, then it would be similar to: > > > > > >On Wed, Sep 30, 2009 at 4:49 AM, Damo Drumm >wrote: > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Users access to a listbox
Hi, at the minute when i add a user to the database they can view all companies on a list box. Im trying to reduce this so they will only have access to what i enter in a table called USERSvCOMPANYACCESS, which has the Users Key and the Company Number in it. Im using the below code, but its displaying all company numbers I enter to that table, rather than just the numbers I have chosen for that one user. Can anyone help me out here? select COMPANY_Number,USERS_Key from USERSvCOMPANYACCESS ORDER BY COMPANY_Number selected> [#COMPANY_Number#] ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using a Listbox to allow Users Access
Thanks, The first option will suit me so if i set up a field in My Users table called CompanyAccess, then followed by the correct code it will be able to pick out wheather or not I can access it depending which numbers I have entered in my CompanyAccess field >Depending on how you have your validation structured for permissions, an >idea would be: > >Session.CompanyAccess = '1,2,5,6' > >Then you can validate it when needed. > >Now if you are going further to set permissions such as CRUD: > >Session.CompanyAccess.Permissions_1 = "C,R,U,D" >Session.CompanyAccess.Permissions_2 = "R" >Session.CompanyAccess.Permissions_3 = "C,R,U" > >(CRUD = Create, Read, Update, Delete) > > > > >On Mon, Sep 28, 2009 at 6:01 AM, Damo Drumm >wrote: > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using a Listbox to allow Users Access
Hi, I have a drop down list on a form showing a list of Companies, which ive linked to a table called Company, Im trying to use this list to give access for each username, at them min when someones name is added to the Table (Users) they have access to all Companies on the list box, im trying to change this so i can give each person access to only the companies I require Can someone help me out on how I go a bout doing this? Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: selecting different template based on file name
Hi Jason Ive tried that but Im still getting the same error >The error means that InvoiceTemplateType_Key is a column in both tables, so >you have to let the database know which one you actually want. Use your >table aliases: > > >SELECT > IT.InvoiceTemplate_FileName, > IT.InvoiceTemplateType_Key, > I.Invoive_Key > FROM InvoiceTemplate IT, INVOICE I > WHERE I.IINVOICE_Key = #url.invoice# > AND IT.InvoiceTemplateType_Key = 1 > > >Looks like you're not JOINing your tables either, which could be pretty bad >in both performance and results, and please be sure you're using >CFQUERYPARAM in actual code to screen that URL variable. Something like >this (making assumptions here about data types and column references): > > > >SELECT > IT.InvoiceTemplate_FileName, > > IT.InvoiceTemplateType_Key, > > I.Invoive_Key > FROM InvoiceTemplate IT INNER JOIN > INVOICE I ON IT.InvoiceTemplateType_Key = >I.InvoiceTemplateType_Key > WHERE I.IINVOICE_Key = value="#url.invoice#" /> > AND IT.InvoiceTemplateType_Key = cfsqltype="CF_SQL_INTEGER" value="1" /> > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
selecting different template based on file name
Hi im having trouble with the below piece of code, im trying to set it up to add the correct template as a watermark based on the filename in the database in field (INVOICE_PDFFile) can anyone help me out? at the minute im getting this error message - Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Ambiguous column name 'InvoiceTemplateType_Key'. heres my code: select INVOICE_PDFFile from INVOICE where INVOICE_Key = #url.invoice# select InvoiceTemplate_FileName, InvoiceTemplateType_Key, Invoive_Key from InvoiceTemplate IT, INVOICE I where IINVOICE_Key = #url.invoice# AND InvoiceTemplateType_Key = 1 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stop cursor typing past 500 characters
Hi Marcus I notice now its actually a Email Text : only problem is maxlength doesnt seem to be doing anything, am i putting it in the right place? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: stop cursor typing past 500 characters
Hi Philip If I change it to text on the SQL server, it only allows me to type 16 characters >Just curious. If you have a text box, have you considered changing the >field type to text? > > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stop cursor typing past 500 characters
Hi Philip If I change it to text on the SQL server, it only allows me to type 16 characters >Just curious. If you have a text box, have you considered changing the >field type to text? > > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stop cursor typing past 500 characters
Hi Agha Thanks for that, ive put in in the following place but its not doing anything, Im I putting it in the correct place? Email Text : Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
stop cursor typing past 500 characters
Hi Iâve a text box on my form, and in the database it is set to allow 500 characters to be entered, however i can write any amount of characters above 500, I do get an error sayng: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated. But the email still sends anyway, what im trying to do is get rid of the error message altogether, so is there a way I can stop the cursor from typing past 500 characters? Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Move contents of a folder to a new location
Hi Rick Thats what the code is doing already, i want it to move the contents but leaving the actual folder behind, sorry i might not have explained this properly in the last comment > On Wed, Sep 9, 2009 at 10:31 AM, Damo Drumm com> wrote: > > > > Im trying to move the contents of a folder once processed to a new > folder, the only problem is, its moving the actual folder (testfiles) > inside the processed folder. > > Can anyone suggest how I fix this; the contents within the testfiles > folder are text docs and pdf's > > I found this comment in my code for CFFM: > > "coldfusion can actually rename a directory into a new location, but > bluedragon 6.1 could not, > so I chose to use the moveDirectory() function instead " > > However, I can't tell if this helps you. > > If you WANT to move the whole folder, including the folder itself... > "testfiles" into the Processed folder.. then do this: > > source="c:\inetpub\wwwroot\sites\qspool\www_root\testfiles" destin> ation="c:\inetpub\wwwroot\sites\qspool\www_root\Processed\testfiles"> > > You can check out the moveDirectory() function in cffm.cfc at > http://svn.riaforge.org/cffm/cffm.cfc > > -- > Rick Root > CFFM - Open Source Coldfusion File Manager > http://www.opensourcecf. com/cf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Move contents of a folder to a new location
Hi Iâm trying to move the contents of a folder once processed to a new folder, the only problem is, itâs moving the actual folder (testfiles) inside the processed folder. Can anyone suggest how I fix this; the contents within the testfiles folder are text docs and pdf's ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326135 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Move contents of a folder to a new location
Hi Iâm trying to move the contents of a folder once processed to a new folder, the only problem is, itâs moving the actual folder (testfiles) inside the processed folder. Can anyone suggest how I fix this; the contents within the testfiles folder are text docs and pdf's ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326134 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Move contents of a folder to a new location
Hi Iâm trying to move the contents of a folder once processed to a new folder, the only problem is, itâs moving the actual folder (testfiles) inside the processed folder. Can anyone suggest how I fix this; the contents within the testfiles folder are text docs and pdf's ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Display Windows Log on ID
Cheers Mike That worked perfect Thanks > Use the listLast() function with "/" or "\" as the delimiter. You may > need to use both as the delimiter because both are allowed. > > mike > > _ > > From: Damo Drumm [mailto:damien.dr...@quinn-group.com] > Sent: Thu 9/3/2009 8:18 AM > To: cf-talk > Subject: Display Windows Log on ID > > > > > Hi > Im trying to display the Windows log on ID using coldfusion, im using > cgi.REMOTE_USER at the minute but its displaying the Domain also, is > there something i can use which will only display the log on ID, or > else some way of deleting the domain which is the first 12 characters > of the text > > Thanks > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325982 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Display Windows Log on ID
Cheers Mike That worked perfect Thanks > Use the listLast() function with "/" or "\" as the delimiter. You may > need to use both as the delimiter because both are allowed. > > mike > > _ > > From: Damo Drumm [mailto:damien.dr...@quinn-group.com] > Sent: Thu 9/3/2009 8:18 AM > To: cf-talk > Subject: Display Windows Log on ID > > > > > Hi > Im trying to display the Windows log on ID using coldfusion, im using > cgi.REMOTE_USER at the minute but its displaying the Domain also, is > there something i can use which will only display the log on ID, or > else some way of deleting the domain which is the first 12 characters > of the text > > Thanks > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Display Windows Log on ID
Hi Im trying to display the Windows log on ID using coldfusion, im using cgi.REMOTE_USER at the minute but its displaying the Domain also, is there something i can use which will only display the log on ID, or else some way of deleting the domain which is the first 12 characters of the text Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Display Windows Log on ID
Hi Im trying to display the Windows log on ID using coldfusion, im using cgi.REMOTE_USER at the minute but its displaying the Domain also, is there something i can use which will only display the log on ID, or else some way of deleting the domain which is the first 12 characters of the text Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
