CFLOCK instead of CFTRANSACTION

) /cfquery cfquery name=new datasource=#request.mainDSN# SELECT max(fooID) AS ID FROM foo /cfquery /cflock +---+ Bryan Love Macromedia Certified Professional Internet Application Developer

RE: CFLOCK instead of CFTRANSACTION

I know that the database itself can handle transactions using InnoDB tables. The error I'm getting from CF is that the ODBC DRIVER can't handle them. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database

RE: Dynamic var name

this will check existence like you wanted cfif structKeyExists(session,var) AND isArray(session[var],2) /cfif +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems

RE: OT: SQL without Subquery

this won't return rows with counts of 0... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: SQL without Subquery

) ON l.id = ll.id) WHERE c.mail_list 0 GROUP BY l.id, l.description,l.build_date,l.edit_date,l.admin_user ORDER BY description DESC +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: Converting new lines to br

replace(yourString,chr(10),br,all) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

CFTREE changed???

? +---+ 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

RE: CFTREE changed???

Much thanks, I'll check the known issues on MM's site before I post another question like that :o +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: Multiple Apps, one name

yes you can. Application-specific variables are based on the application name so you CAN have one application inherit information from another. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: Array Help

cfoutputLI#i#/cfoutput /CFLOOP /ol +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble

RE: Array Help - SOLVED

why would you convert a list to an array then convert it back to a list again? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: CFHTTP question

... +---+ 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

RE: CFHTTP question

+---+ 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

RE: Need help with CFHTTP

and inserted into the query header. The query has all of the functionality of a standard CFQUERY object. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: Strange JS Wierdness with CF

dunno for sure, but it would be dirt simple to have JS clear the form on page load... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: UCASING in the DB

Sure it is. You have two choices - a trigger or a stored procedure. I think you are way better off leaving it the CF server though (unless you're talking about thousands of characters per second...). +---+ Bryan Love Macromedia Certified

RE: OT: Multiple Inserts

); +---+ 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

RE: UCASING in the DB

in fact, why don't you just put the upper() function in your insert query like so.. INSERT INTO table VALUES( upper(#text#), upper(#text#) ) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: UCASING in the DB

true, but if you do it during the INSERT you only do it once - if you do it during the SELECT you do it thousands, maybe millions of times. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: multiple OUTER joins in SQL?

ON c.itemID = r.itemID) WHERE c.activated = 1 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: parsing user input to get count

+---+ 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

RE: Run a check before an insert

also assume you have a column (type) that can be used to differentiate the items. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: cfinput

the only thing unique about CF inputs is that they cause the CF Server to generate JavaScript that is used for validation and such... Otherwise they end up the same as any other HTML input +---+ Bryan Love Macromedia Certified Professional

RE: Urgent: Need help with a CFFILE error

if you must use a URL then use CFHTTP The content of the file will be in cfhttp.filecontent after the call. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL

RE: Las record

the query is even run. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let

RE: UUID's ( maybe OT)

not generally a good idea. If you're gonna use nText, nChar, nVarchar, make sure you have a really good reason! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL

RE: CFMX - cftree doesn't work

if it is not. +---+ 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

RE: CFMX Updater

I posted this question once before, but I don't remember getting a response and I don't have email from this list that old... Does anyone know of a size limit for input type=file...? I couldn't find one in the official HTTP RFC... +---+ Bryan Love

HTTP file limit?

oops, I posted this with the wrong subject line... see question below +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: Using a variable to collect query-like results

actually it should probably be: cfquery datasource=firmdaily name=GetMyQueryResults #preserveSingleQuotes(myquery)# /cfquery +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication

RE: Man this query @#%$*

), DATEPART(mm, logdate), DATEPART(d, logdate) ORDER BY DATEPART(dy, logdate) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: cfdirectory

and keep in mind that expandpath() evaluates a templates full path FROM THE CALLING TEMPLATE - NOT from the current web location. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication

RE: cfdirectory

missing quotes: ..#expandPath(../directory/files)#... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: cfdirectory

... +---+ 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

RE: cfdirectory

actually I believe removeChars(len(listLast(...))) is faster than reverse(), but I could be wrong. Not that it really matters unless you're doing it in a loop... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer

RE: Java and Verisign

Try this for your JVM path (it's looking for the dll): Java Virtual Machine Path: C:\Program Files\JavaSoft\JRE\1.3.1_04\bin\hotspot\jvm.dll +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: iif usage

of the editor and looks messy and is also difficult to immediately comprehend when scanning a page. It really has no place in well written code. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: cflocation vs. server side redirect.

) writeOutput(body onload=window.location=''); /cfscript +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: cflocation vs. server side redirect.

I haven't worked with CFMX yet, so my replies are for CF 4.5 and 5.0 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: Client Vars again

then put it back in the session struct after clearing. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: cflocation vs. server side redirect.

page3 Client side (using JS or HTML): - user submits page1 - server processes page 2 - server returns page2 - browser requests page3 - server processes page3 - server returns page3 Maybe I'm wrong, but I don't think so... +---+ Bryan Love Macromedia

RE: Mysterious second set of single quotes

the most obvious answer is to not write anything to the db until they have confirmed all is correct. Just pass the form fields through to the next page... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database

RE: Mysterious second set of single quotes

oops, I replied to the wrong thread! please disregard! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

File Upload Size Limit?

Does anyone know if there is a file upload size limit for input type=file...? Anyone? Anyone? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: dynamically naming arrays

checking to see if it's defined is simple: cfif isdefined(Application.#theVar#) or cfif structKeyExists(application,theVar) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication

RE: CFMODULE vs CFINCLUDE

cfinclude is WAY WAY WAY faster ALWAYS use includes if you can... Of course there will always be circumstances where you won't be able to (like recursive calls), but always try. +---+ Bryan Love Macromedia Certified Professional Internet

RE: OT: ecommerce live chat case study

. +---+ 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

RE: Client Vars again

how did you confirm that the client vars are not being recorded in DB? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: Variable Precedence

if you leave a variable unscoped it will search in this order (in CF 4.5 and I think 5.0): query (if inside of a cfoutput query=) variables url form +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database

RE: Client Vars again

in the url, form, or variables scope. Anyway, make sure they are all the same and if not then make sure you're looking up the right one. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication

RE: Client Vars again

of them is getting changed and that is throwing you off... Also, be sure to delete all cookies on the test machine(s) before running the test and comparing the results to those on other test machine(s). +---+ Bryan Love Macromedia Certified

RE: Client Vars again

:) +---+ 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

RE: Client Vars again

be there days, weeks, months later. That can cause a problem debugging if you don't realize they exist... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: Query to CSV problem

,',','ALL')# chr(10) /CFOUTPUT CFFILE ACTION=APPEND FILE=thecsvfile.csv OUTPUT=#csvstring# ADDNEWLINE=No cfset csvstring = /cfloop +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database

RE: Query to CSV problem

BTW... I just ran some tests on this out of curiosity and the looping structure I wrote below is more than 10 times faster than using the IF statement with a counter. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer

RE: Anything better than Quilldesign's Site Director or Able Comm erce???

+---+ 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

RE: Looking for mail tag - submit form emails contents without al l the code...

+---+ 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

RE: dynamically naming arrays

or alternatively cfset Application.#dynamicName# = arrayNew(1) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: dynamically naming arrays

- +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: Reverse Engineer DayOfYear Function?

#/#theYear#; } else if( theDay LTE decEnd ){ newDay = theDay - novEnd; theDate = 12/#newDay#/#theYear#; } /cfscript +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication

RE: Reverse Engineer DayOfYear Function?

wow. mine was total overkill. I figured there was an easier way brainfart +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: CF Structures

study structures in general - for any language. The concept is always the same (key-value). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED

RE: SQL Injection Attacks (scrubbers cont.)

I might be way off here, but wouldn't you just need to screen for semi-colons? In order to hack a query the user would have to enter a semi-colon to end the current statement and begin one of their own... +---+ Bryan Love Macromedia Certified

RE: CFEXECUTE account

I believe it would be whatever account the CF Service is running under... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Suggestions on saving a search

in mind though that using WDDX takes up a LOT of space (relatively speaking of course). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: thanks and sharing the bubbly

Hot links if you have any. They're great with sauerkraut! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Why is this query not working in Access??

there... +---+ 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

RE: rotating mail servers - cfmail...

the remainder after dividing value A by value B. When MODing by 3 it will always be 0, 1, or 2. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Average Orders Per Day

what DB? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let

RE: problem with FB 3.0

The username and password you are supplying most likely can't see DBO tables... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: problem with FB 3.0

The username and password you are supplying most likely can't see DBO tables... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Shopping Carts

easy to understand. Check it out at http://aloha-webdesign.com/ +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Shopping Carts

well said! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let

RE: Locking a record in database!!

a record locked before timeout. Anyway, you get the idea... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: transact(ms sql) VS PL SQL(Oracle)

What do you want to know? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: cftry/catch scoping

will capture errors thrown in CFINCLUDEs (since they operate in the same memory space), so you might try that instead. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems

RE: Directory permission bitwise operation help needed

I believe Lewis Sellers can help you. He has written CFX tags to manipulate users and permissions. You'll find posts from him on this talk list... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database

RE: Directory permission bitwise operation help needed

Dunno... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let

RE: Directory permission bitwise operation help needed

with a permission setting of 0 and use BitMaskSet(client.permissions,1,BIT_CANEDIT,1) to turn the bit on and BitMaskSet(client.permissions,0,BIT_CANEDIT,1) to turn it off Good luck! +---+ Bryan Love Macromedia Certified Professional Internet Application

RE: strange SQL error

do this: cfquery name=Update datasource=#Form.DSN# Update #preserveSingleQuotes(Form.Tablename)# SET #preserveSingleQuotes(FieldNameValues)# WHERE ID = #preserveSingleQuotes(Form.ID)# /cfquery +---+ Bryan Love Macromedia Certified Professional

RE: milonic menu problems

try putting the menu in a layer with a greater z-index than the rest of the page. That should solve it. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: ORDER BY question

You are using SQL Server. The function name is not the same in SQL Server as in Oracle. I can't remember what the exact function is, but it would be worth your time to look it up... +---+ Bryan Love Macromedia Certified Professional Internet

RE: Multiple CFApplication under 1 application.cfm

to login page /cfif +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Killing a cached query

. +---+ 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

RE: Dynamically Processing Form Values

a hidden field [hidIDs] passed to the processing page containing a comma-delimited list of the items that had a QTY greater than 0. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication

RE: Running program with cfexecute

=... EXECUTE sqlexec [whatever] /cfquery +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Running program with cfexecute

I've done this also and it worked. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: ORDER BY question

together. I chose UNION ALL because it is faster than UNION... UNION filters out duplicate rows... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: ORDER BY question

by string. --- cfquery name= ... SELECT * FROM myTable WHERE ID IN (#orderList#) [or whatever here] ORDER BY instr('#newOrderList#',',' | idColumn | ',') /cfquery +---+ Bryan Love Macromedia Certified Professional Internet

RE: Bytes to MB/GB conversion tag?

Is this a trick question?? MB = bytes/1,000,000 -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 7:11 AM To: CF-Talk Subject: Bytes to MB/GB conversion tag? Hi, I have a database of about 35,000 files with their filenames, sizes, ID tags and so

RE: Bytes to MB/GB conversion tag?

LOL THANK YOU!!! -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 1:51 PM To: CF-Talk Subject: Re: Bytes to MB/GB conversion tag? Neil Clark - =TMM= wrote: 1 MB = 1024KB. You're wrong :) 1 MB = 1000 kB = 100 B 1 Mi = 1024 Ki =

RE: CFTREE Question

? +---+ 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

RE: dynamic image

You could do it with layers and Javascript. Just put a layer containing text over the top of the image. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Getting MIME Type for a file

I've run into this problem before... I think the best way to solve it is to use a meta refresh and let the client do the work. META HTTP-EQUIV=Refresh CONTENT=0; URL=#url.file# +---+ Bryan Love Macromedia Certified Professional Internet

RE: Getting MIME Type for a file

of. Here's a comprehensive list of mime types http://www.utoronto.ca/webdocs/HTMLdocs/Book/Book-3ed/appb/mimetype.html +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL

RE: Creating a CSV in a select

what DB are you using? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble

RE: Creating a CSV in a select

this will cause any NULL entries to be *... so you would get this... a,b,c,*,d if the fourth column is NULL +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Problems installing a cfx dll

did you stop and restart the CF service? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Shopping cart

Netready is very good. Huge feature list, relatively cheap, works with ACCESS, SQL Server, and Oracle, available in FB3. You can't go wrong here! http://aloha-webdesign.com/index.asp?fuseaction=detailspid=19 +---+ Bryan Love Macromedia Certified

RE: ( escape character

use JSStringFormat() +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble

<    1   2   3   4   5   6   >