RE: Using cfloop for query

2003-02-20 Thread Philip Arnold - ASP
> > > > ... > Convert it to an Array, unless you've only got less than 10 elements in the list... ListGetAt is horribly slow on large lists, as is ListLen ... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limi

RE: Should be easy :)

2003-02-20 Thread Philip Arnold - ASP
> Yes. To replace all, you'd make it 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 www.aspmedia.

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 > > Should read Don't use #'s where you don't need them Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.

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

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

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-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

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 Switchb

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

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
> 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 run

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

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 p

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 S

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 Multime

RE: Cfloop

2002-08-19 Thread Philip Arnold - ASP
> > Can You have nested > 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 inne

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 wa

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 remove

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 www.aspevents

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 ther

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 va

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: 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. > 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: 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 ou

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 > http://www.fusionauthority.com

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 case

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: 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
> > 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 Co

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=""; fo

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?

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 tim

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 fi

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: > >type="READONLY"> > > > > Do insert > > > > > > Would this cause any problems? Tag balancing - an open part of a tag MUST be on the same

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 Tec

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 Certifie

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 i

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: quotation marks" and their rules...

2002-07-29 Thread Philip Arnold - ASP
> > > 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, Len(status_code) will only break out of the loop if status_c

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 th

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
> 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 b

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 que

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 > i'd like to create a query object with the data from > the field(s) held in one row as opposed to multiple

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 C

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 negati

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 ar

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 access

RE: getting auto id from SQL Server

2002-06-27 Thread Philip Arnold - ASP
> How would this done with SQL Server Set nocount on Insert into myTable (field) Values (value) Select @@identiy as ID Set nocount off Query.ID Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www

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 a

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 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: 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: > > directory="c:\

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(, , ) SELECT @@Identity AS StaffMember_id SET NOCOUNT OFF Try that, it might make a difference Also, wha

RE: QueryAddColumn / QuerySetCell ??? Answer !!

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

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 www.as

RE: CFIF Statement

2002-06-24 Thread Philip Arnold - ASP
> > #LASTNAME#, #FIRSTNAME# > #DEPARTMENT# > 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 Arnold Technical Director Certified ColdFusion Developer A

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? > > #LASTNAME# Your CFIF says that the WHOLE LastName must be "A" Try Philip Arnold Technical Director Certifie

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 o

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 pa

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 re

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 >

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? http://w

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 thi

RE: CFFlush Client Var Error?

2002-06-14 Thread Philip Arnold - ASP
> If I create a new template with the ONLY content being > "testtest2", 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 do

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 b

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 see

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 >

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 simila

RE: iif driving me nuts

2002-06-12 Thread Philip Arnold - ASP
> Please help me with this or can you guys and gals tell me a > better way to code this. Of course the phrases will be > changed but this will give you the basic concept. > > #iif((qryquicklinks.recordcount gte 8), DE("onClick='alert("Sorry, you > suck")';"), DE("onClick='alert("You Deleted Me")'

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 d

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: 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: 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

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: 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 Philip Arnold Technical Director Certified ColdFusio

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

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 us

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. > > #officealias# > > > #ministryalias# > > I¹m asking for help in getting both offices and ministries > into one list of so

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: +

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..

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

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 A

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 t

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

RE:

2002-06-07 Thread Philip Arnold - ASP
> C:\temp>test.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 8

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 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.aspe

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: 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

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 CFINCL

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 (right(Form

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 Philip Arnold Technical Director Cert

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

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

RE: cf_ vs cfmodule (was: Quick question on custom tags)

2002-05-31 Thread Philip Arnold - ASP
> If I'm reading this correctly, the ones where CF_ is slower > is on Website Pro. Not all the time - the 4.5 one is faster on WSP, but since it's CF doing the work, how can WSP effect it? > OT: Is Website Pro even supported? What's the big hoopla about it? I > keep hearing about it, but ... I

RE: cf_ vs cfmodule (was: Quick question on custom tags)

2002-05-31 Thread Philip Arnold - ASP
> > Can I ask, which version of the server this is? In CF4 and 4.5, I know > > it's true, not done extensive (only simple) testing on 5 and > > not touched MX for this yet > > Testing was done on W2K Pro/IIS/CF5. OK, here's something VERY strange I tested it on 4 servers, each different hardware

RE: cfml - asp

2002-05-31 Thread Philip Arnold - ASP
> > I am trying to get pass dynamic CFML data from a cfm page > to a ASP page? > > > > Any ideas - custom tags etc? How do you intend to communicate between the 2? CFHTTP? Form submissions? If you only want to pass simple data, then use a form, it will allow you to pass data to anything - we cur

RE: cf_ vs cfmodule (was: Quick question on custom tags)

2002-05-31 Thread Philip Arnold - ASP
he > explicit template path, I was unable to find a consistant > winner one way or > the other. Based on what I've seen here I have a hard time > supporting the > statement that cfmodule is faster than cf_. Anyway, it was a > fun way to kill > a half hour. > > > > >

RE: Multiple Record Update--Resolved

2002-05-31 Thread Philip Arnold - ASP
> Thanks Phillip, > > That got me going in the right direction. No probs, glad to help 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 com

RE: Question for the experts... Can I change content after its already in CF Server's buffer?

2002-05-31 Thread Philip Arnold - ASP
> Here's a challenge... I need to have my Keyword and > description tags as the first tags in my head tag. For example, Here's another way of looking at it Do you use CFFLUSH? If not, put the HEADER parts into a variable, and the change them if needed At the bottom of the page use CFHEADER I

RE: Multiple Record Update

2002-05-31 Thread Philip Arnold - ASP
> Really? Even for just the small forms? - this works quite > quickly on the small forms - upon clicking submit I see the > confirmation page instantly. > > I'll keep that in mind though the SQL is more powerful anyhow What you've got to remember is that CFUPDATE is ugly, code wise, it does

  1   2   3   4   5   6   7   8   9   10   >