RE: Good CFCatch code

cfdump isn't available on CF 4.5.x. -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Dave

RE: SQL question

Why don't you just use Transact-SQL functions? SELECT SUBSTRING(COL_NAME,1,(PATINDEX('%.%',COL_NAME)-1)) FROM TABLE_NAME This will return any characters before the '.'. NOTE that the STR() function will also do this for you with columns of type FLOAT. ALSO NOTE that it would be smart to

RE: Flash/XML emergency

Hey Jeff, Sorry to hear about your dilema. Fortunately, I think I can help. How are you getting the data? Is it through a web service, or just and XML feed? What format is the date in (eg. 7/26/2002, etc.)? What version of Flash, 5 or MX? Can I see the

RE: dynamic body #DynamicContent#

What I have done in the past is create a Request variable to store information about my main HTML tags in an action, and then output them in my display file (Fusebox): !--- app_globals.cfm --- cfscript function initHTML() { Request.HTML = StructNew();

RE: It's official: CFMX is 10% faster than CF5

FYI: Piece of S**t -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Brook Davies

RE: OT JS Question

Two things: 1) Use window.opener instead of just opener. Also make sure that the parent window that opened this child window is still opened (otherwise, it will not be defined. 2) name is a property of the form object, so if you are trying to set the value of a form field called name, it might

RE: Can I lock variables inside a UDF?

This leads me to make this statement: If you place CFLOCK around a call to a UDF, all of the variables used within the UDF are subsequently locked. Is this statement correct? cfscript function getFooStruct() { return Session.fooStruct; } /cfscript cflock

RE: FAQs for CF-Talk was (Admin) Behavior

I already started building a little tool to collect these FAQs and save them in a DB (still in development, should be done tonight or tomorrow). http://www.brdwrks.com/cf-talk/faq Ben, shoot me an email off-list ([EMAIL PROTECTED]) and we can work on this together if you like, and help Michael

RE: CFMX JDBC Drivers

Simon said it: 1) Make sure the RDBMS is running SP2. I ran into this problem during Beta 2, and Raymond Camden pointed this out. If you don't have SP2, you can download it here: http://www.microsoft.com/sql/downloads/2000/sp2.asp Also, there is a Microsoft SQL Server 2000 Driver for JDBC

RE: CF Server Error Msg - unknown exception condition - TagCFX::e xecu te

The problem is a result of an exception in the execute method of the TagCFX C++ class. I have run accross this before, and it turned out to be system incompatibility (the CFX was built and compiled on NT 4, but we were trying to use it on W2K). You might contact the author of CFX_AUTHSMTP and

RE: Flash: load sounds

If you are storing references from each MP3 to the appropriate actor in a database, you can simply create a CFC to retrieve the actor information (including the file reference) - given you have the files available on the web somewhere (http://www.actorsite.com/mp3/*). Here's what your CFC might

RE: Flash: load sounds

Thanks for the tip :) -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Raymond Camden

RE: When Does Purge Take Place?

I am unsure of this myself, however you can setup your own Scheduled Task to do this for you. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.

RE: When Does Purge Take Place?

I am unsure of this myself, however you can setup your own Scheduled Task to do this for you. cfset HKLM = HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion cfregistry action=GetAll branch=#HKLM#\CurrentVersion\Clients

RE: Zipcode finder

In the past, we have purchased a database of ZIP codes from the United States Postal Service, which included the latitude and longitude for each ZIP code epicentre. Using this information, we could calculate the distance between a given ZIP code epicentre's latitude and longitude, and the

RE: Crosspost: SQL JOINS - brain fart

Did you try LEFT JOIN? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Bryan Stevenson

RE: Accessing Session Data

When storing Session information to the Registry, I am not sure about accessing the acutal Session data, however you can get a list of Session ID's. cfregistry action=GetAll type=Key name=Sessions branch=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Client s The query

RE: ssl cert with many domains

I'm going to try to use conditional logic based upon the value of cgi.server_name to point them to the correct app. If you are using IIS, you can simply create a new web site (under the IIS admin) for each application and use Host Headers to filter the requests based on host name. -- Scott

RE: help writing a stored proc

After the insert SELECT @@IDENTITY AS @newUserKey Do forgot to SET NOCOUNT ON and OFF around the INSERT statement. The SET NOCOUNT statment, when ON, will suppress the (1 row(s) affected) message which is returned. snip DECLARE @NewUserID SET NOCOUNT ON INSERT INTO dbo.user_index(

RE: Pointing multiple sites to the same IP

The host header is a required part of ANY http request. This is true, but only for HTTP 1.1. I believe that HTTP 1.0 does not send this header with each request. However, those browsers which user HTTP 1.0 are IE 4.x and older versions of Netscape and Opera. The only downfall of virtual

RE: help writing a stored proc

SET @person = @tablePK RETURN 2 END -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 2:45 PM To: CF-Talk Subject: RE: help writing a stored proc After the insert SELECT @@IDENTITY

RE: Unique file/directory ID?

Here are some useful resources on the File Object of Microsoft Windows: Visual Basic 6.0 - File Object http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/ht ml/vaobjFile.asp Microsoft Windows Script 5.6 Documentation

CFMX and SQL 2000 Views

Greetings, Has anyone experienced problems on CFMX using the Microsoft SQL Server JBDC Driver to query Views? I have a database with quite a few Views, and every query against a View returns the following error: snip [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name

CFMX and SQL 2000 Views

Greetings, Has anyone experienced problems on CFMX using the Microsoft SQL Server JBDC Driver to query Views? I have a database with quite a few Views, and every query against a View returns the following error: snip [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name

Downgrading CF 5 Pro to Eval

We recently purhcased a more powerful server, and want to transfer the license of CF 5 Pro from the old server to the new one. However, we still wish to retain the old machine as a development server. I tried upgrading the install to EVALUATION in CF Admin, but it didn't work. Any thoughts?

RE: ColdFusion Studio 5.0 trial download?

Is it on the CF Server 5 CD? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: [EMAIL

RE: Back button and history.go()

Unfortunately, As far as I know, you cannot capture events outside of the document area of the browser. Thus, the BACK button resides outside of the document area, and you cannot capture any events. If this is an intranet, I would suggest that you dissable the toolbar with javascript when

RE: Most efficient way to check if two lists

I build a UDF to do just that cfscript function compareLists(listIn,listToCheck) { delim = ,; // Default if (ArrayLen(arguments) GT 2) { delim = arguments[3]; } listIn = delim listin delim; regExp = delim ReplaceNoCase(listToCheck, delim, delim | delim, ALL)

RE: Annoying DB question

The error you are getting suggests that your PK value is not unique for the row that you are inserting into tblBenefit. Are you using IDENTITY on the PK for that table, or are you inserting the value from the SP? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013

RE: CFINTERNALDEBUG

Thanks for the tip! Anyone else know what the other actions do, or how to use them? Happy Programming! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad,

RE: Windows - pesky folders

Similar thing happened to me. I think the reason is that the hacker go into through FTP on a U/Li/nix machine, and name the folders files with invalid characters. Any suggestions? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL

RegExp Question

I need to find all #someVariables# in a string, so I came up with the following RegExp: /#.*[^#]#/ (Which in CF would be ##.*[^##]#) What the HELL am I doing wrong? This will find the first occurence of the # in a string, but will continue until it finds the last occurence of # - whereas I

RE: RegExp Question (Solved)

, HomestarRunner.com -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 3:36 PM To: CF-Talk Subject: RegExp Question I need to find all #someVariables# in a string, so I came up with the following RegExp: /#.*[^#]#/ (Which in CF would

RE: OT : js submit into new window...

This works in IE, but I haven't tested it in NN. snip html head titleUntitled/title SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- function subForm(obj) { window.open(,WinName,width=500,height=300); obj.submit(); } //-- /SCRIPT /head body form

RE: A Tip (maybe new, maybe not)

There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205

Looping Over Variables Scope

Is it possible to loop over the Variables scope? cfloop list=#Variables.VarNames# index=ind #ind#: #Variables[ind]# /cfloop ??? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Hello

FW: calling a java method

You don't have to use any certain tags. You can either call the method in a CFSCRIPT tag, or have a dummy variable to which you set nothing to. cfscript someString = mailer.returnString(); // Return: String mailer.deleteMailFromQueue(); // Return: void cfscript Or cfset temp =

RE: load java class from a package

Make sure the you have a Class Path setup for the package you are trying to use in ColdFusion Administrator (located under Java). cfscript mailerObj = CreateObject(Java,mailer.mainMailer); /cfscript If the class constructor takes arguments, simple call the init() function and pass the args in

RE: SQL Question

With SQL Server, you would do a LEFT JOIN: cfquery datasource=#prefs.dsn# name=header select h.id, h.header, l.link, l.link_title from headers h LEFT JOIN links l ON f.sub_object = l.headerid where f.sub_object = h.id group by h.header, f.state, f.sort, l.link,

CFENCODE Decoder

One of my developers deleted a file w/o backing it up. *_* Do any of you out there have one of those handy litte tools to decode a CFENDODE.exe'ed file? You can email me of list if you want to remain anonymous :) Thanks! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles,

Execution Time

Is there a way (perhaps in OnEndRequest.cfm) to obtain template execution times which are show when Show Detailed Processing Time Breakdown is turned on, as variables for use in a template? Thanks! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel

RE: CFENCODE Decoder

: CFENCODE Decoder Still need it? Will - Original Message - From: Van Vliet, Scott [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Thursday, May 09, 2002 8:51 PM Subject: CFENCODE Decoder One of my developers deleted a file w/o backing it up. *_* Do any of you out there have

Editor Woes (was RE: Macromedia Folks: What are you thinking?)

I wish I could code with VI. Everyone that I know who uses it, loves it, and will use no other editor. On top of that, they are CRAZY fast at coding with it. -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED]

RE: Editor Woes (was RE: Macromedia Folks: What are you thinking? )

friends :-) Ian -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: 07 May 2002 17:14 To: CF-Talk Subject: Editor Woes (was RE: Macromedia Folks: What are you thinking?) I wish I could code with VI. Everyone that I know who uses it, loves

RE: Editor Woes (was RE: Macromedia Folks: What are you thinking? )

Developer Mob:07759 956523 Office:01252 556220 Data + Structure = Information -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: 07 May 2002 17:14 To: CF-Talk Subject: Editor Woes (was RE: Macromedia Folks: What are you thinking?) I

RE: using != in a filed with a null value

I have always used for NOT EQUAL. Give it a try ^_^ +--+---+ | SCOTT VAN VLIET | SBC SERVICES, INC.| | Senior Analyst | ITO Enterprise Tools | | Tel: 858.886.3878| 7337 Trade St. Room 4000 | | Pgr:

RE: HTML in URL Variable?

Try wrapping URLEncodedFormat() around the variable when you embed it in the URL EXAMPLE a href=GoToCategory.cfm?category=#URLEncodedFormat(Category)##Category#/a OUTPUT a href=GoToCategory.cfm?category=%3Cb%3EDiamonds%3C%2Fb%3EbDiamonds/b/ a HTH!

RE: neo question

Well, I hate to join in these long threads, but I read something that I could not resist answering. It is not about who or what someone can do re: CF J2EE convertor(which seems a little pointless with Neo There has been a J2EE implementation of CF for quite some time (3 years, I think),

RE: RecordNum =0

I have done this before, and here is what worked for me: DECLARE @RecordCount int SET @RecordCount = SELECT COUNT(COLUMNNAME) FROM TABLENAME WHERE CONDITION = SOMETHING IF @RecordCount 0 BEGIN ... I think you are

RE: How to close Excel ODBC connection at end of query

What about the Maintain database connections setting for the DSN under ColdFusion Administrator? This should take off the lock place on the XLS file. I am not sure if this will work for your problem, but you might want to give it a shot.

RE: Javascript: onKeydown event

Is there any reason you have two onKeyDown events, or is that just a typo? If that is the case (that you have two), NN 6.x and IE are very forgiving when having duplicate attributes, however NN 4.x might be crapping out because of this. HTH

RE: Wild Card

TRY THIS: cfset City = St Louis cfset Replacement = Saint cfoutput#REReplace(City,[sS][tT][\.| ],Replacement)#/cfoutput To verify, place a . after St. HTH +--+---+ | SCOTT VAN VLIET | SBC SERVICES, INC.| | Senior Analyst

RE: Wild Card

Good Point. Try this instead. There is prolly a better Regular Expression than this, but it works :) cfset City = East St. Louis cfset Replacement = Saint cfoutput#Trim(REReplace(City,[ ][sS][tT][\.| ],Replacement))#/cfoutput +--+---+ | SCOTT

Finding Images in HTML and Uploading

Before I go any farther than I already have, I thought I should ask you folks if you have already seen this functionality, or know of a custom tag or UDF to do this: I have a client who wants to be able to post HTML to a content management site, and have the ability to upload the images he

RE: how to tell if a session has expired

You can just do an IsDefined('Session.SomeSessionVar') on a common session variable you create for each user (usually a Session.LoggedIn or Session.Authenticated). At least that's been the technique I have used, and it works great ;) +--+---+ |

RE: how to tell if a session has expired

What's wrong with: IsDefined('Session.Cart')? If the Session is expired, that structure will not exist. - Scott +--+---+ | SCOTT VAN VLIET | SBC SERVICES, INC.| | Senior Analyst | ITO Enterprise Tools | | Tel:

RE: CFOBJECT

What type of object are you using? Java? COM? -- Scott Van Vliet Senior Analyst SBC Services, Inc. ITO Enterprise Tools Office: 858.886.3878 Pager: 858.536.0070 Email: [EMAIL PROTECTED] -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002

OT: What IDE are you using for Java CFX?

What IDE are you folks out there using for developing Java CFX? I am currently using CF Studio and the command line compiler (pain in the @$$). I was considering buyin' a copy of JRun Studio, but wanted to see what the masses think. Thanks! -- Scott Van Vliet Senior Analyst SBC Services, Inc.

RE: Checks

Verisign's PayFlow offer's support for checks. http://www.verisign.com/products/payflow/pro/index.html -- Scott Van Vliet Senior Analyst SBC Services, Inc. ITO Enterprise Tools Office: 858.886.3878 Pager: 858.536.0070 Email: [EMAIL PROTECTED] -Original Message- From: Michael Ross

RE: Auto logout when leaving the application

I am working on a custom tag that will solve this, and will post it when I finish. -- Scott Van Vliet Senior Analyst SBC Services, Inc. ITO Enterprise Tools Office: 858.886.3878 Pager: 858.536.0070 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Auto logout when leaving the application

Pacific Technology Solutions -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 8:49 AM To: CF-Talk Subject: RE: Auto logout when leaving the application I am working on a custom tag that will solve this, and will post it when I

CF_AutoLogout (was RE: Auto logout when leaving the application)

PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:05 AM To: CF-Talk Subject: RE: Auto logout when leaving the application I am building a JS tool that will automate this process. I will post it.. -- Scott Van Vliet

RE: File sizes

CFDIRECTORY ACTION=LIST ... http://livedocs.macromedia.com/cf50docs/CFML_Reference/Tags14.jsp -- Scott Van Vliet Senior Analyst SBC Services, Inc. ITO Enterprise Tools Office: 858.886.3878 Pager: 858.536.0070 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED]

RE: How do you change this number 70.0500 to 70.05?

cfset num = 70.0500 #DecimalFormat(num)# -- Scott Van Vliet Senior Analyst SBC Services, Inc. ITO Enterprise Tools Office: 858.886.3878 Pager: 858.536.0070 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

RE: How do you change this number 70.0500 to 70.05?

SELECT ('$' + CONVERT(VARCHAR,DollarField)) As DollarField FROM TABLENAME (Where DollarField is the Column you are getting the dollar value from) The convert function trimmed off to only 2 decimals in the conversion. I was starting to get all crazy with SUBSTING, but I think will work just

Java CFX Question

Can you create a new query in a Java CFX, or can you only modify a passed query reference? When I try to create a query object, I receive an error message saying that com.allaire.cfx.Query is only an abstract, and cannot be instanciated. Any thoughts? TIA. Scott -- Scott Van Vliet Senior

RE: Java CFX Question

Question You can absolutely create a new Query object. What is the code that you're using? - Matt Small -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 2:09 PM To: CF-Talk Subject: Java CFX Question Can you create a new query

RE: SQL Update Increment Value

Well, if you wanted to increment a field from it's current maximum value, you could: UPDATE TABLE SET COL1 = '#value#' ,COL2 = '#value#' ,COL3 = ((SELECT MAX(COL3) FROM TABLE) + 1) WHERE COL4 = #value# HTH

RE: What is MX

If there was a input type=file control available in Flash MX, I would be sold for good ^_^ -- Scott Van Vliet Senior Analyst SBC Services, Inc. ITO Enterprise Tools Office: 858.886.3878 Pager: 858.536.0070 Email: [EMAIL PROTECTED] -Original Message- From: Rick Walters [mailto:[EMAIL

RE: How can I add a timespan to a date in sql (access)?

Try This: cfset Today = Now() cfset AWeekFromToday = DateAdd(w, 1, Today) cfquery name=getShows datasource=showstop select * from shows where showdate between #CreateODBCDate(Today)# and #CreateODBCDate(AWeekFromToday)# /cfquery HTH -- Scott Van Vliet

RE: How can I add a timespan to a date in sql (access)?

DOH! ww is correct ^_^ -- Scott Van Vliet Senior Analyst SBC Services, Inc. ITO Enterprise Tools Office: 858.886.3878 Pager: 858.536.0070 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002

RE: Reading files on mapped drive

You have to make sure that the CF Service has access to that mapped drive (and/or file, for that matter). You can also change the account which the CF Service runs under. That worked for me before. (Also note that mapped drives are relative a user's account on that machine, so if H:\ is mapped

RE: CDONTS and ReplyTo header (SOLVED!)

I got it! cfscript newMail = CreateObject(COM,CDONTS.NewMail); ... newMail.value(Reply-To, [EMAIL PROTECTED]); ... newMail.send(); /cfscript value is actually a psuedo method of the CDO.NewMail object. So, by passing these arguments to it, it works

RE: CF/Database Help

Depending on the depth of you database, the best thing to do would to be create a master RECIPE table, and a master INGREDIENT table. The, you could create an linkage table that would like n number of ingredients to a recipe. EXAMPLE: RECIPE ==

RE: CF/Database Help

the same functionality? --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: VAN VLIET, SCOTT E (SBCSI) [EMAIL PROTECTED] Reply

RE: CF/Database Help

Chocolate Brownies Sugar Chocolate Brownies Egg Chocolate Brownies Salt Chocolate Brownies Chocolate -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 1:49 PM To: CF-Talk Subject: RE: CF/Database Help Depending

RE: Java Custom Tag

I believe that you only have to register the .class file for the CFX tag. Then, any .class files (libraries, etc.) should be placed in a CF Java class path. You can set multiple classpaths in the ColdFusion Administrator, so just map a classpath to the folder where the library is located. Hope

RE: Announcement: New Flash MX component

I can't get to the site :( Our firewall is blocking the domain because, if I recall correctly, there was a virus called DaVinci, and anything related to that is being blocked! Errr.. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL

RE: Forcing Query Refresh (Sometimes)

You could have an Application variable that would flag your page whether or not updates to the database had been made. If changes were made, you could set the cachedwithin to zero. EXAMPLE: cfset cacheTime = CreateTimeSpan(1,0,0,0) cfif Application.DataHasBeenUpdated EQ 1 cfset

OT: Oracle version of TOP

Sorry for the OT, but do any of you know the Oracle function for selecting the top n records. (ie. SELECT TOP 10 * FROM TABLE - in SQL). Thanks! Scott -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: mailto:[EMAIL PROTECTED] [EMAIL

RE: OT: Oracle version of TOP

, 2002 2:31 PM To: CF-Talk Subject: Re: OT: Oracle version of TOP VAN VLIET, SCOTT E (SBCSI) wrote: Sorry for the OT, but do any of you know the Oracle function for selecting the top n records. (ie. SELECT TOP 10 * FROM TABLE - in SQL). Thanks! Scott rowcount is similar but my oracle skills have

RE: VeriSign PayFlow Configuration/Sample Code

There are two releases of the Verisign CFX implementation: Version 2.31 (which is the C++ version), and Version 3.0.* (which is a Java-based CFX tag. A client of mine was forced to upgrade to the Java version because of issues with the FraudScreen service. If you need code for the Java version,

RE: Checking an email

SMTP Server, SMTP Port, and Timeout. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 2:23 PM To: CF-Talk Subject: RE:

RE: Closing window

If there is nothing to display on the page: script window.close(); /script Not that this is buggy in NN, so I would recommend: .. Your CF Code goes here .. html head script type=JavaScript !-- function closeMe() { window.close(); } //-- /script /head body onload=closeMe(); /body /html

RE: Returning only one record HELP PLEASE!!!!

I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAMECOLOR - 1 Quiksilver T-Shirt Blue 1

RE: Returning only one record HELP PLEASE!!!!

-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002

RE: Returning only one record HELP PLEASE!!!!

record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP

RE: Returning only one record HELP PLEASE!!!!

) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE What are you trying to accomplish? The GROUP attribute will only

RE: SQL lisence headaches

There is an ASP license available: http://www.microsoft.com/serviceproviders/licensing/licensing.asp -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]]

RE: web server for XP home?

Yes. XP Home = Windows 9x. XP Pro = NTx/2K Workstation. NET = NTx/2000 Server That's it. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Alex [mailto:[EMAIL

RE: web server for XP home?

(I know that Win 9x could join a domain, but I was trying to emphasize the point that XP Home is for home users) -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI

RE: Screen width, Height, Color Depth

You will need to have a listener page grab the screen properties via JS, then send those to a CF page, then go to the index page as if they were entering the site. You can also base this on session state - so that if this is the users first request for a particular session. EXAMPLE (in you

RE: Time Issue

Are your web server smtp server on the same box? If not, then this time may be coming from the smtp server. HTH -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From:

Looping over a query with CFSCRIPT

Is this possible? If so, sample code would be appreciated. I tried the following, and got an access error (i understand that you can't modify currentrow, etc, but one can wish, right ^_^): cfscript while (selProd.CurrentRow LTE selProd.RecordCount) { writeOutput(selProd.PR_NAME);

RE: Looping over a query with CFSCRIPT

Many Thanks ^_^ -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 3:56 PM To: CF-Talk Subject: Re: Looping over a

RE: Reorder List Using Flash.

Check out the following links: http://chattyfig.figleaf.com/~bhall/code/wddx.as http://chattyfig.figleaf.com/~bhall/code/xmlnitro.as These objects make using XML in Flash a heck-of-a-lot easier to deal with, and have been used to get send WDDX packets. HTH! -- SCOTT VAN VLIET SENIOR ANALYST

Reading ID3-Tags w/ColdFusion

Do any of you out there know of a COM Object or JavaBean that can read ID3-Tags from MP3 files? If so, has anyone had experience using one of these objects in ColdFusion? I am buildling a Flash MX Streaming MP3 client (as well as the NEO-based server component) and was to read in the meta

RE: Reading ID3-Tags w/ColdFusion

HTH -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: 22 March 2002 17:52 To: CF-Talk Subject: Reading ID3-Tags w/ColdFusion Do any of you out there know of a COM Object or JavaBean that can read ID3-Tags from MP3 files? If so, has anyone had

PreserveSingleQuotes() - CF 5 Bug?

When nesting functions in the PreserveSingleQuotes() function, CF 5 throws an error. EXAMPLE: cfset preservedInput = PreserveSingleQuotes(trim(form.inputfield)) This throws the following error: Error Diagnostic Information Just

RE: Inserting CFIF into CFINPUT

Try This: cfinput type=Radio name=sex value=Male cfif #GEC.Sex# eq Male CHECKED/CFIF -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Angel Stewart [mailto:[EMAIL

  1   2   >