Use the IsNumeric function to test for a number value, then perform your
MOD stuff
>Hopefully someone can shed some light on this. I've got a field where I'm
>looking for an integer. I then need to verify that this field is in an
>increment of 100:
>
>
> It's not an increment of 100!
>
>
. The usual cause is an error in the expression
>structure.
>
>-
>
>I have tried it with and without quotes.
>
>Todd
>
>- Original Message -
>From: "Alexander Lamon" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
&g
Instead of try using
Using Len is faster than using 'IS NOT ""' and I think you need to use
EVALUATE to test for an empty string in this case.
>I am trying to check for the existance of a dynamic Form.Field. The actual
>name of the form field is found by looping through a query and append
Check out Training Server from Syscom. It has a CF web interface going up
against your choice of SQL or Oracle. It's pretty pricey, tho.
>Does anyone know of an application that has already been developed in
>ColdFusion that can track employee training, schedule courses, etc.? I'm
>trying to
Sherry,
How 'bout converting both sides of the WHERE clause to all upper (or
lower) case? Might be simpler way of bypassing case-sensitivity e.g.
SELECT *
from aTable
where upper(proj_name) LIKE '%#UCase(projcontains)#%';
>
>SELECT *
>FROM pwcntrct
>
>...various other CFI
You can do it two ways:
1) Schedule a page to create the text file at a certain time interval and
then link to that file. (Only updated every so often.)
2) Have the user hit a page that runs a query and uses CFCONTENT based on
that query to download the file to the user. (Always the freshest v
To kill session vars upon browser close:
Just put it in your application.cfm file.
>Hi,
>
>there was a post to show how to kill the session variables when user close
>browser.
>I can not find it, does any one know how to kill the session variables when
>user close browser.
>The
Jeff,
Session and application variables and can be accessed using the Struct
functions. To see all of the session variables for an application, you
can do something like this:
#variable# = #StructFind(session, "#variable#")#
I use this kind of thing to see who's on a few of my site
Check the Allaire site. I think the Custom Tags and Applications contain
a couple of CF-based real estate apps.
Good luck.
>Howdy,
>
>A client wants to re-create a realtors.com-type app
>for a particular region. They want a site where
>realtors can enter real-estate information, and buyers
>c
Robert,
Are the primary keys you refer to below consecutive *and* contiguous? If
so, you can do something like this:
select article from someTable;
select article from someTable
where ID = #randomID#;
*However*, if you have gaps in the numbers like 1,2,3,7, this won't work
for obv
James,
Try the ListSort() function. You can sort alpha and numeric list values
in ascending or descending order before you run your output.
>Any way to order a list easily???
>
>Say I have a LIST and I want it alphabetized?
>
>I am looping thry the list and would like to have some contro ove
Joel,
It's definitely a locking issue. I'll bet there's an Access .ldb file in
the same directory as your database file when this happens. I ran into
this myself. Access started to lock my DB file all by itself. Turns out
that the database had grown beyond Access capabilities and I had to mo
12 matches
Mail list logo