cfmail

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 cfquery name=qgetdetails datasource=#test# Select * From comments where confirmation = 1 /cfquery

cfmail

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 cfquery name=qgetdetails datasource=#test# Select * From comments where confirmation = 1 /cfquery

cfmail

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 cfquery name=qgetdetails datasource=#test# Select * From comments where confirmation = 1 /cfquery

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:

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

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,

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

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

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

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

Re: Check Boxes

Heres the code im using cfquery name=qgetcustomer datasource=#request.dsn# SELECT invoice.*, customer.CUSTOMER_Name FROM invoice left join customer on invoice.CUSTOMER_AccNum = customer.CUSTOMER_AccNum; /cfquery /select

Re: Check Boxes

This was what i meant to put in instead of qgetcustomer query So am I still missing a join somewhere cfif isdefined(url.invoice) cfquery name=qgetcompanyno datasource=#request.dsn# select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum from INVOICE

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

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 cfif left(trim(Variables.aryLoop), 3) is

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:

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

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

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 cfif previouslinenumber eq 26 cfset linenumber = 27 /cfif cfif (linenumber eq

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

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

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

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

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

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

Re: Uploading Error

Thats great Rick works perfect Thanks !--- cfset linenumber = right(linenumber + vvalue2,1) --- + is mathematical addition. I'm guessing that you're trying to do string concatenation, and need to use instead. cfset linenumber = right(linenumber vvalue2,1) Rick

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

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? cfif len(i) gte 6 !--- Temp value of

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))

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

Re: Users access to a listbox

/cfif /cfloop *** 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: cfif listfind(FORM.COMPANY_NUMBER, COMPANY_NUMBER) option /cfif On Wed, Sep 30, 2009 at 4:49 AM, Damo Drumm damien.dr...@quinn

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

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

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

Re: Using a Listbox to allow Users Access

Session.CompanyAccess.Permissions_3 = C,R,U (CRUD = Create, Read, Update, Delete) On Mon, Sep 28, 2009 at 6:01 AM, Damo Drumm damien.dr...@quinn-group.comwrote: ~| Want to reach the ColdFusion community with something they want? Let them know

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.

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: cfquery name=qgetcreditnotetemplate datasource=#request.dsn#

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

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? tr td valign=topEmail Text :/td tdtextarea name=body rows=10 cols=85 maxlength=500/textarea/td /tr Thanks

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

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

Re: stop cursor typing past 500 characters

Hi Marcus I notice now its actually a textarea name rather than a text box if that makes a difference heres my line of code: td valign=topEmail Text :/td tdtextarea name=body rows=10 maxlength=10 cols=85/textarea/td only problem is maxlength doesnt seem to be doing anything, am i putting it in

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 Drummdamien.dr...@quinn-group. com wrote: I’m trying to move the

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 /cfloop cffile

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 /cfloop cffile

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 /cfloop cffile

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

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

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

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