RE: utterly, utterly bizarre CFEXIT problem (kinda long but fun ny)

2002-02-08 Thread Bryan Love
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

RE: Window on Top

2002-02-08 Thread Bryan Love
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

RE: capture email address

2002-02-07 Thread 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

RE: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC

2002-02-07 Thread Bryan Love
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

RE: Client Variable Mix Up

2002-02-04 Thread Bryan Love
. +---+ 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: client side disable cookies

2002-02-01 Thread Bryan Love
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

RE: Access Db Query Date Syntax

2002-02-01 Thread Bryan Love
createODBCdateTime(dateVal) is correct... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Output Question

2002-02-01 Thread Bryan Love
. +---+ 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: Output Question

2002-02-01 Thread Bryan Love
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

RE: Output Question

2002-02-01 Thread Bryan Love
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

RE: The darndest time w/ Cookies. Actually form checking.

2002-01-31 Thread Bryan Love
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

RE: Trouble with Query Update

2002-01-30 Thread Bryan Love
# UPDATE Events SET Level = Level + 1 WHERE EventID IN (#approvedList#) /CFQUERY /cfif +---+ Bryan Love Macromedia Certified Professional Internet

RE: Trouble with Query Update

2002-01-30 Thread Bryan Love
repeated calls to the db. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble

RE: Trouble with Query Update

2002-01-30 Thread Bryan Love
) 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

RE: Trouble with Query Update

2002-01-30 Thread Bryan Love
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

RE: little OT, getting DataTypeEnum from DAO

2002-01-29 Thread Bryan Love
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

RE: creating a list from a query

2002-01-25 Thread Bryan Love
. +---+ 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: replace list????

2002-01-25 Thread Bryan Love
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

RE: Another dealing with inventories?

2002-01-17 Thread Bryan Love
. +---+ 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: cold fusion reporting...

2002-01-15 Thread Bryan Love
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

RE: How to time out a session held as client variables?

2002-01-15 Thread Bryan Love
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

RE: weird CFQuery problem

2002-01-15 Thread Bryan Love
replace strSQLwhere with preserveSingleQuotes(strSQLwhere) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: CFDirectory

2002-01-15 Thread Bryan Love
. 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

RE: Problem with QuerySetCell

2002-01-10 Thread Bryan Love
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

RE: Problem with QuerySetCell

2002-01-09 Thread Bryan Love
(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

RE: Problem with QuerySetCell

2002-01-09 Thread Bryan Love
/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

RE: Problem with QuerySetCell

2002-01-09 Thread Bryan Love
+---+ 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: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Bryan Love
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

RE: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Bryan Love
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

RE: DBTYPE=Dynamic

2002-01-09 Thread Bryan Love
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

RE: Weird Join (o8i)

2002-01-09 Thread Bryan Love
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

File Locking?

2002-01-08 Thread Bryan Love
() and FILEEXISTS() functions? Any help would be appreciated :) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: E-commerce integration

2002-01-03 Thread Bryan Love
. +---+ 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

RE: Disable form field based on select box

2001-12-20 Thread Bryan Love
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

RE: CFLOCK and CFLOCATION

2001-12-20 Thread Bryan Love
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

RE: cfselect question

2001-12-19 Thread Bryan Love
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

RE: CF and Time

2001-12-19 Thread Bryan Love
when you write the queries! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble

RE: CF and Time

2001-12-19 Thread Bryan Love
if you are using SQL Server, use SMALLDATETIME +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED

RE: Quick Question

2001-12-19 Thread Bryan Love
Yup. 800x600 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let

RE: Form Processing Page

2001-12-19 Thread Bryan Love
of the two layers to swap places. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: SQL Licensing/User Question

2001-12-19 Thread Bryan Love
. +---+ 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

RE: CF and Time AM and PM

2001-12-19 Thread Bryan Love
-- // 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

RE: SQL Licensing/User Question

2001-12-19 Thread Bryan Love
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

RE: CF and Time AM and PM

2001-12-19 Thread 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

RE: IN condition... help?

2001-12-17 Thread Bryan Love
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

RE: tricky form question

2001-12-17 Thread Bryan Love
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

RE: Lists, Access, the IN sql operator - Help needed.

2001-12-14 Thread Bryan Love
preserveSingleQuotes() prevents CF from escaping single quotes +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED

RE: Lists, Access, the IN sql operator - Help needed.

2001-12-14 Thread Bryan Love
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

RE: Dynamic query columns weirdness

2001-12-14 Thread Bryan Love
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

RE: Passing form field data

2001-12-14 Thread Bryan Love
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

RE: What might be causing this cfserver error message?

2001-12-13 Thread Bryan Love
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

RE: Production server running way too slow (Long)

2001-12-13 Thread Bryan Love
. +---+ 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

RE: wharts wrong with this cfhttp?

2001-12-13 Thread Bryan Love
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

RE: regex for escaping ampersands

2001-12-13 Thread Bryan Love
= 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

RE: CFGRID Not updating

2001-12-13 Thread Bryan Love
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

RE: RegEx Help

2001-12-13 Thread Bryan Love
,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

RE: CFGRID Not updating

2001-12-13 Thread Bryan Love
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

RE: Displaying of HTML in page?

2001-12-12 Thread Bryan Love
actually I believe it's HTMLEditFormat() +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED

RE: How to Sort Multidimensional Array

2001-12-11 Thread Bryan Love
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

RE: Get PK value from Oracle table with AutoNumber Trigger (tds)?

2001-12-07 Thread Bryan Love
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. +

RE: Client vars - yet again!

2001-12-07 Thread Bryan Love
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,

RE: CFFile Replacment

2001-12-05 Thread Bryan Love
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:

RE: MS Access: True/False Questions

2001-12-05 Thread Bryan Love
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

RE: problems with backslash and quotes..

2001-12-03 Thread Bryan Love
+---+ 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

RE: AbleCommerce

2001-12-03 Thread Bryan Love
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

RE: Restricting execution of CF tag

2001-11-30 Thread Bryan Love
\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

RE: ArraySort

2001-11-30 Thread Bryan Love
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

RE: SQL Syntax

2001-11-29 Thread Bryan Love
differences between the two. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble

RE: cfif shorthand

2001-11-29 Thread Bryan Love
. +---+ 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

RE: RDS

2001-11-21 Thread Bryan Love
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

RE: Client variables and slow down

2001-11-21 Thread Bryan Love
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

RE: Question about CFGRID??

2001-11-20 Thread Bryan Love
', 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

RE: SQL To Sum data

2001-11-19 Thread Bryan Love
(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

RE: Looping through text string

2001-11-19 Thread Bryan Love
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

RE: is fileexists slow?

2001-11-16 Thread Bryan Love
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

RE: cfhttp error

2001-11-15 Thread Bryan Love
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

RE: convert from money to number

2001-11-15 Thread Bryan Love
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

RE: ODBC terror...

2001-11-14 Thread Bryan Love
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

RE: ODBC terror...

2001-11-14 Thread Bryan Love
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

RE: SQL Query

2001-11-13 Thread Bryan Love
- 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

RE: SQL INSERT

2001-11-13 Thread Bryan Love
, 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

RE: submitting a form with out a button? unload

2001-11-12 Thread Bryan Love
=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

RE: Multiple case statements in SCRIPT

2001-11-12 Thread Bryan Love
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

RE: tickcount to actual time conversion

2001-11-12 Thread Bryan Love
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

RE: left outer join - and null results (Lazy but Stumped)

2001-11-12 Thread Bryan Love
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

RE: Request Scope Questions

2001-11-12 Thread Bryan Love
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

RE: Inserting single quotes into SQL Server...

2001-11-12 Thread Bryan Love
() 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

RE: (sql) Between -- date range

2001-11-09 Thread Bryan Love
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

RE: Frames and variable scoping

2001-11-01 Thread Bryan Love
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

RE: CF reading the wrong file?

2001-10-31 Thread Bryan Love
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

RE: Sort two-dimensional array

2001-10-29 Thread Bryan Love
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

RE: User Login

2001-10-27 Thread Bryan Love
. 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

RE: Escaping Quotes

2001-10-27 Thread Bryan Love
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

RE: Access Question

2001-10-23 Thread Bryan Love
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

RE: Please Help: Parsing URL into Array and structure

2001-09-20 Thread Bryan Love
= 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

RE: help with moving from access to sql server

2001-09-04 Thread Bryan Love
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

RE: Displaying an image with CFcontent

2001-09-04 Thread 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

RE: Efficient Query Manipulation?

2001-08-31 Thread Bryan Love
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

RE: Quick format question

2001-08-31 Thread Bryan Love
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

RE: Attributes Scope Variable List

2001-08-31 Thread Bryan Love
cfloop collection=#attributes# item=i #i# = #evaluate(attributes. i)#br /cfloop Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED

<    1   2   3   4   5   6   >