RE: Should be easy :)

2003-02-20 Thread Philip Arnold - ASP
Yes. To replace all, you'd make it cfset temp = Replace(temp,.,,all) The all must be in quotes, otherwise it look s for a variable called all Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911

RE: Using cfloop for query

2003-02-20 Thread Philip Arnold - ASP
cfloop from=1 to=#ListLen(mylist)# index=i step=2 cfset firstelement = ListGetAt(mylist,i) cfset secondelement = ListGetAt(mylist,i+1) ... /cfloop Convert it to an Array, unless you've only got less than 10 elements in the list... ListGetAt is horribly slow on large

RE: Using a CFIF on RIGHT(#value#, 3)

2002-11-20 Thread Philip Arnold - ASP
Just a point, can I suggest you read Ben's To # or not to # article CFIF #CMFileName# IS NOT CFSWITCH EXPRESSION=RIGHT(#CMFileName#,3) Should read CFIF CMFileName IS NOT CFSWITCH EXPRESSION=#RIGHT(CMFileName,3)# Don't use #'s where you don't need them Philip Arnold Technical

RE: Query Column as an Array

2002-11-14 Thread Philip Arnold - ASP
Well - it's a little short - but not as short as it could be. You can do a ValueList() to turn any column into a List then use ListToArray() to get the array. It's not pretty, but it's only two functions and it works. ;^) Watch out for delimiters on this, if you use commas, then it'll make

RE: Using CFDirectory on every page

2002-11-06 Thread Philip Arnold - ASP
Is there a unacceptable performance hit if I were to use cfdirectory on every page of my site? What I want to do is look in each directory for an include and if it isn't there look for that include in the parent directory. This will allow me to use the same include for an entire section but

RE: HELP!! sql wierdness ERROR message

2002-11-05 Thread Philip Arnold - ASP
Honestly I'm still a little confused here... I still don't think that PerserveSingleQuotes() does what you suggest. As far as I understand it (which may turn out to be not at all) CF will automatically escape single quotes in variables placed inside a cfquery. I've never found it to be 100%

RE: HELP!! sql wierdness ERROR message

2002-11-05 Thread Philip Arnold - ASP
Isn't it impossible to do this when you're using Access? I know you shouldn't be using Access, etc., but I've never been able to get multiple SQL statements to work in Access. Is there a trick I'm missing, or is this just something else to live with and remind me I shouldn't be using

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
Not to argue with Ben, but I don't think that PreserveSingleQuotes() is the answer... That function prevents CF from automatically esacping single quotes (in this case you WANT CF to escape them for you). I think you're confused a little with what CF terms as escaping the single quotes It

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
It is not the only way, and it isn't a guaranteed way unless you rewrite your replace statements for each RDBMS. Each RDBMS uses different escape characters/sequences and delimiters. Use cfqueryparam. This is of course impossible if you're building your SQL in a string first and then running

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
Not being able to use cfqueryparam (or cfprocparam, which is also a typed variable) is a very good reason not to do that. Apart from that, using TSQL already confines you to using one specific RDBMS, so the exception I mentioned applies. Although I still doubt that somebody not being a

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
but if you want to do 50 small inserts in a row, in a row? Do you mean updates of one row of a table or subsequent inserts into a table? I mean inserting 50 rows into a table or multiple tables in the same database sending those requests as separate CFQuery tags is pretty much insane -

RE: HELP!! sql wierdness ERROR message

2002-11-04 Thread Philip Arnold - ASP
your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. I'm not talking about 50 fields, but 50 rows Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited

RE: Hiding Source Code...

2002-09-09 Thread Philip Arnold - ASP
From what I have read, their is no real effective way to hide source code in HTML, is their a way to hide source code with .cfm pages? If you're talking about client-side code (HTML, JavaScript, etc), then the answer is no. Jochem van Dieten, a regular list contributor, often posts this

RE: SQL Help

2002-08-20 Thread Philip Arnold - ASP
Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Try SWYNK.com - they have some useful stuff there Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia

RE: Can CF talk to a ODBC compliant db via an ISDN line.

2002-08-20 Thread Philip Arnold - ASP
My client has a sql DB server abroad that he connects to via an ISDN line to check status information of a cash transfer. His inhouse system built in VB does this.Qusetion is - is it possible to get CF to do the same? Any ideas as to how to proceed. As long as the server can talk to the SQL

RE: Cfloop

2002-08-19 Thread Philip Arnold - ASP
Can You have nested Cfloops Yes, but not through 2 queries (i think) The problem isn't that you can't loop through queries with nested loops, but that CF can't see the current record of outer loops from inner loops As long as you store the currentRow from the outer loop before entering the

RE: Friday Joke

2002-08-16 Thread Philip Arnold - ASP
http://www.zeetec.net/host/logs/ While (kinda) funny, this does not help towards the amount of OT talk on this list Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk

RE: CF Mail problem sending multiple times

2002-08-16 Thread Philip Arnold - ASP
Warning,1288,08/15/02,18:35:41,,Unable to move the spooled mail file, C:\CFusion\Mail\spool\BC91.cfmail. The process cannot access the file because it is being used by another process.. It is causing emails to be sent out over and over again because the file can't be removed from the spool

RE: debugging

2002-08-16 Thread Philip Arnold - ASP
We use dynamic ip's here that constantly change, so we can't list them in the CF Admin debugging. I'd like to be able to see the queries that are being run on my submit page, I've tried using mode=debug, but doesn't seem to work with the javascript form submit I'm using. Is there a way to

RE: Single Quote in Multiple Record Update Conundrum

2002-08-13 Thread Philip Arnold - ASP
I've got a form that allows updating multiple records using the code below. Works great except for one thingif the client types anything using a single quote or apostrophe ( ' ) into the Comments field, I get a Syntax Error PreserveSingleQuotes() only makes sure that the CF variable

RE: Extract substring from cgi.http_referer string

2002-08-13 Thread Philip Arnold - ASP
I need to extract d%3A%5Ctemp%5Ctestdir000\ and decode the line so it appears as d:\temp\testdir000\ I'm not sure of the correct syntax? http://127.0.0.1/test/index.cfm?dir=d%3A%5Ctemp%5Ctestdir000\ Look up URLdecode(), it does exactly that - unless you're running CF4.5, then there isn't

RE: cfflush

2002-08-09 Thread Philip Arnold - ASP
I have this below and want to output Product X updated! but I don't want it to output one per line. I need it to replace the output and update. Kind of like the loading % on a flash movie does. OK, for one thing, your OUTPUT variable will never change CFPARAM NAME=OUTPUT DEFAULT=Product:

RE: cfhttp

2002-08-09 Thread Philip Arnold - ASP
on the cfhttp tag for username and password.. is it wanting a system pasword or a username and password to login to a cold fusion tag? It's the username and password that would popup in the dialog box when you go to browse the location If the directory isn't secured, then you leave them out

RE: JavaScript Help - PLEASE!

2002-08-09 Thread Philip Arnold - ASP
I'm in a bit of a quandary here, and was hoping that some if the brilliant minds on this list could offer some insight. CF_SNIP Questions: Is there any way to spoof the DOM into thinking that the first form on the page is document.form[100]? (Can you override how the DOM indexes objects in

RE: post form variables to another action with cfhttp?

2002-08-09 Thread Philip Arnold - ASP
Can I post form variables to another action page with CFHTTP and have the user relocated to that action page at the same time? I'd rather not user JavaScript to submit the form if I don't have to and from what I know about cfhttp, it keeps the user on the originating server... I think

RE: DateDiff (Still Having Problems)

2002-08-03 Thread Philip Arnold - ASP
I thought I might have gotten it to work, but I was incorrect. There are 5 cases in table. Today is August 2nd. I dated 4 cases with dates of 8/4/2002 to simulate 2 days from due date. 1 case is dated 7/31/2002 to simulate over due. The results I am getting are as follows: 1 cases are

RE: Increments

2002-08-02 Thread Philip Arnold - ASP
Yes, as you realise IncrementValue() should generally be avoided. Really? I haven't seen this before. What's the rationale? Is it documented somewhere? It's a depreciated function - it's still there now, but it may not be in future releases Philip Arnold Technical Director Certified

RE: Increments

2002-08-02 Thread Philip Arnold - ASP
thats deprecated :-p OK, so I can't spell today :P Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company.

RE: Increments

2002-08-02 Thread Philip Arnold - ASP
It is NOT deprecated. So, has it been un-deprecated? For version 5 (and 4.5 I think) it was on the list... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An

RE: Passing Application Variables between Applications

2002-07-31 Thread Philip Arnold - ASP
I am working on a large-scale portal application and need some way to pass application variables between applications. I am wondering if anyone has any simple ideas on how to do this? For instance, I have an application running in a root directory and a second application running in

RE: Select Display Name?

2002-07-31 Thread Philip Arnold - ASP
Is there a way to reference the display name of a select box??? I need to store the select value and display name in an array I'm not sure I understand your problem The DisplayName is the name of the object, so it's form.whatever And the selected value is what's returned when the form is

RE: Passing Application Variables between Applications

2002-07-31 Thread Philip Arnold - ASP
You can certainly cfinclude application.cfm. I do it all the time. I know it has issues if you already have an application.cfm in the current folder It also depends on the version you're running - you never know if MM will stop it being includable... Philip Arnold Technical Director

RE: Unsubscribe

2002-07-31 Thread Philip Arnold - ASP
Unsubscribe FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts Look at the bottom of the message (I've copied it above) It's on every post Philip Arnold

RE: CFLOCK and CFIF

2002-07-31 Thread Philip Arnold - ASP
Hello list..Another, hopefully, quick question. Is there a problem with putting a cfif tag within a cflock? Here is an example: cflock timeout=45 throwontimeout=No name=look_pick type=READONLY cfif session.picks is Yes /cflock Do insert CFELSE CFLOCATION somewhere

RE: Passing Application Variables between Applications

2002-07-31 Thread Philip Arnold - ASP
You can certainly cfinclude application.cfm. I do it all the time. I'm trying to remember why I couldn't do it at the time - since then we've avoided it like the plague I know there's a reason, and it had something to so with the include levels, so that we had to rename the application.cfm

RE: evaluatives between hashes / and cf performance

2002-07-31 Thread Philip Arnold - ASP
Wow, thats good to know, thanks! A lot of my evaluate statements are done within a loop. Sounds like trouble right? The longer the list, the slower it gets Reason; ListToArray goes through the list once, then uses pointers to the locations ListGetAt starts at the front of the list every

RE: Studio 5 Install problem

2002-07-31 Thread Philip Arnold - ASP
In attempting to install Studio 5.0 the install works but the CFIDE directory is not created on the machine. I cannot access the CF administrator. The target box is a Win 98 running PWS. Can I just copy the CFIDE contents from another computer? What has happened in this install? Studio

RE: Good CFCatch code

2002-07-31 Thread Philip Arnold - ASP
Anyone have a snippet of code that would show all the information available when an error occurs? I am looking for something like what CF displays if I wasn't using the catch but I will email it to me when it does :) I prefer to do this (in CFscript) messageString=; for (i

RE: quotation marks and their rules...

2002-07-29 Thread Philip Arnold - ASP
cfloop condition=isDefined(status_code) and Len(#status_code#) why doesnt this make sense? it keeps buggin on me ARGHHH! yes, status_code was set to 0 prior to the beginning of the loop ;) If status_code is being set to 0 before the loop, then the isDefined() isn't needed Also,

RE: local vs. request

2002-07-25 Thread Philip Arnold - ASP
I try to avoid Custom Tags as much as possible.. takes twice the time to run compared to a Regular Includeby defining its own space. Unless its something low level(CFX) CF cant do.. why bother? One word - Recursion! You can't recurce (effectively) with a CFINCLUDE, but using a CF_ or

RE: Manually created queries,any limitations?

2002-07-25 Thread Philip Arnold - ASP
I'll break this into small parts; I have a field in a database which contains data over multiple rows in the database. (I didn't design the database nor can i change it) I'm sorry g i'd like to create a query object with the data from the field(s) held in one row as opposed to multiple

RE: Manually created queries,any limitations?

2002-07-25 Thread Philip Arnold - ASP
I'm trying to remember a while ago when I tried something similar and I found some anomalies regarding datatypes. I cant remember the details but think I had a query which did something along the lines of: Select name from Users where age 6 Where users was actually another query

RE: Transport port

2002-07-25 Thread Philip Arnold - ASP
I'd like to know if there is a method to know the Transport port (es. 9080) and the Transport mode (es HTTP) in CFML. CGI.SERVER_PORT gives you the current Transport Port, so 80 for HTTP and 443 for HTTPS CGI.SERVER_PROTOCOL gives you the basic protocol and it's version (HTTP and HTTPS are

RE: Transport port

2002-07-25 Thread Philip Arnold - ASP
No...this is the server port in audit for the http request. I want to know the effective transport port like http://localhost:9080 or http://localhost:9084 and so on. As Dave says, CHI.SERVER_PORT gives you the port, so it would return 9080 or 9084 respectively on your requests If you want

RE: Transport port

2002-07-25 Thread Philip Arnold - ASP
When I request a page from the server, the port 80 answers from the HTTP_Server. But in reality the plugin comunicate with the Application server trough the port 9080. I want to know if is possible to know this transport port. Is the plug-in talking to CF? If not, then CF can't return the

RE: 4 million messages per hour - --- CFMAIL Branch off.

2002-07-02 Thread Philip Arnold - ASP
I find it so amazingly quick now to grab some information from a form - and generate a few emails. Some times the key to developing is efficiency. But I am curious technically why you would not use it even for a simple message? Not questioning you - don't want to turn this to a negative -

RE: getting auto id from SQL Server

2002-06-27 Thread Philip Arnold - ASP
How would this done with SQL Server CFQUERY DATASOURCE=DSN NAME=query Set nocount on Insert into myTable (field) Values (value) Select identiy as ID Set nocount off /CFQUERY Query.ID Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20

RE: Outlook Appointment

2002-06-27 Thread Philip Arnold - ASP
I need to be able to add an appointment to Outlook on the user machine not the server is this possible with COM? This is impossible with COM unless you get them to download and execute a program you create Since COM is executed by opening a port to the application required, and then accessing

RE: Dynamic Array Help

2002-06-27 Thread Philip Arnold - ASP
Ok I've got my array However Now, I sent it back to where it needs to go... How do I take the data within the array and basically query it so I can sort it so I can parse the records out to populate my form??? WDDX? You can convert large data blocks into WDDX and pass them

RE: QueryAddColumn / QuerySetCell ??? Answer !!

2002-06-25 Thread Philip Arnold - ASP
Much easier to create column in SQL statement DUH!!! ( on my part ) cfquery name=qryJobAgent datasource=#setting.dsn# select *,JobsFound = 0,JobsRespondedTo = 0 from search_job where jobseeker_id = #client.jobseekerid# /cfquery Depending on your SQL flavor, you might want to do it

RE: CFQueryParam / @@Identity / CFMX problems

2002-06-25 Thread Philip Arnold - ASP
Just one thing, SQL Server doesn't need the semi-colons after the commands in this query, you could happily do SET NOCOUNT ON INSERT INTO StaffMembers(FirstName,LastName,EmailAddress) VALUES(cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Trim(attributes.FirstName)#, cfqueryparam

RE: cfloop in the cfmail tag?

2002-06-25 Thread Philip Arnold - ASP
Is it possible to use inside a tag? I want to filter through a directory list and only mail files with today's date. Specifically, I want to check the mail/undelivr folder each night and email the names and contents of entries for that day. Here is what I have: cfdirectory

RE: Browser Question

2002-06-25 Thread Philip Arnold - ASP
Then that's crazy! How do i protect my apps??? 3rd party software? Heh Simple - don't put them on the web g Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net

RE: EXCEL COM Object

2002-06-25 Thread Philip Arnold - ASP
Is there an Excel COM object that can be registered on the server instead of installing the Excel application on the server? COM requires an app to be on the server for it to call The problem is that if you want an Excel-like app on the server, then you might not have the same controls as

RE: CreateODBCDateTime: When do I have to use it?

2002-06-24 Thread Philip Arnold - ASP
When do I need to use CreateODBCDateTime() to insert a date to a sql-server-database? What happens with my code when I move to another database which uses instead of an ODBC-Connection an OLE-DB or JDBC-Connection? Do I have to change all my insert-queries? ODBCdateTime doesn't work on

RE: CFIF Statement

2002-06-24 Thread Philip Arnold - ASP
Trying to do a CFOUTPUT Statement that returns all of the lastname records that begin with the letter A, and order by lastnames, but the following is not working, any ideas? cfif LASTNAME IS A#LASTNAME#/cfif Your CFIF says that the WHOLE LastName must be A Try CFIF Left(LastName,1) is A

RE: CFIF Statement

2002-06-24 Thread Philip Arnold - ASP
CFOUTPUT QUERY=list cfif Left(LastName,1) eq A#LASTNAME#/CFIF, #FIRSTNAME# #DEPARTMENT#BR /CFOUTPUT On top of the Query suggestions... What you're doing here is only not displaying the surname, but quite happily displaying the FirstName and Department, no matter what the name is... Philip

RE: carriage returns in RegExpr's

2002-06-24 Thread Philip Arnold - ASP
Chr(13) is Carriage Return Chr(10) is Line Feed If a file is written with most text editors, then you'll get Chr(13)+Chr(10) Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk

RE: Getting datatype before SELECT

2002-06-20 Thread Philip Arnold - ASP
Does anyone know of a way to determine the datatype of a column in a SQL database before running a cfquery? I have created a dynamic query and need to determine the datatype of ColumnList fields before executing a query. If a person enters text and the table column is an integer the page

RE: CFTalk Archive Problem - Any Alternatives?

2002-06-18 Thread Philip Arnold - ASP
Anyone else noticed a problem with the CFTalk archive? Can't seem to get search resulots back from it. I've seen mention here of alternative resources for accessing it. Anyone have a url? I know Michael has been working on the archives Which one are you referring to being wrong?

RE: SOT : Leading 0's in csv file

2002-06-18 Thread Philip Arnold - ASP
I'm building a csv file and the data has a leading 0 in front -- for example: 0123,0456,0789 etc... When I bring it into excel, it shows as 123 , 456 , 789 etc. Is there any way I can output the .csv so that it retains that leading 0 when I bring it into excel? (My gut feeling is no, but

RE: Query to Multiple Horizontal Columns (ordered vertically)

2002-06-18 Thread Philip Arnold - ASP
Perhaps I haven't had enough coffee this morning. But I'm having the darnedest time wrapping my head around this one (or maybe I just got to the point of abstracting this one a little too much in my head): I have say (4-5) queries of variable record count and would like to split the results

RE: CFFlush Client Var Error?

2002-06-14 Thread Philip Arnold - ASP
Has anyone seen this error before, we just started using CFFlush for the first time and are getting this error... The amount of data you have stored in global client variables is too long. The Cookie header has already been sent to the client, most likely because a CFFLUSH tag has been

RE: CFFlush Client Var Error?

2002-06-14 Thread Philip Arnold - ASP
If I create a new template with the ONLY content being testCFFLUSHtest2, I *still* get the error message. Obviously, no client variables are being used/referenced/updated here. Try it in a folder without a CFAPPLICATION in it, see if that works - I have no problems with CFFLUSH as long as I

RE: Limit simultaneous requests

2002-06-14 Thread Philip Arnold - ASP
When CF queries a database, does it hold open a thread for the whole life of the query till the answer set is returned? For example, if I have 'Limit simultaneous requests' in the CF Administrator set to 5, and my database queries take 20 seconds to execute and return results, does this

RE: Com Help!

2002-06-13 Thread Philip Arnold - ASP
I'm new to com! And would like to know if the following is achievable. I am constructing a recruitment database, which holds cv's i need to be able to open the cv within the browser, allow changes to be made and then save it back to the server. If this is possible could someone point me

RE: Loading Large Files through a Browser

2002-06-13 Thread Philip Arnold - ASP
I was wondering if anybody out there has had any timeout issues when loading large files through the web browser with cffile. I have been trying to upload a 6 to 15 meg file through a file input field and the browser seems to time out, I don't get a cold fusion error just the browser seems

RE: Progress Bar

2002-06-12 Thread Philip Arnold - ASP
Anyone have a nice progress bar? Simplest way; Have a JavaScript function which draws a bar (named image) When you move the progress on, output a quick JavaScript bit of code calling said function, then CFFLUSH That should do it for you In Netscape you might have to play with iFrame or

RE: WYSIWYG HTML editors (a'la soEditor) for Macs ?

2002-06-12 Thread Philip Arnold - ASP
we have a client, who despite our best efforts ( :-) ) is steadfastly Macintosh. They won't purchase a PC, they won't even purchase Virtual PC. Now, in many of our administration systems we use soEditor (lite, not that it matters), which works wonderfully under IE on windows, and

RE: CF Cache size

2002-06-11 Thread Philip Arnold - ASP
What's a good rough formula for setting the cache size in the CF administrator? We've got a server with 1 gig of RAM, but the cache is only set to 2048 kb Don't forget that the cache is only used when it needs to be, so you could set it to 512Mb, and CF would just keep on expanding the

RE: Call a variable in a Custom Tag?

2002-06-11 Thread Philip Arnold - ASP
I know that, within a custom tag, I can set/update a variables on the calling page using the caller scope. However, is there a way to do the opposite? On the calling page, I'd like to reach in to the custom tag and pull out a variable that gets set. The reason why I'd like to do it this was

RE: Call a variable in a Custom Tag?

2002-06-11 Thread Philip Arnold - ASP
Thanks all. I didn't think you could do it, and your explanations make sense. I'm going to go the SetVariable() to solve my problem. It's not the use of SetVariable() that will solve your problems, but the scope you use on the variable Philip Arnold Technical Director Certified ColdFusion

RE: Hiding Info In View Source

2002-06-11 Thread Philip Arnold - ASP
Does anyone know of a way to hide some form fields in the view source code? It really boils down to what the visitor uses to view the source - if they use NotePad, sure (not sure which character to start with, but I think it's 26) I personally use CFStudio, so there's no way to block what I

RE: showing leading zeros in CSV

2002-06-10 Thread Philip Arnold - ASP
That's what I do for UPC codes... (Stick a single quote in front). Or do you mean ' vs ` ? Does one work different than the other when importing into Excel? I'd use the standard apostrophe, not the back one, but you can use any character that's easy to strip off (if you don't want to use

RE: showing leading zeros in CSV

2002-06-10 Thread Philip Arnold - ASP
The reason I ask (and this is for excel specifically) is that if you check a field that you've formatted to text, Excel actually puts a single quote in front of the value (you can see it in the contents of the cell in the bar at the top of the spreadsheet. I thought if you used one over the

RE: showing leading zeros in CSV

2002-06-10 Thread Philip Arnold - ASP
Yes, that's true, whether you used the native Excel single quote or not. My question is really which one of the two ' or ` is the native one, if either at all? If memory serves, it's ', but the simple answer is to try both g Philip Arnold Technical Director Certified ColdFusion Developer

RE: Hacking a shared SQL server

2002-06-07 Thread Philip Arnold - ASP
In a few months nobody is using CF 4.5 anyway. Really? And you can guarantee this? We have people on this list still using CF4, that's 3 generations old (since CFMX is out now) - people stick with software the know works... Not everybody can afford to/wants to upgrade to the latest software -

RE: dbm vs cfm (tds)

2002-06-07 Thread Philip Arnold - ASP
In fact, I encourage everyone to use .ray files. : Hey, that's a damn fine idea... CFMX2 running .ray files as default g Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk

RE: cfexecute

2002-06-07 Thread Philip Arnold - ASP
C:\temptest.bat output.txt I'd suggest putting a location before the output.txt, something like Test.bat c:\output.txt I'm not sure where CFEXECUTE calls the file from... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099

RE: Cffunction beware

2002-06-07 Thread Philip Arnold - ASP
This is very cool. However. If you get carried away with your #signs and write: #getpages(1,#variable#,3)# Ie, put pound signs inside the function, you get an error saying Missing argument name. which has nothing to do with your problem. So, use # signs correctly and don't put them in

RE: Hacking a shared SQL server

2002-06-07 Thread Philip Arnold - ASP
But are they running a shared host with sandbox security? Or do they only run code they consider trusted? Although there are probably thousands of systems around running CF 4.5.x, I would be surprised if there were more than a couple of dozen running shared hosting services, and less then

RE: Disguising the URL

2002-06-07 Thread Philip Arnold - ASP
I have a site using subdomains, with each subdomain in it's own subdirectory. The main domain is in it's own dir as well. Is there a way to make the URL show up as www.domain.com rather than www.domain.com/domain? Frames? Philip Arnold Technical Director Certified ColdFusion Developer ASP

RE: Disguising the URL

2002-06-07 Thread Philip Arnold - ASP
Eh? Apache - Virtualhost directive in httpd.conf IIS - create a virtual site and point it at whatever dir you like... Or am I missing some vital piece of info? :-) Form the way I read the original request, he wanted anyone who typed in www.domain.com/domain to only see www.domain.com in

RE: showing leading zeros in CSV

2002-06-07 Thread Philip Arnold - ASP
I am looking for a way to show numeric values in a csv file preserving leading zeros. For instance, say someone's ssn is 005353828 I want it to show up that way instead of 5353828. Anyone out there have any nuggets of wisdom to do this in excel? Stick an apostrophe in front of it... But if

RE: SOT: showing leading zeros in CSV

2002-06-07 Thread Philip Arnold - ASP
Can't you set the column properties to include leading zeroes? I know you can in Access, I had to do it for zip codes. It's a CSV, a text file - how do you set column types in a text file? Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44

RE: One alpha sort on two queries

2002-06-07 Thread Philip Arnold - ASP
I have two queries running, one is an office listing and the other is a ministry listing. I have a drop down list that is populated dynamically with the results. cfoutput query=qryallofficealias option value=office.#officeid##officealias#/option /cfoutput cfoutput

RE: Netscape and IE

2002-06-06 Thread Philip Arnold - ASP
Has anyone encountered a problem where some code will work perfectly in Netscape but not work in IE. I am specifically wondering if anyone has encountered a problem on an action page where the code will process fine in Netscape and get hung up in IE never timing out. If anyone has, I would

RE: CF MX works on WebSite Pro (was: RE: Ridiculous Problem!)

2002-06-06 Thread Philip Arnold - ASP
With all the woes that IIS has suffered (and also being a sentimental old bugger) it would be great for me to see Website Pro re emerge as a contender in the Webserver stakes. All we need now are the grumbles from the Website Orphans list to be sorted g Philip Arnold Technical Director

RE: Number formatting issue

2002-06-06 Thread Philip Arnold - ASP
I have a series of numbers that can have up two decimal places. I'd like to trim the trailing zeroes so that I have 9.56, 8.5 and 6 rather than 9.56, 8.50, and 6.00. What's the easiest way to do that? Write a UDF to do it... Function StripDigits(FormattedNumber) { If

RE: CF MX works on WebSite Pro (was: RE: Ridiculous Problem!)

2002-06-06 Thread Philip Arnold - ASP
Saying this, we have a client who used to use IIS - they thought they had all of the back-doors bolted... Then one of the Code Red variants came along and strolled straight through - they now use WSP Here are some things that IIS allows you to do: - handle server-side includes (I use

RE: CF MX works on WebSite Pro (was: RE: Ridiculous Problem!)

2002-06-06 Thread Philip Arnold - ASP
Well, I'm glad they're not using IIS then. However, this is an illustration of their inability to configure a server correctly, rather than an illustration of some special problem with IIS. I mean, this stuff is just not that hard. We're talking about ten minutes of initial configuration, or

RE: view Word document without showing URL

2002-06-05 Thread Philip Arnold - ASP
how can i pust a microsoft word document content into a client browser by not letting the user know the actual location and file name of the word document, is that possible? On top of CFCONTENT, you could always use Frames, that way you know the URL isn't displayed Personally though, I'd go

RE: Verity w/ Queries

2002-05-31 Thread Philip Arnold - ASP
Has anyone had any Verity issues w/ CF 5? I am indexing a Query and the bottom records of my recordset are not being indexed. If I reverse the ORDER BY, then the records that are not being indexed are FOUND. THis seems like a bug... any Ideas? I don't have maxrows specified at all

RE: Quick question on custom tags

2002-05-31 Thread Philip Arnold - ASP
Are there any internal implemenation details which make cfmodule faster than the cf_ syntax, or was this what you were refering to? Just curious... CFMODULE naturally runs faster than CF_, it's to do with the way it's calling the custom tag There are general issues with using CF_ and the

RE: Coldfusion and COM Limitations

2002-05-31 Thread Philip Arnold - ASP
We have a site which we are considering moving to CF from ASP. The site makes extensive use of COM objects so I wondered if they could be *easily* re-used. Does anyone know any restrictions/limitations or any other gothcas which could cause a problem? This REALLY depends on your version of

RE: Coldfusion and COM Limitations

2002-05-31 Thread Philip Arnold - ASP
I'd dispute that. I've run several COM apps that worked with CF 4 and 5 (and even CF 3!) on CF MX, and some work while others don't. CF MX uses a third-party COM interface for Java, JIntegra. I suspect that it has some limitations. True, I should have put As good as they've got - it's better

RE: Multiple Record Update

2002-05-31 Thread Philip Arnold - ASP
I have a form that displays multiple records populated from the database. Something like this: Department EmployeeName Add1(text input) Add2(text input) City (text input) EmployeeName Add1(text input) Add2(text input) City (text input) . . Department

RE: Coldfusion and COM Limitations (Test Results)

2002-05-31 Thread Philip Arnold - ASP
From Macromedia documention (ColdFusion MX - Migrating ColdFusion 5 Applications) Marcomedia has admitted calling COM Objects to be slower in CFMX cause they use JNI. Macromedia tests results for calling COM Objects were ColdFusion 5 completed = 50 Milliseconds ColdFusion MX completed =

RE: Coldfusion and COM Limitations

2002-05-31 Thread Philip Arnold - ASP
I've never used COM so I'm hoping it wont be too much trouble. COM, not too much trouble? HAHAHAHAHAHAHA! Sorry... Haven't had such a good laugh in ages COM can be a nightmare at times - don't go in thinking that it's going to be an easy process - if the COM object doesn't expost it's

RE: Multiple Record Update

2002-05-31 Thread Philip Arnold - ASP
On this, try to avoid using CFINSERT and CFUPDATE - they're horrible and slow, not to mention having memory leaks at times... Use real SQL as much as you can Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20

  1   2   3   4   5   6   7   8   9   10   >