#\@conv_#dateformat(dateadd(d,-1,now()),'dd-mm-')#.txt
cfif FileExists(#fname#)
(the above will check for the file and find it)
then i need to copy the file to the cf server and work with it, that's
were you lost me.
cfelse
not found
/cfif
ok, so then how would I
SELECT proxloc from MainServer
/cfquery
cfset
fname=#param.proxloc#\@conv_#dateformat(dateadd(d,-1,now()),'dd-mm-')#.txt
cfif FileExists(#fname#)
(the above will check for the file and find it)
then i need to copy the file to the cf server and work with it,
that's
will check for the file and find it)
then i need to copy the file to the cf server and work with it,
that's were you lost me.
cfelse
not found
/cfif
ok, so then how would I do the copy from w2k3 to cf9 server
You would use CFHTTP to grab the content from the other server
, handle it appropriately (ex. the file isn't there, etc).
Regards,
Michael L Gueterman
Integrated Information Systems, Inc.
--
-Original Message-
From: Russ Michaels r...@michaels.me.uk
To: cf-talk cf-talk@houseoffusion.com
Date: Tue, 1 Apr 2014 10:37:37 +0100
Subject: Re: how to check
thanks for the info
ok, so then how would I do the copy from w2k3 to cf9 server
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Using cffile?
Russ Michaels
www.michaels.me.uk
cfmldeveloper.com
cflive.net
cfsearch.com
On 31 Mar 2014 08:32, safo 2000 safokas...@hotmail.com wrote:
thanks for the info
ok, so then how would I do the copy from w2k3 to cf9 server
ok, so then how would I do the copy from w2k3 to cf9 server
You would use CFHTTP to grab the content from the other server, and then save
it as a file on your CF9 server.
Personally I would do a separate CF app, scheduled in the CF administrator,
that would periodically look for the file on
hi,
i have w2k3 server that holds a text file, say x.txt, generated by an VFP9
app., on a separate server i have a cf9 app. that needs to check for file x, if
it exists get a copy of it and merge it with another text file that is
generated by the app.
well, how can i do the checking part
#
If a 404 handler isn't there, then this would have worked.
On Sat, Mar 29, 2014 at 2:19 AM, safo 2000 safokas...@hotmail.com wrote:
hi,
i have w2k3 server that holds a text file, say x.txt, generated by an VFP9
app., on a separate server i have a cf9 app. that needs to check for file
x
You can use fileExists w/ a URL but unfortunately, if the server has a 404
handler than it will return true even when the 404 handler fires.
cfif fileExists(http://www.raymondcamden.com/index2332.cfm;)
yes
/cfif
cfhttp url=http://www.raymondcamden.com/index2332.cfm;
cfdump var=#cfhttp#
Oh good point there. So - ignoring my server where I don't have a proper
404 (grin), this should work for you:
cfhttp url=http://www.cnn.com/index2332.cfm;
cfif cfhttp.responseheader.status_code is 200
good
/cfif
On Sat, Mar 29, 2014 at 9:38 AM, Dave Watts dwa...@figleaf.com wrote:
You
Oh good point there. So - ignoring my server where I don't have a proper
404 (grin), this should work for you:
cfhttp url=http://www.cnn.com/index2332.cfm;
cfif cfhttp.responseheader.status_code is 200
good
/cfif
Your original point is perfectly valid, though - lots of people don't
return
CFX_ValidEmail, I'd look at performing an MX lookup on the domain
and then if you need to do an SMTP check, you'd have to implement a short
SMTP client that pretends to be sending an e-mail to the relevant server
and validates the inbound e-mail address against the mailboxes it looks
after.
In my POPCFC
To replace CFX_ValidEmail, I'd look at performing an MX lookup on the domain
Thanks for your feedback.
This is what I have implemented in my address validation function used by my
forms.
and then if you need to do an SMTP check, you'd have to implement a short
SMTP client that pretends
exists for a certain domain name would have
saved me 2 hours this morning!
Is someone aware of some tool that will check for a mail server from CF?
Thanks.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe
Is someone aware of some tool that will check for a mail server from CF?
I don't know that, it would be a nice feature... but I do know if you put
yourself as the failto address in CFMAIL that will give you a much easier way
to see failed mail then digging through the mail server. I
Is someone aware of some tool that will check for a mail server from CF?
There's a CFC that will look up MX records (among other things). You
could use that to see if there are corresponding MX records for a
given domain - it would not tell you whether there was actually a
server accepting
aware of some tool that will check for a mail server from CF?
Thanks.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http
You need to use nslookup
Yes, this is what I end up doing.
Here is a function that returns the name of the mail server id there is on, or
an empty string if there is not.
(tested on Windows)
CFFUNCTION NAME=nslookup
CFARGUMENT NAME=domain REQUIRED=yes TYPE=string
CFEXECUTE
...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=]
Sent: 10 October 2013 19:26
To: cf-talk
Subject: Check an email domain
Hi,
I just lost about 2 hours digging in my mail server logs to find why a user
did not get his message sent by CF
-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=]
Sent: 10 October 2013 21:38
To: cf-talk
Subject: Re: Check an email domain
You need to use nslookup
Yes, this is what I end up doing.
Here
Thanks, but the notice All our CFX tags and tools are for the Windows platform
only. makes me think this tag is written in C, not Java.
I am hesitating installing new tags on my server.
Although I have a 64bit server, I had to install the 32 bit version of CF
because of some heritage CFXs, and
, there isn't really a reliable way to check if a user
exists other than sending an email to that address and getting a
response. Mail servers can be configured to blackhole messages sent to
invalid addresses, for example.
http://stackoverflow.com/questions/3024819/how-do-i-check-if-an-email-address
Unfortunately, there isn't really a reliable way to check if a user
exists other than sending an email to that address and getting a
response.
Right, and I even add
and getting a response... from a user who knows that he has a spam folder
somewhere and who knows how to look in it.
But I'm
I use it to avoid duff mail addresses producing
spam triggers
Do you know that checking if a user exists without actually sending a message
can also tag you as a potential spammer?
~|
Order the Adobe Coldfusion Anthology
Hello
I am trying this simple json code
http://ja.mesbrown.com/2009/10/coldfusion-and-jquery-using-ajax-to-call-a-cfc-and-return-json/
and no matter where I put my CFC, I get the following message. Any thoughts?
ReferenceError: $ is not defined
$.getJSON(validate.cfc, {
I am trying this simple json code
http://ja.mesbrown.com/2009/10/coldfusion-and-jquery-using-ajax-to-call-a-cfc-and-return-json/
and no matter where I put my CFC, I get the following message. Any thoughts?
ReferenceError: $ is not defined
$.getJSON(validate.cfc, {
That's a
That seems to indicate that jQuery isn't loaded, or perhaps you have
another js library that is in conflict with jQuery.
On Wed, Aug 28, 2013 at 12:55 PM, Torrent Girl moniqueb...@gmail.comwrote:
Hello
I am trying this simple json code
Hi Monique,
you need to make sure that you are definately loading JQUERY, otherwise
the $ function wont exist.
On Wed, Aug 28, 2013 at 5:55 PM, Torrent Girl moniqueb...@gmail.com wrote:
Hello
I am trying this simple json code
There anyone that can assist me in this?
I've been trying for some time trying to get various examples that
I've found online how to do this, but none seem to do any checking
after I leave the input field that contains the username to be checked.
I'll first post the link to my work in
check on the server side, after
they submit the form, because javascript can be pretty easily bypassed, or
errors like this can cause it to not validate on the client side.
Another thing, you've written a lot of jQuery to be hardcoding an onChange
event on your html input element. You can
I've been trying for some time trying to get various examples that I've found
online how to do this, but none seem to do any checking after I leave the input
field that contains the username to be checked. I'll first post the link to my
work in progress and then post my code to my .cfm and
LinkedIn
Find out why I use LinkedIn. Stay in touch and build your professional network.
- William
William Hartley
President at Wilco Technology of the Treasure Coast, Inc.
Fort Pierce, Florida Area
Confirm that you know William Hartley:
Find out why I use LinkedIn.
Who cares? ;-)
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
...@boldacious.comwrote:
Is there any to check the validity of a zip file with cfzip. I can't see
anything in the docs.
The only way I could see was to do a cftry, but that seemed cumbersome.
My problem is that I receive a zipped file from an external source, so
need to be able to verify that it is a valid zip
OK - thanks for that.
There's no way to check validity with CFZIP other than by unzipping
the file, which really is the only way to really ensure that the file
can be unzipped anyway. You can use Java to directly check for the
magic number that zip files contain in their first four bytes
Is there any to check the validity of a zip file with cfzip. I can't see
anything in the docs.
The only way I could see was to do a cftry, but that seemed cumbersome.
My problem is that I receive a zipped file from an external source, so need
to be able to verify that it is a valid zip
Is there any to check the validity of a zip file with cfzip. I can't see
anything in the docs.
The only way I could see was to do a cftry, but that seemed cumbersome.
My problem is that I receive a zipped file from an external source, so need to
be able to verify that it is a valid zip file
Does anyone know a means to implement Spell Check functionality into the
CFTEXTAREAs toolbar?
I don't think CFMX 9 has a SpellCheck engine so I have to find an
alternative.
~|
Order the Adobe Coldfusion Anthology now!
http
you will probably need to use TinyMCE or CKeditor instead
On Wed, Oct 3, 2012 at 6:40 PM, ColdFusion Developer cfdev2...@gmail.comwrote:
Does anyone know a means to implement Spell Check functionality into the
CFTEXTAREAs toolbar?
I don't think CFMX 9 has a SpellCheck engine so I have
I don't think CFMX 9 has a SpellCheck engine
You may need to add it to the toolbar:
http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7a01.html
-Leigh
~|
Order the Adobe Coldfusion
Never mind. I just checked and think you are about the engine itself.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
to implement Spell Check functionality into the
CFTEXTAREAs toolbar?
I don't think CFMX 9 has a SpellCheck engine so I have to find an
alternative.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe
On 10/3/2012 1:40 PM, ColdFusion Developer wrote:
Does anyone know a means to implement Spell Check functionality into the
CFTEXTAREAs toolbar?
I don't think CFMX 9 has a SpellCheck engine so I have to find an
alternative
Hello all,
I would like to check a string against a list of keywords and either null the
string or replace the keywords if found.
Over the past couple of weeks someone has been probing my sites for SQL
injection vulnerabilities. I have used queryparams and other types of
validation. but I
Regular expressions.
if ( reFindNoCase((select|declare),myString) 0 )
{
// at least one of the words is present
}
HTH
On Tue, Oct 11, 2011 at 9:11 AM, Brian Cain bcc9...@gmail.com wrote:
Hello all,
I would like to check a string against a list of keywords and either null
AM, Matt Quackenbush quackfu...@gmail.com wrote:
Regular expressions.
if ( reFindNoCase((select|declare),myString) 0 )
{
// at least one of the words is present
}
HTH
On Tue, Oct 11, 2011 at 9:11 AM, Brian Cain bcc9...@gmail.com wrote:
Hello all,
I would like to check a string
Wouldn't this also catch words like 'myselection'?
Brook
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: October-11-11 7:16 AM
To: cf-talk
Subject: Re: Check for list of words in string
Regular expressions.
if ( reFindNoCase((select|declare),myString
For my specific implementation, I decided to use a combination approach.
Remembering this is an attempt to mitigate SQL injection exploits, I check
for select or declare in the query string. I realized forms posed a
slightly different problem, as I have many user posting long text data
Wouldn't this also catch words like 'myselection'?
Yes. \b is your friend. :)
Or possibly even stuff like (?=^|;)\s*(?:SELECT|DECLARE|EXEC|etc)\b to
ensure this is stuff at a beginning of a string/statement.
But I don't really agree with the general approach here.
With cfqueryparam +
I think this would be easy but seems not. We have a main site at
www.oursite.com and then we have 2 subdomains. We'll call them:
second.oursite.com and third.oursite.com.
A person visits our main site at www.oursite.com and we set these two cookies:
cfcookie name=TestWWW
Hello All,
I think this would be easy but seems not. We have a main site at
www.oursite.com and then we have 2 subdomains. We'll call them:
second.oursite.com and third.oursite.com.
A person visits our main site at www.oursite.com and we set these two cookies:
cfcookie name=TestWWW
Short of attempting toBinary() in a try/catch, does any one know how to
check if a string is base64 encoded?
Brook
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp
() in a try/catch, does any one know how to
check if a string is base64 encoded?
Brook
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive
To: cf-talk
Subject: Re: check for a base64 encoded string
Why not just make the attempting toBinary() in a try/catch logic into a
function?
http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172
e0811cbec22c24-7ff3.html
On Fri, Apr 22, 2011 at 9:25 AM, Brook Davies cft
Reason being that throwing exceptions are expensive and also an ugly way of
programming an evaluation. IMHO..
Throwing exceptions isn't especially expensive, compared to whatever
conditional logic they might otherwise replace. The ugliness thing is
more a matter of the eye of the beholder, but
Right...and, if you make it into a function, the aesthetic problem gets
hidden and your code reads:
isbase64()
On Fri, Apr 22, 2011 at 11:36 AM, Dave Watts dwa...@figleaf.com wrote:
Reason being that throwing exceptions are expensive and also an ugly way
of
programming an evaluation.
: Re: check for a base64 encoded string
Reason being that throwing exceptions are expensive and also an ugly
way of programming an evaluation. IMHO..
Throwing exceptions isn't especially expensive, compared to whatever
conditional logic they might otherwise replace. The ugliness thing is more
: April-22-11 9:37 AM
To: cf-talk
Subject: Re: check for a base64 encoded string
Reason being that throwing exceptions are expensive and also an ugly
way of programming an evaluation. IMHO..
Throwing exceptions isn't especially expensive, compared to whatever
conditional logic they might
:37 AM
To: cf-talk
Subject: Re: check for a base64 encoded string
Reason being that throwing exceptions are expensive and also an ugly
way of programming an evaluation. IMHO..
Throwing exceptions isn't especially expensive, compared to whatever
conditional logic they might otherwise replace
Hello all --
I have a form that contains checkboxes which sends multiple record numbers to
an action form for processing. For example, it would send:
formfield1=ABC
formfield2=1,2,3,4,5,6,7
In the database I want to update the formfield1 column to ABC wherever the
formfield2 column value is
update tablename
set formfield1 = cfqueryparam value=#form.formfield1#
cfsqltype=cf_sql_varchar
where formfield2 in cfqueryparam value=#form.formfield2#
cfsqltype=cf_sql_integer list=true
On Fri, Mar 4, 2011 at 11:01 AM, Scott Williams
myscottwilli...@yahoo.comwrote:
Hello all --
I have a
Are you doing the update via a SQL statement or stored proc?
On Fri, Mar 4, 2011 at 11:01 AM, Scott Williams
myscottwilli...@yahoo.comwrote:
Hello all --
I have a form that contains checkboxes which sends multiple record numbers
to
an action form for processing. For example, it would
Never mind -- I figured it out. This works:
cfquery name=query2 datasource=#dsn#
UPDATE aTable
SET ColumnA = '#form.var1#'
WHERE ColumnB IN (#form.var2#)
/cfquery
I had tried using IN in my update query except that I didn't include the
parentheses.
Scott
That is exactly what I was going to suggest. Good job.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Be sure to add cfqueryparam / to your query. If you want to know why,
post a link to your live site, and we can show you. :-)
~|
Order the Adobe Coldfusion Anthology now!
lol
On 3/4/2011 12:26 PM, Matt Quackenbush wrote:
Be sure to addcfqueryparam / to your query. If you want to know why,
post a link to your live site, and we can show you. :-)
~|
Order the Adobe Coldfusion Anthology
SET ColumnA = '#form.var1#'
WHERE ColumnB IN (#form.var2#)
How ever, make sure you check for form.var2 not being empty, because ColumnB IN
() causes an error.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com
Ok... so I'm starting to set down an approach
based on all the feedback to this point.
How about this, as far as domain/directory setup goes:
Main Parent Site
Directory Structure for main parent site:
e:\inetpub\webroot\mobile
Domain for parent site:
mobile.xyz.com
Client
Any suggestions on a decent spell check engine? (Preferably one that
works for both English and Spanish.) Need one that runs entirely on
the server in a closed environment, or at the least has the server
making the API calls, not the client. Any ideas?
-Justin
Jspell and ASpell is pretty popular/common spell check plugin.
or take a look at http://www.spellchecker.net/
http://www.spellchecker.net/
On Mon, Jan 31, 2011 at 8:09 PM, Justin Scott leviat...@darktech.orgwrote:
Any suggestions on a decent spell check engine? (Preferably one that
works
We use Jspell as well. I am happy with it over all. However, we needed to
have it check individual fields one at a time which the version we purchased
did not do out of the box. I remember it being a *bear* to get it to work in
that manner. I don't know if that is one of your requirements but I
Hello everyone.
I am new to coldfusion. Please help.
In table1, I have something like:
WKIDName
1002High School
In table2, I have something like:
WKTitleApproval
1002 Math Teacher Yes/No
1002 Scienct Teacher Yes/No
problem is if I only check one checkbox, but in table2, every checkbox is
checked (yes) and saved. How do I know which one is checked? if so only checked
box is saved in table2.
I see something like this:
cfloop from = 1 to=somethin here index = i
.
/cfloop
But I do not the detail
Hello All.
I'm pretty sure that this is something very simple and I am over thinking it
but here is my issue:
I have a form with dynamically created input boxes one of which can be a
checkbox.
When the user submits the form, of course the checkbox field is submited as
one, but with 2 values
You're just going to have to write some logic to loop over the values that
are a list.
On Fri, Nov 12, 2010 at 3:59 PM, Monique Boea moniqueb...@gmail.com wrote:
Hello All.
I'm pretty sure that this is something very simple and I am over thinking
it
but here is my issue:
I have a form
use listgetat(form.checkboxa,1, ) and listgetat(form.checkboxa,2,
) and keep them as one value in the value field in the checkbox
input value=4454 16829 type=checkbox
~|
Order the Adobe Coldfusion Anthology now!
Form Utilities CFC would work nicely for that sort of thing.
http://formutils.riaforge.org/
http://www.briankotek.com/blog/index.cfm/2007/9/4/Implicit-Creation-of-Arrays-and-Structures-from-Form-Fields
On Fri, Nov 12, 2010 at 3:59 PM, Monique Boea moniqueb...@gmail.com wrote:
Hello All.
Three fun pieces of code I found today while doing some maintenance on
code I did not write:
#1 - here's what happens when you use varchar fields for numeric data!
SELECT SUM(CAST(FLOOR(CAST(OI.ItemQuantity AS float)) AS int) *
round(CAST(OI.ItemPrice AS float),2) * ((100-CAST(OI.ItemDiscount
Just goes to showpeople will make things work no matter how
convoluted the code may become ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: br...@electricedgesystems.com
web:
I'm glad you posted this today, I just found this one a few minutes ago:
#Year(DateAdd(, 1, Now()))-1#
Thanks,
Eric Cobb
ECAR Technologies, LLC
http://www.ecartech.com
http://www.cfgears.com
Rick Root wrote:
Three fun pieces of code I found today while doing some maintenance on
code
You're right. The correct version should be:
#Year(DateAdd(, 0, Now()))#
No need for the -1.
andy
-Original Message-
From: Eric Cobb [mailto:cft...@ecartech.com]
Sent: Tuesday, August 31, 2010 4:13 PM
To: cf-talk
Subject: Re: Check out this... code
I'm glad you posted
Must be going through some of my old code...
:)
I find some shtuff in my own code all the time.
Rick
-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: Tuesday, August 31, 2010 4:25 PM
To: cf-talk
Subject: RE: Check out this... code
You're right
...@ecartech.com]
Sent: Tuesday, August 31, 2010 4:13 PM
To: cf-talk
Subject: Re: Check out this... code
I'm glad you posted this today, I just found this one a few minutes ago:
#Year(DateAdd(, 1, Now()))-1#
Thanks,
Eric Cobb
ECAR Technologies, LLC
http://www.ecartech.com
Is there a way, in CF 8, to determine if the current request is calling
a CFC that has access=remote? Basically, I'd like to mimic CF 9's
onCFCRequest() method, but only for remote methods.
I spent a good portion of yesterday afternoon trying to figure out why
my jQuery AJAX call would work
specifically for detecting jquery ajax calls to remote cfc functions
you can use something like this:
cfset headers = getHttpRequestData().headers
cfif structKeyExists(headers, X-Requested-With) AND
headers[X-Requested-With] eq XMLHttpRequest
it's an ajax request using jquery!
/cfif
more
Just to be clear - checking the header works when the library used for
calls uses it. It's not 100% correct (but speaking practically, it is
safe).
On Tue, Jun 15, 2010 at 10:23 AM, Azadi Saryev azadi.sar...@gmail.com wrote:
specifically for detecting jquery ajax calls to remote cfc functions
I am having a problem with using a jquery function that allows me to check all
boxes in a dynamically created page. no matter how I try it it always throws
and error at me and then the check all function just doesnt work. I know the
check all function works because I have tried it on its own
I would move the javascript outside the cfdiv. It should work then.
--
Kumar Shah
http://www.coldfusion-ria.com/Blog/
On Tue, Dec 15, 2009 at 11:49 AM, Brady Ashworth
bra...@constructionmonitor.com wrote:
I am having a problem with using a jquery function that allows me to check
all
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
Showing code would be a good first step...
On Tue, Dec 8, 2009 at 6:27 AM, Damo Drumm damien.dr...@quinn-group.comwrote:
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
On Tue, Dec 8, 2009 at 9:27 AM, Damo Drumm damien.dr...@quinn-group.comwrote:
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
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
cfquery name=qgetinvoices datasource=#request.dsn#
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 =
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
On Tue, Dec 8, 2009 at 10:35 AM, Damo Drumm damien.dr...@quinn-group.comwrote:
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#
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
On Tue, Dec 8, 2009 at 11:53 AM, Damo Drumm damien.dr...@quinn-group.comwrote:
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
If that is the case then the query
I am trying to checked that a specific number is entered into a form
field. I am able stop the form from executing, but can't get the form to
submit with the correct number. Any guidance would be appreciated.
cfif IsDefined(form.num) AND form.num NEQ AND
IsNumeric(form.num) EQ 4
cfelse
isNumeric(form.num) will always evaluate to 0 (and not 4). It's a literal
string (by virtue of the fact that it's enclosed in quotes). So this
condition will never be true.
What you want is isNumeric(form.num). Which will return true or false. So
when you say isNumeric(form.num) eq 4... I'm
1 - 100 of 1124 matches
Mail list logo