Re: Allaire on a Mac?

2001-01-23 Thread Nick Slay
r them. I don't like Macs, you do. I won't buy one you will. Let's end the > conversation or move it off of here before you get more flames. > > > > Bob Everland > > -Original Message- > From: Nick Slay [mailto:[EMAIL PROTECTED]] > Sent:

Re: Allaire on a Mac?

2001-01-23 Thread Nick Slay
Ah... but are you still running windows on it???:^) And one of the things I failed to mention about my Powerbook is that it has wireless networking UNREAL!! We have two PC's, a G4 Mac and this powerbook, and there are no cables between the Mac's and PC's, yet they have full network acces

Re: OT: RE: Allaire on a Mac?

2001-01-23 Thread Nick Slay
ytime I decide to browse the web or do anything that might tax it's poor >> little chips!! > > Run Linux or Win2k Pro, then see if your computer crashes. > > --=@ greg @=-- > - Original Message - > From: "Nick Slay" <[EMAIL PROTECTED]> > To: "

Re: OT: RE: Allaire on a Mac?

2001-01-23 Thread Nick Slay
And I got one!! hehehhee While being a PC user for ColdFusion development, I use an Apple Powerbook for EVERYTHING else.. mainly because I'm sick and tired of my PC freezing anytime I decide to browse the web or do anything that might tax it's poor little chips!! I have everything I need on this

Re: Allaire on a Mac?

2001-01-23 Thread Nick Slay
Macromedia tools are available on the Mac, Fireworks, Flash, Dreamweaver and Ultradev. (not sure about generator though) ===== Nick Slay Technical Director Webbods Pty Ltd (ACN 086 160 189) PO Box 4047 Copacabana NSW 2251 Tel: 02 4381 0284 Mob:

Re: SQL syntax problem

2001-01-21 Thread Nick Slay
Hi, you can use a function called PreserveSingleQuotes before storing the information to the database. At least that's what I think it's for!!! :^) > From: "Phoeun Pha" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 21 Nov 2000 19:31:42 -0600 > To: CF-Talk <[EMAIL PROTECTED]>

Help with grouping

2001-01-21 Thread Nick Slay
Ok, I'm beating my head trying to figure this one out, so I figured I'd try the list to see if anyone can help out before I tear ALL my hair out!!! I'm currently writing a Forum System, and I just can't figure out a way of grouping the messages correctly... If I have 10 messages entered, I want

Re: Newbie Question about Application.cfm

2001-01-09 Thread Nick Slay
Hi Athlene, The Application.cfm file should not have any HTML in the file, otherwise that get's put on the page. The CFAPPLICATION tag should be the first thing in the file. After that you can set your session variables, and output header code etc etc Nick > From: "Gieseman, Athelene" <[EMAI

Re: Calendar Question

2001-01-04 Thread Nick Slay
Oops, Sorry Duane, I misled you... after looking back through the code, I don't actually have a formula, I simply have a table that will display 4, 5 or 6 rows which is dynamically calculated using loops. So if you are after something that can only show 4 rows, or show 6, depending on the days

Re: Studio - left panel missing

2000-11-15 Thread Nick Slay
Try pressing F9 to re-open the resource tab! Nick > From: "W Luke" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Wed, 15 Nov 2000 18:28:35 - > To: CF-Talk <[EMAIL PROTECTED]> > Subject: Studio - left panel missing > > Hi, > > For some bizarre reason the left panel, with dire

Re: SQL7 count query

2000-11-08 Thread Nick Slay
Hi Kay, Try getting the counts as sub queries, for example SELECT COUNT(*) AS Artists, (SELECT COUNT(*) FROM Artworks) AS Artworks, (SELECT COUNT(*) FROM News) AS News FROM Artists Hope this helps a little! N\ > From: "Kay Smoljak" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROT

Session Variable vs Application.cfm Opinions

2000-10-12 Thread Nick Slay
-Transfer-Encoding: 7bit Content-Description: Card for Nick Slay Content-Disposition: attachment; filename="nickslay.vcf" begin:vcard n:Slay;Nick tel;cell:0414 810284 tel;home:02 4381 0284 tel;work:02 4381 0284 x-mozilla-html:FALSE url:http://www.webbods.com.au org:Webbods Pty Ltd adr:;

Re: Help with Anchor Tag

2000-10-11 Thread Nick Slay
uot;; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit But the '&' is coming through in the URL. Can you not just escape the hash with another #, so it looks like this? Robert Forsyth wrote: > the '&' is part of the '&##035;' or &

Re: Help with Anchor Tag

2000-10-11 Thread Nick Slay
--1232FE0970466C95AEECB53D Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit ooopp!!! Hold that thought... you could actually try REMOVING the & before the #1510 first!! :^) Nick Robert Forsyth

Re: Help with Anchor Tag

2000-10-11 Thread Nick Slay
-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar

Re: Wheel reinvention?

2000-10-10 Thread Nick Slay
x.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --86E1E185367D836B084256AE-- --EA50CD5CA090F4E146C54089 Content-Type: text/x-vcard; charset=us-ascii; name="nickslay.vcf" Content-Transfer-Encoding: 7bit Content-D

Re: SMS and CFM

2000-10-08 Thread Nick Slay
=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --38B460C3F75CA5D4BF638725-- --12275102467CEF6452F0E516 Content-Type: text/x-vcard; charse

Re: Autonumber?

2000-09-28 Thread Nick Slay
r=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --642EBD9C7220BF144AD611F4-- --18DED34028AA5599808DB230 Content-Type: text/

Re: SQL Stored Procedure Question...

2000-09-26 Thread Nick Slay
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --778FA7AB3A393FFA7903E735-- ---

Re: [CF-Talk] Automatic E-mail Daily !!!!

2000-09-19 Thread Nick Slay
sion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --374FE0F94DD20ACF25FC753C-- --35F056CA6E0261F69FD82875 Content-Type: text/x-vcard; charset=us-ascii; name="nickslay.vcf" Content-Transfe

Re: I am ashamed to ask this question

2000-09-11 Thread Nick Slay
t; > Thanks, > > Brandon > > -Original Message- > From: Nick Slay [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 11, 2000 9:59 PM > To: [EMAIL PROTECTED] > Subject: Re: I am ashamed to ask this question > > This is a multi-part message in MIME format. > ---

Re: I am ashamed to ask this question

2000-09-11 Thread Nick Slay
sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --E2EF1F783A55267E2016B800-- --504203CF46E683D24535EDA9 Content-Type: te

Re: Searching records with specific date values

2000-08-29 Thread Nick Slay
anAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index

Re: Dates

2000-08-24 Thread Nick Slay
k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --C5B1CED1872C5D6A5BF3D04F-- ------B98F7D204F3DEB6DAC11353E Content-Type: text/x-vcard; charset=us-ascii; name="nickslay.vcf" Content-Transfer-Encoding: 7bit Content-Description: Ca

Re: Mail Servers?

2000-08-23 Thread Nick Slay
ouseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --4D0756494B78D8296B69FFA2-- --58793D4CBCA3

Re: Mail Servers?

2000-08-23 Thread Nick Slay
t; http://www.airportnet.org">http://www.airportnet.org > > > > --- > > > > > > > > > > -- > > Archives: http://www.mail-archive

Re: Stored Procedure Not Working, Help?

2000-08-22 Thread Nick Slay
ot; VALUE="#Tax#"> <CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="TotalAmount" VALUE="#TotalAmount#"> I just tried adding the DBVARNAME parameter but that didn't help. Help? :) --

Re: CFStudio: really really bad?

2000-08-03 Thread Nick Slay
ts. Its a >> > really nasty crash too... I cant shut down, I have to power cycle. >> > >> > I brought this up on the Allaire Forums and found 45 other people agreeing >> > that it was unuseable. >> > >> > I read everyone in this mailing list using

Re: SQL Server Error

2000-07-25 Thread Nick Slay
x27;unsubscribe' in the body. --6295FC42334BFDBE7E090772-- --3AC1679D82E388DFA7B6332E Content-Type: text/x-vcard; charset=us-ascii; name="nickslay.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Nick Slay Content-Disposition: attachment; fil

Re: Mail Headers under CF4

2000-07-17 Thread Nick Slay
hives: http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=l

Re: Mail Headers under CF4

2000-07-16 Thread Nick Slay
d within the SUBJECT tag. > Also note the hard return after the subject value (before each custom > header) and the colon (:) instead of an equal sign. > > This solution is instead of paying for custom enhanced CFMAIL tags, > etc... -- let me know if it does the trick. > > Hope tha

Re: Mail Headers under CF4

2000-07-16 Thread Nick Slay
ax, and this service does it... the only trouble is you need to specify additional mail headers! Nick Mike Weaver wrote: > I'm sorry I am unable to help but would like information on the fax service > you use. > > Mike > - Original Message - > From: "

Mail Headers under CF4

2000-07-16 Thread Nick Slay
t-Transfer-Encoding: 7bit Content-Description: Card for Nick Slay Content-Disposition: attachment; filename="nickslay.vcf" begin:vcard n:Slay;Nick tel;cell:0414 810284 tel;home:02 4381 0284 tel;work:02 4381 0284 x-mozilla-html:FALSE url:http://www.webbods.com.au org:Webbods Pty Ltd adr:

Re: Stored Procedures

2000-07-14 Thread Nick Slay
age to [EMAIL PROTECTED] with 'unsubscribe' in the body. --93F79355261CF38FE03EE6E7 Content-Type: text/x-vcard; charset=us-ascii; name="nickslay.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Nick Slay Content-Disposition: attachment; filename=&

Re: FIrmware Design in Australia - anyone else deal with thesepeople?

2000-07-14 Thread Nick Slay
-- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -

Re: What are you using instead of IDENTITY...Part II

2000-07-12 Thread Nick Slay
sts&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --A7BE0BF80779091639066FC5-- --203822714A115D6C6B550678 Content-Type: text/x-vcard; charset=us-ascii; name="nickslay.vcf" Content-Transfer-Encoding: 7bi

Re: What are you using instead of IDENTITY...Part II

2000-07-12 Thread Nick Slay
>> Why is the city example a bad one? It's something that every address that >> is stored has, and can potentially contain many duplications. > > It is a good, real-world, example, IMO. I completely agree. > One thing you gain, regardless of key, is the domain constraint... > the employee's

Re: What are you using instead of IDENTITY...Part II

2000-07-12 Thread Nick Slay
Hi Sean, Yes, I understand what Joe is saying. But no one seems to be able to say WHY Joe is saying this. Why is he entirely correct? The true test that you mention would not fail if you set the database to allow identity inserts. Obviously this depends on the database, but I'm guessing if a

Re: What are you using instead of IDENTITY...Part II

2000-07-12 Thread Nick Slay
Is it just me, or does Joe seem to avoid the actual questions that Tom has asked?? Or have the questions been truncated in some way? Why is the city example a bad one? It's something that every address that is stored has, and can potentially contain many duplications. What is the relevance of

Re: Urgent

2000-07-11 Thread Nick Slay
Add the ORDER BY to the end of the query... ie, SELECT FirstName, LastName FROMClient ORDER BY LastName, FirstName You can also put DESC to order descending, ie, ORDER BY LastName DESC > From: "Pavan" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Wed, 12 Jul 2000 11:00:27 +1

Re: What are you using instead of IDENTITY?

2000-07-11 Thread Nick Slay
I'll second that!!! :^) I completely agree! We all have our own opinions, preferences and experiences, and until I can be convinced that Identity columns are bad, and 'real' primary keys are good, I will continue to use Identity columns. The benefits that they give me (most are listed below by

Re: What are you using instead of IDENTITY?

2000-07-11 Thread Nick Slay
One of the reasons I use Identoty columns is because it is so much more convenient when dealing with lists in things like VB and CF for that matter. If you have a primary key that consists of seven fields... and you want that information selecteable in a list, what do you set as the key?? At leas

Re: problem

2000-07-11 Thread Nick Slay
Hi, try this INSERT INTO ans_answer (ans_ans, ans_pol_id) VALUES ('¬', #ans_pol_id#) VALUES ('#form.ans_Answer1#', #ans_pol_id#) INSERT INTO ans_answer (ans_ans, ans_pol_id) VALUES ('¬', #ans_pol_id#) VALUES ('#form.ans_Answer2#', #ans_

Re: Source Control

2000-07-11 Thread Nick Slay
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: RE: Source Control > > Resurecting a previous thread on source control (see end for summary): > > Seems to be 2 options so far: > > 1. MS source safe - good, but hard to configure(?), and a possib

Re: SQL

2000-07-10 Thread Nick Slay
have you tried just putting NOT IN ? > From: "Adrian Cesana" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Mon, 10 Jul 2000 17:14:11 -0700 > To: <[EMAIL PROTECTED]> > Subject: SQL > > Is there anyway to do the opposite of this...? I need something like NOT IN. > > SELECT blah from

Re: Force database connections to close....

2000-07-10 Thread Nick Slay
Hi Joe, Can't this be controlled from the CF Administrator on a per ODBC connection level? If you look at the ODBC connections, there is an option to keep the connections open for that data source. I normally leave this as on, but I assume that unchecking that option would not keep the connect

Re: LessWhiteSpace

2000-07-09 Thread Nick Slay
Please excuse me, but I missed the original post here... I'm going to presume you were asking about all the white space in the CFML pages... and how to reduce it... if not, then I'm sorry!! If you are using CF Server 4.5, then you can use the CFSETTING Tag, and set the ENABLECFOUTPUTONLY paramete

Re: Getting the ID after insert...

2000-07-06 Thread Nick Slay
I guess it's half a dozen of one, and six of the other While there is an overhead in writing the stored procedures and CFSTOREDPROC tags, I think you'll find that the site performance will make up for it. If this is set up as a CFQUERY, then you're going to be making three database calls, o

Re: Hundreds of messages left undelivered ... why?

2000-07-06 Thread Nick Slay
e. > > Cheers, > Mike Kear > AFP Web Development > Windsor, NSW, Australia > > > > On Thu, 6 Jul 2000, Nick Slay wrote: > >> I'm not sure how many reasons there are for rejecting messages, in my >> experience, I know that specifying a sender addr

Re: Hundreds of messages left undelivered ... why?

2000-07-06 Thread Nick Slay
another client? If the 'undeliver' messages are placed there for a > good reason, then it wouldn't make much sense trying to send them again. > > Jim > > > -Original Message- > From: Nick Slay <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] <[E

Re: Hundreds of messages left undelivered ... why?

2000-07-05 Thread Nick Slay
ECTED] > Subject: Hundreds of messages left undelivered ... why? > > Yesterday, I did a dumb thing and got into a nasty pickle with my email > newsletter. I'm really grateful to Nick Slay for coming rapidly to my > rescue with the solution. > > Now I find there's another p

Re: sigh, still not working

2000-07-05 Thread Nick Slay
Greg, Check your fields on the second insert. You are passing #address# into City, #City# into State and #state# into Zip... are these correct? Also, is BoatYear a Text field? if it's not, remove the ' 's that are around the #boatyear# variable. Hope this helps a little > From: "gregg Kachel

Re: I really goofed here - but where?

2000-07-04 Thread Nick Slay
Yup.. the error is in the CFMAIL tag... you're including the QUERY parameter, which will send a copy to every address in the query maillist. So every time you loop through the maillist query, you are also sending a copy to every member in the list! Nick > From: Michael Kear <[EMAIL PROTECTED]>

Re: return value of Identity Column

2000-07-02 Thread Nick Slay
Or in the stored procedure you could save the @@IDENTITY in a variable and return it at the end... i.e: /*Do an insert here*/ INSERT BLAH BLAH DECLARE StoredId INT SELECT StoredId = @@IDENTITY /*Do 2nd Insert Statement*/ INSERT BLAH BLAH SELECT @StoreId This still doesn't require the need

Re: return value of Identity Column

2000-06-30 Thread Nick Slay
Hi Tom, I seem to recall that someone posted to this list a few weeks ago saying that there were no problems at all with using the @@IDENTITY method of getting the Identity Column. I've certainly used it ever since I've been writing stored procedures and have never experienced any problems, eve

RE: NULL using it in CF

2000-06-27 Thread Nick Slay
>But don't use: > Can you tell us why we shouldn't use this? >-- >Mark Warrick >Phone: (714) 547-5386 >Efax.com Fax: (801) 730-7289 >Personal Email: [EMAIL PROTECTED] >Personal URL: http://www.warrick.net >Business Email: [EMA

Re: Server times + international site

2000-06-27 Thread Nick Slay
Yup, I've done the very same thing Each member has a timezone id, and I use that to store ALL dates as GMT, and then calculate the local time when the records are retrieved. I wouldn't set the clock to GMT, as it may cause you problems if you want to mirror the site etc etc. Leaving it a

Re: Error 22005 calling SQL Server stored proc

2000-06-26 Thread Nick Slay
--=_1833866==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Try putting the MAXLENGTH attribute on the CFPROCPARAM's that are of type CF_SQL_VARCHAR. Hope this helps Nick At 13:56 26/06/00 +0100, you wrote: >This message is in MIME format. Since your m

Re: SourceSafe integration

2000-06-25 Thread Nick Slay
Hi Ken, I use SourceSafe with Studio and it seems to do the trick. I had a few problems with Studio 4.5, i.e. not reflecting the true checked in status of files, and so I went back to Studio 4. I haven't heard that the problems have been fixed and so I'm not game to try it again just yet!

Re: CFSTOREDPROC and Access97

2000-06-22 Thread Nick Slay
I haven't tried calling queries in Access 97 with CFSTOREDPROC, however I started development of a recent site using CFSTOREDPROC to call queries in Access 2000, this worked really well, and changing to SQL Server 7 later was pretty straightforward... the only trouble I had was that there wasn

Re: escaping special characters between

2000-06-21 Thread Nick Slay
Use another #. ie, TD BGCOLOR="##CC">#variable# At 15:47 21/06/00 -1000, you wrote: >This is most likely a stupidly simple question, but I can't seem to find a >solution in the reference books. How can a place a "#" inbetween >tags? > >i.e. > > > > >#variable > > > >This just pretend code,

Stored Procedure Help

2000-06-21 Thread Nick Slay
Now the list appears to be operational again, I'll try and throw this back out and see if anyone has any ideas! :^) I have a small stored procedure (do_something) that takes a parameter, adds a value to it, and then returns a value, straight forward enough, right but what I'd like to do i

RE: Mail Servers

2000-06-20 Thread Nick Slay
Have you looked at Merak Mail Pro? I'm not sure what the capacity is though. I use Merak Mail as my email server and am very happy with it... the support is excellent, the best I've ever come across for any product!! I have had feature requests implemented within a week!!! www.merakmail.

Re: Studio and MS Visual Source Safe

2000-06-19 Thread Nick Slay
I use Studio and Source Safe together. I had problems with source control integration under Studio 4.5, and from what I understand the problems still haven't been resolved, so I'm still using Studio 4.I wouldn't do any coding without having Source Safe to fall back on now, it's saved me fr

Scheduling Pages and CFSCHEDULE

2000-06-11 Thread Nick Slay
Hi, I wonder if anyone might be able to give me some pointers. I have a site in development, running under CF 4.5.1, and using SQL Server 7 as the backend database. I'd like to be able to schedule events, mainly the sending of email messages, to happen at specific times. I thought that CFS

SQL Stored Proc Question

2000-06-08 Thread Nick Slay
Hi, Just wondering if anyone can help with a SQL Server 7 Stored Procedure question. I have a stored procedure that returns a group of fields from a table. What I'd like to do is return a field which is the result of another stored procedure that does something to one of the fields from the t

Slightly OT: SQL Stored Procedures

2000-06-06 Thread Nick Slay
Hi, Just wondering if anyone can help with a SQL Server 7 Stored Procedure question. I have a stored procedure that returns a group of fields from a table. What I'd like to do is return a field which is the result of another stored procedure that does something to one of the fields from the

Re: Another question on performance

2000-06-06 Thread Nick Slay
. > >using scalar functions or T/SQL statements (SQL Server). > > > > From what I have heard/read/experienced, the SQL engine can probably > >do this a lot more efficiently that any CF routines you could write. > > > >Dick > > > > > >At 10

RE: CF Training?

2000-06-04 Thread Nick Slay
> willing to share ideas, code, and provide a CF sounding board. > > > > Sharon >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sid

RE: Another question on performance -- better than lists?

2000-06-03 Thread Nick Slay
In order to get the element specified in ListGetAt, CF still has to work through the list and find that element, which still means reading each character etc etc. You can do the same with an array without calling a funciton... nameofarray[elementno] If you can, use arrays over lists. At

RE: Another question on performance -- better than lists?

2000-06-03 Thread Nick Slay
Mike, Lists are slower because CF has to process the string character by character looking for delimiters. At 10:20 1/06/00 -0400, you wrote: > > ok... so when it comes to performance, it's better to use > > strutctures than > > arrays and both of those are better than lists. > >i thought list

Re: Another question on performance

2000-06-01 Thread Nick Slay
rom what I have heard/read/experienced, the SQL engine can probably >do this a lot more efficiently that any CF routines you could write. > >Dick > > >At 10:10 AM +1000 6/1/2000, Nick Slay wrote: > >ok... so when it comes to performance, it's better to use strutctures than &

cf-talk@houseoffusion.com

2000-06-01 Thread Nick Slay
Is it more efficient to use CFML scripting rather than tags? For example, I have some code that loops and does some calculations. At the moment I have this using lots of and tags... would it be quicker to put all this inside a tag. Thanks

Re: I want my #$# on the first of the month.

2000-05-31 Thread Nick Slay
From memory... CreateODBCDate( CreateDate(Year(Now(), Month(DateAdd("m", 1, Now())), 1)) At 16:32 31/05/00 -0400, you wrote: > > >I have been on a 23 hour coding spree to finish up a project. How do >you create an odbc date value for the first of next month? I thought >i had it but someth

Another question on performance

2000-05-31 Thread Nick Slay
ok... so when it comes to performance, it's better to use strutctures than arrays and both of those are better than lists. But what about queries? Queries that are generated using QueryNew as opposed to SQL statements. I have a SQL Query result set that I need to loop through, calculate a

Re: OT: Frames vs NoFrames

2000-05-30 Thread Nick Slay
Oh yeah... One other one... .Netscape calculates the borders in a funny way!! For example, if you have two columns say 160 pixels, and the other frame 100%, and the margins and borders are all set to 0 and NO etc, Netscape still does some funny things with that first column... it seems to st

Re: OT: Frames vs NoFrames

2000-05-30 Thread Nick Slay
This thread could open a nice long debate!!! :^) Personally, I like frames they make site navigation a breeze... however I have run into a couple of things that make me bang my head against a wall!! - Probably THE single most annoying omission from CF... you can't specify a target fram

Re: Removing spaces

2000-05-29 Thread Nick Slay
gotcha... the answer then, is not so good! :^)Unless anyone knows better, I think that you'll have to use a CFQUERY to Insert the records rather than CFINSERT. That way you can do the Replace() on the field. hmmm... the only other thing you could try, and I'm not sure if this will work,

RE: SQL server error

2000-05-29 Thread Nick Slay
You may also want to try the DBCC CHECKIDENT (tablename) just to make sure there aren't any problems with Identity columns if you are using them. At 22:49 29/05/00 -0400, you wrote: > > Can anyone tell me what may be causing the following error on > > NT4, SP5, CF4.01 & SQL7.0 SP2, MDAC 2.5 in

Re: Removing spaces

2000-05-29 Thread Nick Slay
Try Replace(Form.Field, " ", "") Nick At 19:18 29/05/00 -0500, you wrote: >I need a form field that accepts the data, but removes all appearances of >spaces from the field in case a user enters any. > >CW > >-- >Archive

Re: Source Control

2000-05-26 Thread Nick Slay
--=_428728268==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed I use SourceSafe all the time with CF Studio 4.1. Everything seems to work very well, I haven't come across any problems.. UNTIL... I installed Studio 4.5. It had terrible problems with s

Re: store encrypted datas in database

2000-05-26 Thread Nick Slay
After you encrypt the variable, convert it to base 64 before storing in the database... unfortunately the function to do this, ToBase64, is only available in CF 4.5. To encrypt, use and then when comparing later, use... HTHAL Nick At 08:59 26/05/00 -0400, you wrote: >I use te fu

Re: Problem with CFIF

2000-05-25 Thread Nick Slay
Just a suggestion, but try checking CheckEmail.RecordCount is GT 0 before you do the IF test to see if CheckEmail.Email EQ. At 18:39 25/05/00 -0700, you wrote: >Sorry, the first message was sent in HTML formathere it >is again. I am trying to use CFIF in a mailing list application to >do

Re: Slightly OT: Dev. for multiple browser versions

2000-05-25 Thread Nick Slay
: (703) 393-2659 >http://www.ebstor.com >http://www.pacel.com >email: [EMAIL PROTECTED] > >Chaos, panic, and disorder - my work here is done. >-- > >Nick Slay wrote: > > > > > > Now if only I

Re: Slightly OT: Dev. for multiple browser versions

2000-05-25 Thread Nick Slay
t;fax: (703) 393-2659 >http://www.ebstor.com >http://www.pacel.com >email: [EMAIL PROTECTED] > >Chaos, panic, and disorder - my work here is done. >-- > >Nick Slay wrote: > > > > DOH!!! What am I talking about. I've ordered VirtualPC for this >

Re: returning autoID after insert [sql] [tip]

2000-05-25 Thread Nick Slay
I'm a bit puzzled with this one. Why would you write a Trigger to fire after an Insert statement, when you can do it in one hit using SELECT @@IDENTITY after the INSERT Statement all in one stored procedure? CREATE PROCEDURE UserFunction_Add @FunctionId INT = 0 OUTPUT,

RE: Avoiding using the MAX function

2000-05-25 Thread Nick Slay
Hi Sean... >I find it very interesting that people don't recommend the use of UUID >as DB keys. In this way, using CreateUUID, CF would already know the >key value and the DB INSERT would proceed on it's own. I wasn't making any recommendations, I was simply answering a question that was asked

Re: Avoiding using the MAX function

2000-05-24 Thread Nick Slay
If the MAX() function is used within a transaction you should be ok. but it does mean two calls to the DB, instead of one. So there is a performance overhead... the worst performers in a web application are the calls to the database, so trying to reduce them as much as possible is a good

Re: Slightly OT: Dev. for multiple browser versions

2000-05-24 Thread Nick Slay
And not to mention all the problems with SourceSafe integration!! I tried 4.5, had lots of problems (like files being marked as checked out when they weren't etc etc), so I rolled back to 4.1. I believe these problems haven't been fixed in 4.5.1, but I'm not game to try it again! At 09:1

Re: Slightly OT: Dev. for multiple browser versions

2000-05-24 Thread Nick Slay
iable junk mwahhahahah'!!) At 15:51 24/05/00 -0700, you wrote: >At 8:23 AM +1000 5/25/2000, Nick Slay wrote: > > > >Now if only I could get a copy of CF Studio for the Mac... I'd ditch my PC > >faster than I could open the window and throw it out!! ;^) > > > &g

Re: Slightly OT: Dev. for multiple browser versions

2000-05-24 Thread Nick Slay
Dick, Thanks for all this information.. it makes me even happier with my decision to switch to a Powerbook with VirtualPC for my admin work/emailing etc etc!! Can't wait for it to arrive!! hehehe droool! What a spec. built-in modem, network adapter, hot-swappable DVD Drive, SVideo co

Re: I've got the alternating table row color blues

2000-05-24 Thread Nick Slay
Sorry for dropping in on this thread, but what you've said isn't strictly true although a little pedantic, the correct way of specifying colours in HTML is to put a # in front of the colour code, for example, #FF or #99CCFF, so the first output statement that you listed is actually co

RE: SQL Server

2000-05-23 Thread Nick Slay
>SQL Server has stored procedured Access 2000 finally has stored procedures too!! Not that I'm suggesting you use Access of course... but I find it makes developing a site easier using Access initially, and then upsizing to SQL when the site is ready to go live. Saves on a few table drop

Re: Authorization error - Directory access not allowed

2000-05-22 Thread Nick Slay
Could be because the index.cfm page doesn't exist on yahoo.com? If you browse to the url you get a page not found error. Nick At 23:45 22/05/00 -0700, you wrote: >I really thought this was working yesterday. > >The code: > > >http://www.yahoo.com/index.cfm" method="get"> > > >#c

Re: update year only

2000-05-22 Thread Nick Slay
Hi Adrian In SQL Server 6 you could use Date Functions in stored procedures or by executing script in the enterprise manager. I would say you can still do this in SQL Server 7. You should be able to do something like: UPDATE tablename SET datefield = DateAdd(yy, 1, datefield) WHERE whatever-

RE: Best Editor

2000-05-22 Thread Nick Slay
I'm a Studio user through and through and our designers use Dreamweaver. I second Philip's comments about Frontpage!!! At 10:44 22/05/00 +0100, you wrote: > > Which is the best editor out there that you fellow cf'ers like? > > > > Adobe Go Live > > Dreamweaver > > Homesite > > Frontpage > > Liq

Re: Wherefor art thou, CGI?

2000-05-19 Thread Nick Slay
hmmm... never had the chance of doing Romeo & Juliet at school :^( What an educational list this is :^) At 11:47 19/05/00 +0100, you wrote: > > >(For the record, WHEREFOR means "why" or "for which reason", it does not > > >mean "where" :-) ) > > > > h... so, Romeo, Romeo wherefor art

Re: COOKIE NOT EXPIRING IN IE 5.0

2000-05-18 Thread Nick Slay
Hi, I experienced the same problem with a site I was developing... I got around it using Client variables which seemed to work well. I'm not sure if it's an option for you, just thought I'd mention it! N I don't know if this will be At 17:59 18/05/00 -0500, you wrote: >Hi, > >I cannot to

Re: Pesky dollar format

2000-05-18 Thread Nick Slay
Do you really need to display the $ in the field? Could you not put it on the page before the text field?, then you wouldn't need to display the $ sign. Alternately, you could replace the $ with nothing using Replace(fieldname, "$", "") Nick At 15:18 18/05/00 -0700, you wrote: >Hi, All > >

RE: Wherefor art thou, CGI?

2000-05-18 Thread Nick Slay
>(For the record, WHEREFOR means "why" or "for which reason", it does not >mean "where" :-) ) h... so, Romeo, Romeo wherefor art thou Romeo... means... 'why are you Romeo? :^) -- Archives: http://www.eGroups.c

  1   2   >