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:#Ema
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:#Ema
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:#Ema
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:3
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 someth
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 d
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
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 prin
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
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 somethin
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#
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 :
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
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
> > 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
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:
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
~~
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
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
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 th
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 ov
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
~~~
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 m
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
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 some
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
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)
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?
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
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
UE 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 commu
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 dis
,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:
>
>>
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
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.Invoic
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]
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 k
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 c
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 c
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
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
t
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 co
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
~
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
~
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
~
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...@q
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...@q
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
Th
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
Th
49 matches
Mail list logo