Check out the query functions: QueryNew(), QueryAddRow(), QuerySetCell()
along with CFFILE and a bit of looping and a liberal sprinkling of list
functions should do the trick.
Steve
> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]]
> Sent: 21 December 2001 15:08
> To: C
function startWaiting()
{
page.style.display='none';
waiting.style.display='block';
}
One should use parameterised SQL to get around that
For example:
Select *
>From MyTable
Where SomeField =
> -Original Message-
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: 19 December 2001 16:38
> To: CF-Talk
> Subject: Re: SQL Attacks (was Forms and CF Code)
>
>
> I have
Just spotted this thread. Surely, unless the scenario referred to by Ray
is encountered you should simply HTMLEditFormat() any user submitted
output in order to escape any special characters.
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]]
> Sent: 19 December 2001 1
ListFirst(GetFontFamily, ".")
> -Original Message-
> From: phumes1 [mailto:[EMAIL PROTECTED]]
> Sent: 19 December 2001 14:46
> To: CF-Talk
> Subject: Re: Stripping last 4 characters from string
>
>
> Hi,
>
> I have a variable #GetFontFamily# which displays the results
> "Garamond.fnt"
True, but it isn't anything that you would normally do so there isn't
really anything to worry about there.
> -Original Message-
> From: David Brown [mailto:[EMAIL PROTECTED]]
> Sent: 17 December 2001 16:12
> To: CF-Talk
> Subject: Bug I think
>
>
> Server Product ColdFusion Serve
You mean like this:
SELECT ItemName, BrandName, RetailEach, RetailUnit, UnitSize,
DetailedDescription, ItemNumber, MainCategory,
SubCategory1, SubCategory2
FROM MasterItemTable
WHERE 0=0
AND (SubCategory1 = '#SubCategory1#')
OR (SubCategory2 = '#
ListLast(string, "*") eq "END"
> -Original Message-
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: 17 December 2001 01:10
> To: CF-Talk
> Subject: Re: String ends
>
>
> len(st) GE 4 and right(st,4) EQ "*END"
>
> (you need to check length because right(st,4) with give an
> error
1) See bottom of message
2)
#form[field]#
Steve
> -Original Message-
> From: laurent hsld [mailto:[EMAIL PROTECTED]]
> Sent: 14 December 2001 13:46
> To: CF-Talk
> Subject: search a form
>
>
> Hello !
>
> First of all, could one of you remind me the url where all the past
CC,
Can I assume that you're having problems with dates being treated as
though they were being represented as MM/DD/YY? This is a common
stumbling block and sadly doesn't affect anyone in the US. I have
attached one of my many FAQs on this subject for your information.
Hope this is of use.
Steve
Are they still around?
Ignoring the mem leak issues (or "the escapes of memory" ;-) ) I recall
that Allaire recommended that connections should not be maintained to
Access dbs with CF3.x but changed the database pooling methods with 4.x+
and hence recommended that connections should be maintaine
Porquoi?
> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2001 17:27
> To: CF-Talk
> Subject: Re: Releasing Access locks with Coldfusion?
>
>
> On 12/12/01, Jon Hall penned:
> >You can also uncheck Maintain Database Connections in the CF
> admin and the
>
An alternative approach - try using the MS Office 2000 HTML filter:
http://download.microsoft.com/download/office2000prem/msohtmf/2000/WIN98
/EN-US/msohtmf2.exe
Steve
> -Original Message-
> From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2001 14:36
> To: CF-Talk
> Subjec
Can't see anything to cause a syntax error but you do have a superfluous
WHERE clause as the expression is being handled by the join.
Could you post the CF code that generates the SQL pls.
Steve
> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 200
s' and
> 'No' as oppossed
> to 0/1.
>
> -Original Message-
> From: Steve Martin [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2001 14:28
> To: CF-Talk
> Subject: RE: ODBC or OLE DB
>
>
> I'm curious as to what differences you've found as I'
Or just use Trim() on the variable containing the file content and then
write it out again.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2001 14:44
> To: CF-Talk
> Subject: Re: Trimming Files
>
>
> Depending on what line separator(s) are
I'm curious as to what differences you've found as I've used both
interchangeably without any problems whatsoever. Could you possibly
enumerate the differences for the benefit of the list.
Cheers,
Steve
> OLEDB handles dates and boolean fields slightly differently at times
> (perhaps other data t
> -Original Message-
> From: Alexander "just me" Apartsev [mailto:[EMAIL PROTECTED]]
> Sent: 07 December 2001 08:29
> To: CF-Talk
> Subject: query name vs. query object
>
>
> Hello All,
>
> i have a custom tag making a query. I would like to access
> its results in
> another custom t
There are various ways. One is as simple as:
#pwd#
HTH
Steve
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 06 December 2001 18:30
> To: CF-Talk
> Subject: Random passwords
>
>
> Does Anybody know how to generate random passwords f
in that case make sure you pass the literal name of the query into the
CFOUTPUT tag.
If you've called the query REQUEST.TheQuery then:
Steve
> -Original Message-
> From: Alexander "just me" Apartsev [mailto:[EMAIL PROTECTED]]
> Sent: 06 December 2001 18:20
> To: CF-Talk
> Subject: quer
For future reference:
C:\>net helpmsg 1450
Insufficient system resources exist to complete the requested service.
Steve
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 16:22
To: CF-Talk
Subject: RE: Windows NT error #1450 occurred.
that or the reg
Do you have "Suppress whitespace by default" checked in the CF admin? If so
then you'll always end up with a leading space as it would appear to
compress runs of zero (yes, zero) or more whitespace characters to a space.
Had me pulling my hair out for a while once.
Steve
-Original Message---
You can confirm the server version with the following code:
OS: #Server.OS.Name#
Ver: #Server.OS.Version#
Build: #Server.OS.BuildNumber#
Extra Info: #Server.OS.AdditionalInformation#
Steve
-Original Message-
From: Michiel Boland [mailto:[EMAIL PROTECTED]]
Sent: 09 November 2001 08:05
T
> This works to combine two Access datasources into one query.
> http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914
Eh oh, that tells you how to query 2 TABLES not 2 datasources!
You can query 2 datasources in Access using the following technique however:
SELECT tableA.field1, tabl
dump the contents of the FORM, URL & ATTRIBUTE structs using a handy tag
such as for example CF_ObjectDump.
Steve
-Original Message-
From: Jason Blum [mailto:[EMAIL PROTECTED]]
Sent: 01 November 2001 17:27
To: CF-Talk
Subject: ### Output all variables?
Anyone know of a quick and dirty
Local variables are scoped as variables.variablename
After running item 1 you can refer to the local variable as variables.Fname
Item 2 won't have a structure associated unless you explicitly created one.
You have simply created a variable called Names.Fname
Steve
> -Original Message-
>
[Outlook] File/Import & Export/Export to file
> -Original Message-
> From: John McCosker [mailto:[EMAIL PROTECTED]]
> Sent: 31 October 2001 10:59
> To: CF-Talk
> Subject: archiving cftalk mails
>
>
> Has anyone wrote an app or aware of one that can scan your inbox and write
> your emails
Word docs are binary files and CF isn't too hot at handling binary data from
databases. You'll probably have to use some sort of custom tag (Java or C++)
to return the binary data to the browser with the appropriate headers or
write it to a temp file and use CFCONTENT in the manner indicated by Ma
Session vars aren't related to the type of browser you're using. The only
dependency on the browser is that it must perpetuate the cfid and cftoken
values. This is usually done through a cookie. If Nutscrape has cookies
turned off for whatever reason and you are not passing the values from page
to
eh-oh:
SELECT *
FROM Wherever
WHERE somefield IS NULL
> That's because IS is not a valid SQL keyword...
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprof
Shhh!, it's sleeping.
> ... I thought the list was Dead!!
>
> Jason Lees
> National Express
> Email : [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Erika L. Walker [mailto:[EMAIL PROTECTED]]
> Sent: 02 July 2001 16:53
> To: CF-Talk
> Subject: RE: is this list dead?
>
>
> I'm ge
Don't forget the query attribute of your CFOUTPUT tag. That's why you're
only getting the 1st record returning.
Steve
> -Original Message-
> From: Tim [mailto:[EMAIL PROTECTED]]
> Sent: 12 June 2001 16:05
> To: CF-Talk
> Subject: Aggregate functions (AVG())
>
>
> I have a simple query th
HTMLEditFormat()
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 06 June 2001 12:58
> To: CF-Talk
> Subject: RE: Preserve ampersand tagged data (SGML)
>
>
>
> I'm using french accented characters.
>
> Is there a CF function to preserve ampersand stuff ?
In a manner of speaking, yes. And this also applies to any page that you
want a Please Wait for. You can use the OnBeforeUnload event (IE5+ only) to
bring up a Please Wait message before the current page unloads and the
requested page is called. Typically what you would do is have for example a
-
CFQUERY is allowed in any type of CFLOOP so the addition of CFOUTPUTs into
the loop is irrelevant.
This thread reminded me of a BUG in CF which I can confirm is still in CF5RC
(haven't checked with the final release yet but I doubt it has changed!)
which concerns the nesting of query driven loops
Although browsers work fine without hashes (pounds for you yanks ),
technically speaking the 'standard' is for hex numbers to be preceeded with
a #.
Steve
> -Original Message-
> From: Gina K. Anderson [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 16:12
> To: CF-Talk
> Subject: RE: Thank
You have an unterminated CFQUERY in your page though you have only pasted a
snippet of the code into your email. Take a look above your code and try to
find the offending tag.
> -Original Message-
> From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 16:38
> To: CF-Talk
>
You could potentially create the entire mail body dynamically by encoding
the dynamic data on the fly and using cfmailparam insert the relevant mail
headers along with the encoded data. Your best bet, unless somebody else
provides a step by step set of instructions would be to examine an existing
You can put whatever you want inside a CFCATCH block. Check to see whether
the email is being created or not by examining the SPOOL and UNDELIVR
directories under CFUSION. If not then see what happens without the
CFLOCATION though this shouldn't be causing CFMAIL to fail.
Steve
> -Original M
FYI, the first line is superfluous as CGI vars are special in that they will
always exist, including made up names like cgi.happy_hovercraft. In fact,
cgi vars afaik are r/o so cfparaming them would be pointless.
Steve
> -Original Message-
> From: another programmer [mailto:[EMAIL PROTECT
Click here
> -Original Message-
> From: Erika Foster [mailto:[EMAIL PROTECTED]]
> Sent: 15 May 2001 18:34
> To: CF-Talk
> Subject: OT: open link in new, maximized window?
>
>
> I need a link to open up in a new maximized browser window. I
> figure its a
> windows setting issue instead of
Is your OperaID an autonumber field perchance? Trying to insert a value into
an autonumber field is not going to happen.
Steve
> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: 14 May 2001 12:36
> To: CF-Talk
> Subject: query error
>
>
> Hello,
>
> Must be having
fdisk
> -Original Message-
> From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
> Sent: 10 May 2001 15:55
> To: CF-Talk
> Subject: Internal Server Error
>
>
> We just set up a Windows 2000 Advanced Server with
> ColdFusion 4.5.1 SP2 and cannot get any cfm files to
> work, it always gives
Try: CFHTTP.StatusCode
Should contain 404 if the server is contacted and returns a 404.
Steve
> -Original Message-
> From: Gene Kraybill [mailto:[EMAIL PROTECTED]]
> Sent: 09 May 2001 19:05
> To: CF-Talk
> Subject: OT: Spider 404s
>
>
> I'm building a little spider in CF and want to ch
Dave, it would appear that CF is aware of the true file type of an uploaded
file in spite of any file extension renaming. By way of a quick test I took
a JPG and renamed it to .MP3 and uploaded it. file.contenttype and
contentsubtype reflected the fact that the file was indeed an image/pjpeg
and n
*** Team Pixie ***
If you think about it, arrays are suited to storing an arbitrary number of
bits of information from 1 ... n - similar to the way a table stores an
arbitrary number of records. Structures are suited to storing groups of
ass
select * from pressreleasetable
ORDER by pressreleasedate DESC
Should do the trick
Steve
> -Original Message-
> From: Darren Adams [mailto:[EMAIL PROTECTED]]
> Sent: 30 April 2001 15:28
> To: CF-Talk
> Subject: Arrays and Structur
Try the following instead:
btw, make sure your locale is set to a non-US locale otherwise your dd/mm/yy
will be interpreted as mm/dd/yy (unless the date is beyond the 12th of the
month).
Steve
> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: 24 April 2001 12:
Can the server that CFHTTP is being called on actually see the URL that it
is supposed to be accessing?
> -Original Message-
> From: Holger Lockertsen [mailto:[EMAIL PROTECTED]]
> Sent: 19 April 2001 10:28
> To: CF-Talk
> Subject: again...
>
>
> Running 4.5.1 SP2 on a server we are getti
nb is the same as
attributecollection is what still appears to be an undocumented method of
passing a dynamic list of attributes into a tag. You just create a structure
containing keys pertaining to the attributes you want to pass into the tag
along with the associated values and then pass it
I recall there being some change in the way ints are handled between the two
versions (4.0 & 4.5). I can't remember the specifics but your symptoms point
to that as being a likely suspect. Anyone who knows the details care to
elaborate?
Steve
> -Original Message-
> From: C. Hatton Humphre
That was because your dates were in the incorrect format.
Try:
SELECT * FROM wwebsales
where orderdate between #startdate# and #enddate#
> Thanks for the suggestion. It didn't work though. I have a form with a
> dropdown menu. Can dates in an Access table between: 01/01/00 and 01/01/01
> be
Have more than 1 in the same form on a page and use
the corresponding number of on the action page.
Steve
> -Original Message-
> From: paul . [mailto:[EMAIL PROTECTED]]
> Sent: 03 April 2001 13:44
> To: CF-Talk
> Subject: multiple file upload in the same time..
>
>
> well Guys i need t
Why don't you just use the premade session.URLToken?
> Yup sounds ok to me. The only thing I do extra is to put some code in my
> Application.cmf which creates a string containing the CFID and CFTOKEN if
> the user has session level cookies turned off. I then append
> this string to
> every hyp
If it wasn't installed by default then it will be on your
CD.Windows[productVersion]
-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 18:32
To: CF-Talk
Subject: Personal web server install
Hello all,
I am trying to install microsofts personal web ser
The CFID and CFTOKEN are NOT automatically appended to the URL when a page
is served.
I guess you really want to find out how to stop CFID & CFTOKEN being passed
to the browser as cookies as that is how they are passed by default.
Firstly, make sure SETCLIENTCOOKIES is set to NO in your CFAPPLICAT
No.
-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 12:59
To: CF-Talk
Subject: Calling Custom Tags in
Hi All,
In CF Version 4.5 is it possible to call a custom Tag from with in a
CFScript block
EG
the x^2 = #y#
How woul
5) Other - IE5 (though IE5.5 has more granular object control)
Hi All,
Just a quick survey to appease my curiosity...
If you use a web-based WYSYWIG editing tool, what do you use?
1) ActiveEdit (www.cdev.com)
2) eWebEditPro (www.ektron.com)
3) ezEdit (www.siteobjects.com)
4) HTMLArea (www.iaut
You're talking about client variables, not session variables. However:
They are as safe as they were in the registry as they are keyed on the
CFID/CFTOKEN pair which are generated by CF. Make sure in your
you have UseDomainCookes set to TRUE so that no matter
which server you happen to being serv
I can't remember back that far to know whether the variable naming rules
were more lax then but as far as CF4.52 is concerned, variable names must
contain only letters, numbers and underscores, and must start with a letter.
This translates to meaning that your query names should follow the same
co
cgi.HTTPS_KEYSIZE= [40/128]
Steve
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 12:50
To: CF-Talk
Subject: Re: Can I tell if a browser is 128 bit with CF
CF is server side. Browser detection must be done client side with
JavaScript. I know there
Use CFX_GetIPHostname
-Original Message-
From: Paul Bowley [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 11:14
To: CF-Talk
Subject: Finding host from IP
Hi all
A question for the ASP-literate among you. We have some ASP code that looks
like this:
Set DNS = CreateObject("TCPIP.DNS")
Worldpay have what is known as a 'data fetch' method whereby when you enter
the payment system you pass in a cart ID. The payment system then does the
equivalent of a CFHTTP to a URL on your site that you predefine in the
payment system administration pages passing the cart ID as a parameter. You
You can change the site wide error handler from within the CF admin. Specify
a template and use the #error.X# variables to format the error layout.
Steve
> -Original Message-
> From: Shannon Carr [mailto:[EMAIL PROTECTED]]
> Sent: 14 February 2001 14:35
> To: CF-Talk
> Subject: CFABO
DateFormat assumes US date formats by default - it is effectivelt a
hardwired US locale specific version of LSDateFormat. I would recommend that
you set your locale using SetLocale("English (UK)") [or whatever] and then
use the locale specific versions of the date and time manipulation
functions.
Don't forget the old ยง gem! That's a browser screwup (IE4) which causes
CF to barf.
> If you're talking about CF errors ZERO!
>
> If you're talking about JavaScript errors, then early version will have
> problems, but try to build in redundancy so that it won't break if they
> don't have the fun
Do a tracert from the box to the alleged local IP and see if it is the case
Steve
> -Original Message-
> From: George Lemos [mailto:[EMAIL PROTECTED]]
> Sent: 13 February 2001 04:51
> To: CF-Talk
> Subject: CF Server Question
>
>
>
>
> I've noticed recently that on one of our cold fusion
Explanation: You have used a CFTRANSACTION tag within the
scope of another CFTRANSACTION tag (nesting of
CFTRANSACTION tags is not permitted).
Sorry to point out the obvious but!
> -Original Message-
> From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 17:21
> To:
The following should do what you want.
Steve
> -Original Message-
> From: Peter Benoit [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 15:56
> To: CF-Talk
> Subject: Random letter/number value
>
>
> Hi,
>
> I'd like to produce a random letter/number value for a p
a) Yes
b) Yes
> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 00:08
> To: CF-Talk
> Subject: excel - access - sql?
>
>
> if anyone can help me on this i would appreciate it
> i was wondering:
>
> A. i could convert an excel file to sql
>
> > Apparently the removewhitespace setting only applies to
> > whitespace internal to tags
> > e.g.
> >
> > datasource="dsn"
> > dbtype="odbc">
>
> I know this is a dumb question, but WHAT F***ING USE IS THAT?
The internal CRs do bleed into the generated text so the all
Apparently the removewhitespace setting only applies to whitespace internal
to tags
e.g.
datasource="dsn"
dbtype="odbc">
> -Original Message-
> From: Jason Lees (National Express)
> [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 10:34
> To: CF-Talk
>
Paul,
Verity will index database content as well as a variety of documents. Check
out the cfindex type="custom" for the syntax for indexing databases. It
shouldn't be too much trouble to integrate your current text indeces with
the database content into one collection. When creating a collection,
>
> > Thats very interesting, because doing a view source indicates
> > that they are
> > using CF:-)
> >
> > I mean how many other scripting languages generate that much
> whitespace!
> >
>
> Erm...
>
> Loads of languages generate that much whitespace!
Which ones?
~
Mary,
The quote is closing the quote in the form thus rendering it invisible.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2001 12:37
> To: CF-Talk
> Subject: Weird Problem
>
>
> I am having the strangest problem...
>
> I have a varchar fie
The messages are accessible through Windoze:
>From a command prompt type:
net helpmsg 109
"The pipe has been ended"
Steve
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2001 12:25
> To: CF-Talk
> Subject: Windows NT Error Number 109
>
>
> Wh
create an icon called favicon.ico and IE will automatically look for it at
the root of the web site.
Steve
> -Original Message-
> From: Milks, Jim [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2001 18:39
> To: CF-Talk
> Subject: OT:How do I put the little image in the address bar in IE?
It doesn't work if you use hidden form fields, you need to append the token
to the file portion within the form tag:
etc.
Steve
-Original Message-
From: Peter Lutwyche [mailto:[EMAIL PROTECTED]]
Sent: 26 January 2001 12:27
To: CF-Talk
Subject: CFID and CFTOKEN, client variables,
[EMAIL PROTECTED]
(or possibly even [EMAIL PROTECTED] )
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 24 January 2001 16:56
To: CF-Talk
Subject: Allaire wish list
What's the e-mail address to send CFAS enhancement requests to?
Thanks
--
Aidan Whitehall <
Oops, no atachments allowed. Here it is in full:
Originally posted by Gregory Narain - ages ago.
===
All of the entries go into the
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\InetInfo\Parameters
key
ObjectCacheTTL (DWO
ssage-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: 21 December 2000 11:11
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0
But why doesn't allaire use StructCopy ... ;)
-Original Message-----
From: Steve Martin [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 11:43
T
.
ATB Steve Martin
-Original Message-
From: Zachary Bedell [mailto:[EMAIL
Attached is a posting from a while back which addresses this issue (IIS4).
Other workarounds include wrapping a bit of exception habdling around the
code so that should the problem occur then you can queue the process i.e.
place the source and destination file refs in a db and reexecute it later.
Not entirely true. Structcopy does actually duplicate the structure in
question. I think there's some confusion here over which creates a pointer to the original. Structcopy
however only performs a shallow copy in that any embedded structures within
the structure that you are trying to duplicate
quite simply text/xml
You need IE5+ to view the XML in the browser.
-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: 06 December 2000 11:51
To: CF-Talk
Subject: Passing XML content back as XML
is there anyway in cf to pass am xml packet back, so that the browser
URLEncodedFormat() even.
Steve
-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2000 18:12
To: CF-Talk
Subject: RE: passing a negative value
wouldn't urlencrypt() work? Pass in -5, it gets url coded, and then on the
application page you don't have to
When a user logs in, update an application variable keyed on their userid
with a timestamp. To view a list of logged in users simply list all the
userids which have a timestamp of less than your chosen session timeout
period.
Steve
> -Original Message-
> From: AustralianAccommodation.com
SELECT * FROM table
WHERE datefield BETWEEN #LSParseDateTime(date1)# AND
#LSParseDateTime(date2)#
Book: SQL for smarties - Joe Celko
Steve
> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 20:41
> To: CF-Talk
> Subject: date compariso
CF is basically untyped. When using variables or constants CF uses 'lazy
evaluation' where the type of a particular var or const is evaluated at
runtime, for example you can stick an integer value into a variable and then
stick that variable into a dateformatting function and you will only get an
Make use of the custom fields when you create your indexes. Custom1 could be
used to store a reference to the table and custom2 to the primary key in
said table. Check your docs for details on how to use these fields - it's
pretty straightforward.
Steve
> -Original Message-
> From: Peter
tp://www.somewhere.com/admin/login.cfm?username=myuser&password=mypass"
>
> That is why I used the term "at the very least".
>
> Lets just say that it is the least the programmer should do.
>
> Paul
>
> > -Original Message-
> > From: Steve
"Passing it through the HTTP header as a form variable would be more secure
at the very least."
I wouldn't say so. If the value is passed either via URL or by form field
the data is still plaintext and can be intercepted either way.
>
> Jake,
>
> I would suggest using javascript to encrypt the p
#Evaluate(DE(longstring))#
Steve
> -Original Message-
> From: Gordon Burns [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 05, 2000 23:06
> To: CF-Talk
> Subject: Variables within string
>
>
> I have a variable #longstring#. This variable contains a string on
> the lines of:
>
You would use CFHEADER to return any custom headers you like. This includes
headers to tell proxy servers not to cache. Quite what 'optimum values'
means in terms of http headers I don't know.
Incidentally, are you _really_ going to deploy a site using CF4.0.0 bearing
in mind it officially contai
This can apply to normal select fields too given that the criteria for
passing the required field stipulation is that the value of the field in
question contains must value that isn't the empty string - in the same
manner as required text fields. For example your first option may be (Please choose
Similarly cookies are stored in the cookie structure so you could do a
StructKeyList(cookie)
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 01, 2000 09:05
> To: CF-Talk
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Getting List of all cookies
>
>
Absolutely. In fact I don't even let CF anywhere near the executing of the
batch file, I have IIS call it directly - with the relevant security - of
course, that way if it fails to restart first time I can call another batch
file that runs a net start.
> -Original Message-
> From: lseller
I can think of what
it could be at present.
> My mapping settings are:
>
> Logical Path: /Templates/
> Directory Path: C:\Inetpub\wwwroot\new\Templates\
>
>
> This is my CF Code:
>
>
>
> >From: "Steve Martin" <[EMAIL PROTECTED]>
> >Repl
Alternatively you could rig up a batch file with execute permissions which
contains a NET STOP/START to the appropriate services which you can call
from a browser.
Steve
> -Original Message-
> From: lsellers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 17:27
> To: CF-Talk
Sal, can you detail _exactly_ what you did, i.e. exactly what you typed for
your mappings and exactly what you typed to include the file.
Steve
> -Original Message-
> From: S R [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 17:13
> To: CF-Talk
> Subject: Re: CFINCLUDE Proble
1 - 100 of 157 matches
Mail list logo