RE: Fusebox - opinions?

2001-11-19 Thread Rick Lamb
Not to mention the fact you get to be lazier because somebody has already done the documentation for you and it's readily available. Instead of coming up with a bunch of documentation I tediously created and walking the new developer through it I can just say, go to this site and read up. Come

RE: (sql) Getting Unique Max() Value

2001-10-29 Thread Rick Lamb
Here's a quick stabb at it: SELECT auc_bids.BIDS_ID, auc_bids.ITEMS_ID, auc_bids.BIDDERS_ID, auc_bids.MAX_BID, auc_bids.WINNING_BID, auc_items.ITEMS_ID, auc_items.ITEM_NUM,

originating domain

2001-09-10 Thread Rick Lamb
Does anybody know a way to get the originating domain the user is accessing your site from? Thanks, Rick ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

RE: Disabling back button

2001-09-07 Thread Rick Lamb
I think this was it: script language=JavaScript type=text/javascript window.history.forward(); /script Rick -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 7:58 AM To: CF-Talk Subject: RE: Disabling back button I remember some time

from web media to print?

2001-09-04 Thread Rick Lamb
I wanted to get feedback on how you all handle print versions of your data. I've had a number of clients that after I've built this great site with administrable content, they call up and say Why don't the products print out on my printer like they show up on the website?. For some reason they

RE: Throttling CFMAIL

2001-08-30 Thread Rick Lamb
You could use a meta=refresh for whatever interval you wanted. Then use a session variable to keep track of what record your on and increment it every time the page loads. Make sense? Rick -Original Message- From: DSJ / PC1, Inc. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30,

RE: SQL

2001-08-29 Thread Rick Lamb
DELETE FROM TABLE -Original Message- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:36 PM To: CF-Talk Subject: SQL I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the

reg expression help please?

2001-08-27 Thread Rick Lamb
Hoping someone with regular expression knowledge could help me. I need to take a string and eliminate everything but numbers, - negative signs and . decimal points. Basically just leaving pos and neg decimal numbers filtering out anything else. Anyone willing to help? Thanks, Rick

cf mail hanging

2001-08-06 Thread Rick Lamb
I'm having a periodic problem where a message is hung in the cf mail spooler directory on the cf server and is sent over and over again until it's cleared out. When I log onto the server there is usually a Dr. Watson error that need to be cleared out before the message can be delete. Anyone have

OT - dynamically populating pdf forms

2001-07-17 Thread Rick Lamb
I found some archives that said the best way to do this is to use acrobat to create the forms and a fdf file. Then use this fdf file as a template to create on the fly with cf populated with the data you want to use. What I'm hoping is that somebody has some sample code (would make a good

SOT: Form builder software

2001-07-10 Thread Rick Lamb
Hi all, I need to find a better solution than html forms to meet my clients needs. My client has a bunch of paper forms and documents that he wants to use online. I've tried creating these in html but the lack of formatting and print control is causing some problems. Not to mention the huge

RE: GROUP BY gives an error?

2001-07-09 Thread Rick Lamb
A better question is what the heck are you trying to do. If you use a group by clause in sql you either need to include each field you're selecting in the group by clause or do some sort of aggregate function to them. If you trying to group the query by makename, then just order by makename in

OT - batch printing dynamic pages

2001-05-24 Thread Rick Lamb
Does anybody know of a way to batch print a bunch of dynamic cf pages? Basically, is what I want to do is collect some data from the user by a form and then using that data to fill in the dynamic content, print out a number of documents. This needs to be done by clicking a button if at all

Creating Dynamic documents

2001-05-22 Thread Rick Lamb
Hello all ye people, Does anybody know of a way to let a user build documents dynamically and include fields that can be dynamically inputted from a previous form. For example, I would like the user to be able to create a buyer contract for a product, allow them to add whatever legal terms and

OT: catalog.wci filling up hard drive space?

2001-05-14 Thread Rick Lamb
We have a server that is filling up hard disk space very quickly and most of the growth is happening in this catalog.wci folder. Is this the logging folder for index server? If not what is it used for and how can I control it's growth? Thanks, Rick

OT - synch files automatically

2001-05-02 Thread Rick Lamb
I am having problems replicating images across to load balanced servers. We have users that are upload images to one server and need to have an automated way to check the other server for this file and if it doesn't exist we need to transfer a copy over. Has anyone came across any solutions for

RE: Resume Field

2001-04-25 Thread Rick Lamb
We use WebEditPro for similar needs which has always been bought fairly cheaply for unlimited access per domain name. I think it's 300 per domain name unless you buy ten or more. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 2:42 PM

How do i set up a Java CFX tag.

2001-04-23 Thread Rick Lamb
I need to use a cfx tag written in java and am not sure how to set it up. Do I need to install a Java Virtual Machine on the server? Any thing else required? The error I get now is asking me to set up a JVM on the server. How do I do this. Can someone help me get started? Thanks, Rick

exploiting shopping carts

2001-03-15 Thread Rick Lamb
Hey all, I just got this article today about how people are exploiting shopping cart logic to change prices and essentially stealing products. After some testing on my own carts I have been able to exploit some of them by building a form with all there required hidden fields and modifying there

verity error

2001-03-14 Thread Rick Lamb
Hey all, I'm getting this verity error now when I try and search, create, or index a verity collection: Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -100 Anybody have any suggestions? I've been searching everywhere I can think and haven't found any

RE: verity error

2001-03-14 Thread Rick Lamb
I found the problem. Apparently you need a "common" directory under the verity directory. I just copied it from another server with the same version and the problem was fixed. Just in case anybody else runs into this. Rick -Original Message----- From: Rick Lamb [mailto:[EMAIL

Can CF work with a FileMakerPro database?

2001-03-12 Thread Rick Lamb
I've been asked if I can interface with a FileMaker database using CFS. I understand that the 5.0 version of FileMaker does support ODBC connections. I would then assume there wouldn't be any problems working with the information in this type of database but I would like someone to confirm that

RE: connecting to remote SQL server via TCP-IP

2001-03-12 Thread Rick Lamb
Make sure you have your default network library set to tcp-ip (this is in your "client network utility" on your machine). Rick -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 1:06 PM To: CF-Talk Subject: OT:connecting to remote SQL server

RE: Input type=File

2001-02-27 Thread Rick Lamb
Here's a script I got to change the file button to an image. It might give you some ideas at least. form name="form" input type="Text" name="textField" action="beautyFileUpload.htm" input type="image" src="whatever.gif" name="button" value="File Upload"

Verity doesn't work with office 2000 documents!

2001-02-26 Thread Rick Lamb
Anybody else run into this. Apparently with cfs versions 4.0 and 4.51 verity will not index office 2000 documents. This is having a huge impact on my sites. Has anybody found a way to work around this. Possibly by using alternative verity application? Thanks for any help! Rick

duplicate() or readonly lock?

2001-02-24 Thread Rick Lamb
I have some confusion on reading shared memory variables. I've been using a read locks to read shared memory variables to a request scope for using through the site, but I've recently heard of people using the duplicate() function to read shared memory variables. Can anybody help me why I should

a single quote bug with cf4.0?

2001-02-13 Thread Rick Lamb
I'm having a problem with a query. I've isolated the problem to a field that contains a single quote and can't figure out why it's now escaping it correctly. Is there a bug with cf 4.0 with not escaping single quotes, or is it something else? Thanks for any help! Here's the error I'm getting:

RE: Getting Rid of a Query

2001-02-07 Thread Rick Lamb
again, I'm not sure how to do this, or even if CF's memory management and deallocation mechanisms go into play before a template is fully processed. It would be good to know, however. Jim - Original Message - From: "Rick Lamb" [EMAIL PROTECTED] To: "CF-Talk" [E

RE: CFLOCK question

2001-02-07 Thread Rick Lamb
Yep. I would say a for sure chance. Only a 4.5 attribute. Use the name attribute instead. Rick -Original Message- From: JB Mentzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 9:25 AM To: CF-Talk Subject: CFLOCK question Hi all I'm attempting to execute this: cflock

RE: How to kill session variables ???

2001-02-06 Thread Rick Lamb
With 4.5 session variables are stored as a structure. So you can use structDelete function to delete. Rick -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 4:43 PM To: CF-Talk Subject: How to kill session variables ??? Can anyone help me

cfstoredproc vs. exec storeproc

2001-02-06 Thread Rick Lamb
Do any of you guys know what the advantages are when using the cf tag cfstoredproc instead of just executing the stored procedure through a sql statement? It seems easier and cleaner to me to do it through a sql statement, but they must have developed the tag for a reason. What am I missing?

ot: executing a dts package

2001-02-01 Thread Rick Lamb
I'm trying to execute a dts package through CF but have only been able to do it through the dtsrun.exe utility and using cfexecute. The problem is the server I need to do this on doesn't have dts installed. Is there anyway I can still execute a dts packaged from this machine? Maybe using a stored

RE: killing locks on files?

2001-01-30 Thread Rick Lamb
ile though. -Original Message----- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 3:05 PM To: CF-Talk Subject: killing locks on files? Anybody know how to kill a process lock on a file. I'm trying to rename an excel file but it's erroring out saying the a process has

RE: killing locks on files?

2001-01-30 Thread Rick Lamb
locks on files? you can kill DSN locks using CFUSION_DISABLE_DBCONNECTIONS (4.5.x only) if a query of the excel file has caused the lock. you didn't specify what "process" has locked the file though. -Original Message----- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

RE: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Rick Lamb
Your code would insert a blank space. Sounds like you need something like this: CFIF trim(ListGetAt(Phone,x)) contains "n/a" Phone = null, CFELSE Phone = '#ListGetAt(Phone,x)#', /CFIF -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, January

import excel

2001-01-26 Thread Rick Lamb
Do you guys know of a way to insert an uploaded excel document into a database? Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: Setting a timeout on a page

2001-01-25 Thread Rick Lamb
Try supplying the requestTimeOut=whatever url variable. Rick -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:31 AM To: CF-Talk Subject: Setting a timeout on a page Ok, I've looked through my ColdFusion books, been through the Allaire

RE: Dynamic variable construction and it's use

2001-01-25 Thread Rick Lamb
#Evaluate(session.application_view_list[i].name "_red")# would ouptut the value. So would #evaluate(countvar)# Rick -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 12:42 PM To: CF-Talk Subject: Dynamic variable construction and it's

array length of a dimension?

2001-01-25 Thread Rick Lamb
I need to find the arraylen of a 2 dimensional array. Can somebody recommend a technique to do this? Thanks, Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: SQL Create Table

2001-01-25 Thread Rick Lamb
I far I know, there is no such thing as a Boolean datatype. You could try creating a user defined datatype as a bit or integer, then applying a rule to have it only allow 0 or 1. Not sure if that would work, but it's an idea. Rick -Original Message- From: Owens, Howard [mailto:[EMAIL

RE: array length of a dimension?

2001-01-25 Thread Rick Lamb
never mind. i figured it out while i was waiting for my post to show up. turns out i had a combination of little problems. once i got those fixed, arraylen worked fine. rick -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 1:20 PM To: CF

RE: array length of a dimension?

2001-01-25 Thread Rick Lamb
s 2 --- #ArrayLen(MyArray[1])#br !--- returns 3 --- #ArrayLen(MyArray[2])# !--- returns 2 --- /cfoutput HTH, Chris -Ursprüngliche Nachricht- Von: Rick Lamb [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 25. Januar 2001 20:20 An: CF-Talk Betreff: array length of a dimension?

RE: SQL Server Index

2001-01-25 Thread Rick Lamb
Verity should do a better job if your not already using it. Rick -Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:09 AM To: CF-Talk Subject: SQL Server Index Merry Meet, I have a small problem. I have a database, SQL Server 7.0,

wddx limitations?

2001-01-24 Thread Rick Lamb
Hi all, I'm considering using wddx for an application and want to get some advice on whether any of you have hit limits when uploading serialized wddx strings into database fields and when submitting long wddx strings across pages using form fields. I've heard story's of people running into

How do I work with XML?

2001-01-16 Thread Rick Lamb
I'm going to be getting database updates as xml doc's from a third party. Can somebody give me some direction on working with this? I need to know how I can first import the data into a SQL 7.0 database, then how to work with it using CF. Any direction would be very helpful. Thanks, Rick

OT - encryption for sql 7.0

2001-01-10 Thread Rick Lamb
I've tried to get some help for this from the sql lists but haven't got any response, so I'm going with the trusty CF group on this. Is what I'm looking for is software to encrypt certain table fields in a sql 7.0 database. I would also like to here from any of you on how you handle sensitive

RE: OT SQL STORED PROCEDURES

2001-01-09 Thread Rick Lamb
Here's an example script I was given that show how you can loop through a query using a cursor. Hope it helps. Rick USE Master GO DECLARE @DBname VarChar(50) DECLARE DBCursor SCROLL CURSOR FOR SELECT Name FROM Master..SysDatabases ORDER BY Name -- ORDER BY DBID

RE: Storing images in SQL

2001-01-08 Thread Rick Lamb
Larry, I've asked this question before also. And got similar responses as yours which is appreciated. But is there any way you could tell us (a number of people have asked this question) why it's slower and messier. I'm sure for somebody that knows the details on what it takes to do this can

line breaks in cfmail

2001-01-04 Thread Rick Lamb
Hey all, I have this ongoing problem with line breaks not being respecting when formatting my email bodies using the cfmail tag. For example something like this: cfmail Email Address: #form.email# Business Name: #form.businessname# /cfmail Is showing up like this when sent: Email Address:

RE: line breaks in cfmail

2001-01-04 Thread Rick Lamb
Using Html type would explain things. But that is not the case. I still haven't found the cause of this, but I was given a work around. The suggestion to use cfprocessingdirective suppresswhitespace="no" by Ed allowed me to get it to format the way I needed. Thanks for all of the suggestions!

RE: !-#include file=cfFile.cfm -

2001-01-04 Thread Rick Lamb
That's not going to work because it has to run before the html is parsed, which is when the SSI is included. Rick -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 11:19 AM To: CF-Talk Subject: !-#include file="cfFile.cfm" - Hello all,

aliasing using cfmail

2001-01-03 Thread Rick Lamb
Do any of you guys know how to alias the "from" parameter as to include a display name along with the email address? EG: cfmail from="Rick [[EMAIL PROTECTED]]" /cfmail Thx! Rick ~~ Structure your ColdFusion code with Fusebox. Get the

RE: setting structures into arrays

2001-01-02 Thread Rick Lamb
I seem to remember last time I did something like this that ArrayAppend worked. Either way I know I found another way around this without using the duplicate function sense I was not using cfs 4.5. Let me know if you are in a similar situation and I will look up the code I used. Rick

RE: Update to Null

2001-01-02 Thread Rick Lamb
UPDATE Employees SET Age = NULL WHERE Id = 2 This has always worked fine for me using MS SQL 7.0 and MS Access. Rick -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 9:31 PM To: CF-Talk Subject: OT: Update to Null Is it

storing images in SQL database

2000-12-29 Thread Rick Lamb
Could you guys give me suggestions for the best way to store images in a database. Thanks, Rick ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365

RE: storing images in SQL database

2000-12-29 Thread Rick Lamb
hit, and is possible, seems to be a much cleaner solution. Rick -Original Message- From: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Friday, December 29, 2000 5:07 PM To: CF-Talk Subject: Re: storing images in SQL database Quoting Rick Lamb [EMAIL PROTECTED]: Could you guys give

OT - How can I make an external request?

2000-12-28 Thread Rick Lamb
This may sound weird, but I was hoping somebody here would know of a tool that can simulate or proxy through a browser request as if I was outside of my internal network. Basically I'm having a problem simulating dns and routing that people are experiencing on the sites we host and I think it's

RE: how many milliseconds is too many?

2000-12-15 Thread Rick Lamb
If your using MS SQL, views do a good job of this too. You can consolidate your normalized data in a central location and still keep your ever expandable normalized database. Best of both worlds. Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, December

RE: CFPARAM or CFSET

2000-12-15 Thread Rick Lamb
I use cfparam for a number or reasons: It helps avoid errors by cfparam all your varaibles so they will always be defined. I also saves the hasle of having to do something like this: cfif not isdefined("url.var") cfset url.var=0 /cfif instead use: cfparam name="url.var" default=0 Which will

RE: Problem with cachedwithin

2000-12-14 Thread Rick Lamb
It will also work if you just evaluate the timespan first: cfset cache = "#CreateTimeSpan(0,2,0,0)#" cfquery name="test" datasource="#datasource#" cachedWithin="#cache#" Rick -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 5:49 PM

RE: Unlimited Line Item Subform functionality in a FORM

2000-12-13 Thread Rick Lamb
Bob, Sounds to me like your talking about an everyday shopping cart. I would use a associative array (structure) to store all the items names and values for each item and then append each of these structures to an array. At the end of the order, just loop through the array and output the

division

2000-12-13 Thread Rick Lamb
This was suppose to be easy... I'm trying to divide a recordcount by 100 and then round up. Currently my recordcount is 162 and i'm using the ceiling function to round up but it keeps giving me 1. I've tried using number format and decimal format with no luck. Any suggestions? Code below: cfset

RE: division

2000-12-13 Thread Rick Lamb
Ok. I'm a dumb @#$!. I just needed to point my slash the right way, /, not \. HeHe! So when you guys get this in 2 hours or so, excuse my thickness. Rick -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 11:02 AM To: CF-Talk Subject

RE: query between 2 database types

2000-12-13 Thread Rick Lamb
Gona have to wait for CF 5.0. It has the ability to query a query which will allow this. Rick -Original Message- From: Eli Shechter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 12:26 PM To: CF-Talk Subject: query between 2 database types Hi I recently started using a

RE: passing cfquery results to another page

2000-12-07 Thread Rick Lamb
Correct me if I'm wrong here, but I didn't think client, form, url, or cookies variables can hold complex data like a wddx packet. I would suggest using a session or application variables for these techniques. Rick -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent:

RE: Form Question

2000-12-06 Thread Rick Lamb
Just name the checkbox's the same name and have the value be the id of each record in the database. Then when you do your update/delete you would use the in clause in your sql statement like so: update table1 set productname = '#form.productname#', description = '#form.description#' where id in

RE: development mappings

2000-12-04 Thread Rick Lamb
Can you map a drive to this location \\servername\sharename\inetpub\wwwroot\foldername? if not then you either don't have correct permissions or you have the path\sharename wrong. To figure the browse path you'll have to check with the webserver it's on and see what the root is for the website

RE: Bulk imports into database

2000-12-04 Thread Rick Lamb
Data transformation services works really well. It comes with MS SQL 7.0, but I think it's a stand alone product that you can get separately to work with other types of databases. Rick -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000

RE: Query functions problem

2000-12-04 Thread Rick Lamb
Probably because of how queries are store. They are stored in structure with each key name linking to a field name in the database. In each key is a one dimensional array containing all the records for each field. So if you wanted to delete row number 10 you would do something like this: cfloop

RE: Bulk imports into database

2000-12-04 Thread Rick Lamb
How many times do I have to say this people. Use DTS if your using sql server. That's what's it's there for! Rick -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 3:07 PM To: CF-Talk Subject: Re: Bulk imports into database Actually,

RE: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?

2000-12-04 Thread Rick Lamb
I would suggest using cfcontent to a file on the server then providing a link to it for the client to click on. You could also set the cfcontent tag for download, which would make the excel file and then prompt them to download it in one step. Rick -Original Message- From: Dempsey,

RE: getting only unique query results

2000-12-04 Thread Rick Lamb
This may not be related to your problem, but may I suggest writing your query this way: cfquery name="qFoo" datasource="#application.ds#" SELECT name, product_id FROMtblProducts WHEREcategory_id in ',#attributes.theList#' /cfquery Much cleaner, and from what I understand

condition loop

2000-12-01 Thread Rick Lamb
Having a hard time with writing a conditional loop that stops when x = 1. Can somebody help me with the correct syntax? Thanks, Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at

This may be OT but...

2000-12-01 Thread Rick Lamb
It's that time of year. Yes, that's right, annual review time. I was just wondering what you guys experience as far as percentage increases. It's been my experience that the only way to get anything above a 3 percent increase is to switch jobs. Just curious if this is a common thing for the cf

RE: Java and CF

2000-12-01 Thread Rick Lamb
Better get moving then. You only have until the end of next year to convert to PHP. Rick -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 9:39 AM To: CF-Talk Subject: RE: Java and CF -BEGIN PGP SIGNED MESSAGE- Hash: SHA1

RE: Using cfquery inside cfscript?

2000-12-01 Thread Rick Lamb
I've successfully done this using the cf_exec custom tag. Pretty sure the tag is on the allaire developer exchange. Here's an example: CFSET P = "##" CFSET G = "" CFSET L = "" CF_EXEC #G#cfscript#L# while(x EQ 0) { count = count + 1; rahim = 1;

RE: Get the last 12 months transactions?

2000-11-30 Thread Rick Lamb
Check out the function dateDiff() -Original Message- From: fr me [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 9:59 AM To: CF-Talk Subject: Get the last 12 months transactions? Does anyone know how to test that a date is in the last 12 months?

RE: Finding duplicate records

2000-11-30 Thread Rick Lamb
You should be setting up primary keys or unique index's in your database for the fields you don't want duplicates. Then around your insert/update statements us cftry type="database" to catch it when they try and insert duplicate information, then deal with them appropriately. Rick -Original

RE: Cold Fusion and ASP

2000-11-29 Thread Rick Lamb
I would suggest using oledb instead of odbc in this case. I think there are some issues with how cf set's up it odbc connections when done through cf admin. If you need to use odbc for your asp apps try setting up your odbc through the system and not use cfadmin to set them up. I have ran into

OT: Dat files

2000-11-28 Thread Rick Lamb
I'm trying to move over a site that was once using a Sybase backend. They sent me a .Dat file and I'm wondering how I can take this file and use it to create a sql database. Anybody have any experience with converting from Sybase to sql using a dat file? Thanks, for anyone who can help. Rick

RE: Dat files

2000-11-28 Thread Rick Lamb
Tried it, but they don't seem to be compatible. Thanks for the suggestion though. Rick -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 28, 2000 11:30 AM To: CF-Talk Subject: RE: Dat files I know SQL Server 6.5 did it's database backups with

RE: Converting Access DB to SQL Database

2000-11-21 Thread Rick Lamb
They should have set up a new datasource for the sql database. Then you should have your dsn in your cf apps as a variable in the application.cfm page. So all you would have to do is change what the variable is. As far as upgrading your access database, I've used Microsoft Access 97 Upsizing

Java to cf

2000-11-21 Thread Rick Lamb
I've been handed a site that was written in jhtml using Java, class, and cgi for the backend stuff. The task I've been given is to convert this Java based website into a cf site (we don't support java). Anybody have any suggestions on how this could be done or if it is even feasible considering I

RE: Stucture help (from GetFunctionList)

2000-11-20 Thread Rick Lamb
The only way I know is to loop over the collection: cfloop collection="#structure#" index="key" /cfloop Rick -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 9:43 AM To: CF-Talk Subject: Stucture help (from GetFunctionList) This message

rounding to first decimal

2000-11-16 Thread Rick Lamb
I thought this would be simple. How can round a long integer eg: 2.146752 to the first decimal point? Thanks, Rick Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: rounding to first decimal

2000-11-16 Thread Rick Lamb
: rounding to first decimal On 11/16/00, Rick Lamb penned: I thought this would be simple. How can round a long integer eg: 2.146752 to the first decimal point? That's not an integer. LOL This is the way I do it: cfset number = "2.146752" cfset number = round(2.146752 * 10) / 10 = 2.1 Add

javascript to submit a form

2000-11-16 Thread Rick Lamb
This is a multi-part message in MIME format. --=_NextPart_000_005C_01C05012.824E8030 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Can somebody help me with the syntax to submit a form with an onclick even? Thanks, Rick

RE: Locking

2000-11-15 Thread Rick Lamb
It makes sense to me that it shouldn't cause any problems, but they still recommend doing it every time, whether for read only or not. The technique that Ben Forta recommends is after setting it to an application variable set it to the request scope for reference throughout the rest of the

RE: Setting up a webserver

2000-11-15 Thread Rick Lamb
Just go straight to service pack 6a. There is an order you should install the option pack. I think you need to install the option pack before installing sp6a. Rick -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 9:40 AM To: CF-Talk

RE: Back Button on Dynamic pages

2000-11-15 Thread Rick Lamb
I think this would work: onload { window.location.reload(true);} Rick -Original Message- From: Nathan Focht [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 11:02 AM To: CF-Talk Subject: Back Button on Dynamic pages This is a multi-part message in MIME format.

RE: How To Determine Logged In Users

2000-11-15 Thread Rick Lamb
Make them register, then store the info in a client variable or as a cookie on the client. Rick -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 2:51 PM To: CF-Talk Subject: How To Determine Logged In Users

RE: List Delimiter Question

2000-11-14 Thread Rick Lamb
Would it be possible to use a different delimiter? If so then just specify the delimiter in your list functions. Otherwise, you could do a replace function to take out submitted coma's and replace them with something else. Rick -Original Message- From: Craig A. Zingerline [mailto:[EMAIL

RE: Netscape 6 out UGH!!!!

2000-11-14 Thread Rick Lamb
Does any of this really matter? All that they should care about is if there browser conforms the W3C specifications so I can count on things to work how they are suppose to. Not how they are suppose to according to Microsoft or Netscape or any other browser. I thought that's what the whole point

RE: Force Download in Browser

2000-11-14 Thread Rick Lamb
You should supply the mime type in the cfcontent tag. Rick -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 4:14 PM To: CF-Talk Subject: Force Download in Browser This message is in MIME format. Since your mail reader does not

RE: Dump Entire Array Contents?

2000-11-14 Thread Rick Lamb
You can loop from 1 to arrayLen or use a custom tag called objectdump from the developer exchange. There is also cfa_object dump which does a similiar function as the custom tag cf_objectdump. These custom tags are mainly used for looking at complex data structures not for client side viewing.

RE: Force Download in Browser

2000-11-14 Thread Rick Lamb
I disagree. This is the syntax I use with the best success for all types of files: cfheader name="Content-Disposition" value="attachment; filename=#url.file#" cfif isdefined("url.nonsecure") !--- map to gates webdocs directory --- CFIF HTTP_USER_AGENT CONTAINS "MSIE"

RE: CFLOOP has me stumped again.

2000-11-13 Thread Rick Lamb
First off, there is no point in grouping your sql query by all the fields. This does nothing, and remember that there is a very big difference when you use grouping in sql then when you use grouping in cold fusion. I'll let you look into the sql group, but here is how i would use a cold fusion