CFQUERY help

2007-03-24 Thread Eric Creese
Trying to run this but it keeps on failing.I got the right permissions because I can run this fine in SQL Query Analyzer. BULK INSERT stgContacts FROM 'C:\CFusionMX\wwwroot\ileaflet\clients\1\contacts.txt' WITH (FIELDTERMINATOR = '|') ~~~

Re: Installation help

2005-12-20 Thread Eric Creese
Nobody have a clue? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:22737

Re: Installation help

2005-12-20 Thread Eric Creese
BTW no specific error code is generated. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/li

Re: HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

2005-08-02 Thread Eric Creese
okay but how can you do it in the profile on the HOF site? Barney Boisvert <[EMAIL PROTECTED]> wrote:Hit the unsubscribe link which is at the bottom of every email? cheers, barneyb On 8/2/05, eric.creese wrote: > How do you reset your email on this darn board. I am stuck getting emails to > tw

tiered pricing

2005-05-09 Thread Eric Creese
I have an ecom app I put together sometime ago. I need to allow for tired pricing for a customer so when some one updates their basket I need to 1.) do a check on the product and see if it has tiered pricing. 2.) if it does I need to determine the correct tier. 3.) apply the update to the basket

Re: take duplicate out of a list

2005-04-20 Thread Eric Creese
if you want to do this through the database backend simply add a new column to the table and assign a unique id, then find the row you want and delete it where the unique id = x - Original Message - From: "Keith Gaughan" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, April 20, 2005 6:

Re: MySQL DSN troubles

2005-03-28 Thread Eric Creese
Nothing? - Original Message - From: "Eric Creese" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, March 28, 2005 6:47 PM Subject: Re: MySQL DSN troubles > Nobody has any ideas? > - Original Message - > From: Eric Creese >

Re: MySQL DSN troubles

2005-03-28 Thread Eric Creese
Nobody has any ideas? - Original Message - From: Eric Creese To: cf-talk@houseoffusion.com Sent: Monday, March 28, 2005 5:46 PM Subject: MySQL DSN troubles Okay still having trouble with this. I downloaded the connector and followed the directions at this link (http

MySQL DSN troubles

2005-03-28 Thread Eric Creese
Okay still having trouble with this. I downloaded the connector and followed the directions at this link (http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253) However I now get a new error. Connection verification failed for data source: bhkjxk []java.lang.NoClassDefFoundError

Re: Setting up MySql Data Source

2005-03-28 Thread Eric Creese
Actually I checked the port at 3306 and that appears fine. I am using localhost for the server setting? Should I use something else? > I just loaded MySql to my development machine. I have MySql up and running and even created the database I will be using. I am trying to set up a DSN in CFAdmin bu

Setting up MySql Data Source

2005-03-28 Thread Eric Creese
I just loaded MySql to my development machine. I have MySql up and running and even created the database I will be using. I am trying to set up a DSN in CFAdmin but it keeps failing. Since this is a non-server machine do I have to change the port? my error Connection verification failed for da

RE: SQL Server Tuning Tools?

2005-03-17 Thread Eric Creese
sql-server-performance.com. get what you need there. -Original Message- From: Cynthia Reece [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 11:37 AM To: CF-Talk Subject: RE: SQL Server Tuning Tools? Sounds like you're talking about SQL Profiler. You can set up a trace of the a

RE: Server recommendations

2005-03-16 Thread Eric Creese
I take it that is a NO -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 3:22 PM To: CF-Talk Subject: RE: Server recommendations IIS 6.0 is part of Windows 2003. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent

RE: Server recommendations

2005-03-16 Thread Eric Creese
I am running Win2k IIS 5. I really do not want to change OS right now but would like to Upgrade from IIS5 to IIS6. Is this possible? -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 2:42 PM To: CF-Talk Subject: RE: Server recommendations We just m

RE: NCAA Pool App

2005-03-15 Thread Eric Creese
DOes not matter they will be out of it before you blink -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 3:04 PM To: CF-Talk Subject: Re: NCAA Pool App looks cool rick, might jazz it up, and make sql server database for it... on another note...i

RE: NCAA Pool App

2005-03-15 Thread Eric Creese
okay I am in -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 2:37 PM To: CF-Talk Subject: NCAA Pool App Okay, since nobody apparently has written an NCAA pool application, I did one myself. It is public domain! http://www.webworksllc.com/fina

RE: OT: Image Submit button

2005-03-15 Thread Eric Creese
shouldn'e mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 9:58 AM To: CF-Talk Subject: Re: OT: Image Submit button > I have another problem with a submit button. It works well as input > type="submit" and moves on to the next ten records, but when I change > it to an image it seems to ju

Re: CF to excel

2005-03-14 Thread Eric Creese
> This code snippet should prompt you to download/save each spreadsheet > w/o opening Excel directly. > > M!ke > > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Monday, March 14, 2005 9:22 PM > To: CF-Talk > Subject: CF to exce

CF to excel

2005-03-14 Thread Eric Creese
How come the following will not work. I get a 500 error CLASS of #getYRInfo.class_year# Spread Sheet #fname# #lname# #mname# #addr1# #addr2# #city# #state# #country# #zip# #email# #phone# ~

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
I am. However the email seems to get passed CF and I noticed the emails are all siting in the mailroot/Queue directory as NTFS*.eml's. Anyideaa why they would not go out? -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 2:16 PM To: CF-Talk

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
Not on port 25, on the new port I set up. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 11:28 AM To: CF-Talk Subject: Re: Using SMTP authentication for CFMAIL So you are running an open relay on port 25? Thats catastrophic. Restrict I

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
, You were getting verification and successfully mailing before adding the user:password@ part to your SMTP server name, right? Rick -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 12:07 PM To: CF-Talk Subject: RE: Using SMTP authentication

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
Subject: RE: Using SMTP authentication for CFMAIL Eric, You were getting verification and successfully mailing before adding the user:password@ part to your SMTP server name, right? Rick -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09,

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
Ok got it to verify. So I tried sending an email. Wait nothing comes to me. So I check the Event Log and find the following error: Message delivery to the remote domain 'message.alltel.com' failed for the following reason: The remote server did not respond to a connection attempt. -Origi

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
CFMAIL if your router is only allowing traffic from specific ports, then yes. On Wed, 9 Mar 2005 10:27:53 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > am I going to have to change this in my router as well? > > -Original Message- > From: Matt Robertson [mailto:[EMAIL

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
Okay I made the port changes in the two areas. Allowing Annonymus access. Stoped SMTP service and restarted. Go into CFAdmin, enter my ip address and server port, check to verify and submit, and still check verification fails. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTEC

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
am I going to have to change this in my router as well? -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 10:11 AM To: CF-Talk Subject: Re: Using SMTP authentication for CFMAIL oh and also the button marked 'connection' on the same dialog.

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
open the smtp service dialog and click advanced next to ip address. the rest should be simple enough :-) On Wed, 9 Mar 2005 09:57:20 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > Thanks for the info. > > Okay how and where do I set the SMTP port? > > -Original Mess

RE: Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
Thanks for the info. Okay how and where do I set the SMTP port? -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 9:57 AM To: CF-Talk Subject: Re: Using SMTP authentication for CFMAIL to into the cf admin and click Mail Settings. In the m

Using SMTP authentication for CFMAIL

2005-03-09 Thread Eric Creese
Okay I have my SMTP ACCESS tab set up where the Annonymmus box is unchecked and the Basic and Windows boxes are checked. So now I am assuming that to use my SMTP you will have to authenticate. So in CFAdmin how do you set this up. It states to authenticate you need to enter this format for the S

Using CFMAIL

2005-03-07 Thread Eric Creese
System Win2K IIS CFMX 6.1 Ok this is my taks today to get settled once an for all. I use CFMAIL in my applications that I write and host on my own server. I do not have any applications that accept mail. I simply use CFMAIL to send emails based on users requests, i.e. Forgotten password, or sub

RE: Spyware and registry

2005-03-01 Thread Eric Creese
running win2K, sorry. Thanks for the info though -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 10:31 AM To: CF-Talk Subject: Re: Spyware and registry Ericif you're using XP you may need to turn off System Restore before you clean th

OT: Spyware and registry

2005-03-01 Thread Eric Creese
I am using SpyBot Search and destroy. It cleans most of the crap off of my machine however I got 3 entries it does not seem to get rid of and they are hooked into my registry. They are below. Can I go into regedit and simply delete the keys? DSO Exploit: Data source object exploit (Registry ch

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
thanks ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196355 Archives: h

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
@fullname = substring(@fullname,Charindex(' ',@fullname) + 1 ,len(@fullname)) Set @fullname = substring(@fullname,1 ,charindex( ' ', @fullname )) return @fullname END On Thu, 24 Feb 2005 10:43:04 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > I will give it a try. I wnet

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
X(' ', Names, 1)) - 1) + '::' 'LastName' FROM #temp DROP TABLE #temp I've put :: on either side to make sure no white space is being returned along with the name. Ade -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 24 February 200

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
ames LITTLE, LITTLE VICTOR and LITTLE Victor? LITTLE DONALD V LITTLE DONALD VICTOR LITTLE DONALD Victor JR Ade -----Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 15:37 To: CF-Talk Subject: RE: OT-SQL matching Okay I go something to work so my orginal ques

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
Okay I go something to work so my orginal question is taken care of. However I have another question that deals with this sort of thing. I am now looking at another datasource that I am going to have to match on at somepoint later but they have a single name field where a persons name is one fie

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
VALUES ( 'GORE', 'AL', 'BACKWOODS' ) INSERT INTO #table2 ( LName, FName, City ) VALUES ( 'BRADSAW', 'TERRY', 'HOUSTON' ) SELECT t1.*, t2.* FROM #table1 t1 INNER JOIN #table2 t2 ON ( t1.LName = t2.LName OR SUBSTRING(t1.LName, 1, CHARINDEX('

RE: OT-SQL matching

2005-02-23 Thread Eric Creese
. Is that any help? Ade -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 23 February 2005 22:22 To: CF-Talk Subject: RE: OT-SQL matching TABLE1 LNAME FNAME CITYST DOE JR JOHNPHOENIX AZ GATES BILLREDMOND WA GORE IIIA

RE: OT-SQL matching

2005-02-23 Thread Eric Creese
: Left(str, Len(str) - Len(ListLast(str, " ")) - 1) The only difference would be how you do something like ListLast in SQL. Ade -Original Message----- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 23 February 2005 22:03 To: CF-Talk Subject: RE: OT-SQL matching Thanks but I am doi

RE: OT-SQL matching

2005-02-23 Thread Eric Creese
;s always a one word suffix then try #Left(yourQuery.yourColumn, Len(ListLast(yourQuery.yourColumn, " ") + 1))# Not tested but it looks right. Ade -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 23 February 2005 21:48 To: CF-Talk Subject: OT-SQL matching F

OT-SQL matching

2005-02-23 Thread Eric Creese
For a CF page I am doing I need to out put matched results. However in one table I have last names with a suffix like "MOLINA JR" and in another table the last name and suffix are in different columns. I need to strip out the suffixes as well as the preceding space in the first column. Any ideas

RE: How u convert this cfquery to TSQL for MS SQL stored procedure

2005-02-21 Thread Eric Creese
for speed. So the goal here is to have MS SQL 2000 do the work instead of CF. And my problem... ahem... challenge... is converting this logic into TSQL :( Thanks for your response though:) - Original Message - From: "Eric Creese" <[EMAIL PROTECTED]> To: "CF-Talk&qu

RE: How u convert this cfquery to TSQL for MS SQL stored procedure

2005-02-21 Thread Eric Creese
may not have to do that if you try the following select * from profiles where 0=0 and firstname='#form.firstname#' and zipcode in () -Original Message- From: Pardeep Singh [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 1:32 PM To: CF-Talk Subject:

RE: SOT - Ecommerce

2005-02-18 Thread Eric Creese
Do not mean to take this in another direction but since we are on the topic of Gateways and PayPal inparticular I have a question. I tried following the PayPal turtorial on EasyCFM.com but it does not work for me and I end up having to process peoples accounts myself. Basically they sign up it

RE: Getting SQL Data

2005-02-18 Thread Eric Creese
can you not make a back up of the db and FTP the bak file to your server or set up a job that could right the backup toa remote server? -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 1:29 PM To: CF-Talk Subject: Getting SQL Data I have an SQL data

RE: MySQL charging hard?

2005-02-18 Thread Eric Creese
2005 10:55 AM To: CF-Talk Subject: Re: MySQL charging hard? On Fri, 18 Feb 2005 10:34:31 -0500, Rick Root <[EMAIL PROTECTED]> wrote: > Eric Creese wrote: > > Does not sound as if you Oracle tunned properly and being that you do not > > have DBA on staff that can make it c

RE: MySQL charging hard?

2005-02-18 Thread Eric Creese
Does not sound as if you Oracle tunned properly and being that you do not have DBA on staff that can make it challenging. With it tunned properly it runs great in my oppinion. Plus your applications may not be tunned properly either. I also Run SQL2K and it has its benefits as well. Dabbled litt

RE: OT - Sql Help

2005-02-17 Thread Eric Creese
I created a table called test with two columns tid(identity int) and tdate(datetime filled it with date values. This is in SQL2k SELECT * FROM test where datepart(month,tdate) Between 1 and 2 and datepart(year,tdate) =2005 -Original Message- From: Mickael [mailto:[EMAIL PROTE

RE: CF 5.0

2005-02-17 Thread Eric Creese
Try SELECT * FROM getMemberActivity ORDER BY call_date ,call_time DESC -Original Message- From: Paul Roe [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 9:34 AM To: CF-Talk Subject: CF 5.0 Hey I'm having a problem I have data in a table that looks like this Call_Date 2005-0

RE: Alternatives to Windows SMTP service

2005-02-16 Thread Eric Creese
Ok so I am trying to get my SMTP working but when I changed all the port information and startted it I went into CFAdmin and set the Mail properties and it keeps failing? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wed 2/16/2005 4:15

RE: Using CFMAIL

2005-02-16 Thread Eric Creese
does this mean I need to close the port 25 and open 2526? -Original Message- From: Eric Creese Sent: Wednesday, February 16, 2005 3:26 PM To: CF-Talk Subject: RE: Using CFMAIL Thanks I will give it a try -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent

RE: Using CFMAIL

2005-02-16 Thread Eric Creese
Thanks I will give it a try -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 3:07 PM To: CF-Talk Subject: Re: Using CFMAIL On Wed, 16 Feb 2005 08:54:52 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > Yes I do need that hel

RE: Alternatives to Windows SMTP service

2005-02-16 Thread Eric Creese
I would like too but I am not sure how to configure it. I had it working before but my event log was getting filled up and my server comes to a grinding halt so I turned it off. Soon as I turn it on I get the following messages. If you like I can tell you what the properties for SMTP are set to.

RE: Alternatives to Windows SMTP service

2005-02-16 Thread Eric Creese
Not sure if I mentioned or not but I do not offer email service to my clients they usually get that from their ISP. I simply build sites and host them for them. And in my sites I have some very basic features that send emails from my server from the app but the apps are not email applications li

Alternatives to Windows SMTP service

2005-02-16 Thread Eric Creese
I would like to know what alternatives there are to Windows SMTP. I use Win SMTP for my web Apps to send emails to the owners of my web apps such as question form, or email notifications to web app clients when a pucrchase was made at their estore, or sending password requests.

RE: Using CFMAIL

2005-02-16 Thread Eric Creese
Yes I do need that help cause I would like to use it. What else can I use that is FREE? -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 6:32 PM To: CF-Talk Subject: Re: Using CFMAIL So you mean the Windows SMTP service, right? Personal

RE: Using CFMAIL

2005-02-15 Thread Eric Creese
In the Event Viewer for the log file, particularly the SYSTEM log. When you go into the Properties setting for SMTP is there something I need to set correctly to stop this. Essentially if I turn the SMTP service on, my server comes to a stand still. I am running Win2K SP3, IIS 5.0, CFMX6.1 -

Using CFMAIL

2005-02-15 Thread Eric Creese
I am using CFMAIL for some of my applications. Problem I am having is SMTP. Not sure how I need to set it up to work. I turned SMTP on and the log file is filling up with warning meesages that other are trying to use my server for relaying and are denied. But when I turn SMTP on my server goes t

RE: a distinct sql problem....

2005-02-15 Thread Eric Creese
Porbably is pulling multiple distinct dates -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 8:19 AM To: CF-Talk Subject: Re: a distinct sql problem this is what I'm getting back (fields truncated)... as you can see I get multiple cand

RE: Web Analytics

2005-02-14 Thread Eric Creese
Statistex -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, February 14, 2005 8:17 AM To: CF-Talk Subject: RE: Web Analytics WebLog Expert isn't too bad. Gives basic feedback on traffic without all the complex options of WebTrends. Also, only costs about $7

SQL Stored Proc output

2005-02-10 Thread Eric Creese
>From a web page I allow users to create a text file via a stored proc(below). >However the problem I am having is the txt file that the stored proc creates >is huge filled with spaces and carriage returns between each record output. CREATE PROCEDURE testpullfile AS DECLARE @cmdva

OT-Server question but not sure if CF related or not

2005-02-09 Thread Eric Creese
Not sure if this is CF related. I run CF on Win2k, and IIS of course. Whenever I reboot my server I usually have to go into Services and shutdown IIS and restart WWW service. If I do not you can go to www.mypage.com but not www.mypage.com/about.cfm? Has anyone else experienced this and does it h

RE: OT SQL question-SOLVED

2005-02-08 Thread Eric Creese
danke! -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 2:12 PM To: CF-Talk Subject: Re: OT SQL question Eric Creese wrote: > I want to verify email addresses that are entered into one of my apps. > Unfortunately I already inh

RE: OT SQL question

2005-02-08 Thread Eric Creese
link http://vyaskn.tripod.com/handling_email_addresses_in_sql_server.htm On Tue, 8 Feb 2005 12:55:42 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > I want to verify email addresses that are entered into one of my apps. > Unfortunately I already inherited close to 100k email addres

OT SQL question

2005-02-08 Thread Eric Creese
I want to verify email addresses that are entered into one of my apps. Unfortunately I already inherited close to 100k email address. So I want to do the following in SQL via a stored procedure so I can write the bad addresses out to an error table. Need to check if there is an @ sign, if the TD

RE: Time Entry code

2005-02-07 Thread Eric Creese
I wrote an application that do this all you would have to do is import the existing excel sheet into the database. of course there will be a need for modifying the excel to meet the database schema. -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED] Sent: Monday, February 07

RE: Time Entry code

2005-02-07 Thread Eric Creese
-Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED] Sent: Monday, February 07, 2005 1:24 PM To: CF-Talk Subject: Re: Time Entry code Chris, Was'up... Use ColdFusion Components and with a Flash MX front end. Sorry, but I have no code to share though. Troy On Mon, 7 Feb 20

RE: Hot fixes

2005-02-07 Thread Eric Creese
Okay from what I am reading then i will only need the trhee hot fixes located in the table ColdFusion MX 6.1 Updater Hot Fixes since I applied the 6.1 Updater already. Just making sure it is just these three. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, Fe

Hot fixes

2005-02-07 Thread Eric Creese
Ok I installed the 6.1 updater this weekend. Is there a complete list of hot fixes I need to also install? I looked but I missed. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Star

Pitfalls or gotchas uprading from CFMX 6.0 to 6.1x?

2005-02-03 Thread Eric Creese
Pitfalls or gotchas uprading from CFMX 6.0 to 6.1x? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware t

RE: How do you change the color of each row?

2005-01-31 Thread Eric Creese
-Original Message- From: Discover Antartica [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 3:02 PM To: CF-Talk Subject: Re: How do you change the color of each row? is there a way to do this without CSS? Barney Boisvert <[EMAIL PROTECTED]> wrote: tr.alt1 td { backgro

RE: Need single quotes in SQL but is stored inside variable. - SOLVED

2005-01-24 Thread Eric Creese
, 2005 4:46 PM To: CF-Talk Subject: RE: Need single quotes in SQL but is stored inside variable. Have you tried it? I think it will work. Ade -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 24 January 2005 22:33 To: CF-Talk Subject: RE: Need single quotes in SQL but

RE: Need single quotes in SQL but is stored inside variable.

2005-01-24 Thread Eric Creese
e the single quotes like so? @QUERY= 'SELECT email FROM table WHERE donotemail = ''Y''' ~Cynthia -----Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:25 PM To: CF-Talk Subject: Need single quotes in SQL but is stored insi

Need single quotes in SQL but is stored inside variable.

2005-01-24 Thread Eric Creese
I need to write out a SQL statement to a string and set it to a varible inwhich i can call it from the EXEC() command. However in my SQL state ment I have to use single quotes for string criteria for example : SELECT email FROM table WHERE donotemail = 'Y' But what I have to do is take that exmp

RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed.

2005-01-24 Thread Eric Creese
Hey that worked, thanks. I tried this below the create statement and kept failing. Now i get a new error. Any idea/ i am searching for it on line as we speak, but everything I am find is for import not export. Error as follow: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsof

RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed.

2005-01-24 Thread Eric Creese
I did that but I still can not get the SQL statment to fire and fill the excel file. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 2:36 PM To: CF-Talk Subject: RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed. Re

OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed.

2005-01-24 Thread Eric Creese
Ok I have a created a stored procedure that gets a list of email addresses on Thurdays and will write them to an EXCEL file, the logic decent and works however when the statement that fetches the data is run I keep getting the "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS opti

Using variables to build a string

2005-01-20 Thread Eric Creese
I am trying to build a chatracter string with parts of a date to name an excel file I am outputing. But it's trying to mathmatically calulate the values. Can't remember how to do this. can anyone help??? SET @month = CONVERT(varchar(3),DATENAME(m,getdate())) SET @day = CONVERT(varchar(2),DATEPAR

RE: Table Layout

2005-01-20 Thread Eric Creese
Here is a little thing I do but the empty cell part I do not have. ~| Discover CFTicket - The leading Cold

OT-SQL DATE QUESTION

2005-01-20 Thread Eric Creese
Okay I have a function that retrieves the last day of the month based on feeding it todays date which would return 1/31/2005. I am trying to modify this function to determin if today is the last Thursday of the month. Does anyone have any ideas for this? I have tried a few things like using the

RE: Double tick confusion

2005-01-18 Thread Eric Creese
thanks -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 12:54 PM To: CF-Talk Subject: RE: Double tick confusion > From: Eric Creese [mailto:[EMAIL PROTECTED] > I am a little confused on the double tick. I am aloowing >

RE: MySql to Sql Server Convert LIMIT

2005-01-18 Thread Eric Creese
LIMIT like the number of records you return If so SQL server has TOP [number of records]. Not sure if that is what you are looking for? -Original Message- From: Lori [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 12:51 PM To: CF-Talk Subject: MySql to Sql Server Convert LIM

Double tick confusion

2005-01-18 Thread Eric Creese
I am a little confused on the double tick. I am aloowing users to store a (") in a product name to indicate inches( 1"x2"x4") but when they go to edit the product forinstance and display the name in the form everything after the first (") is gone. How do I correct this? I thought I took care of

RE: ASP help

2005-01-05 Thread Eric Creese
Be careful asking such questions that are not CF and that you can easily Google, cause John Burns will let you know about it. I am surprised he has not scolded you yet. -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 05, 2005 8:17 AM To: CF-Talk Su

RE: OT-ASP pagination

2004-12-16 Thread Eric Creese
, Web Developer -----Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 11:29 AM To: CF-Talk Subject: RE: OT-ASP pagination I figured most on this board would have more knowledge of other things than CF. Sorry you are so limited. -Original Me

RE: OT-ASP pagination

2004-12-16 Thread Eric Creese
it appears that I somehow hurt your feelings by doing so. I'm sorry to hear that you're easily upset and hope you find your answers to your questions. John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Eric Creese [mailt

RE: OT-ASP pagination

2004-12-16 Thread Eric Creese
more appropriate for specific ASP questions. John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 10:56 AM To: CF-Talk Subject: OT-ASP pagination Ok I have

RE: OT-ASP pagination

2004-12-16 Thread Eric Creese
Active Server Pages -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 10:10 AM To: CF-Talk Subject: RE: OT-ASP pagination ASP as in Active Server Pages? , or ASP.NET ( or even C# .NET) .. Micha Schopman Software Engineer Modern Media,

OT-ASP pagination

2004-12-16 Thread Eric Creese
Ok I have not touched ASP in a few years. I have been using nothing but ColdFusion for 4 years. Now the company I am with I have unsuccessfully been unable to convince them to use CF. So They have taked me to create a page in which I have comeup with the idea to use pagination. Basically we have

RE: Passing variable in cffile-solved

2004-12-14 Thread Eric Creese
the 2 and i usually have both in > the application page but comment 1 out depending on if its live or local > > also > destination="#updir#\small\" > > should be > destination="#updir#/small/" > > on the live server > > -- Original Me

CFFILE upload error help needed please.

2004-12-14 Thread Eric Creese
can someone tell me why I would get this error while trying to upload a file? String index out of range: -4 The error occurred in C:\CFusionMX\wwwroot\portplus\x_admin_edit2.cfm: line 50 48 : 52 : step8 ~| Special thanks

Passing variable in cffile

2004-12-14 Thread Eric Creese
trying to pass a vaiable intot the destination field of CFFILE tag and it pukes. I always thought this could be done? I keep getting an error. Attribute validation error for tag CFFILE. The value of the attribute destination, which is currently "C:\CFusionMX\wwwroot\portplus\images\2\small\", i

RE: Deleting Multiple files with CFFILE??????-SOLVED

2004-12-14 Thread Eric Creese
deleted. Then use CFDirectory Again to delete the directory. You can not delete multiple files with one CFFILE statement -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 12:19 PM To: CF-Talk Subject: Deleting Multiple files with CFFILE?? I

Deleting Multiple files with CFFILE??????

2004-12-14 Thread Eric Creese
I want to use CFFILE to remove all the pictures in a directory then use CFDIRECTORY to remove the directory. How can I do this with CFFILE using a wildcard to get all the files deleted at once.? ~| Special thanks to the CF Co

OT- DBA question SQL2K

2004-12-10 Thread Eric Creese
When setting up backup strategies would you rather wrtie the commands and save them in a job and schedule them or use the Data Maintainence Plan Wizard? I simply write the code and stick it in jobs and it works fine, however I got some people her telling me to use the Wizard because jobs are unr

RE: Basic ColdFusion sending E-mail question.

2004-12-08 Thread Eric Creese
I used to do this but found my SMTP was being attacked, What is the best way to secure the SMTP so I can start using CFMAIL again. I am afraid to use it cause of the attacks. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 3:27 AM To

RE: OT-javascript-Solved

2004-12-07 Thread Eric Creese
Like I said i am an idiot -Original Message- From: G [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 11:43 AM To: CF-Talk Subject: Re: OT-javascript Eric, just add

RE: OT-javascript

2004-12-07 Thread Eric Creese
yes I am an idiot. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 11:37 AM To: CF-Talk Subject: RE: OT-javascript You can see it here: http://www.cvwp.com/test/test.html Does that help? Ray At 12:27 PM 12/7/2004, you wrote: >? >

  1   2   3   4   5   >