Re: OT: Access 2K and MSDE Connection Problem

you have the Client Network Utility installed on your workstation and configured to access the server? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

What and why are these errors happening?

art at the time of the errors. Also. What is this and how do I fix it? :-D "Error","TID=140","04/11/01","17:25:37","Unable to write reply -- timed out writing data back to web server." "Error","TID=140","04/11/01",&q

RE: What and why are these errors happening?

On 4/11/01, Peter J. MacDonald penned: Bud, I think the single quotes need to be double quotes. cfif not isdefined('session.id') changed to cfif not isdefined("session.id") Single quotes have worked fine for me for 2 years. The default session.id gets set fine when visitors

Re: CF Shopping Cart Solution?

eone gets confused. I'm easy and fun to deal with and have never had a chargeback against my merchant account. LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 95

RE: SQL 7 and 2000 on same machine?

versions on my development box. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion

Re: Is CF still relevant?

that ColdFusion is, generally speaking, the best solution for web application development in 2001? All of the above. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com

RE: SQL 7 and 2000 on same machine?

version). Do you have something to add to that? Nope. I mistakenly thought that the old version of EM remained with SQL 7. Thanks for setting me straight. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL

RE: WARNING: PCAnywhere

tickled pink that I found it. I just wish I would have found it before I purchased pcA. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

Re: Access/SQL/hosting question

. With the money you'll save initially, I'd suggest putting AT LEAST a gig of RAM on the server and as much CPU power as possible. You can upsize the Access dbs at your leisure and by then you'll know if you need to migrate your new SQL databases to a dedicated SQL server. -- Bud Schneehagen

Re: More locking confusion...

the setting of the request scoped variable. However if you store a complex structure, such as a query, in a session or application variable, then it creates a pointer and accessing the request scope would also need to be locked. -- Bud Schneehagen - Tropical Web Creations

Re: New CF5 Partner Hosting License

their cash to macromedia unless the return is worth it. I've done fine without querying queries and using built-in functions for 2 years now. I can go awhile longer. I tried my darndest to wait until the 30th when the official pricing is released. -- Bud Schneehagen - Tropical Web Creations

RE: New CF5 Partner Hosting License

I charge to host CF sites now is right at the upper limit of what an end user will pay that doesn't understand the technology or that doesn't have a very profitable website. So, I get out of the dynamic application hosting business or I take advantage of a free technology. -- Bud Schneehagen

RE: New CF5 Partner Hosting License

investment while being able to offer well performing, stable hosting to my clients. That will be hard to do spending 6k for a license for every 50 sites. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED

RE: New CF5 Partner Hosting License

a second...) Don't they charge for support? Of course they do, and I'm sure at a rate that is profitable for them. That should cover 1 and 2 nicely. As far as 3, it will be hard to fund development if nobody buys their product. -- Bud Schneehagen - Tropical Web Creations

Re: Update in CFquery is failing, somone code check this ?

Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Off the top of my head it looks like note may be a number field. In which case you will get that error if you try to insert anything but a number. -- Bud Schneehagen

Re: I'm sure this worked earlier

more fields to the sql and now it had buggered it all up. This is bugging me, any help will be very appreciated. I see you have all the other fields commented out. Are you sure they are all set to accept nulls and set as not required? -- Bud Schneehagen - Tropical Web Creations

RE: Connecting to MSDE on Another Server

that. I believe the database is named WebBoardPrimary, which is what you'll enter in the Login:Database field. Do all that and see if it verifies. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED

Re: SQL Server Licensing question

a month which I'll pass onto my clients, I'd probably rather not go to court with M$'s lawyers. ;) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

RE: MDAC Question

On 5/3/01, Thomas Chiverton penned: Also is there any performance gain in converting my access databses currently based on Access97 to Access2000? Probably not ;-) 2000 is more stable and less likely to eat up memory. -- Bud Schneehagen - Tropical Web Creations

Re: Has anyone seen this before?

://www.allaire.com/Handlers/index.cfm?ID=15821Method=Full -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

Re: CF5 Hosting License FAQ

you on. c) Learn another language. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your

.cfm extension and URLs

in .cgi or have a query string in the URL. Am I wrong? Any documentation you can point me to one way or the other? Thanks a bunch! -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http

RE: .cfm extension and URLs

On 5/15/01, Robert Long penned: Tell him to go to www.google.com and type in .cfm and tell you how many records are returned. Hi. He doesn't dispute that .cfm pages can be indexed, only that robots will not follow links with a .cfm extension. -- Bud Schneehagen - Tropical Web Creations

CF vs Perl

Hi all. I'm curious what the difference is, resource-wise, between CF and Perl for doing stuff like writing to a database, sending out simple forms, etc. Does CF use much more of the server's resources? Or is it comparable? Thanks, -- Bud Schneehagen - Tropical Web Creations

Re: CFLOCK with CF 5.0

clear of memory resident variables as possible and stick with client variables. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

ConnectionWrite (send()) error

a bunch. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get

Re: HTTP Headers, firwalls and malicious users

or not supported by the web server, so you don't have to check if they are defined. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

Re: OT: FTP Server

On 5/24/01, Duane Boudreau penned: Can anyone suggest a decent and moderatly priced (~ $250) FTP server that will run as a service unter Win2k? Serv-U Professional is 249.95. Best in the business as far as I know. http://www.serv-u.com/ -- Bud Schneehagen - Tropical Web Creations

Re: Weird CF error that is only on Mac machines?

a form and there is an error, I can't simply change the code and refresh because the form variables don't get reposted. And when I go back to submit the form again, if the page was cleared from the cache and I had submitted form variables to that page, I can't just refresh that page. -- Bud

Duplicating database row

Howdy all. Is there an easy way to duplicate a row in a database rather than querying for a record then doing an insert of a new record with identical data? Something that will work in both Access and SQL Server would be great. Thanks, -- Bud Schneehagen - Tropical Web Creations

Re: Curious about CFIF

with 1,000 lines of code and cfif, cfelseif all over the place, every little bit helps. And the same test running cfswitch had pretty similar results on the initial load, but reloads were always 0 or 1 ms. -- Bud Schneehagen - Tropical Web Creations

Re: IE4.5 Mac form problem issue! Help.

variables when there is more than one button, (more than one action based on the button you click). Try using a hidden input field since you only have 1 button and the variable should get passed. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions

Re: CFIF Help - Simple SQL Question:

- SQL IS or EQ - = IS NOT or NEQ - GT - LT - GTE - = LTE - = This gave me fits for months when I first started. LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http

Re: Alternative to CFSchedule?

allow it, do you mean they actually don't allow it, or they just won't set it up for you in cf administration? Because there is a way to create a schedule yourself with a template. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions

OT: SQL Server logical filenames

for any help you SQL gurus can give me on this one. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

Re: Shopping cart problem - no cookies, no deal

cfid=cftoken=xx at the end of EVERY link when cookies are disabled. if not, then the session will die wherever you don't pass it. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http

Which SQL ODBC Login method?

. Of course then if someone hacks into your ftp directory then they have your username and password. Thougths? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

RE: Which SQL ODBC Login method?

the database without actually seeing the source files. B. If you can get in to see the source files, then you could just do what you want from there anyway. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED

RE: Which SQL ODBC Login method?

=16;%20DELETE%20FROM%20Customers Well, that's not very reassuring. LOL I'm gonna be fixing some pages here right quick. This seems to do the trick at the top of the page. CFIF isdefined('ID') and (ID contains DELETE or ID contains Update)CFLOCATION url=#home# addtoken=no/CFIF -- Bud

Multiple mimeattach(ments)

Hi. Can you attach more than a single file to cfmail? (version 4.01). What would be the syntax if so? Thanky! -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com

Re: Multiple mimeattach(ments)

Howie. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get

Has anyone seen this?

files on my local machine work fine. The exact same application works fine on 10 other sites. It's gotta be a gremlin. I'm stumped on this for hours and I'd love to how this can possible happen. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion

Re: Fileexists

uot;Some other text" Adding some text you get for each server you're testing on when a file isn't found. Otherwise, I'm at a loss. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Developmen

RE: MSDE on Win2K... anyone successfully install it?

On 10/21/00, Jeff Beer penned: MSDE appears to the developer exactly like SQL Server. It does not come with SQL Enterprise Manager, so you'll either have to get a copy of that Is there a legal way to do that, short of purchasing SQL Server? Thanks, -- Bud Schneehagen - Tropical Web Creations

Regular Expressions in SELECT query

like to change the last 2 to pick up a full word in the middle of a field (#%') or at the end of a field (#') with one of the characters I mentioned (and a space for the 2nd one) at the end of the word, like: foo like '% bar#.,[space]?!' Can it be done? -- Bud Schneehagen - Tropical Web

Re: Suppressing Repeating Groups in a Query

uot;cfset prev_state = "" table border=1 cfoutput query="myquery" tr tdCFIF prev_myid IS myidnbsp;CFELSE#myid#/CFIF/td tdCFIF prev_code IS codenbsp;CFELSE#code#/CFIF/td tdCFIF prev_state IS statenbsp;CFELSE#state#/CFIF/td /trcfset prev_myid = myidcfset prev_code = codecfset prev

Re: Problem with CFFTP

On 10/29/00, paul smith penned: One of my users says his attempted use of CFFTP replies with a "CFObject Disabled By Administrator" error. I don't see where to enable/disable CFFTP CFFTP uses CFOBJECT, which CAN be disabled and probably is. -- Bud Schneehagen - Tropical Web

URGENT! Client variable help needed

ll for an answer to this. It's got me by the you know what. 5 gold stars to anyone that can give me a clue. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www

RE: URGENT! Client variable help needed

On 10/31/00, Stephen Moretti penned: It may be that something is seeing "total" as a reserved word somewhere along the way. Try changing 'total' to something a little more meaningful, such as 'CartTotal'. Yep, I did that after I sent the e-mail. No dice. -- Bud Schneehagen - Tr

RE: Hosting Question???

, with a meager 512 Kbps connection, and everyone is extremely pleased with the performance. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreatio

Re: Remote DB Alteration

bad query. CFQUERY DATASOURCE="your_datasource" NAME="breakodbclock" SELECT nota FROM nothing /CFQUERY This will return an error and break the lock on the database and you can upload right over it. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_

Re: Client Settings???

quot; list="#clientlist#" cfset temp = DeleteClientVariable('#i#') /cfloop -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreatio

Re: 2 Submit button on one form

submit the form. name="action" value="Do This" name="action" value="Do That" -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED]

Re: [Cached Queries]

wait 1/2 hour and set it back. This assures everyone is getting up to date records. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www

Re: [Cached Queries]

ucts (Records=1815, Time=Cached Query) SQL = SELECT product_id,product_name FROM products getproducts (Records=1815, Time=Cached Query) SQL = SELECT product_id,product_name FROM products getproducts (Records=1815, Time=90ms) SQL = SELECT product_id,product_name FROM products -- Bud Schn

Re: [Cached Queries]

On 11/11/00, pan penned: As a final test to see if reformatted sql affects caching I repeated A B with the difference that afetr a restart I excluded the reformatted sql call from the template but included it within B. Result is that Bud is absolutely right. My mistake was that I have a machine

PCodeDocumentNodeImp::validateSelf

What is that? It's giving me an error message on a custom tag (regular cf_ tag not a C++) on one site and not others and it never has before. PCodeDocumentNodeImp::validateSelf Nothing like an error message in English! Cripes! -- Bud Schneehagen - Tropical Web Creations

Re: [Cached Queries]

e loaded, and didn't work at times probably due to the same thing. I ended up just going to an extra screen to choose the state based on the country. An extra click, but still much quicker. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion S

Re: PCodeDocumentNodeImp::validateSelf

server and it went away. I'm using the same custom tag, that the PCode message said caused the error, under multiple sites and it only happened on the one, so it seems to be a random thing. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions

RE: PCodeDocumentNodeImp::validateSelf

nd except for the PCode error I got for the first time the other day, it's been solid as a rock. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 95

Re: rounding to first decimal

ecimal you want to round to: cfset number = round(2.146752 * 100) / 100 = 2.15 cfset number = round(2.146752 * 1000) / 1000 = 2.147 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTE

Re: clientVar storage/multiple CFAS/single storage db

database for each machine. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code

expiring cookies

Hi. I'm curious. I know when setting cookies using cfcookie, expires="1" expires it in one day. Can you set a value of say .25 to expire it in 6 hours? Thanks. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce D

Re: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS

cedure was used, what effect BLOCKFACTOR and MAXROWS have if the SP itself was limiting rows. I would think blockfactor would have the same results with SP. Maxrows is purely on the CF side of things. All rows from the query are returned with or without SP, but only the number you set as

RE: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS

be 32 / 1 for a blockfactor of 32? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion

RE: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS

it is not needed will hurt performance because allocating and freeing those larger buffers takes time (and takes memory away from where it could be more efficiently used). Well, how can you know when it's needed? Obviously, when doing a search, you may return 1,000 records, or you may return 1. -- Bud

RE: Caching Queries......

0 and wait a half hour and set it back. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your Col

Re: Caching Queries......

on the server. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get

RE: Caching Queries......

ning, do I need to have two query files, one with CACHEDWITHIN and another one without? If it's been in cache for 23 hours and you call it, you'll be good for another 24 hours. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce D

Re: Cookies

pplication tag. i have an application that i want to expire the CFTOKEN/CFID without expiring the other applications on the same server. Why not just delete the session for that application? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions /

Re: HELP HELP HELP!!!

#', /cfif Take a peek at this. If author2 is not defined, and anything after it is, required1 and the next field will not have a comma separating them. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce

Re: uploading tabular data...

;#datarow#" delimiters="#chr(9)#" #datafield# /cfloop /cfloop -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~

Re: Auto-deleting old events from CF events calendar

', -30, now()) CFQUERY DATASOURCE="#attributes.DSN#" DELETE FROM events WHERE eventdate #createodbcdate(deletedate)# /CFQUERY As far as auto deleting it, you'll need to set up a cfschedule or have it load every time someone accesses some page. -- Bud Schneehagen - Tropical Web

Re: Seamus' Stupid Stupid Thing

quot; is the default. Exit and save changes. Good luck. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Struc

Re: Query Question

, except you need to use AS. SELECT max(ACTLOGID) AS something, JobNum FROM activitylog Where Jobnum='1234' Then, ACTLOGID would be called as #queryname.something# Note: Remove the quotes if Jobnum is a number field. -- Bud Schneehagen - Tropical Web Creations

Re: CFFILE - writing a CF template woes

FFILE??? Someone had mentioned calling the page with CFHTTP - but that wont do, as no coldfusion code will show up... Help Please. How are you trying to write it? Better yet, how are you inputting the code? From a database? Pasting into a form field and submitting? -- Bud Schneehagen - Tropica

Re: Form Error

ion,DCApplication WHERE 0=3D0 ANDPDFs.AppID=3DDCApplication.AppID ANDPDFs.LocID=3DDCLocation.LocID CFIF #form.ReorderNo# NEQ 'All' AND PDFs.ReorderNo LIKE'%#form.ReorderNo#%' /CFIF David. If you can send this message as text, I'll try and look at it (and form error #2 as well). I can't read

Re: CFFILE - writing a CF template REDUX

olor=" chr(34) variables.myBGColor chr(34) "" chr(10) chr(10) variables.SomeVar chr(10) chr(10) "/body" chr(10) "/html" cffile action="WRITE" file= "C:\inetpub\wwwroot\testing\Page.cfm" addnewline="No" output="#Va

Re: access 2000

the Visual FoxPro ODBC Driver. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code wi

Re: Advanced queries

which match an email address in payments or invoices. You'll need to add 1 more join since you are using 3 tables in your From clause. You have payments joined to advert_details. Now you need to join invoices to payments will probably do the trick. -- Bud Schneehagen - Tr

Re: access 2000

? You won't HAVE to, but it will help with stability and memory leakage I believe. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

Re: carriage return question

mited list... Try: cfset mylist = "" cfloop index="listitem" list="#form.list#" delimiters="#chr(10)#" cfset mylist = listappend(mylist, listitem) /cfloop cfset session.list = mylist Lock when setting your session.list as appropriate for CF 4.0 or

Re: Help

uot; /TD On the Action page: cfif len(Attributes.DocLoc) cffile action="UPLOAD" filefield="DocLoc" destination="\\Cctest\Documents\" nameconflict="ERROR" accept="html" /cfif You shouldn't have any value in the cffile field. input t

Re: ColdFusion's Portal for LatinAmerica Spain

if he even saw your post. It personally wouldn't bother me if I got something of interest in my personal mailbox from a bona fide member of the list, like you Peter. I consider all of you friends. Of course, other people may feel differently. :-O -- Bud Schneehagen - Tropical Web Creations

Re: Who's hacking around ???

ned System Administrator. LOLOL Thanks a bunch for the link! -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 95

Re: Proper use of CFINCLUDE?

he leading slash. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fu

Re: Advanced Queries (take 2)

single quotes around the like parameters. Not sure though. I've never used "LIKE" in a table join. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED]

Re: newbie question

endance to 1. Note again, if members 3, 7, 8, and 10 were in attendance, form.ID will be passed as 3,7,8,10 CFQUERY DATASOURCE="LLL" UPDATE Attendance SET #form.month# = 1 WHERE cfloop index="ThisID" list="#form.ID#"ID = #ThisID# or /cfloop0=1 /cfquery Again, if

RE: Shopping Cart query

form.color Then I test against that. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your

Re: Which message-board to get

ther, as I find them harder to integrate into my code. Can anyone advise? I set up fusetalk for a customer and it was very easy and works real well. Runs on Access or SQL Server. The open source is pretty expensive though. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_

Re: Which message-board to get

On 12/9/00, W Luke penned: Do you have a URL for that Bud? fusetalk.com -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452

Re: Renaming a CF Server (NT/Win2K)

, has anyone run into any problems or quirks? Forewarned is forearmed... Hi Eric. If you don't get an asnwer to this here, try the WIN-NT list. Good resource. To subscribe: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=WINNT-L -- Bud Schneehagen - Tropical Web Creations

Re: Access ODBC error

wrong or something. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code

Re: cftry cfcatch/cfcatch/cftry

. Please advise or throw ideas (even bones will do) A bone: If you can put this at the VERY bottom and VERY top of every page, perhaps at the end of application.cfm and put the closing in OnRequestEnd.cfm? -- Bud Schneehagen - Tropical Web Creations

RE: Complex expressions w/ cfswitch

On 12/8/00, Hal Helms penned: No, you can't do that. Complex expressions aren't allowed in cfcase. You'd have to create a series of if/then statements. Thanks Hal. I didn't think so as I pulled my hair our trying it. LOL -- Bud Schneehagen - Tropical Web Creations

RE: cflock vs. cftransaction

ilable for Linux and/or mySQL. The only real problem I've seen so far is whenever I hit a cftransaction block. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~~

Re: Making changes to a live Database

y /html cfabort /CFIF Then I can just add "yes" and "within several minutes." or "by 10 PM EST." to the cfparam tags. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion So

Re: CFPARAM or CFSET

n is "action2" But, in example 3: cfset action="action1" Some code cfparam name="action" default="action2" Here the action remains as "action1". Only if action1 hadn't been set via cfset or a form

RE: LOCKING revisited...

iables in the future if need be. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure

Re: (ot) Domain Name Database

On 12/20/00, Eric Dawson penned: Where can I get a domain name database? Can't seem to find a good source. You mean a database containing all domain names? That would be one mean sucker. I'd hate to download it. -- Bud Schneehagen - Tropical Web Creations

  1   2   3   4   5   6   7   8   9   10   >