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
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
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
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
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
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
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
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
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
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
. 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
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!
>
>
12 matches
Mail list logo