RE: Restarting CF from Web

2001-05-15 Thread Raymond B.
Starting and stoping CF will generally require root/administrator access in default install. If you take the following suggestions make sure you're aware of how to exec system commands safely in a web accessible script. *NIX: - If your under *nix w/ Perl or PHP support; change to a user

RE: Harpoon Release is Final Available

2001-05-15 Thread Rich Wild
Heh, Could have saved myself some time by simply RTFM! Never mind, its always useful to see how someone else architects things: (From componentkit.pdf) Two mechanisms were evaluated for passing information from Macromedia ColdFusion to Macromedia Flash. One involved passing variables in over

Not very related - search engines

2001-05-15 Thread Heidi Belal
Have any of you got an idea about where i can submit my url to search engines. I need a place that will work. Plus i wanted to know, if i wanted each keyword to go to a certain page in the site not just to the homepage, is that possible? Or would that mean a separate submission for each page?!

RE: Harpoon Release is Final Available

2001-05-15 Thread Thomas Chiverton
I dont suppose anyone had the beta .zip file anywhere ? I'd like to have a look at the datagrid that they left out ! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: using WDDX for next 'n' style browsing

2001-05-15 Thread Kola Oyedeji
Dick Thanks for your advice, its funny but my boss just said the same thing (about using flash) My main goal was to not make another trip to the server (hence the use of javascript and wddx) Only the neccesary fields would be sent to the browser. I suggested using an applet but my boss pointed

RE: best search

2001-05-15 Thread James Maltby
OK - verity searches *best* on text files - and I gather you will be creating a collection of text files - but you have to consider the display of the content (i.e. to send the searcher to the correct page with the correct formatting) - what we have done historically is this five stage process:

RE: Restarting CF from Web

2001-05-15 Thread James Maltby
You can set up a batch file stop/start function and call it via telnet - safer than the http version in 4 On NT the code is something like: @echo off echo stopping ColdFusion... net stop Cold Fusion Application Server echo restarting ColdFusion... net start Cold Fusion Application Server

Re: best search

2001-05-15 Thread Michael Lugassy
My problem is that I'm already have 300mb of textual content. The Verity Connection to CF really rocks and can help significantly in design, but I don't think it can handle the amount of data. Are you familier with Microsoft Solutions for this? (i.e MSSQL Full Text Search?) As for your project,

RE: Does application tag need to be executed every time?

2001-05-15 Thread Kevan . Windle
It's only going to execute if application.name is not defined. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 15:15 To: CF-Talk Subject: Does application tag need to be executed every time? I have this code in my application tag: cfif NOT

RE: Code Snippet:Random Password Generator(repost)

2001-05-15 Thread Daniel Kemp
You could always run the output through a bad word filter and regen a password if there's a match (against the bad word list). But the rude words are so much easier to remember, or is that not the point? Dan. This message is intended only for the use of the person(s) (the intended

2 simpl q's about locking

2001-05-15 Thread Michael Lugassy
2 questions about locking: 1. Do I need to lock application.engines whenever I try to isDefined() it or is this enugh: CFIF IsDefined(appliaction.engines) CFLOCK cfoutput#application.engines#/cfoutput /CFLOCK /CFIF 2. The Timeout Value - does it represent the MAXIMUM time (in

RE: Does application tag need to be executed every time?

2001-05-15 Thread Kola Oyedeji
Right, which means after the first execution there is no call to the application tag I thought that this would mean that none of my session vars or application vars would work as the application tag has not been called in this page request but they seem to be fine? KOLa -Original

RE: 2 simpl q's about locking

2001-05-15 Thread Raymond B.
The timeout value repressents how long the process will wait to obtain a lock of the type specified. If throwontimeout is set to Yes it will raise an exception if a lock can not be obtained, if it's No then the code will skip to the end of the block (not executing anything in the block). Eg. 1)

RE: Query Help!! Problems???

2001-05-15 Thread Kevan . Windle
Not quite sure of the problem. Would you not expect mutiple records. Your where clause doesn't look like a unique identifier. -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 04:14 To: CF-Talk Subject: RE: Query Help!! Problems??? are

RE: Query Help!! Problems???

2001-05-15 Thread Andy Ewings
What are you expecting to get? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/

RE: Query Help!! Problems???

2001-05-15 Thread Andy Ewings
-- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890

well that's a task!!!

2001-05-15 Thread Michael Lugassy
I got this assignment recently: I need to create a thumbnail view of the front/home page of a given site. that should be done automaticlly, ofcourse. for example: I run this: CF_THUMBSITE site=http://www.imvamp.com; somehow I need to grab all of the site content and PICTURE IT as it were on a

RE: Does application tag need to be executed every time?

2001-05-15 Thread Kevan . Windle
the application tag enables session variables while the application is running. That only needs to be set once. Then session variables can eb set and maintained by cf. Application variabls will last the lifetime of the application anyway. -Original Message- From: Kola Oyedeji

Re: catalog.wci filling up hard drive space?

2001-05-15 Thread Tim Painter
Yes, that is the index for the index server. It's been a while, but I believe the space that it takes up is roughly 40-50% of the amount of space taken up by what it is indexing. If you are running newsgroups on the same server and indexing those, it can skyrocket. You can go into IIS and look

RE: best search

2001-05-15 Thread James Maltby
Sure - for v. big sites I have used AltaVista (www.dfee.gov.uk for example) and this is coolio - if I was to do it again though I would probably use Atomz.com stuff - for various reasons. Rationale for splitting full address into 3 parts: 1) Holding one url field means that you may as well use

Re: 2 simpl q's about locking

2001-05-15 Thread Michael Lugassy
Got it! and what about the isDefined(question) ? do you know the answer to it? Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: Does application tag need to be executed every time?

2001-05-15 Thread Michael Lugassy
will I need to lock the isDefined(application.name) code for application.name. I mean - should I lock the code just to check for var existence via isDefined? I know the rest of the code should be locked! Thanks, Michael Lugassy - Original Message - From: [EMAIL PROTECTED] To: CF-Talk

RE: 2 simpl q's about locking

2001-05-15 Thread Raymond B.
Sorry, it's late and I had completely forgetten about 1 by the time I finished reading 2.. hehe. I'm going to go a bit out on a limb here and say no. As you're only checking the symbol table to see if the name is defined -- not trying to get a coherent value from it or access the same memory

RE: Harpoon Release is Final Available

2001-05-15 Thread Benjamin S. Rogers
I have one of them (Beta 2?), though not the most recent. My guess is that they gave up on the grid and the tree since they duplicated the now reworked CFFORM Java applets do to be released in ColdFusion 5. E-mail me off list if you want a copy of file. Benjamin S. Rogers Web Developer, c4.net

Reworked CFFORM java applets ?

2001-05-15 Thread Thomas Chiverton
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] the now reworked CFFORM Java applets do to be released in ColdFusion 5. Does anyone have anymore details ? Specifcaly, does the new cfgrid provide the ability to specify data types (date, number) and defaults for new rows ?

OT: SQL Server 7 book(s) recommendation

2001-05-15 Thread Aidan Whitehall
My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can

RE: finding special characters in a list

2001-05-15 Thread Mike Townend
What you will probably have to do is use the Find() function in conjunction with the Chr() function. Ie to find a carriage return in some text you would Find(Chr(10) Chr(13), mystring) HTH -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14,

RE: SQL Server 7 book(s) recommendation

2001-05-15 Thread Andy Ewings
I've found the ones produced by Wrox Press and Que are good. I hear Professional SQL Server 2000 Programming by Robert Viera is quite good although I haven't read it. There are plenty of beginning SQL server books which are more likely to cover the basic Transact/and ANSI SQL language but they

Re: SQL Server 7 book(s) recommendation

2001-05-15 Thread Jon Hall
I bought Lan Times Guide to SQL, and it was a good book to get my feet wet. It doesn't get into anything SQL Server specific though, and sticks to the standards. I also got the black Using SQL Server 7 from Que. I was totally underwhelmed, stay away from it. I now have 2 of the SQL Server 2000

RE: CF and custom stylesheets

2001-05-15 Thread alistair . davidson
Hi Scott We did exactly the same thing - the trick seemed to be that the style.cfm page has to have a CFCONTENT tag in it, otherwise the browser just doesn't get it. By the way, we found that it killed performance by an incredible amount, so we switched to doing it by writing the stylesheet to

RE: SQL Server 7 book(s) recommendation

2001-05-15 Thread alistair . davidson
I'd recommend Inside Microsoft SQL Server 7.0 by Ron Soukup and Karen Delaney (Microsoft Press). It's fifty something quid, but it goes into a lot of detail on just about every aspect of SQL 7, T-SQL included. It's a right rivetin' read..almost as good as Fly Fishing by J.R. Hartley.

CFFORM Bug !!

2001-05-15 Thread Hamid Hossain
Hi, I tried to use CFForm with GET as a method but when I ran the cfm I found that CF server changed my method to POST !! I found this bug in CF 4.0 and 4.51. So, It is over versions bug !! any suggestions will be appreciated. Hamid Hossain Saudi Arabia

RE: SQL Server 7 book(s) recommendation

2001-05-15 Thread Darren Adams
I have that Professional SQL Server 7 and think its quite a good book. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 13:54 To: CF-Talk Subject: RE: SQL Server 7 book(s) recommendation I've found the ones produced by Wrox Press and Que are good. I

RE: SQL Server 7 book(s) recommendation

2001-05-15 Thread DeVoil, Nick
Aidan, I'm afraid this is a negative one as well, but on the strength of Amazon ratings I bought a very expensive M$ Press book called something like SQL Server 7.0 Database Implementation Kit which did include a 3-month eval of the DBMS but was very superficial. The only use I've found for it

Re: CFFORM Bug !!

2001-05-15 Thread David E. Crawford
That is expected behavior. DC - Original Message - From: Hamid Hossain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 09:27 Subject: CFFORM Bug !! Hi, I tried to use CFForm with GET as a method but when I ran the cfm I found that CF server changed my

RE: SQL Server 7 book(s) recommendation

2001-05-15 Thread Kurt Ward
Personally, I think the M$ books are too vague (rendering them useless), and a waste of money. The best book I've come across (and has since been referred to as the bible) is Transact-SQL Programming from O'Reilly. It covers MS SQL 7 and certainly has more than just T-SQL. Kurt -Original

Re: CFFORM Bug !!

2001-05-15 Thread David E. Crawford
To further clarify: the FORM scope is only availble to CF if the method was POST. So it only makes sense that CFFORM uses the POST scope when it writes out the FORM block. DC - Original Message - From: David E. Crawford [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May

Re: CFFORM Bug !!

2001-05-15 Thread savan . thongvanh
it's not a bug. the docs SAY that cfform only takes post. Hamid Hossain [EMAIL PROTECTED] on 05/15/2001 08:27:32 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: CFFORM Bug !! Hi, I tried to use CFForm with GET as a method but when I ran the cfm I

ACP + M? What's it gonna be?

2001-05-15 Thread Critter
Hello cf-talk, In regards to certificaton, I would assume that it cannot be called MCP (Macromedia Certified Professional), will it still stay ACP (Allaire Certified Professional) ?? Critter ~~ Structure your ColdFusion code with

hiding the path of an included file

2001-05-15 Thread Todd Ashworth
I have this in one of my style sheets: ..mask { cfoutputbehavior : url(#Attributes.ApplicationPath#/mask_js.htc);/cfoutput } When this runs, it shows the path to the mask_js.htc file if someone views source. I would like to hide this path, so that no one can download thit file easily.

RE: finding special characters in a list

2001-05-15 Thread Stephenie Hamilton
this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie -Original Message- From: Mike Townend [mailto:[EMAIL

RE: hiding the path of an included file

2001-05-15 Thread Dave Watts
I have this in one of my style sheets: ..mask { cfoutputbehavior : url(#Attributes.ApplicationPath#/mask_js.htc);/cfoutput } When this runs, it shows the path to the mask_js.htc file if someone views source. I would like to hide this path, so that no one can download thit file

Re: finding special characters in a list

2001-05-15 Thread Michael Dinowitz
* Team Allaire * It may be either a chr(13) or a chr(10). Look for each individually. this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText =

RE: finding special characters in a list

2001-05-15 Thread Howarth, Craig (IBK-NY)
You have them reversed. Try cfset errorText = Find(Chr(13) Chr(10), mylist). -Original Message- From: Stephenie Hamilton [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 10:28 AM To: CF-Talk Subject: RE: finding special characters in a list this doesn't seem to work,

Re: finding special characters in a list

2001-05-15 Thread David E. Crawford
CR is generally CHR(13)+CHR(10) in that order. DC - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 10:28 Subject: RE: finding special characters in a list this doesn't seem to work, i need it to find the

RE: 2 simpl q's about locking

2001-05-15 Thread Dave Watts
I'm going to go a bit out on a limb here and say no. As you're only checking the symbol table to see if the name is defined -- not trying to get a coherent value from it or access the same memory address from possibly multiple simultaneous threads -- it should be thread safe. I

Using MySQL with CF and Apache.

2001-05-15 Thread Arden Weiss
I and a couple other members of the Annapolis CF User Group WWW.ANCFUG.COM are investigating getting MySQL database server to work with Cold Fusion 4.5 and Apache Web Server on Win9x/ME/NT boxes. Like to collaborate with any others interested in same. We have CF, Apache and MySQL installed

RE: finding special characters in a list

2001-05-15 Thread Mike Townend
Yea... Off hand I don’t know the code for the paragraph code. What you could do is with a bit of text where you know there is a paragraph char loop over it and use the ASC() command with it to output the ascii code to it... Then track down the paragraph cmd and use chr(). Ie CFSET sSomeText =

Re: CFFORM Bug !!

2001-05-15 Thread Bernd VanSkiver
It's a feature, not a bug :) Bernd --- David E. Crawford [EMAIL PROTECTED] wrote: To further clarify: the FORM scope is only availble to CF if the method was POST. So it only makes sense that CFFORM uses the POST scope when it writes out the FORM block. DC - Original Message

RE: Harpoon Release is Final Available

2001-05-15 Thread Evan Lavidor
Dave, Can you point me to any documentation/info from Macromedia or Figleaf which shows this? I'm going to be starting a project with one of our Flash developers who's excited about the concept of using XML, but if it doesn't perform as well... But I'd like to have something with which to back

#cgi.HTTP_IF_MODIFIED_SINCE#

2001-05-15 Thread Paulista
how can i use the variable #cgi.HTTP_IF_MODIFIED_SINCE# with IIS 5? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

CFMAIL

2001-05-15 Thread tom muck
I'm using CFMAIL to send emails to a list of names in a database. Everything works fine, except for the fact that CF only releases about 100 emails at a time to our mail server. Our mail server is capable of sending many more, so it gets the hundred emails from CF and sends them out in a second,

OT: @@identidy in sql server 7

2001-05-15 Thread Kola Oyedeji
Can anyone please remind me how i get the value of a record which was just inserted into a sql database. I know its called @@identidy. I had a snippet but i cant find it,Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the

Load me up

2001-05-15 Thread James Maltby
Anyone used RadView? What do you think? Else anyone suggest a good CF compatible server load testing app? TIA J The Force is strong in this one... - Darth Vader ~~ Structure your ColdFusion code with Fusebox. Get the official

Re: CFMAIL

2001-05-15 Thread tom muck
I found the Spool Interval setting since this post, but it seems the minimum is still 15 seconds. What I'd really like to see is if there is a way to get it to send more than 100 at a time. tom tom muck [EMAIL PROTECTED] wrote in message 3b014caa$[EMAIL PROTECTED]">news:3b014caa$[EMAIL

RE: Harpoon Release is Final Available

2001-05-15 Thread Steve Drucker
Well, here's some anecdotal evidence -- Once we removed XML as a transport mechanism and started relying on loadvariables, the average object shrank in byte-size by over 50% and load times, in one particular case (cascading menu), went from 8 seconds to under 2 seconds. Regards, Steve Drucker

grab links from a webpage

2001-05-15 Thread Art Broussard
I have several hard coded link pages that I would like to grab all the links from and write to a database. I figured that if I did a cfhttp to the file and then did some sort of search on it, i could get the href and the link name and write it to the database. This isn't something that I have

Here's an idea ... hiding the path of an included file

2001-05-15 Thread Mike Kear
Hey Todd, here's an idea .. .you could put that project down while you think about it .. then while you're not working on it, you could help me get my SITES BACK TOGETHER ... ITS BEEN NEARLY 2 WEEKS NOW SINCE YOU BROKE EVERYTHING ... I STILL HAVE ONLY ONE SITE UP AGAIN AND I AM STILL UNABLE TO

Re: OT: @@identidy in sql server 7

2001-05-15 Thread Clint Tredway
Depending on what you are doing... inside a stored procedure you can do this // Insert Into Table (ColumnList) Values(Values) Select @@Identity as NewID / HTH Clint -- Original Message -- From: Kola Oyedeji [EMAIL PROTECTED]

RE: @@identidy in sql server 7

2001-05-15 Thread Garza, Jeff
CFQUERY name=whatever dsn=mydsn SET NOCOUNT ON INSERT INTO myTable (myVAL) VALUES ('#form.val#'); SELECT @@IDENTITY AS NewID; SET NOCOUNT OFF /CFQUERY This Assumes an Identity field in myTable... CFOUTPUT query=whatever #NewID# /CFOUTPUT Jeff Garza Web Developer/Webmaster Spectrum Astro,

RE: finding special characters in a list

2001-05-15 Thread Stephenie Hamilton
thanks michael, craig, david... got it working -- Stephenie -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 10:35 AM To: CF-Talk Subject: Re: finding special characters in a list CR is generally CHR(13)+CHR(10) in that order. DC

SQL Joins.

2001-05-15 Thread Darren Adams
Hello folks, I ma having a spot of bother with joining tables in a query and could do with some advice. There are 4 tables: company_table, slow_stream, medium_stream and fast_stream Company table holds: company ID, name. The other tables also have a company_name field. I want to join all

RE: @@identidy in sql server 7

2001-05-15 Thread Diana Nichols
set nocount on insert into table () values () select @@identity as newID set nocount off HTH D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long -Original Message- From: Kola Oyedeji

Slightly OT: Informix DB

2001-05-15 Thread Matthew Fusfield
Hi, We have a client who has a Informix database hosted on a unix server. We are working on a set of applications that will require us to tie into it via ColdFusion and Visual Basic. While I know ColdFusion has native support for Informix, we will need to setup ODBC for the other applications -

RE: Harpoon Release is Final Available

2001-05-15 Thread ibtoad
Is there any way to make the top level of the horizontal tool bar scroll? I can only fit 4 top level options, the second level will automatically scroll when there are more than the ammount of options that will fit on the screen. Rich -Original Message- From: Steve Drucker

Re: finding special characters in a list

2001-05-15 Thread Howie Hamlin
It should be chr(13) chr(10) and not the other way around. Not sure if that will work or not as I'm not sure what Studio flags as a paragraph but that is the proper sequence of CR and LF chars... HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com

RE: SQL Joins.

2001-05-15 Thread John
I am guessing this is a one to many relationship between company_table and the remaining tables. select * from company_table t1 left outer join slow_stream t2 t1.name = t2.name left outer join medium_stream t2 on t1.name = t3.name left outer join fast_stream t4 on t1.name = t4.name However,

RE: @@identidy in sql server 7

2001-05-15 Thread John
The other responses got it right but you probably want to either enclose both these statements in a transaction tag either on the sql side in a stored procedure or on the cold fusion side because someone could add another record to the table between your two statements and then you would get the

RE: SQL Joins.

2001-05-15 Thread John Wilker
You could use INNER JOINs if each table has a company ID for sure. FROM company_table INNER JOIN slow_stream ON slow_stream.ID = company_table.ID INNER JOIN mesium_stream ON medium_stream.ID = company_table.ID INNER JOIN fast_stream ON fast_stream.ID = company_table.ID That

RE: @@identidy in sql server 7

2001-05-15 Thread Mike Kear
What does the set nocount on do? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] set nocount on insert into table () values () select @@identity as newID set nocount off HTH D * Diana Nichols

RE: @@identidy in sql server 7

2001-05-15 Thread Kola Oyedeji
Diana, clint, Garza thanks Kola -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 17:07 To: CF-Talk Subject: RE: @@identidy in sql server 7 set nocount on insert into table () values () select @@identity as newID set nocount off HTH D *

Re: grab links from a webpage

2001-05-15 Thread sebastian palmigiani
on 5/15/01 10:57 AM, Art Broussard at [EMAIL PROTECTED] wrote: I can pull up the page using cfhttp. Now how do I search for links on it? Do i need to use find or refind? I don't fully understand reg expressions so I don't know how to use it that well.go To learn more about regular

RE: SQL Joins.

2001-05-15 Thread Bob Silverberg
I think you need something along the lines of: Select fieldlist FROM company_table INNER JOIN slow_stream ON company_table.Name = slow_stream.company_name INNER JOIN medium_stream ON company_table.Name = medium_stream.company_name INNER JOIN fast_stream ON company_table.Name =

Scientific Notation Formatting

2001-05-15 Thread Corina Moore
Anyone have any ideas on how to format a number using scientific Notation? For example I have the number 2600 and I want to display 2.6e11 I would appreciate any help. Thanx * Corina S. Moore IMDC Software Developer 301-286-6124 http://imdc.nasa.gov

Re: best search

2001-05-15 Thread Paul Smith
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8828 best, paul At 12:58 PM 5/15/01 +0200, you wrote: Any help on MS SQL Full Text Search would be great!!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: @@identidy in sql server 7

2001-05-15 Thread Diana Nichols
Honestly, I'm not sure, but the @@identity won't work without it. I can't find it in the SQL docs, but pulled it from a message on this list at one point. D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering.

RE: @@identidy in sql server 7 (What is SET NOCOUNT)

2001-05-15 Thread Garza, Jeff
From the SQL Server BOL: SET NOCOUNT Stops the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results. Syntax SET NOCOUNT { ON | OFF } Remarks When SET NOCOUNT is ON, the count (indicating the number of rows affected by a

RE: @@identidy in sql server 7

2001-05-15 Thread Clint Tredway
no problem... feel free to ask me for help anytime... -- Original Message -- From: Kola Oyedeji [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 15 May 2001 17:49:05 +0100 Diana, clint, Garza thanks Kola -Original Message- From: Diana

CSV file;CFFILE;Sybase IQ12

2001-05-15 Thread Carol Bluestein
Hi all. Hoping someone who has BEEN THERE, DONE THAT can help. Have to create a csv file from a cfquery resultset which can then be imported into a number of programs that do statistical analysis. Approximately 5000 rows/records with a final size of 1730 kb. A sql count and the display of the

RE: Harpoon Release is Final Available

2001-05-15 Thread Patricia Lee
No. It's an inherent limitation. |-Original Message- |From: ibtoad [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 12:40 PM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Is there any way to make the top level of the horizontal tool |bar scroll? |I can only

OpenIngres Database

2001-05-15 Thread WNELTO
Help! Does anyone know if there's a way to make an auto- incrementing number field in a CA OpenIngres database? Thanks! Norman Elton ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: @@identidy in sql server 7

2001-05-15 Thread Wjreichard
SET NOCOUNT - determines if SQL returns the number of rows affected by the SQL command. So for an insert ... SQL would return a 1 (if successfully insert one row) or 0 (if the insert failed due to unique constraint or something) for the number of rows affected vice the SELECT @@identity.

RE: finding special characters in a list

2001-05-15 Thread Mike Townend
That’s what I get for doin it off the top of my head... I don’t usually need to worry about them both as if I am looking for a crlf then I set up vairable... But mainly its for formating pages and so I just look for the one i.e. Replace(sMyString, Chr(13), BR, ALL) -Original

SQL Newbie - Help!!!!!

2001-05-15 Thread Julie Clegg
Hello, I have a large sql query I need to write and am having some problems with it. I have broken it down into several sections...the fist section I cannot figue out involves 3 table which I have listed below along with the main fields I need to deal with in parenthasis: tblContacts

CF-Notes database connection

2001-05-15 Thread loyd_w_campbell
I investigated the CF-Talk archives and found a very brief mention of this last December, but am wondering if anyone else has had any experience with getting data into or out of a Lotus Notes database. I downloaded Lotus' NotesSQL driver, installed it, created a DSN, and verified it in CF

Re: Scientific Notation Formatting

2001-05-15 Thread Howie Hamlin
You can do something like: cfset num=26000 cfoutput#numberformat(num / 10^(len(num)-1),9.9)#e#evaluate(len(num)-1)#/cfoutput Just bear in mind that this works for numbers =1 HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101

ot on mouseover

2001-05-15 Thread Joshua Tipton
I need a good script so that when you do an onmouseover on a link it will display text about the link. Then when an onmouseout it disappears. Joshua TIpton ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Certified Developers listing on Allaire

2001-05-15 Thread Tim Bahlke
How long after one certifies does it take to get listed on Allaire's site? Thanks, Tim Bahlke ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Strange problem (or still asleep)

2001-05-15 Thread David Baskin
Hello, i'm running the code below and i'm not getting the expected results. i'm passing in a variable with the length of 5 so i would expect that the errorString would not be appended, but in fact it is. The same thing happens when i pass in a variable with the length of 9. I can't seem to figure

RE: Harpoon Release is Final Available

2001-05-15 Thread ibtoad
Why? Rich -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:35 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available No. It's an inherent limitation. |-Original Message- |From: ibtoad [mailto:[EMAIL PROTECTED]] |Sent:

CFLOOP and multiple variables

2001-05-15 Thread Chad Gray
I have a shopping cart system (part of the one that came with CF Server) and i would like to have users be able to order multiple items with different quantities. IE a user could order 4 red hammers, 2 blue hammers, and 5 green hammers in one click of the button. When they hit the submit

RE: Harpoon Release is Final Available

2001-05-15 Thread Steve Drucker
Well, you could adjust the font size down to accommodate more options as well... -S -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:35 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available No. It's an inherent limitation.

CF 4.5/5.0 ORACLE stored procedures - how to cache results??

2001-05-15 Thread Darren Nickerson
Folks, A key aspect of our site is a search function that allows users to specify criteria in several categories for a DSS-type query against the database.  Since use of this feature is expected to be heavy, response time is critical. To optimize performance, we've designed this section to

RE: ot on mouseover

2001-05-15 Thread Duane Boudreau
use the title attrib. not sure if it works in NN though a href= title=hellotext/a -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:06 PM To: CF-Talk Subject: ot on mouseover I need a good script so that when you do an onmouseover on a

Re: Strange problem (or still asleep)

2001-05-15 Thread Todd Ashworth
Change your OR to AND :) Todd Ashworth -- Certified ColdFusion Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] - Original Message - From: David Baskin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001

Re: CSV file;CFFILE;Sybase IQ12

2001-05-15 Thread tom muck
Wrap your CFOUTPUT Query in a CFHEADER tag: CFHEADER NAME=Content-Disposition VALUE=inline; filename=test.csv CFCONTENT TYPE=application/unknown cfoutput query=rs #rs.column1#, #rs.column2##chr(10)#/cfoutput cfabort tom www.basic-ultradev.com Carol Bluestein [EMAIL PROTECTED] wrote in

E-commerce Dilemma

2001-05-15 Thread Christine Kelley
Hi! I need to implement an e-commerce package for one of my sites, but I haven't worked with e-commerce before. What they want is fairly simple, just the ability to buy items on-line. This in mind, I think AbleCommerce would be over-kill. The two I have researched are CFWebstore and

RE: SQL Newbie - Help!!!!!

2001-05-15 Thread John
I think this will give you what you want. select top 1 t2.pk_CasacAppt from tblCasacCM left outer join tblCasac t2 on t1.pk_CasacAppt = t2.pk_CasacAppt left outer join tblContacts t3 on t1.pk_CMAppt = t3.CMAppt where pk_uniqueID = #Variable# order by t2.CasacDate desc John Hancock

OT: open link in new, maximized window?

2001-05-15 Thread Erika Foster
I need a link to open up in a new maximized browser window. I figure its a windows setting issue instead of a code issue, correct? This is for a demonstration later today. My CF app is launching the GIS application and its opening the GIS App in a small window and its having trouble

RE: Strange problem (or still asleep)

2001-05-15 Thread John
Not sure but trim the variable to make sure it's not carrying the spaces. John -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:20 PM To: CF-Talk Subject: Strange problem (or still asleep) Hello, i'm running the code below and i'm not

  1   2   >