Inline IF? IIF() :)
IIF(expression, true_expr, false_expr)
Check the lang. ref. for more detail.
-Original Message-
From: Stevens, Jason [mailto:[EMAIL PROTECTED]]
Sent: May 16, 2001 23:42
To: CF-Talk
Subject: Imbedding IF statements into a tag...
Is it possible to imbed IF statem
Is it possible to imbed IF statements into a tag? For example, you have the
following statement:
Of course, when the session variable session.Form.CCEmail doesn't exist, it
error's off. Would there be a way to imbed an if statement that would only
add the cc section of the cfmail tag if the var
* Team Allaire *
>
> SELECT colum1,colum2
> CONTAINS .
> AND.
> WHERE
>
SELECT colum1,colum2
WHERE CONTAINS(*,'wheat beer') AND temperature=#justRight#
* Team Allaire *
> I haven't decided yet on which SQL version to use : 7 or 2000 (any major
> diffrence?,
> because money is an issue...)
sql server 2000's full text has quite a few nice improvements. we can't even
buy new sql server 7 here.
What does this error message mean? I'm using an access database as an
interim measure with this project. The CFQUERY mentioned hasn't got
anything special in it .. this page is copied from another site that works
fine with identical setup - only the data itself is different. So I don't
think i
I'm currently re-query-ing Simple Message Board to work with Oracle. Not
entirely difficult.
> Once again on the subject of Forums, I noticed that allaire forums are not
> compatible with oracle. Does anyone know of any Oracle friendly forums
> that are already developed that are for sale. My
You might not have to live with it. If you use CFHTMLHEAD to write the correct
function, it will be used in lieu of the CF-generated function since it will
follow (and hence overwrite) the CF-generated one.
Not pretty, but it works.
-David
On Wednesday, May 16, 2001 3:49 PM, Jann VanOver
[S
Here is some Javascript that I use
Include this javascript in the form and
then use validate="checkInteger" instead of validate="integer" in your
tag
//Returns true if value is a number or is NULL
//otherwise returns false
function checkInteger(object_value) {
if (object_value.length == 0)
Here is an experment that did and it works for IE, someone on the list may
have the equivilent for NS.
Here are the docs for all the char codes.
http://msdn.microsoft.com/workshop/author/dhtml/reference/charsets/charset1.
asp
Basicaly I just added an event to the input tag after it was loaded and
Fusetalk
http://www.fusetalk.com
### FROM http://www.e-zonemedia.com/fusetalk/mainfeat.cfm
FuseTalk currently supports four database platforms: Microsoft SQL Server
7/2000, MySQL, Oracle, and Microsoft Access.
###
-Original Message-
From: Ray Bujarski [mailto:[EMAIL PROTECTED]]
Sent: W
just was curious if there are any issues with it, i have run into it before
=) its saying the varialbe is not there EVEN though its typed into the page
and hits the INDEX.CFM (fusebox style)
but this is not a fusebox questions (thats why its on Cf-talk) its a basic
is there anything special you ha
Once again on the subject of Forums, I noticed that allaire forums are not
compatible with oracle. Does anyone know of any Oracle friendly forums
that are already developed that are for sale. My company would be very
interested in purchasing one as opposed to rebuilding a wheel.
Ray
At 03:21
If you want to use CFINPUT, you have to live with it.
I found early on that I couldn't count on the CFFORM javascript and write
all my own Javascript validation code. You can find many examples on the
net, like http://irt.org
-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL PR
FUSETALK!
Awesome forum software :)
If you got the bucks, its the best money can buy.
www.fusetalk.com
-Gel
-Original Message-
From: Paul Smith [mailto:[EMAIL PROTECTED]]
On the subject of Forums, what Forum software is being used at
http://forums.allaire.com ?
best, paul
Instead of opening a new window, why don't you use an onUnload or
onBeforeUnload event in the body tag to close the session? This script from
MSDN worked in IE5.5 for me and supposedly it works in IE4+.
function closeIt()
{
// enter your close session script here
event.returnValue =
Matt,
Can I correct this js problem, or do I have to live with it?
Michael
- Original Message -
From: "Jones, Matt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 4:58 PM
Subject: RE: CFINPUT -- not validating Integer
> There is an error in the java
Thanks...that is exactly what I was looking for!!
Julie
>From: Jann VanOver <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: manipulating DatePart Function???
>Date: Wed, 16 May 2001 15:09:14 -0700
>
>You can do this ALL with one function:
On the subject of Forums, what Forum software is being used at
http://forums.allaire.com ?
best, paul
At 02:20 PM 5/16/01 -0400, you wrote:
>Just to give you an example. I built a real estate site for someone. After
>the main site was built he mentioned that for every neighborhood that an
>agen
> You're using CreateODBCTime() where you should be using
CreateODBCDateTime():
>
>
>
>
> Your current code will only return the time part for comparison, not the
actualy date associated with the time.
Brill - cheers Andy.
Will
~~
Structure yo
You can do this ALL with one function:
timeFormat(BeginTime,"h mm")
The lower case h tells it to use 12 hr clock (use upper case for 24 hr)
(Note you don't have to say "QRYCasacActivity.BeginTime" because you are
inside a CFOUTPUT with query = QRYCasacActivity)
-Original Message-
Fro
Hello,
Does anyone know how I can make the following code workI am trying to
use the DatePart Function to parse out the hour and minute from a date/time
field. however I am getting the hour in military time. To get around this
I thought I would subtract 12 from any hour 13 and over...bel
There is an error in the javascript created by cfform
This is the function
function _CF_checkinteger(object_value)
{
//Returns true if value is a number or is NULL
//otherwise returns false
if (object_value.length == 0)
return true;
//Returns true if value is an i
Yes - "General Date."
Any other ideas?
- Original Message -
From: "Alex" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May 16, 2001 10:44 PM
Subject: Re: [Re: [Using 'Between' sql for Times/Dates]]
> is logdate a date/time datatype?
>
> "W Luke" <[EMAIL PROTEC
Hey, you could just use www.logiforms.com to create your survey.
At 02:17 PM 16/05/01 -0700, you wrote:
>Bill, please post the code that threw the error. Let's see
>qry_postcompanysurvey.cfm
>
>We're not psychic! ;-)
>
>-Original Message-
>From: William J Wheatley [mailto:[EMAIL PROTE
Howdy,
I am trying to get the CFINPUT Tag to validate an integer on a form. The darn tag
will validate SSN, zipcodes, etc, but when I enter the integer parameter and test the
validation using the following value ( .3 or any value that starts with a decimal
point ) the javascript validation fa
Does your tag look like this
or like this
the latter would fail as it is missing the attributes prefix. Just a stab
in the dark.
Brook
At 05:04 PM 16/05/01 -0400, you wrote:
>Ok heres the issue, i am sending out an HTML Form via email that is supposed
>to post back to our server.
>
>and
Bill, please post the code that threw the error. Let's see
qry_postcompanysurvey.cfm
We're not psychic! ;-)
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 2:05 PM
To: CF-Talk
Subject: Email Forms
Ok heres the issue, i am sending o
Ok heres the issue, i am sending out an HTML Form via email that is supposed
to post back to our server.
and i'm sure its something simple, but it gives this
An error occurred while evaluating the expression:
#attributes.companyname#
Error near line 5, column 10.
---
Encrypted with server? The only real way of encrypting server side is
using the decrypt() or cfusion_decrypt() functions ... This requires you
to know your key string. However, I think you're referring to .cfm
files encrypted with Studio. There's no "official" way to do it, unless
you contact A
Thanks. My guess was memory, tho the Linux box says the resources
are fine. Oh well.
J
"Joel Firestone" <[EMAIL PROTECTED]> wrote in message
3b028d3f$[EMAIL PROTECTED]">news:3b028d3f$[EMAIL PROTECTED]...
> Everyone:
>
> We have an application that uses session vars to track if the user is
> logg
Sure, just use the Mod function to determine if you are the second column.
See code example below:
SELECT ID
FROMtblDLO
#ID#
ya i just ignore it. as long as my pages dont get screwed i dont care!
Alexander Sicular
Chief Technology Architect
The Neurological Institute of New York
Columbia University
212.305.1318
as867 {at} columbia [dot] edu
> -Original Message-
> From: Jeff Green [mailto:[EMAIL PROTECTED]]
>
What version of Studio do you have?
I bet if you check out the Knowledge Base at Allaire.com, and search for the
error you are receiving you'll find a fix.
Some versions of Studio need patches, which can be download from Allaire.com
(and found through the Knowledge Base).
H.
Howard Owens
Inte
Na, don't give up control to CFTable -- you CAN do this, it is just a bit
trickier.
The following code will start a row for odd-numbered entries and close the
row after even numbered entries. Take a look:
http://#linkSiteURL#"; target="_blank">
#linkSiteName#
Hi everyone.
Basically, I have a record set that returns a whole bunch of links, and
spits them out one to a table row, like so:
http://#linkSiteURL#"; target="_blank">
#linkSiteName#
Would it be possible to set it up to display the links side by side,
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Ray Bujarski <[EMAIL PROTECTED]> wrote:
If I want to decrypt a file that was encrypted with cf server, how would I
go about doing this?
Ray
~~
Structure your ColdFusion code with Fus
Does anyone else get an error upon closing cfstudio?
How do I fix it? :)
TIA,
jeff
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk
is logdate a date/time datatype?
"W Luke" <[EMAIL PROTECTED]> wrote:
That just pulled all the record, irrespective of time...I get the logic, but
not why it isn't working.
Hmmm.
- Original Message -
From: "Alex" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May
Does anybody have a reference of what database systems support SQL functions
like this?
Thanks in advance
Nathan Nelson
Cold Fusion Developer
..::[CFDynamics]::.
www.cfdynamics.com
[EMAIL PROTECTED]
(801)621-8511
* * You've got to check this out! * *
CFDCalendar http://demo.cfdynamics.com/cfdca
> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 1:34 PM
> To: CF-Talk
> Subject: Using 'Between' sql for Times/Dates
>
>
> Hi,
>
> I have a list of dates and times, in a field called logDate, which are
> constantly updated. I need to pull
Just to give you an example. I built a real estate site for someone. After
the main site was built he mentioned that for every neighborhood that an
agent
signs up for he wanted a discussion forum *sigh* so we already owned CF
Forum 2000
open source. I simply modified the source to create a new for
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:34 PM
To: CF-Talk
Subject: Using 'Between' sql for Times/Dates
Hi,
I have a list of dates and times, in a field called logDate, which are
constantly updated. I need to pull the last 2 hours wor
If I want to decrypt a file that was encrypted with cf server, how would I
go about doing this?
Ray
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-arch
UGHH
And I thought I wouldn't have to see HL7 data any more!
I too worked on a project, interfacing LabCorp (through DIALUP, for goodness sake)
with our server, parsing the HL7 files and then inserting data based on our client's
data model into the database.
I wrote a nifty parse routine that
Thanks to all for the help.
Shortly after I sent that message, the vendor sent me an e-mail ... "oh, you
know what, we do have a list of ASCII we use in the system. Here is is." So
that solved my problem. There was actually a pesky little "leader" ASCII
code that was causing me the most proble
Looking back at your question you may be better served by
"GetCurrentTemplatePath()" and "GetFileFromPath"
BTW The trick works with form, session and url variables as well
Massimo
"Justin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]...
> Hey, nice trick.
~~~
check www.andamooka.org
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 6:51 AM
To: CF-Talk
Subject: RE: Article Discussion ready solution
SIMPLEMESSAGEBOARD! :)
-Gel
-Original Message-
From: Fouad Al-Farhan [mailto:[EMAIL PROTECTE
That just pulled all the record, irrespective of time...I get the logic, but
not why it isn't working.
Hmmm.
- Original Message -
From: "Alex" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May 16, 2001 6:52 PM
Subject: Re: [Using 'Between' sql for Times/Dates]
Sorry for the long reply lag everybody, I didn't put a URL in on purpose
because there isn't one yet. The site which hosts the product and
purchasing info for the aforementioned e-commerce application is relocating
due to traffic volume and will temporarily be unavailable. The process
should onl
try...
where logdate > (now() - 2hours)
"W Luke" <[EMAIL PROTECTED]> wrote:
Hi,
I have a list of dates and times, in a field called logDate, which are
constantly updated. I need to pull the last 2 hours worth of rows that have
been added. I think there's a specific part of time-handling that I
Well, I don't know how dynamic you're trying to be with this, but I figure
it's probably good to start simple. It could get trimmed down, but more
complicated with arrays. But for a quick and easy to figure out
solution... you might want to try this...