RE: Please Help

return true; } Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: CF Crazy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 3:12 PM To: CF-Talk Subject: Please Help I

RE: Query boggle

ER BY CI.ChildGender /CFQUERY - Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: John W

RE: session management

this mailing list is your absolute best source for information. Ask and learn :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Savan

RE: Passing query back to page through caller in custom tag

piece o' cake: cfquery name="caller.myQuery" datasource="... Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: David

RE: Why wont this advance to the next record

e filename is correct. I've also made some minor code changes that make your logic slightly cleaner - (just suggestions) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Origin

RE: CFFILE ACTION=copy and NAMECONFLICT

Actually you can use the FILEEXISTS() function to see if a file name exists :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Chad Gray

RE: Session variables stored in SQL server

to understand and manipulate, but they are reliable, scalable, and safe (no CFLOCKS). You would be wise to learn how to utilize them yourself :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED

RE: retrieve remote images using cfhttp?

that you would need cooperation from whoever you want to take files from; they would have to make a site that you can hit that would send you files, but that is a whole other issue entirely:) Good luck! Bryan Love ACP Internet Application

RE: how to access the cf administrator page

in application.cfm (or equivilant) you have put a CFAPPLICATION tag with CLIENTSTORAGE set to "CAVO". Just remove that attribute altogether and let the system use the registry until you get everything set up :) Bryan Love AC

RE: Parsing a text field from a db...

in a seperate DB table, or use relative pathing to avoid the problem altogether. Take it from someone who has been there and go back before you get too far down this road, you'll find nothing but headaches at the end! Bryan Love ACP Internet

RE: CFGRID Display Problem

tags use the web root as a starting point to look for the CFIDE folder). Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Les Mizzell [mailto

RE: QUERY TROUBLE

DS_1#" dbtype="ODBC" SELECT #preserveSingleQuotes(selList)# FROM RMOTownName T, Attractions A WHERE A.RMOTown=T.RMOTown AND T.RMOTown'#RMOTOWN#' AND Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE RMOTown='#RMOTOWN#') ORDER BY T.rmotown, A.PrimaryName

RE: Thanks everyone but one last question

You can create whatever WHERE statement you wish to select whatever rows you need from the DB to get row 2, column 2: SELECT password FROM table WHERE ID = 3 Bryan Love ACP Internet Application Developer [EMAIL PROTECTED

RE: form to session

Why you would want to convert innocent, safe form fields into tricky, unstable session variables is beyond me, but here's the code... cfloop list="#form.fieldnames#" index="i" cfset "session.#i#" = evaluate("form." i) /cfloop

RE: RE: form to session

d2#" etc... /form This basic approach works quite well and avoids the use of those pesky session variables :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED]

RE: error resolving parameter

interest to update the entire application... Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Brian Horn [mailto:[EMAIL PROTECTED]] Sent: Wednesday

RE: Flushing Query Cache

Cache=60" in the url string again and be done with it :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 9:00 A

RE: RE: error resolving parameter

look further down in the select and you'll see that a blank one is created regardless ;) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From

RE: CFMail Question

on sending more than, say... 300 mails a day you should seriously consider getting a dedicated machine solely for using CFMAIL. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED

RE: Credit card transaction services

which doesn't always return the variables it's supposed to (they have issues). On the other hand, I don't think there's anything better out ther. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED

RE: how to perform a variety of searches on a database

d use CF's arraySum() function to sum up the column you need. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Tim [mailto:[EMAIL PROTECTED]]

RE: Form Fields cleared on Back

will appear again populated with it's own values. In DSP_BUGLIST.CFM you'll need to put an if statement to default the form values for the first time through. Works like a charm! Bryan Love ACP Internet Application Developer [EMAIL PROTECTED

RE: Any recommendations on an E-commerce software?

How bout a fully fuseboxed, scalable commerce app available with open source? for a demo go here: http://writtenword.adhost.com/blove/Admin/ Uname: demo Pword: demo Bryan Love ACP Internet Application Developer [EMAIL PROTECTED

RE: Session variables

vice versa). Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:14 PM To: CF-Talk Subjec

RE: Any recommendations on an E-commerce software?

, there is much to see :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:36 PM

RE: Session variables

and can be used in a clustered environment. When used in conjuction with request variables you can successfully create a solid, single-threaded-by-nature application that will scale across as many servers as you want. Good luck! Bryan Love ACP

RE: Number to String?

exactly are you trying to do? Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Bryan Rieger [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12

RE: query troubles

seven queries to insert into seven tables p.s. I'd be very interested in knowing how to insert into multiple tables in one statement if you do figure it out! Bryan Love ACP Internet Application Developer [EMAIL PROTECTED

RE: Determining no. of pages in results

numbers || HISTORY || Author: Bryan Love ; [EMAIL PROTECTED] ; 10/10/00 || ATTRIBUTES || - attributes.StartRow R what is the current start row? - attributes.maxRows R how many rows per page - attributes.totalRows R how many rows did the query

RE: query troubles

) - the CEILING() function rounds up no matter what, so if you have recordcount of 11 and divide by ten you will get 1.1 then CEILING() will round up to 2. Bryan Love ACP Internet Application Developer [EMAIL

RE: Determining no. of pages in results

. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 10:57 AM To: CF-Talk Subject: RE

RE: I'm stumped

here's your problem... cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@PollID" value="TRIM(FORM.PollID)" you didn't pound the trim function :)

RE: Nested Loop limit?

... Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 2:52 PM To: CF-Talk Subject: Nested Loop limit? Hi All, I've just added some

RE: How to make recursion in CF

- pretty basic. You'll end up with a list of all files in the original root folder and all subfolders in (stored in request.files) You can do other cool things with this kind of recursion (like use it to build a CFtree).

RE: (yet another) Javascript Question

isValidNum = false; } // return if number is good if( isValidNum ) return true; // alert if number is bad alert("Please enter a valid fleet size."); } B

RE: NULLs

anyway Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: David Clay [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 9:34 AM To: CF-Talk Subject: NULLs I would like

RE: select records from table 1, that are not in table 2 ?

try this, but be prepared for a slow query if the rows aren't indexed or if the tables are big: SELECT letters FROM table1 WHERE pKey NOT IN (SELECT letters FROM table2) Bryan Love ACP [EMAIL PROTECTED

RE: NULLs

THIS IS WHAT SQLSERVER MUST DO IF COLUMN IS NULL if (MyTable-ColumnA.NullBit != false) return myTable-ColumnA.Value else return NULL --- Bryan Love ACP [EMAIL PROTECTED]

RE: Populate array with query

Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 1:58 PM To: CF-Talk Subject: Populate array

RE:RE: select records from table 1, that are not in table 2 ?

I flubbed the query I just posted. should be: SELECT letters FROM table1 WHERE letters NOT IN (SELECT letters FROM table2) sorry ;) Bryan Love ACP [EMAIL PROTECTED] -Original

RE: Relative path?

path to the web root (c:\inetpub\wwwroot) and have all your cffile tags use this variable (cffile action="upload" fileField="upFile" destination="#request.localWebPath#\folder1\folder2") Good Luck! B

RE: ENCTYPE=multipart/form-data problem

fields)? Post the code for all to look at and I'm sure you'll get a more informative answer. Good luck! Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Scott Lowe [mailto

RE: multiline insert

t_id#', '#session.job_no#', '1', '#i#', '#taskHours#', '#DateFormat(Now(), "MM/DD/")#') /cfquery /cfif /cfloop Bryan Love ACP [EMAIL PROTECTED]

Javascript validation

JS without a looping structure?? Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Campbell Morton [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:06 PM To: CF-Talk S

Request VS Application scope

locking set to ON in the CF admin I would very much like to hear some feedback on this if anyone wants to hypothesize about the results. Bryan Love ACP [EMAIL PROTECTED] ~ Paid

RE: loops, queries, ug...

You should never put a query inside a looping structure. Try this: !--- join the tables and order by the subnet --- cfquery name="nets" datasource="whatever" SELECT s.subnet, ip.ip, ip.name, ip.description FROM subnets s, ips ip WHERE s.subnet = ip.subnet ORDER

RE: structures always serialized to WDDX the same way?

structString2) cfif areSame IS 0 The structures are identicle cfelse The structures are different /cfif Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PR

RE: CF java object

Calling a Java class is done using HTML and thus the location of the CF machine is completely irrelevent. You can call Java classes from anywhere. Bryan Love ACP [EMAIL PROTECTED

RE: Process Time Variable WAS Re: Caching Queries......

GetTickCount() Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: defective david [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 8:50 PM To: CF-Talk Subject

RE: Undcocumented Feature (Copyright MS) in Coldfusion 4.5 isde fine d() function

You cannot reference arrays in the ISDEFINED function :) Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Friday, December

RE: Passing variables to a SQL7 stored procedure

will be created and defaulted to 0 (as shown below): EXECUTE Order 1,1 The only catch is that you MUST declare the defaulted values LAST in the stored proc or you'll have problems (I think you can see why) Good luck! Bryan Love ACP [EMAIL PROTECTED

RE: List w/ delims

For the record: You can use more than one symbol for a list delimiter if you assign it to a variable first: cfset delim = "||*||" cfloop list="#list#" delimiter="#delim#". Don't ask why, it just works that way

RE: loops, queries, ug...

You can't nest cfoutputs if they both have query attributes. You can run this in one query with a table join and output using grouping. Bryan Love ACP [EMAIL PROTECTED] -Original

CF and Apache

I've managed to hook CF 4.5 up to Apache just fine. One thing I can't do is get Apache to pull .cfm pages from mapped drives. I can get any other extension just fine, but when I request a .cfm page I get 404 NOT FOUND. I'm guessing this is a restriction in the CF processing module. Can anyone

RE: SQL ID

check the IDENTITY box of the column you wish to autonumber while in Design Mode. The first number after that is the seed value and the second is the step value ___ Bryan Love Director of Development [EMAIL PROTECTED] MarketMatrix Inc. 810 3rd Ave

RE: SQL aggregation prob

values, one for where responseID = 0 and one for where responseID = messageID ___ Bryan Love Director of Development [EMAIL PROTECTED] MarketMatrix Inc. 810 3rd Ave Seattle WA, 98104 206~343~9445 marketmatrix.com

RE: CFFILE

= file.serverfile file name without extionsion = file.serverfileExt file extension = file.serverfileName Use these variables to record the names of the freshly uploaded files. ___ Bryan Love Director of Development [EMAIL PROTECTED] MarketMatrix Inc. 810

disappearing form fields

? ___ Bryan Love Director of Development [EMAIL PROTECTED] MarketMatrix Inc. 810 3rd Ave Seattle WA, 98104 206~343~9445 marketmatrix.com

<    1   2   3   4   5   6