I haven't done much with CF 5.0, but I do know the CF Server can't
change
the way the browser displays static HTML...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
This will do it once...
body onload=window.focus()
..but as for always on top you would have to put window.focus() in
a JS
function that calls itself every second or so. This could be bad if
the
page contains a form...
+---+
Bryan Love
the ONLY way to capture an email address is by having the use type it
in...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
I agree. It simply can't be beat when it comes to speed and usability!
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may
have
peace'...
- Thomas Paine
make a link you have to put #Client.URLToken# at
the end of it.
using the client scope will work ONLY IF client variables are not being
stored in cookies.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database
createODBCdateTime(dateVal) is correct...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my
If you want to display all the banners just leave out the MAXROWS=1
and
each time the banners are displayed the top one will be moved to the
end and
the others will be bumped up one.
+---+
Bryan Love
Macromedia Certified Professional
Internet
the rows in a different order every time.
Be careful that #x# is some number between the min banner_ID and max
banner_ID or the order will never change.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database
how do you know it's not setting?
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must
#
UPDATE Events
SET Level = Level + 1
WHERE EventID IN (#approvedList#)
/CFQUERY
/cfif
+---+
Bryan Love
Macromedia Certified Professional
Internet
repeated calls to the db.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble
)
the column name used with IN should be indexed. If it's a primary key (like
EventID) then it is already indexed.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
level is a reserved word in Oracle, but I didn't know it was in Access or
SQL Server...
Good catch!
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
Have you seen SQLGen? It's a cool program that does just what you're
talking about.
http://aloha-webdesign.com/
click the SQLgen 2.0 Release link
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may
have
peace
is longer then any extra entries will be ignored.
Also, don't forget that replaceList() is case sensitive!
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may
have
peace
SELECT format(thedate,'d') AS e, count(*) AS ec
from products
Group by format(thedate,'d')
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL
put this in application.cfm...
cfparam name=client.lasActionTime default=#now()#
cfif dateDiff(m,client.lastActionTime,now()) GT 60
session has expired
/cfif
cfset client.lastActionTime = now()
+---+
Bryan Love
Macromedia Certified
replace
strSQLwhere
with
preserveSingleQuotes(strSQLwhere)
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
. and .. as the first two
records and you don't want to mess with these).
The backslash (\) only works in Windows while the forslash (/) works on
Windows and UNIX.
*** I am not responsible for any misuse of this tag! ***
+---+
Bryan Love
Macromedia Certified
FROM apps
WHERE IsOnline = 0
GROUP BY ALL DeptName
ORDER BY DeptName, isOnline
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
(from 2 to recordcount
step
2).
Anyway, don't use CF to do what the DB does best...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
/cfoutput
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace
SELECT so.name, sc.name
FROM sysobjects so, syscolumns sc
WHERE so.type = 'U' AND so.ID = sc.ID
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
you can get a comma delimited list of the
query columns with this variable: #myQuery.columnList#
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
uncheck the MAINTAIN DATABASE CONNECTION checkbox in the
CFAdministrator and
the lock will be released after the Excel file is read.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
loop will only list each book once while the inner loop will
iterate over the book's authors
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
() and
FILEEXISTS()
functions?
Any help would be appreciated :)
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may
have
peace
theForm.Contract_Amount.disabled = false;
}
the rest is pretty obvious...
select name=whatever onChange=txtDisable( this.form );
option
/select
input type=text
+---+
Bryan Love
Macromedia Certified Professional
Internet Application
Best guess:
I'll bet that the lock is read first, then the variables are resolved,
then
the lock is released, then everything else happens (the cflocation
would
happen after the lock is released).
+---+
Bryan Love
Macromedia Certified Professional
two
state drop-downs - one for shipping address and one for billing
address.
You would definitely want to use a CFSELECT (or re-think your gui...)
because if you don't you'll end up with an app that won't scale.
+---+
Bryan Love
Macromedia Certified
when you write
the
queries!
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble
if you are using SQL Server, use SMALLDATETIME
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
Yup. 800x600
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let
of the
two
layers to swap places.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may
have
peace
--
// convert to military time
cfset form.hour = form.hour + form.timeOffset
.. do whatever else you need to ...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
are the username/password combos the same for each one?
Just a thought. We run Oracle and I've run into the same problem and
every
now and then I have to disable a datasource in the CF Admin to free up
a
usable connection.
+---+
Bryan Love
00:00 AM is midnight - the very beginning of a new day.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
no need to initiate a loop.
This is much faster...
WHERE item IN ('#replace(listVar,,,',',all)#')
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
use CFHTTP METHOD=post. on your CF page to post the form vars to the
ASP page
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
preserveSingleQuotes()
prevents CF from escaping single quotes
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
CFQUERY NAME=getZip DATASOURCE=sometestdb
Select *
From tblZip
Where ZIP in ('#replace(ziplist,,,',',all)#');
/CFQUERY
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
then
'qdata[form.toplevel]' would simply return a pointer to an array - which can
be passed around (passed to your UDF), but never output.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication
to a different struct then
serializes them. It makes no difference how many pages or how many form
fields you have. At any given time on any given page you will have access
to all the form variables through the POO struct (poo.field1, poo.field2)
+---+
Bryan
check the server log.
It's available through the CFAdmin or you can just go into the logs folder
and open it.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
me too, except that the query has 3 rows and the text file has 4...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
= replace(string,,amp,all)
This ensures that you will never have 'amp;amp;' in your string.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
I'll venture a gues...
put this in your GRIDUPDATE tag:
KEYONLY=Yes
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
,src=http)
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my
to no.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine
actually I believe it's HTMLEditFormat()
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED
the results for verification ---
cfloop from=1 to=#arrayLen(ta[i][j])# index=k
#ta[i][j][k]#br
/cfloopbr
/cfloop
/cfloop
/cfoutput
+---+
Bryan Love
Macromedia Certified Professional
CFTRANSACTION
do this:
cftransaction
INSERT query
SELECT sequence.currVal query
/cftransaction
The transaction tags force both queries to run as a single transaction which
means it's not possible for any other inserts to happen between them - or
even at the same time.
+
You are correct in your understanding of client vars.
If you are using cookies to store client vars then keep in mind that cannot
use a CFLOCATION after a CFSET CLIENT statement. The following will
cause the client var not to be set:
cfset client.userID = 1
cflocation url=home.cfm
Also,
after doing the upload:
#file.serverFile# for the whole thing with extension
+
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
Actually CF may be multi-threaded but Access is not. If you have CF threads
set to three it makes no difference since any concurrent requests are queued
up by the Access driver.
+
~~
Structure your ColdFusion code with Fusebox. Get the official
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace
Why don't you check out NetReady. It blows AbleCommerce away. It's
fuseboxed and modular - very easy to modify. Also works with Oracle,
Access, and SQL 7...
Get details here if you want...
http://aloha-webdesign.com
+---+
Bryan Love
Macromedia
\wwwroot\mysite
then put your tags here:
c:\inetpub\wwwroot\customTags
put your include files here:
c:\inetpub\wwwroot\includeFiles
This way a tag cannot be called directly by the browser.
+---+
Bryan Love
Macromedia Certified
Actually lists are faster than arrays in CF. Create a list like so:
Last,First~Last2,First2~Last3,First3
use listSort() to sort it out
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
differences between the two.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble
.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+
...'If there must be trouble, let it be in my day, that my child may have
peace
It stands for Remote Development Server. Basically you can set up a machine
to be a remote development server and then connect to it with CF Studio.
The whole thing is similar in concept to a VPN connection.
Bryan Love Macromedia Certified Professional
Internet Application Developer
Sounds like database latency. If you haven't touched a certain db for a
while it may take a second or so to connect. It depends on how you have the
datasource set up. Is Maintain Connection checked in the CF Admin for
that datasource?
Bryan Love Macromedia Certified Professional
Internet
', and in NES it's an 'Additional Document Directory'.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
...'If there must be trouble, let it be in my day, that my child may have
peace
(tblDetailEntry.recorddate,'mm/dd/') = '#currentdate#'
instead of your current date comparison (it will strip off the timestamp).
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED
get what letter?
There are many string functions, I'm sure one of them will accomplish
whatever it is you need to do.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
...'If there must
Not really. In my tests it took about 3.5 times longer to run this
cfif fileExists()
than it did to run this:
cfif x IS 1
So you shouldn't worry about it. My mediocre machine will still run about 6
cfif fileExists() per millisecond.
Bryan Love Macromedia Certified Professional
Internet
You ran out of memory. You have 49k available and you need 53,798k. CFHTTP
wasn't intended to read anything that big...
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
...'If there must
wrap each number in a val() function. It forces numeric conversion
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
...'If there must be trouble, let it be in my day, that my child may have
in Win 2k
it's under the ADVANCED tab (instead of the environment tab).
Just a guess...
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What father would hesitate to say 'if there must be trouble
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace'?
- Thomas Paine, An American Crisis
- I would
recommend using the GROUP attribute from option 1 unless there are thousands
of rows.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What father would hesitate to say 'if there must
, CFINSERT is for people who are too lazy
to write out the column names ;)
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What father would hesitate to say 'if there must be trouble let it be in my
=dsp_footer.cfm
/cfcase
If you aren't fond of fusebox your form page might look like this:
cfif isdefined(form.submit)
cfinclude template=act_updateCategory.cfm
/cfif
!--- display form ---
form action=[submit to self]
Bryan Love Macromedia Certified Professional
Internet Application
Philip's got it. Remember when using switch statements in CFSCRIPT that
once a condition is met CF will execute EVERYTHING until it encounters the
end of the switch OR a break.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication
if you want to measure processing time of a page you can get the tickcount
with GetTickCount() at the beginning and at the end then subtract. Since it
is in milliseconds you just need to multiply by 1000 to get seconds.
Bryan Love Macromedia Certified Professional
Internet Application
try this:
select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join b on a.id = b.a_id
where b.g = #attributes.g# or b.id IS NULL
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED
request into its own memory space or
2. By internally recognizing and locking the data associated with the
request scope
Anyone? Anyone?
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What
() function that needs to be removed.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace
to_date() converts a string to a date type in Oracle. The mask specifies
the how Oracle should pick apart the string. If you use to_date() on a date
field it will err.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems
is actually
a struct pointer which is getting copied into the session.theForm variable)
then you can access the variables later like this
#session.theForm.fieldName#
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc
Best Guess:
you've likely missed an include somewhere
Solution:
rename the template that does use the variable in question then sit back and
wait for a TEMPLATE NOT FOUND error to pop up. Then you'll know where it's
being called from.
Bryan Love Macromedia Certified Professional
Internet
such as Fname, Lname, etc and you want to sort by Fname). In this case
you should probably be using an array of structs, but no matter. If you
need to sort then you should re-think the whole way this is structured.
Perhaps using nested lists...
Bryan Love Macromedia Certified Professional
. This
will result in an endless loop.
Good luck :)
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may
try the HTMLEditFormat() function
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace
It's doing the math. It thinks 10/18/2001 is 10 divided by 18 divided by
2001. Use single quotes.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
What father would hesitate to say
= StructInsert(foo,
ListFirst(Opts,:), ListLast(Opts,:))
/cfif
/cfloop
cfset temp = arrayAppend(aColOpts,foo)
/cfloop
/cfif
ps. if you always know that NAME and WIDTH will be the struct keys the
problem becomes much simpler
Bryan
BIT is the correct type to use for a boolean value, but you must think about
it first since BIT typed columns cannot be included in a GROUP BY clauses.
TINYINT is the one to use for boolean values if you need to group by a
column.
Bryan Love
CFCONTENT type= file= to display.
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL
on...
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 10:23 AM
To: CF-Talk
Subject
is easier to understand:
(#left(phone,3)#) #mid(phone,4,3)#-#right(phone,4)#
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message
cfloop collection=#attributes# item=i
#i# = #evaluate(attributes. i)#br
/cfloop
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED
301 - 400 of 558 matches
Mail list logo