RE: CREATE COLUMN

2001-01-30 Thread Christopher Olive, CIO
what database? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 2:13 PM To: CF-Talk Subject: CREATE COLUMN hey yall, how do i make a co9lumn in an existing

RE: Continuous Clock

2001-01-25 Thread Christopher Olive, CIO
you need to look into java, javscript, or some other client side scripting. try www.irt.org and their JS FAQ if you want to use javascript. it's WONDERFUL. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Cami Lawson

RE: array length of a dimension?

2001-01-25 Thread Christopher Olive, CIO
it doesn't really have a "length" for a whole 2D array. more of an area. or do you want the lengths of all the subarrays? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: Spaces in query column names

2001-01-24 Thread Christopher Olive, CIO
try aliasing the columns. if it's access, use []'s to enclose the column names. SELECT [bad column] as badcolumn, then use queryname.badcolumn to reference it in your CFOUTPUT. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: Sometimes I get so sick of CF being weak.... please help

2001-01-22 Thread Christopher Olive, CIO
why don't you turn it on at the beginning of the custom tag, then off again before you exit? or, conversely, why not turn it on before you call the tag, then back off after the tag call? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: Questio\n

2001-01-19 Thread Christopher Olive, CIO
what's the matter, the rest of us not good enough for you? :) i know dave is good, but... :) AFA your problem, this worked fine for me. displayed "stuff" cfset variable1 = "stuff" cfset variable2 = "variable1" CFOUTPUT #Evaluate(variable2)# /CFOUTPUT chris olive, cio cresco technologies

RE: Questio\n

2001-01-19 Thread Christopher Olive, CIO
, January 19, 2001 6:34 AM To: CF-Talk Subject: RE: Questio\n On 1/18/01, Christopher Olive, CIO penned: what's the matter, the rest of us not good enough for you? :) i know dave is good, but... :) AFA your problem, this worked fine for me. displayed "stuff" cfset variable1 = &qu

RE: Struct keys - if text, all upper case?

2001-01-18 Thread Christopher Olive, CIO
no, that's correct. (altough i can't speak for your crack smoking habits.:) internally, cf represents all structure keys as uppercase strings. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Scott Weikert [mailto:[EMAIL

RE: Slightly OT: SSL information

2001-01-18 Thread Christopher Olive, CIO
yeah. ask away. :) i did some security work as webadministrator for a DOD project with SSL. it's VERY easy to implement. are you using IIS? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Peter J. MacDonald [mailto:[EMAIL

RE: Adam, you got to be kidding?

2001-01-18 Thread Christopher Olive, CIO
how can you develop assuming that scripting is ON? if 2% of your customers have scripting disabled (just to use your numbers for a mo'), that's 2% of the people who WON'T be coming back to your site to buy something. that's like refusing to put in handicapped access ramps, because hey, only a

RE: data in columns

2001-01-18 Thread Christopher Olive, CIO
you could just try the count(*) operator. SELECT count(*) as thecount FROM wweb Where cbi like 'CBI' AND cbi IS NOT NULL this will give you a variabel queryname.thecount where cbi is equal to 'CBI' and cbi is not null. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: duplicating inserts

2001-01-17 Thread Christopher Olive, CIO
have the action page of your form do the insert, then use CFLOCATION to send the user to the result page. have not HTML/other markup in your action page. this effectively removes the action page from the user's "back" history. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: Cannot define a frameset in .CFM file?

2001-01-16 Thread Christopher Olive, CIO
aaah. do you have an application.cfm file with HTML in it? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 10:05 AM To: CF-Talk Subject: RE: Cannot

RE: skipping INPUT when tabbing

2001-01-16 Thread Christopher Olive, CIO
why not just change this.blur(); to "whateverthenextfieldnameis.focus();"? this will autotab to the next one, as well as not allowing the field in question to be changed. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Adrian

RE: JS Question

2001-01-15 Thread Christopher Olive, CIO
yes. onLoad="docment.form.controlname.focus();" in the BODY tag. www.irt.org has GREAT JS resources. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 11:13

RE: Replace

2001-01-15 Thread Christopher Olive, CIO
ALL needs to be in quotes. cfset strMyString = Replace(#strMyStringOld#, "ab", "bc", "ALL") chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Shari Jung [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 12:51 PM To:

RE: Cannot define a frameset in .CFM file?

2001-01-15 Thread Christopher Olive, CIO
you don't need a BODY in a frameset. this will work in IE, but NS is unforgiving. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 3:38 PM To: CF-Talk

RE: Sending to local printer from within CF

2001-01-12 Thread Christopher Olive, CIO
that will print to the printer associated with the browser. i think there's a tag in the developer gallery to do this. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]]

RE: Caching a Query: How To?

2001-01-12 Thread Christopher Olive, CIO
look into the CACHEDWITHIN and CACHEDAFTER attributes of CFQUERY. the docs are a bit obscure, but WITHIN is passed a time value, and will cache the query for that long. AFTER is passed a date value, and will cache the query until that date. chris olive, cio cresco technologies [EMAIL

RE: ColdFusion File Handling

2001-01-12 Thread Christopher Olive, CIO
no, not unless the user inputs the file size. CF resides on the server, there's no way for it to "look at" the client machine. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday,

RE: phone stuff and cf

2001-01-12 Thread Christopher Olive, CIO
voxeo is the company Jeremy demoed. they gave out cool shirts. :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 2:48 PM To: CF-Talk Subject: phone

RE: StructSort?

2001-01-12 Thread Christopher Olive, CIO
you could always use ArraySort(StructKeyArray(structname)) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 5:05 PM To: CF-Talk Subject: StructSort? Hey

RE: ColdFusion File Handling

2001-01-12 Thread Christopher Olive, CIO
not really. javascript cannot touch the filesystem because of the security sandbox in which it lives. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 8:00

RE: Regex prob

2001-01-12 Thread Christopher Olive, CIO
AFAIK, pipes are not necessary in the (weak) RE parser in CF. if you remove the |'s, you should be good. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001

RE: Can't you use qry.RecordCount when doing an update?

2001-01-11 Thread Christopher Olive, CIO
what did your CFQUERY look like? did you use ;'s between statements? i was playing around with cramming multiple statements in one CFQUERY, and could never get the darn things to work correctly. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: image root resolving

2001-01-11 Thread Christopher Olive, CIO
if you're using IIS, use the MMC to create a virtual directory to resolve to /images. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:35 AM To:

RE: Can't you use qry.RecordCount when doing an update?

2001-01-11 Thread Christopher Olive, CIO
sweet. thanks. you've solved an annoying question for me. :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 11:04 AM To: CF-Talk Subject: RE: Can't you use

RE: (little OT) MS Word 2000 convert to HTML

2001-01-10 Thread Christopher Olive, CIO
there's a perl script on CPAN that claims to do this. i haven't used it, so i can't speak for its effecitveness, but you might want to give it a try. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Eric Dawson [mailto:[EMAIL

RE: What should be easy has eluded me...

2001-01-10 Thread Christopher Olive, CIO
recordcount is the number of records returned by the query. you're looking for something like select agency, count(*) as thecount fromoimdbadm.assigned where completed = 'Incomplete' GROUP BY agency ORDER BY agency this will give you the number of

RE: App timeout and caching

2001-01-10 Thread Christopher Olive, CIO
that is correct, to the best of my knowledge and belief. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 11:35 PM To: CF-Talk Subject: App timeout and

RE: Allaire Curriculum License

2001-01-09 Thread Christopher Olive, CIO
i wasn't aware that they had a separate "curriculum license" program, other than becoming a training partner. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Erki Esken [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001

RE: Strange output phenomenon

2001-01-08 Thread Christopher Olive, CIO
the information shouldn't be going INTO the db with paragraph format. you should have WRAP="HARD" in your textarea control, then insert the data straight. PAaragraphForamt() is for output, not inuput. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com

RE: And the award goes to ......

2001-01-06 Thread Christopher Olive, CIO
do i get any credit since i quit my [EMAIL PROTECTED] job in september, and have been using this email address since? :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]] Sent:

RE: !-#include file=cfFile.cfm -

2001-01-04 Thread Christopher Olive, CIO
that's because a file with a .html extension doesn't get processed by CFAS. you need to map .html to the CFAS dll. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Thursday, January

RE: CF_NESTED_QUERIES_HELP

2000-12-29 Thread Christopher Olive, CIO
you can't use SELECT * in a subquery. ideally, it should return 1 value (such as product_id or some such) to use in your where clause. think of it as a rvalue in a WHERE clause. you're also missing a modifier (AND/OR) between your sub-selects. ideally, it should look something more like this:

RE: File Download

2000-12-28 Thread Christopher Olive, CIO
well, if the url is http://blahblah.com/myfile.zip, the browser will ask the user about saving/opening the file. unless of course, it's IE, where if it thinks it knows what kind of file it is, it will try to open it in the native program. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: SQL Dropdown List

2000-12-28 Thread Christopher Olive, CIO
your best bet is to do a union ex: SELECT blahblah this is your USA query FROM cities WHERE country = USA UNION SELECT blahblah your Non-us cities FROM cities WHERE country USA try that. a UNION "stacks" the queries on top of one another.

RE: Anonymous access failure in IIS NT4

2000-12-22 Thread Christopher Olive, CIO
have you resynced the anonymous password with the IUSR_MACHINE account via the MMC? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 11:37 AM To: CF-Talk

RE: JOIN and SUM

2000-12-19 Thread Christopher Olive, CIO
no, you can group by all those fields. this will give you a list of all ponumbers, their dates, the carrier, and the quantity shipped for each combination of these three. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Adrian

RE: JOIN and SUM

2000-12-19 Thread Christopher Olive, CIO
out about 15 fields from the master table, it seems like alot of fields to be GROUPing on, is this not a good thing to do? I guess it also depends on the data.. Thanks,Adrian -Original Message----- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] no, you can group by all those fields.

RE: JOIN and SUM

2000-12-18 Thread Christopher Olive, CIO
are you sure you want sum? or just a count of the entries in detail that are for PO number? try SELECT m.ponumber, sum(whatever field you are summing) as thecount FROM master m, detail d WHERE m.ponumber = d.ponumber if you DON'T want sum, replace it with

RE: JOIN and SUM

2000-12-18 Thread Christopher Olive, CIO
eally need to select multiple items from the master as well -Adrian -Original Message----- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Monday, December 18, 2000 5:36 PM To: CF-Talk Subject: RE: JOIN and SUM are you sure you want sum? or just a count of the entries

RE: Internet/Intranet applications based of CF

2000-12-14 Thread Christopher Olive, CIO
Mary Jo Sminkey has developed CFWebstore (at the cleverly named CFWebstore.com...). it's an out of the box e-commerce solution. are you looking for pricing models? or someone to sell it for you? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: Help on Pulldown - Please help...getting coldfusion rage here

2000-12-14 Thread Christopher Olive, CIO
why not do the select by hand? SELECT NAME="rowid" CFOUTPUT QUERY="court_q" OPTION VALUE="#court_q.rowid#"#court_q.whatever the fieldname of the county is# - #court_q.court_nm# /CFOUTPUT /SELECT chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: cflock vs. cftransaction

2000-12-13 Thread Christopher Olive, CIO
no, CFLOCK is only for restricting access to a server side variable. DBs don't benefit from this. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 12:41 PM To:

RE: cflock vs. cftransaction

2000-12-13 Thread Christopher Olive, CIO
the problem with that is that mySQL doesn't support transactions. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 1:29 PM To: CF-Talk Subject: Re:

RE: Postgres CF - good marriage or doomed to divorce?

2000-12-12 Thread Christopher Olive, CIO
i used Postgres with CF. i forget the actual metric, but postgres on its own handles in the hundreds of thousands of transactions per minute. seems pretty scalable to me. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL

RE: Replace

2000-12-11 Thread Christopher Olive, CIO
try CFSET TestString = "whatever you want this string to be" CFSET rs = REReplace(TestString, "[^0-9]", "", "ALL") chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: CF - to - UNIX

2000-12-06 Thread Christopher Olive, CIO
why not try perl? it's probably the best to do what it sounds like you want. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 2:43 PM To: CF-Talk

RE: Encryption problem when passed in URL?

2000-12-05 Thread Christopher Olive, CIO
why not URLEncreyptedFormat() is before you pass it along the URL? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Phill Gibson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 1:46 PM To: CF-Talk Subject: Encryption

RE: CF admin problem

2000-12-02 Thread Christopher Olive, CIO
not to be pedantic, but if you're restricting debug output to 127.0.0.1, are you browsing from the webserver console? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Friday, December

RE: UPDATE on a MS Access Database

2000-12-01 Thread Christopher Olive, CIO
well, you do have your where clause reversed, and with apostrophes. is it a numeric field? if so, take out the 's, reverese it, and you should be good. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL

RE: ListContains wierdness - why?

2000-12-01 Thread Christopher Olive, CIO
that's not necessarily true. a list rather effectively implements a queue type of situation, where the indexing of the variable is immaterial, it is only the order in which they are processed that matters. an array is not designed for that sort of thing. chris olive, cio cresco technologies

RE: GetToken or ListGetAt?

2000-11-30 Thread Christopher Olive, CIO
philosophically though, if you look at them, they're the same function. If you consider an average text string as a " " delimited list, that it. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: DeVoil, Nick [mailto:[EMAIL

RE: a question for everyone? Javascript writing to a hard drive?

2000-11-27 Thread Christopher Olive, CIO
short answer: you can't. longer answer: you most likely can't, because JS lives in a "security sandbox". this does not allow a script to touch the HD of the client machine for security purposes. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: a question for everyone? Javascript writing to a hard drive?

2000-11-27 Thread Christopher Olive, CIO
i think you're referring to windows scripting host. WSH is different than JS. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, November 27, 2000 5:15 PM To: CF-Talk

RE: deleting records

2000-11-21 Thread Christopher Olive, CIO
yup. looks like MM_recordId = "'" MM_recordId "'"; is your culprit. most ID fields in a DB are numbers. try removing that line, or, if you want to be pedantic, try MM_recordId = MM_recordId; that should work for you. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: Deleting Session Variables

2000-11-20 Thread Christopher Olive, CIO
actually, SESSION variables are in a structure (in 4.5+). you can do a StructDelete(SESSION, varname) to get rid of a particular SESSION variable. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Scott Wolf [mailto:[EMAIL

RE: Bizarre CFMAIL problem

2000-11-20 Thread Christopher Olive, CIO
sounds like your mail server is out of disk space. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 10:17 AM To: CF-Talk Subject: Bizarre CFMAIL problem

RE: Stucture help (from GetFunctionList)

2000-11-20 Thread Christopher Olive, CIO
STRUCTKEYLIST will do that for you. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 10:43 AM To: CF-Talk Subject: Stucture help (from GetFunctionList)

RE: Any good update/navigate/archive apps for large CF site?

2000-11-18 Thread Christopher Olive, CIO
i do something similar with this with the "news" of our site. (or at least, will be. it's in development.) just put a "display until" type date field in the article table. on your main news page, only list things that have an display until date greater than today. have a link to an archive

RE: HTTP Referrer

2000-11-18 Thread Christopher Olive, CIO
actually, use the ADDTOKEN="NO" attribute of CFLOCATION. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 18, 2000 8:03 AM To: CF-Talk Cc: [EMAIL PROTECTED] Subject: Re:

RE: file extensions

2000-11-17 Thread Christopher Olive, CIO
i think i remember reading somewhere that .dbm was a legacy naming convention from CF1.5. you could probably use it, but why? actually, you can have (almost) any file convention for CF. just map its extension to the CFML module in your ISAPI mappings (in IIS, at least) chris olive, cio cresco

RE: Nested Structures and Arrays

2000-11-16 Thread Christopher Olive, CIO
you haven't declared Session.Intake.Parent as anything yet. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Eric Gilbert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 9:01 PM To: CF-Talk Subject: Nested

RE: restarting Unix cf server

2000-11-16 Thread Christopher Olive, CIO
there should be a stop executable in the bin directory under the CFroot. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 6:28 PM To: CF-Talk Subject:

RE: Studio - left panel missing

2000-11-15 Thread Christopher Olive, CIO
try View-Resource Windows- dock all. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 1:29 PM To: CF-Talk Subject: Studio - left panel missing Hi, For some

RE: List Delimiter Question

2000-11-14 Thread Christopher Olive, CIO
when you're assembling the list, use a different character as the delimiter. perhaps the pipe symbol (|)? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Craig A. Zingerline [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November

RE: SQL error (minus the mess)

2000-11-13 Thread Christopher Olive, CIO
rd from my CFQUERY - but still receiving the same error of SQL operation unauthorized. Cheers Kylie - Original Message ----- From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 3:29 PM Subject: RE: SQ

RE: SQL error (minus the mess)

2000-11-13 Thread Christopher Olive, CIO
Cheers Kylie - Original Message - From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 4:42 PM Subject: RE: SQL error (minus the mess) ok, second round. when setting up the datasource, did you restrict acces

RE: SQL error (minus the mess)

2000-11-12 Thread Christopher Olive, CIO
at just a quick glance, is the username/password combination valid for that database? did you give access to the user "username"? access by default does not have security. try removing the username and password attributes from your CFQUERY. chris olive, cio cresco technologies [EMAIL

RE: [Cold Fusion Oracle]

2000-11-10 Thread Christopher Olive, CIO
if you're using the enterprise version of CF server (native drivers are only supported there, BTW) go to "Native Drivers" in the administrator. it's right under ODBC. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Peter

RE: Update Error

2000-11-09 Thread Christopher Olive, CIO
you don't need ticks around valid if it's a yes/no field. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jeremy Toevs [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 11:37 AM To: CF-Talk Subject: Update Error I

RE: Form Validate????

2000-11-09 Thread Christopher Olive, CIO
you can limit a text input field (not TEXTAREA) with the MAXLENGTH parameter. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Auction Hard Drive [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 12:31 PM To: CF-Talk

RE: Is Cold Fusion a Typed Language?

2000-11-08 Thread Christopher Olive, CIO
dunno about that. try ada. 10 different types of strings. :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 08, 2000 6:02 AM To: CF-Talk Subject: RE: Is

RE: Strange Access Problem

2000-11-05 Thread Christopher Olive, CIO
added into the database. How would I go about this? Thanks. - Original Message - From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, November 03, 2000 14:54 Subject: RE: Strange Access Problem you don't use a where clause for a

RE: sorting arrays

2000-11-04 Thread Christopher Olive, CIO
there's really no good way to sort a multidimensional array for one reason. CF represents a N dimensional array (internally) as an array of arrays. there's no "scalar" (sortable) value posessed by an array "object", so one cannot sort by it. perhaps if you told us what you're trying to do, we

RE: Strange Access Problem

2000-11-03 Thread Christopher Olive, CIO
you don't use a where clause for an insert. if you're trying to just do an insert, you need to put apostrophes around your #FORM.website# value. if you're doing an update, change your statement to UPDATE tblWebpageTest SET WebpageName = '#FileList.Name#', Website =

RE: Manipulating Cursor Position In Applications

2000-11-01 Thread Christopher Olive, CIO
you don't put the name of the file in there. you use the NAME attribute of the FORM tag. ex. FORM NAME="fred" ... INPUT NAME="UserId" ... /FORM ... /BODY Script document.fred.UserId.focus() /script /HTML btw, JS is case sensitive. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: Manipulating Cursor Position In Applications

2000-10-31 Thread Christopher Olive, CIO
use javascript in the onLoad event. onLoad="document.formname.fieldname.focus();" chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 31, 2000 2:02 PM To: CF-Talk Subject:

RE: Hmm..Calculate Elapsed Time

2000-10-25 Thread Christopher Olive, CIO
if you're using SQL server, there's an SQL function called DateDiff. it will calculate the difference of two date/time fields in the DB. there's also a CF function called DateDiff. it will calculate the difference of two date/time formatted strings (so you don't REALLY have to use datetime if

RE: Problem with email form validation

2000-10-24 Thread Christopher Olive, CIO
you need to add a "return false;" in there. like this function CheckEmail() { if(!ValidEmail(document.EmailForm.Email)) { alert("cfoutput#data.a73#/cfoutput"); return false; } return true; } otherwise, the script will always return true, and always think the email is

RE: disappearing form variables

2000-10-19 Thread Christopher Olive, CIO
actually, it does do back reference for REGXPs. use {} to denote the reference, and use \1...\n to reference them in your replacement string. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: BORKMAN Lee [mailto:[EMAIL

RE: disappearing form variables - yippee!!

2000-10-19 Thread Christopher Olive, CIO
? Many thanks, many apologies. Much embarrassment. Lee. -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] actually, it does do back reference for REGXPs. use {} to denote the reference, and use \1...\n to reference them in your replacement string. IMPORTANT

RE: Preventing Simultaneous Logins

2000-10-18 Thread Christopher Olive, CIO
my suggestion would be an APPLICATION scope variable of those logged in at the present time, along with their time of last activity. this is updated for each user on every page call to the secure area. when someone tries to log in, check the "currently logged in" structure (or data element of

RE: PostGreSQL

2000-10-15 Thread Christopher Olive, CIO
actually, i used it as a backend to CF on Linux. what are you trying to do? a "how to" is hard to come up with unless i know what you're after. of course, there's alwasy www.postgresql.org and the full documentation set...:) chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: PostGreSQL

2000-10-14 Thread Christopher Olive, CIO
yes. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 14, 2000 3:07 PM To: CF-Talk Subject: PostGreSQL Anyone out there using PostGreSQL with ColdFusion? Ian

RE: How can I do this (Query external data source)?

2000-09-29 Thread Christopher Olive, CIO
why not use WDDX or something like that? write a robot like action page (no HTML) that queries the DB and wraps the results in a WDDX package. then on your internal page, CFHTTP to that external robot page, grab the packet, decode it, and go nuts. chris olive, cio cresco technologies [EMAIL

RE: Custom Error Message

2000-09-28 Thread Christopher Olive, CIO
it will, actually. if you catch database errors, use some CFIFs against the native error code value (cleverly named NativeErrorCode) in CFCATCH. CFTRY ...Database insert stuff... /CFTRY CFCATCH TYPE="Database" CFIF NativeErrorCode EQ "whatevr the error code is for that unique key constraint"

RE: conditional where statement

2000-09-28 Thread Christopher Olive, CIO
only problem with that is that it will ALWAYS be true. 0 always equals 0. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 1:29 PM To: CF-Talk Subject:

RE: Personalized links

2000-09-26 Thread Christopher Olive, CIO
it's a comma delimited list. use list funcitons. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 1:13 PM To: CF-Talk Subject: Personalized links

RE: Urgent NAtive Driver Question

2000-09-25 Thread Christopher Olive, CIO
first thing: please don't post in HTML format. it makes code snippets VERY difficult to read. in your CFQUERY tag, do you have DBTYPE defined? if so, is it still "ODBC"? if it is, that'll cause problems. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com

RE: JavaScript object expected error

2000-09-25 Thread Christopher Olive, CIO
you shoule have function validateForm(theForm) {... and reference all objects on this form as theform.elements(i)... you're currently passing the form as a paramater ("return validateForm(this)") but aren't using it in the function. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: JavaScript object expected error

2000-09-25 Thread Christopher Olive, CIO
t;1") registeredCount = registeredCount + 1; } if (registeredCount #classname.class_size#){ alert('The maximum class size is " #classname.class_size# "."'); return false; } return true; }

RE: Fusebox [CF-Talk]

2000-09-22 Thread Christopher Olive, CIO
Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: 22 September 2000 10:59 To: CF-Talk Subject: RE: Fusebox [CF-Talk] OO is a good idea. in its place. i fail to see how you can discount OO based on what "games develop

RE: SQL Max Size

2000-09-22 Thread Christopher Olive, CIO
if this is for an intranet, why not just save the files to some web directory, and only store the links in the DB? it's a bit more manageable, in my experience. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Robert Everland

RE: Fusebox [CF-Talk]

2000-09-21 Thread Christopher Olive, CIO
OO is a good idea. in its place. i fail to see how you can discount OO based on what "games developer"s say. they're not the only ones that code. i'd also be curious to see some evidence/support for your size/speed argument. if you are subclassing objects that have methods or properties that

<    1   2