CreateODBCTime question

2000-06-23 Thread Gary McNeel, Jr.
s for, but apparently not. Or should I just use a char field for this. Sorry if this is too much detail or messy. Please feel free to contact me off-list. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 7

RE: Selecting one number from a list

2000-06-27 Thread Gary McNeel, Jr.
I completely agree with Dave. I am currently in the process of redesigning several important databases that were incorrectly designed in the beginning. Then tons (tonnes?) of CF code was written to handle the resulting problems as the database grew. The original designers backed themselves into a

RE: row numbers

2000-06-28 Thread Gary McNeel, Jr.
Try currentrow. Also tied to recordcount. #currentrow# #field1# #field2# etc. > -Original Message- > From: Douglas Jordon [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 28, 2000 11:19 AM > To: Cold Fusion List > Subject: row numbers > > > Is there a way to find out which row numb

RE: cf vs php

2000-06-28 Thread Gary McNeel, Jr.
rus, you name it. Anyway, my thoughts. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always encountered violent oppositio

RE: Great list WAS: Unsubscribe

2000-06-30 Thread Gary McNeel, Jr.
I could not agree with you more, John. I am on several lists and this is BY FAR the best. -Gary McNeel, Jr. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 30, 2000 8:46 AM > To: [EMAIL PROTECTED] > Subject: Great list W

RE: return value of Identity Column

2000-06-30 Thread Gary McNeel, Jr.
these days). This is my favorite and seems pretty fast. Feel free to contact me off list. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "The pol

Getting the ID after insert...

2000-07-06 Thread Gary McNeel, Jr.
'#Form.PartnerNumber#', '#Form.SourceID#', getdate()) Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great s

RE: (Admin) Re: List wierdness ... again

2000-07-11 Thread Gary McNeel, Jr.
LOL. Someone needs to teach Michael how to use his email program. -;) > -Original Message- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 10, 2000 3:10 AM > To: [EMAIL PROTECTED] > Subject: Re: (Admin) Re: List wierdness ... again > > > Whoops. Thought that was g

RE: RE: What are you using instead of IDENTITY?

2000-07-11 Thread Gary McNeel, Jr.
Man, am I glad I am not a DBA and let myself get constrained by hypothetical arguments. We have old databases here that did NOT use an IDENTITY field. Man, what a mess that has been. Example: For years the KEY to a manila file folder was the date and the number of applications done that day. This

RE: Cookies

2000-07-11 Thread Gary McNeel, Jr.
Or set a quick session variable, do the CFLOCATION and then convert the variable to a COOKIE, then delete the session variable on the CFLOCATIONed page. Works for me. Not sure in really high traffic site. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice Univer

RE: CF And Outlook Address Book

2000-07-12 Thread Gary McNeel, Jr.
Are you using Exchange Server and connecting with Outlook? You could Export your data from Exchange or Outlook (install the Export tools) and import into a database. That is how we did it, but data is static and needs to be dumped often. Was a quick fix. There may be a COM or DCOM way to tackle it

RE: CFLOCK and Client Variables

2000-07-13 Thread Gary McNeel, Jr.
es, and as a CF non-programmer type (regular expressions - we don't need no stinking regular expressions) they both have helped me tremendously. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC]

Forms question

2000-07-14 Thread Gary McNeel, Jr.
Is there a way to nest forms? Ex. I know I can to this programmaticly with CF by looking at values, was hoping for a faster way. TIA Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-

CFIF question...

2000-07-19 Thread Gary McNeel, Jr.
can you use BETWEEN or maybe IN in a cfif? ex: do something ex: do something Is there a better, faster way to do this? Thanks. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713

RE: Authorize.net or.......

2000-07-24 Thread Gary McNeel, Jr.
I (and some of my colleagues) have had very good luck with AuthorizeNet. Easy to setup and configure. I have not seen a good, updated CF custom tag lately though. -Gary McNeel > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 24, 2000 5:04 PM

RE: Calling SQL Server/NT gurus...

2000-07-26 Thread Gary McNeel, Jr.
Look in the SQL Books Online. Search on 'Server Memory Options'. This gives a pretty good overview of what is happening. For most purposes you want to let SQL server handle the memory configuration. Did you change yours? Are you setting it manually? Are you doing full-text searching? -Gary > --

RE: do stored procedures REALLY help performance?

2000-07-27 Thread Gary McNeel, Jr.
One of our programmers got good at, and we are now using, Transact/SQL (T-SQL) to great advantage. Stored procedures probably do speed things up, make it easier to correct or extend a commonly called procedure, etc. He found, for us anyhow, that it is easier to pass variables and such around using

RE: CFLOCKs.... is this really necessary?

2000-07-28 Thread Gary McNeel, Jr.
Sure, go to: http://www.hcfug.com/ -Gary McNeel > -Original Message- > From: Ann Harrell [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 28, 2000 10:26 AM > To: '[EMAIL PROTECTED]' > Subject: RE: CFLOCKs is this really necessary? > > > I just joined the list today. I would be int

RE: Date subtraction

2000-07-31 Thread Gary McNeel, Jr.
Sure ... if we had all of the thread. There would be NO thread if we all waited to see who sent back a reply first. Look at the times, about a 10-15 minute time span. (no flame intended) -Gary McNeel > -Original Message- > From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] > Sent: Monday,

RE: CV/Resume Project Descriptions

2000-07-31 Thread Gary McNeel, Jr.
y through school by doing this development. Ex: * 40% of tuition earned doing dynamic web development. Try not to use the word "I". Almost think in the 3rd person. Instead of: I have done this or that. Go with Have done this or that. Just some thoughts. Gary McNeel, Jr. Project Man

RE: congratulations Daddy Camden

2000-07-31 Thread Gary McNeel, Jr.
Congrats > -Original Message- > From: Jennifer [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 31, 2000 12:55 PM > To: [EMAIL PROTECTED] > Subject: congratulations Daddy Camden > > > I don't know if you guys have been informed yet, but congratulations to > Raymond Camden on the adopti

Working with a string...

2000-08-11 Thread Gary McNeel, Jr.
). TIA Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 http://dacnet.rice.edu/DAC-Net/Staff/Gary/ "Great spirits have always encountered violent o

RE: CFLOCK and server variables

2000-08-18 Thread Gary McNeel, Jr.
Yes. That is how you tell the application you want them enabled. -Gary > -Original Message- > From: Jake Hileman [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 18, 2000 7:01 PM > To: [EMAIL PROTECTED] > Subject: Re: CFLOCK and server variables > > > do you have to use application.cfm t

RE: Mail Servers?

2000-08-23 Thread Gary McNeel, Jr.
Mercury Mail Transport. We run it here. No problems. Works fine on NT. Free to cheap. http://www.pegasus.usa.com -Gary > -Original Message- > From: Neil Middleton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 23, 2000 10:39 AM > To: [EMAIL PROTECTED] > Subject: Re: Mail Servers?

RE: Dates

2000-08-24 Thread Gary McNeel, Jr.
...or > -Original Message- > From: Hinojosa, Robert [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 24, 2000 11:59 AM > To: '[EMAIL PROTECTED]' > Subject: RE: Dates > > > yes > > Robert Hinojosa > WebDeveloper > 512.912.3775 > [EMAIL PROTECTED] > www.cirrus.com > > -Original Mess

RE: cfcontent uncertainty

2000-08-25 Thread Gary McNeel, Jr.
Where can you find really good information about CFHEADER and the type of values that can be used in the attribute fields (NAME and VALUE)? Like value="inline;filename="mydocument.doc". Thanks. -Gary > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Thursday, Au

RE: MS Access V.S. SQL

2000-08-30 Thread Gary McNeel, Jr.
Hello Chad. Here at Rice we use Access for a lot of our simple sites. We have some DBs hold over 60,000 (yes, thousand) records with no problems. Our user load is low on these though, only 3-4 people working with them at any given moment. We do have some that have about 10-20 thousand records th

RE: (OT) making fields readonly with JavaScript

2000-08-31 Thread Gary McNeel, Jr.
Just FYI. We did use Javascript to do this (similar to code below). It worked fine in IE 4+, intermittent problems in Netscape 4+. Also, we found that people would turn off Javascript (for whatever reason) and whamo, no go on keeping them out. So if you are counting on this for some security reaso

Printing to User printers...

2000-09-15 Thread Gary McNeel, Jr.
to make it dynamic. Is there any way to do this with CF? Some way that, if the user knew the printer IP they wanted to print to, you could print to it? TIA and have a great weekend all. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall

Application.cfm Question...

2000-04-25 Thread Gary McNeel, Jr.
n AS LONG as they are not flushed (STRUCTCLEARED or DELETED) or changed? Why would running another application.cfm, that does not delete or change the earlier set application variables, make them unavailable to the application? Do you have to re-create the application.cfm file for each subfold

RE: Opportunity

2000-05-05 Thread Gary McNeel, Jr.
Jeez, enough with the pre-IPO and planned IPO stuff. Everyone is pre-IPO and planned IPO. > -Original Message- > From: THERESA [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 05, 2000 3:23 PM > To: '[EMAIL PROTECTED]' > Subject: OT: Opportunity > > > In need of Cold Fusion Developers for a

OT - SQL Server

2000-05-17 Thread Gary McNeel, Jr.
someone point me in the right direction? Thanks. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always encountered violent opposi

OT: Web Servers

2000-05-18 Thread Gary McNeel, Jr.
Is there a way to tell what another web site is running on? What type of server it is? Thanks. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 &q

RE: Will the last person leaving Cold Fusion please turn out the lights?

2000-05-18 Thread Gary McNeel, Jr.
ting line. What are they running in terms of having to open up the system? You can lock down almost any server if you pull off enough services, etc. It is then a matter of what functionality is lost. Other thoughts? Anyway, Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studi

RE: Automatically transferring data from one table to another

2000-05-30 Thread Gary McNeel, Jr.
flag set to Yes. SELECT * FROM Jokes WHERE Flag = Yes (or whatever your flag equals) That should work and no coping/duplicate tables and data. If you like you can then purge all No records later. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Hou

RE: CF vs. Oracle Application Server

2000-06-07 Thread Gary McNeel, Jr.
I have similar question. Our school uses the Exeter Student Information System (based on Oracle App. Forms)and is moving to web forms. Any feedback on this anyone? Gary McNeel > -Original Message- > From: Troy Simpson [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 02, 2000 4:20 PM > To:

RE: How to stop an infinite CF loop?

2000-06-16 Thread Gary McNeel, Jr.
Look at using CFBREAK in a conditional loop. You can find it's use in a loop on page 887 of the CF Web Application Const. Kit, Second Edition by Forta. > -Original Message- > From: Lon Lentz [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 12, 2000 8:34 AM > To: cftalk > Subject: How to st

RE: selecting random record from a database

2000-06-16 Thread Gary McNeel, Jr.
ith a better way to do it, using less processor time, who knows, maybe it is not significant. Again, thanks a bunch, I was probably just not that clear in my first post. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266

HELP: List questions...

2000-12-13 Thread Gary McNeel, Jr.
y better way to do this? Regards, Gary McNeel, Jr. DACNet Project Manager Research and Graduate Studies Rice University [OP] 713-348-6266 [M] 713-962-0885 [HO] 713-723-9240 ~~ Structure your ColdFusion code with Fusebox. Get the official

HELP: List questions...

2000-12-13 Thread Gary McNeel, Jr.
y better way to do this? Regards, Gary McNeel, Jr. DACNet Project Manager Research and Graduate Studies Rice University [OP] 713-348-6266 [M] 713-962-0885 [HO] 713-723-9240 ~~ Structure your ColdFusion code with Fusebox. Get the official

RE: CGI.HTTP_REFERER and SSL

2000-12-14 Thread Gary McNeel, Jr.
Maybe you could try to capture the cgi.Server_Name or IP instead? You may also want to look at the authorizenet merchant management section though. Login and click on settings. Then select Manage URLs. You'll want to configure this area. -Gary > -Original Message- > From: Chris Montgome

RE: Beware the imposter

2000-12-14 Thread Gary McNeel, Jr.
I confess, it was Uwe who did it. ;) (Moving to Cafe 182). -Gary > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 14, 2000 3:45 PM > To: CF-Talk > Subject: Re: Beware the imposter > > > Todd, what if he works from an internet cafe to

SQL DROP TABLE

2000-12-15 Thread Gary McNeel, Jr.
cannot figure this one out. Thank all. Regards, Gary McNeel, Jr. DACNet Project Manager Research and Graduate Studies Rice University [OP] 713-348-6266 [M] 713-962-0885 [HO] 713-723-9240 ~~ Structure your ColdFusion code with Fusebox. Get the

RE: SQL DROP TABLE

2000-12-15 Thread Gary McNeel, Jr.
ename' > > That should tell you if the table exists. > > Jeff Craig > ICQ 51303123 > > - Original Message - > From: "Gary McNeel, Jr." <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, December 15, 2000 6

RE: Danger of the +.htr bug

2000-12-19 Thread Gary McNeel, Jr.
Absolutely there is a danger. Just off the top of my head I can think of a few. These may not be best practice but: 1. If you put the username and password in a CFQUERY they can see that (and anything else). 2. If you just hard code a password or IP range to be blocked, or other information that

RE: colors...

2000-12-19 Thread Gary McNeel, Jr.
Cool. > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 19, 2000 12:13 PM > To: CF-Talk > Subject: colors... > > > Since there isn't a lot of activity on the list today, and I just > finished a > project (thanks to a lot of help from here), it must

RE: (OT): The +.htr bug strikes again becomes categorically executing want to be dev

2000-12-22 Thread Gary McNeel, Jr.
LOL. But actually, you are right. But aren't big corporations running the governement now anyway? They have been for 40 years. Alas, it will probably get worse now that President (S)elect Bush is in office. -Gary > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Fr

RE: (OT): The +.htr bug strikes again becomes categorically executing want to be dev

2000-12-22 Thread Gary McNeel, Jr.
Hey Eric, I am sending you a package in the mail. It will be in a plain brown wrapper with a return address like Ed McMahon and Company, that sounds like you may have won a lot of money. Just pick it up and shake it violently before ripping it open. Think of it as a holiday present. (Note: Please

RE: Any good Authorizenet solutions?

2001-01-05 Thread Gary McNeel, Jr.
gards, Gary McNeel, Jr. DACNet Senior Project Manager Research and Graduate Studies, Rice University [OP] 713-348-6266 [M] 713-962-0885 [HO] 713-723-9240 [HO] 713-723-9240 > -Original Message- > From: Aaron Johnson [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 05, 2001 9:

RE: CFMAIL question

2001-01-05 Thread Gary McNeel, Jr.
Read-up more on CFFILE. It can handle that for you. First it checks for a file with the same name in the appropriate directory. If it finds one it automagically renames the uploaded file to something like AC109.exe (whatever). It returns the new file name to you in a variable that you can manipula

RE: browser check

2001-01-09 Thread Gary McNeel, Jr.
Go to the CF Developers Exchange look at the custom tags that do this for you. AEBrowser (I think) is the one I use often, works great and returns a lot of useful information on the client that you can use to make good decisions. There are other good ones there too. I use it for checking browser t

RE: high profile CF sites...

2001-01-09 Thread Gary McNeel, Jr.
My guess is they were trying to get the ALT text to step-down in a box format. ex. MBE Online, Connect or Success, "The Complete Internet Access Service) It just did not work. Or maybe they want  ? -Gary > -Original Message- > From: JayB [mailto:[EMAIL PROTECTED]] > Sent: Tuesda

CFX_Excel Tag Error

2001-01-09 Thread Gary McNeel, Jr.
Automation Error while processing tag: The error occurred while processing an element with a general identifier of (CFX_EXCEL), occupying document position (41:1) to (42:220) in the template file (path info) Regards, Gary McNeel, Jr. DACNet Senior Project Manager Research and Graduate Studies

RE: Hosting with Webexpose.net

2001-01-12 Thread Gary McNeel, Jr.
These guys got hammered in a series of exchanges in this forum sometime back. You may want to look at the archives. http://www.mail-archive.com/cf-talk@houseoffusion.com/ -Gary > -Original Message- > From: Jason Larson [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 12, 2001 9:32 AM

OT: Objective and/or subjective reviews of MySQL, MS SQL Server and other SQL products...

2000-03-24 Thread Gary McNeel, Jr.
? What are it's limitations? Why would I use or not use it? Anything else anyone wants to add. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "

Houston CFUG...

2000-03-30 Thread Gary McNeel, Jr.
Does anyone know if there is a Houston CFUG? Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always encountered violent o

RE: Security holes revisited -- reward offered

2000-04-04 Thread Gary McNeel, Jr.
ugh I was employee number 30 something when they were young and struggling. lol) Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "The genius of our r

RE: Any known stability issues with CF Server 4.5 on NT?

2000-04-06 Thread Gary McNeel, Jr.
What web server are you running. We are running O'Reilly and there was a problem with AOL IE browsers seeing the site. Since we have a lot of those, we had to remove the server and go back to 4.1. This is documented both on Allaires and O'Reilly's sites, but no information on a resolution. Gary

Semi OT: Passing JavaScript variables to other CF/JS templates

2000-04-07 Thread Gary McNeel, Jr.
contact me off list. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always encountered violent opposition from mediocre minds.&qu

AOL Server and CF

2000-04-07 Thread Gary McNeel, Jr.
Anyone have any experience with this server? Good or bad. Know issues. Thanks. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits ha

RE: Semi OT: Passing JavaScript variables to other CF/JS templates

2000-04-07 Thread Gary McNeel, Jr.
Oops. I finally figured it out. Sorry for the bother folks. -Gary > -Original Message- > From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 07, 2000 4:45 PM > To: Cf-Talk > Subject: Semi OT: Passing JavaScript variables to other CF/JS templates >

RE: CF and DB2

2000-04-12 Thread Gary McNeel, Jr.
http://www.as400.ibm.com/clientaccess/ Look here. Client Access is a way PC's can talk to IBM systems. Dig around a bit here and I think you find what you need. Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266

CF and SQL on same server...

2000-04-12 Thread Gary McNeel, Jr.
boxes? Please don't respond if you just want to bash Compaq. TIA Gary McNeel, Jr. Project Manager - DAC-Net, Research & Graduate Studies Rice University - Houston [Lovett Hall] 713-348-6266 (Primary) [DAC] 713-348-5184 [M] 713-962-0885 [H] 713-723-9240 "Great spirits have always