Help with joins...

2007-07-21 Thread Mickael Pervinski
I have two tables. Animals - AnimalID AnimalNAME AnimalSEX Projects - ProjectID MaleID FemaleID Let's say Projects holds MaleID:1 and FemaleID:2 I need to write a query that joins these tables, and basically pulls back two sets of animal information per one record in the

Re: Running a DTS package with CF

2005-12-29 Thread Mickael Elmalem
Thanks for the info that works great. I just need to figure out, as Bryan said why it runs as per the schedule most times but does not at others. Mike ~| Find out how CFTicket can increase your company's customer support

Running a DTS package with CF

2005-12-28 Thread Mickael Elmalem
Hello All, I am hoping that someone help me with this one. We have a server in our local network that synchronizes to a remote website. This is done by a DTS package running on a machine in our network at scheduled intervals. The issue is for what ever reason the DTS package that is

File Uploads from Users

2005-12-25 Thread Mickael Elmalem
Hello All, I have an app where users can upload files to their respective folders, the folders are created dynaically when a user is created in my app. I was using CFFILE to upload the files to the file system but the size of the files that you can upload is not very large. There is a

Problem with MySQL

2005-10-25 Thread Mickael Elmalem
Hello All, I have a problem with an app that I inherited that was not working properly. The database is MySQL but they want to convert it to a new database after extracting the old data. I do not have much experience with MySQL and I am stumped with one field that they have in the

Re: Problem with MySQL

2005-10-25 Thread Mickael Elmalem
I just want to get in a format that my client can view on thier desktop to reveiw some of the database contents then place it in MS SQL Nice, helpful response there knucklehead. The BLOB datatype (Binary Large Object) is usually used for storing images in MySQL and stuff like that. My first

Re: Problem with MySQL

2005-10-25 Thread Mickael Elmalem
://dev.mysql.com/doc/refman/4.1/en/blob.html !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 8:40 AM To: CF-Talk

OT-Visual Web Server

2005-10-21 Thread Mickael Elmalem
Hello, Sorry for being OT but I am sure that someone on this list can help me out here. I have an app that my customer wants to host on their own webserver. I gave them the basic config that I require. They came back to me and said that they have decided to go with a Single IP, name based

RE: OT-Visual Web Server

2005-10-21 Thread Mickael
, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! -Original Message- From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Sent: Saturday, 22

Re: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Mickael Elmalem
Hi Joe, Do you know where I can get those updates? Are they cumulative, so that if I install the lastone it will be enough? Hi Mickael, Have you made sure that the most recent SQL server updates are installed? I've had this exact problem after installing recent CF JDBC drivers. -Joe On 10

Re: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Mickael Elmalem
Hi Mark, I have tried, localhost, my machine name also 127.0.0.1 Nothing helps. It is really strange. Mickael, Add an entry in your host file for your machine - or use localhost or 127.0.0.1. When you say my machine name' you are really talking about an NBT name - and the JDBC system would

Re: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Mickael Elmalem
and it worked fine Mickael, Also, using the server network utility (part of SQL server tools) unload the mixed protocol and named pipes - leaving ONLY tcip/ip. -Mark -Original Message- From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 3:07 PM To: CF-Talk Subject

Re: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Mickael Elmalem
Thanks Mike This did the trick From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Do you know where I can get those updates? Are they cumulative, so that if I install the lastone it will be enough? http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446- 99A9

Problems Making a CF DSN to SQL Server

2005-10-18 Thread Mickael Elmalem
Hello All, I need to do some work on a clients site locally on my machine. This is a new laptop that has just been installed for me. I have installed CF 6.1 on the machine because that what the customer is using and Sql Server. I am not able however to get an MS SQL dsn in CF to work. I

CFX_File

2005-10-18 Thread Mickael Elmalem
Hello, I am having a lot of trouble with CFFile on an NT machine. I poked around on google and found a tag called CFX_FILE, how do I get that tag? This is for CF5 Thanks Mike ~| Discover CFTicket - The leading ColdFusion

Re: CFX_File

2005-10-18 Thread Mickael Elmalem
Message- From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 5:09 PM To: CF-Talk Subject: CFX_File Hello, I am having a lot of trouble with CFFile on an NT machine. I poked around on google and found a tag called CFX_FILE, how do I get that tag? This is for CF5

Re: CFX_File

2005-10-18 Thread Mickael Elmalem
The tag is returning the message Action Unknow : Copy Here is my code CFX_FILE USERNAME=username PASSWORD=password ACTION=Copy source=\\machinename\sharename\file.txt destination=c:\inetpub\wwwroot\testfiles\ From: Mickael Elmalem [mailto:[EMAIL PROTECTED] I am having a lot

Re: CFX_File

2005-10-18 Thread Mickael Elmalem
Tried that too. I tried COPY, copy, Copy Still no luck Copy? [...] copy? May be the check for the action is case sensitive. If it is a CFX, it must be in C or Java which bothe compare strings case sensive by default. -- ___ REUSE CODE! Use custom tags;

Re: CFX_File

2005-10-18 Thread Mickael Elmalem
The problem that I was trying to copy a file from an NT Share and I was getting the following error Error: Access is denied. (error 5). This share is open to Everyone. Mike From: Mickael Elmalem [mailto:[EMAIL PROTECTED] The tag is returning the message Action Unknow : Copy No, what

Re: CFX_File

2005-10-18 Thread Mickael Elmalem
Actually CF is running as a user account that has access to that share. I have it working on a different machine with that setup. But it still doesn't explain why CFX_FILE doesn't work. Shouldn't the fact that the tag passes a username and password overcome the permission problem? The

CFTRY and CFCATCH

2005-10-10 Thread Mickael
Hi All, I have never really had a good handle on CFTRY and CFCATCH. If I have an error on my website as follows The request has exceeded the allowable time limit Tag: CFQUERY What type of cfcatch is that? Or can that not be caught by CFCatch? Mike

CF Query Timeout

2005-10-09 Thread Mickael
Hello, I have a unique situation that I only have limited control over. I was hoping someone on the list could provide some assistance. Here is my issue. A have a CF Site on a shared hosting account at Crystaltech. The database is Access. This was fine for a certain amount of time but now

Re: block forms from being filled out automatically

2005-09-14 Thread Mickael
computer pointed at my client's site or not. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET http://ASP.NET hosting from AUD$15/month On 9/14/05, Mickael [EMAIL PROTECTED] wrote: Hi, One of my

block forms from being filled out automatically

2005-09-13 Thread Mickael
Hi, One of my clients is getting bombarded by some jerk, connection to a form on his webpage and filling out the fields with junk and submitting the forms. What can I do to prevent a computer from filling out my forms. I don't really want to use that crazy jumbled image where to you type in

Gateway Pages and IIS

2005-08-12 Thread Mickael
Hi All, I am hoping that someone on this list has worked through this before I reinvent the wheel. We have a small content management system that we have written that allows users to make changes to their site. We would like to add a new feature where users can create gateway for marketing.

Re: Gateway Pages and IIS

2005-08-12 Thread Mickael
generating a www.doamin.com/marketing.htm page would be better than www.ourdomain.com/index.cfm?pageid=111 Russ -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: 12 August 2005 16:59 To: CF-Talk Subject: Gateway Pages and IIS Hi All, I am hoping that someone on this list has

Displaying a TimeStamp in CF

2005-08-01 Thread Mickael
Hello, I have been trying to Steve Ray's Bugtracker to work on my laptop. I know the code works but I am not sure what database this was originally designed for. I am using MSSQL and CFMX 7. The code is trying to return a field called change_date the datatype in MSSQL is TimeStamp, the

Re: OT - MySQL to MSSQL

2005-07-04 Thread Mickael
Thanks I will try that. - Original Message - From: George Abraham [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, July 01, 2005 2:36 PM Subject: Re: OT - MySQL to MSSQL Mickael, DTS comes with MS SQL's Enterprise Manager. And yes, DTS will create the tables, etc

OT - MySQL to MSSQL

2005-07-01 Thread Mickael
Hi All, I was wondering if someone can point me to the best way to import a = MySQL Database to a new MS SQL Database. There is an export utility in = MySQL that exports that tables to a text file with the create table = statements and all the content. But I think this only works from One =

Re: Fusebox + Sajax?

2005-07-01 Thread Mickael
I thought Fusebox works in PHP as well? - Original Message - From: Damien McKenna [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, July 01, 2005 9:59 AM Subject: Fusebox + Sajax? Has anyone tried using Sajax in a Fusebox application? I was concerned over how the

Re: OT - MySQL to MSSQL

2005-07-01 Thread Mickael
, Mickael [EMAIL PROTECTED] wrote: Hi All, I was wondering if someone can point me to the best way to import a = MySQL Database to a new MS SQL Database. There is an export utility in = MySQL that exports that tables to a text file with the create table = statements and all the content. But I

Zipping or Rar Large Files with Coldfusion

2005-06-05 Thread Mickael
Hello, I have a really large Txt file that I would like to Zip then Send to my server then upzip it there using CFX_ZIP. The problem that I am running in to is that the file is too large for a valid zip archive the file is over 5gb. Each time I try to unzip it on the server I get a corrupt

RE: Zipping or Rar Large Files with Coldfusion

2005-06-05 Thread Mickael
line tools for WinRAR (http://www.rarlab.com/download.htm), using cfexecute. Works well for me, but the largest file I've unzipped is around 100 meg. HTH, Brad Roberts -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Sunday, June 05, 2005 5:18 PM To: CF-Talk Subject

Re: HTML Editor

2005-03-24 Thread Mickael
? That's my favorite one. -Dustin -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 3:02 PM To: CF-Talk Subject: HTML Editor Hello All, I am sorry for being OT but I was wondering if anyone could point me in the right direction in regards

HTML Editor

2005-03-23 Thread Mickael
Hello All, I am sorry for being OT but I was wondering if anyone could point me in the right direction in regards to an HTML Editor that can be used for my users to edit their own pages. I have been using FCK editor and SoEditor but find that their support for stylesheets is terrible. Can an

Hosting for SEMI dedicated

2005-03-17 Thread Mickael
Hi All, I know that hosting has been discussed many times on this list. But I would still like to know who the stars are. I am presently hosting with Hostmysite.com and crystaltech.com but as of late their machines are getting overloaded. I am looking for semi dedicated hosting for CF 6.1

Re: Hosting for SEMI dedicated

2005-03-17 Thread Mickael
Will they be able to stay on 6.1 for a while. There seems to be an issue with FB4 Code running CFMX7 that I would rather not get in to right now until the proper fixes get resolved. Mike - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com

UI Problems

2005-03-14 Thread Mickael
Hello All, My developer and I are working on a CMS for various clients. Our clients keep coming up with new requirements as the project grow or change. We are not having any issues meeting these requirement for new functionality on the website. But in my opinion we are not achieving an

Re: OT - UI problems

2005-03-14 Thread Mickael
problems -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Sunday, March 13, 2005 9:51 AM To: CF-Talk Subject: OT - UI problems Hello All, First off you might consider posting this to cf-community - the discussion there could go much farther than here

OT - UI problems

2005-03-13 Thread Mickael
Hello All, My developer and I are working on a CMS for various clients. Our clients keep coming up with new requirements as the project grow or change. We are not having any issues meeting these requirement for new functionality on the website. But in my opinion we are not achieving an

Redirects on Region

2005-02-20 Thread Mickael
Hello All, I was wondering if someone could tell me how the following is done. When you go to google.com for instance it knows that I am from Canada and redirects me to google.ca. I would like to implement the same sort of thing on a site that I working on. For me is it is a little simpler,

Re: Redirects on Region

2005-02-20 Thread Mickael
van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, February 20, 2005 12:01 PM Subject: Re: Redirects on Region Mickael wrote: When you go to google.com for instance it knows that I am from Canada and redirects me to google.ca. I would like to implement the same

Re: Redirects on Region

2005-02-20 Thread Mickael
Cool thanks - Original Message - From: Paul Hastings [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, February 20, 2005 9:57 PM Subject: Re: Redirects on Region Mickael wrote: Thanks for the info. I haven't looked at it in its entirety yet. But is says

OT - Sql Help

2005-02-17 Thread Mickael
Hi All, I am a little stumped with the following task in SQL which seems simple enough to me. I have a form that my users can select a range of Dates for a particular report. The range is not day month year, but month and year and ending month and year. In my database I have a date field,

Re: OT - Sql Help

2005-02-17 Thread Mickael
Hi Rick, That is simple. Thanks just what I was looking for - Original Message - From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, February 17, 2005 11:26 AM Subject: Re: OT - Sql Help Mickael wrote: select * from table where date between

Looking for an FB4 Developer

2005-02-11 Thread Mickael
Hello All, Sorry for being OT. I am looking for a developer in the Toronto Area preferably or someone that is really good at working remotely. To make some ongoing changes and work on a CFMX Fusebox 4 site. Should have a good understanding of FB4 and MSSQL (stored procs) Please reply off

Re: Replacing variable text in a string

2005-02-02 Thread Mickael
primary_assign_id = [[:digit:]]{3},,ALL)# /cfoutput Good luck. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday

Re: Replacing variable text in a string

2005-02-02 Thread Mickael
Please disregard Ryan, This is working fine, it seems that I left out a space before the Digit statement. Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and

Replacing variable text in a string

2005-02-01 Thread Mickael
Hello, I would like replace a portion of a string that is a SQL statement generated by my users via an interface that I have created. I have never used Regular Expressions but from what I have heard about this task sounds like a candidate. I would like to update a SQL statement that is

Re: Replacing variable text in a string

2005-02-01 Thread Mickael
variable text in a string RERepalce(yourString,set primary_assign_id = [:digit:]{3},,all) Should work, but has not been tested. On Tue, 1 Feb 2005 12:57:51 -0500, Mickael [EMAIL PROTECTED] wrote: Hello, I would like replace a portion of a string that is a SQL statement generated by my

OT-SES Consultants

2005-01-28 Thread Mickael
Hi All Sorry for being OT. I have a client that needs search engine optimization done on their website. I would like hire a consultant to do this for me. The site already has SES friend URLs. Can anyone recommend a good and reliable SEO consultant offlist, someone that you have had good

OT Content Protection

2004-12-07 Thread Mickael
Hi All, Sorry for being OT. But I was wondering how the following was accomplished. I went to the following page http://www.nymity.com/pipeda/pipeda.asp#4_9principle9individualaccess And I was not able to highlight the text, to copy in IE or able to Right click copy in Firefox. How is

OpenSource Calendar

2004-12-03 Thread Mickael
Hello All, I am donating some time to a charitable organization. They need a web calendar like the monthly view in Outlook. Were the day is broken down in 1 hour increments and those one hour slots can be booked. Is there something like that in CF available in opensource or something that

Re: OpenSource Calendar

2004-12-03 Thread Mickael
Hi David, Actually all three views would be great. Is there a demo of this working? - Original Message - From: COLLIE David [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 03, 2004 8:04 AM Subject: RE: OpenSource Calendar I am donating some time to a charitable

Re: OpenSource Calendar

2004-12-03 Thread Mickael
- From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 7:02 AM To: CF-Talk Subject: Re: OpenSource Calendar Hi Mickael maybe this is the best web calendar on the web: http://dynarch.com/mishoo/calendar.epl Open source... Cheers Marco On Fri, 3 Dec 2004

Re: OpenSource Calendar

2004-12-03 Thread Mickael
This is cool. Thanks Steve. - Original Message - From: Steve Bryant [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 03, 2004 11:10 AM Subject: Re: OpenSource Calendar You might take a look at this one: http://cfopen.org/projects/coldcalendar/ (one of several

OT Customize DW's HTML tags

2004-11-14 Thread Mickael
Hi All, I sure this is possible, but I just wanted to know where to do it. I would like to customize DWMX so that when I select a tag it comes out how I chose. For example when I select img it comes out as img src=image.gif But I would like the default to be img src=image.gif border=0 And

Re: DW Title Bar

2004-11-10 Thread Mickael
a plugin at communitymx.com that will add a new bar to your display that contains the full path of the current document, as well as add a button for jumping to it in the files panel. That's about it though. cheers, barneyb On Tue, 9 Nov 2004 14:53:34 -0500, Mickael [EMAIL PROTECTED] wrote

DW Title Bar

2004-11-09 Thread Mickael
Hi All, I was wondering if someone knows if it is possible to customize DW slightly. On my PC I have a copy of a Development site and the Production Site. Since both sites are essentially the same, I am having a hard time looking at templates from both sites and determining where they are

Adding Values in Browser

2004-11-05 Thread Mickael
Hello All, I need to create a form that is modelled after an excel spreadsheet with formulas. What the spread sheet does is calculate expenses using the values being entered in its fields. i.e. Rent = $500 Food = $250 Water = $150 etc.. Total = (the total of the above.) How do you do this

SQL Mask not using CF

2004-10-28 Thread Mickael
Hi All I was wondering if someone could help me out with the following SQL function. I would like to select Today(*) from my database but have it display as Thursday, October 28, 2004 This is easily done with a mask in CF but is there a way to do it right in my select statement? Something

Buying Studio MX

2004-10-25 Thread Mickael
Hi All, Is there anyone on this list can point me to a place where I can buy a Boxed version of Studio MX with Flash Pro cheaper than I can from the Macromedia site? I am in Toronto Canada Sorry for being OT Mike ~| The

OT .NET

2004-10-21 Thread Mickael
Hi All Sorry for being OT. But could anyone point me to a good resource to learn .NET, from the begining (hopefully skipping console apps). I am interested in Web and Windows apps. Also if anyone could share their thoughts about VB.NET and C# which to learn? Please note that I am not a

Re: OT .NET

2004-10-21 Thread Mickael
Dave, Thanks for the resources I don't want to start the whole .net vs cf discussion here. But is it possible to build things as quick as you can in C# as you can in CF? Are somethings faster better in C#? Mike - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL

Re: OT .NET

2004-10-21 Thread Mickael
for good tutorials b/c I learn best by example instead of reading page after page of explanation. HTH, Donna On Thu, 21 Oct 2004 12:26:55 -0400, Mickael [EMAIL PROTECTED] wrote: Hi All Sorry for being OT. But could anyone point me to a good resource to learn .NET, from the begining

Re: Problems with Excelsheet in French from Coldfusion

2004-09-18 Thread Mickael
as opposed to numbers. Any Ideas on how I can fix this? Thanks Mike - Original Message - From: Mickael To: CF-Talk Sent: Friday, September 17, 2004 10:02 AM Subject: Problems with Excelsheet in French from Coldfusion Hello, I am having an issue with an excel spreadsheet that I make

Problems with Excelsheet in French from Coldfusion

2004-09-17 Thread Mickael
Hello, I am having an issue with an excel spreadsheet that I make with Coldfusion.The issue is with the dollar values in the sheet.When viewed with an English machine the values show up as currency in Excel which is good.But when viewed with a French Canadian machine the dollar values come out as

Re: HTTPS post

2004-09-14 Thread Mickael
sion.com/show/3272/2/ On Mon, 13 Sep 2004 12:18:39 -0400, Mickael [EMAIL PROTECTED] wrote: Hello All, This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie. The

HTTPS post

2004-09-13 Thread Mickael
Hello All, This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie. They client want this however to run off of a pc not runnnga webserver or CF.They have the ability to

Re: HTTPS post

2004-09-13 Thread Mickael
2:18:39 -0400, Mickael [EMAIL PROTECTED] wrote: Hello All, This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie. They client want this however to run off of a p

Re: HTTPS post

2004-09-13 Thread Mickael
program) and then upload the html form? Are you wanting the VB6 app to upload it or allow the users to upload them? On Mon, 13 Sep 2004 14:17:06 -0400, Mickael [EMAIL PROTECTED] wrote: Don't you need the submit button to be clicked?I would like this to run automated. - Original Message - From

Range in SQL

2004-08-09 Thread Mickael
Hello All, I was wondering if someone could help me with an SQL statement for Sybase.I need to do an update using on SQL not CF.What I would like to do is the opposite of TOP sort of.I have a query that returns lets x records and I would like to not update 125 records and have my statement update

CF Ticketing System

2004-07-30 Thread Mickael
Hello All, Does anyone know of a free Coldfusion ticketing system?The kind where people can log an issue get a ticket number and view them in a queue?I had one in PHP that was free and pretty robust.Just wondering if there is one out there for free or cheap if someone has one to sell. Thanks

CFHTTP

2004-07-28 Thread Mickael
Hello All, I have never used CFHTTP before,and I am running in to an issue.I would like to retrieve information from a form on a remote server.If I simple do this in IE . https://username:[EMAIL PROTECTED]/search.cgi?name=searchnamenumber=123search=all This returns the proper information in my

Re: CFHTTP

2004-07-28 Thread Mickael
Hi Dave, Sorry this was a cut and paste issue, my tag does use https:// - Original Message - From: Dave Watts To: CF-Talk Sent: Wednesday, July 28, 2004 4:31 PM Subject: RE: CFHTTP I have never used CFHTTP before,and I am running in to an issue.I would like to retrieve information

Re: CFHTTP

2004-07-28 Thread Mickael
Thank you very much.The name instead of username was the problem.Works great - Original Message - From: Adam Haskell To: CF-Talk Sent: Wednesday, July 28, 2004 5:03 PM Subject: Re: CFHTTP I would re-look at your actual Cfhttp call Invalid column would indicate to me that you are trying

Problem with SQL Server and CF5

2004-07-19 Thread Mickael
Hello All, I am relatively new to MSSQL so forgive me if the question is rather junior.I have a few pages that make up an image gallery.I designed the pages using CFMX and MSSQL and they worked fine on my machine.I have uploaded them to the server and I am getting the following error

Re: Problem with SQL Server and CF5

2004-07-19 Thread Mickael
ert Dawson To: CF-Talk Sent: Monday, July 19, 2004 1:01 PM Subject: RE: Problem with SQL Server and CF5 What does your Query of a Query say? There are a number of subtle differences in the way it works in CFMX vs. CF5 Bert ____ From: Mickael [mailto:[EMAIL PROTECTED]

Re: Problem with SQL Server and CF5

2004-07-19 Thread Mickael
name=qry_MakeThumbnailList dbtype=query SELECT[name] AS filename FROM imagelist /cfquery It might not like the name column (i would expect MX to complain about it but it doesn't seem to mind either way...) Cheers Bert From: Mickael [mailto:[EMAIL PROTECTED] Sent

Re: Problem with SQL Server and CF5

2004-07-19 Thread Mickael
Hi Ian I tried that and I my imagelist query is returning a proper recordset but it is choking on this query cfquery name=qry_MakeThumbnailList dbtype=query Select name from imagelist /cfquery - Original Message - From: Ian Skinner To: CF-Talk Sent: Monday, July 19, 2004 4:36 PM

CF Image Gallery

2004-07-16 Thread Mickael
Hi All, I was wondering if anyone knows where I can get a some code for an Image Gallery.I have seen tons of these for Free in PHP.But none in CF yet.The gallery I am looking for is type that you upload images to a folder, then on the display page some code makes that thumbnails and displays them

cfx_image

2004-07-16 Thread Mickael
Hi Can anyone point me to where I can find the a tutorial on how to use CFX_Image?Or the docs? Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Manipulation Excel files

2004-07-06 Thread Mickael
://www.daemon.com.au/ - Original Message - From: Mickael [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 10:53:35 -0400 Subject: Manipulation Excel files To: CF-Talk [EMAIL PROTECTED] Hello All, I was wondering if someone could point me in the right direction.I need to be able to extract certain information from

Re: Manipulation Excel files

2004-07-06 Thread Mickael
an open source CFX available at http://sourceforge.net/projects/openxcf named CFX_ExcelQuery that allows you to read and write XLS files as CF queries. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mickael Sent: Monday, July 05, 2004 10:54 AM

Manipulation Excel files

2004-07-05 Thread Mickael
Hello All, I was wondering if someone could point me in the right direction.I need to be able to extract certain information from cells an excel file, update some cell, delete some rows in the file then import the file to my database.Can anybody point me to a resource that explains how to do this

TreeMenu for Fusebox/CF site

2004-07-01 Thread Mickael
Hello All I had a question regarding JS menus and CF.I am looking for a collapsible menu that stays open during use.The type that I am looking for is where the menu would have a + sign to the left of it to display that there is sub-content then clicking on the word would expose the sub-menu

Re: TreeMenu for Fusebox/CF site

2004-07-01 Thread Mickael Elmalem
Massimo, That menu is great!Just what I was loooking for. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: TreeMenu for Fusebox/CF site

2004-07-01 Thread Mickael Elmalem
Massimo, Just one question how do you prevent the titles from Wrapping?Similar to nowrap. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: TreeMenu for Fusebox/CF site

2004-07-01 Thread Mickael Elmalem
Please disreard my last post, I figured it out.Great menu! Massimo, Just one question how do you prevent the titles from Wrapping?Similar to nowrap. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Ordering File Names

2004-06-28 Thread Mickael
Hi All, I need to display file names from my directory on a page.The file names are in the following format 1014133248-1.pdf, 1014133248-2.pdf, 1014133248-3.pdf etc I need to display them in order, this works fine for files up to -9 but after that I end up with 1014133248-1.pdf

Re: Ordering File Names

2004-06-28 Thread Mickael
in a different format, you may want to run some kind of script to rename everything to take the number between - and . And convert it to a 3 digit number. John -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 1:53 PM To: CF-Talk Subject: Ordering File

Re: SMTP Relay service

2004-06-28 Thread Mickael
hostmysite.com has this service, it is not very expensive either - Original Message - From: Trevor Holm-Laursen To: CF-Talk Sent: Monday, June 28, 2004 2:34 PM Subject: SMTP Relay service Hey all, We have several clients that we have built email notification services for where their

Problems saving Files in DXMX 2004

2004-06-26 Thread Mickael
Hi All, I have an issue with my Dreamweaver.I cannot save files properly.I keep getting this error While executing onLoad in _afterSave.htm, the following _javascript_ error(s) occurred: In file _aftersave: ReferenceError: aftersave is not defined Has anyone experienced this problem? Mike

Re: Problems saving Files in DXMX 2004

2004-06-26 Thread Mickael
them and see -- Original Message -- From: Mickael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Sat, 26 Jun 2004 12:33:58 -0400 Hi All, I have an issue with my Dreamweaver.I cannot save files properly.I keep getting this error While executing onLoad

Re: Problems saving Files in DXMX 2004

2004-06-26 Thread Mickael
-0400, Mickael [EMAIL PROTECTED] wrote: Hi, I don't have any extensions installed.Is there somewhere else I can look? Mike - Original Message - From: dave To: CF-Talk Sent: Saturday, June 26, 2004 12:41 PM Subject: Re: Problems saving Files in DXMX 2004 sounds like a conflict

Conntecting to Foxpro Database with CFMX

2004-06-24 Thread Mickael
Hi All, I need to connect to a foxpro database with CFMX but the driver does not appear in my CFAdmin list.How do you connect foxpro? Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Conntecting to Foxpro Database with CFMX

2004-06-24 Thread Mickael Elmalem
That worked Great. Thanks Ben Create an ODBC connection using the Windows Control Panel applet, and then connect to that in CF Admin. --- Ben _ From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 10:09 AM To: CF-Talk Subject: Conntecting to Foxpro Database with CFMX

List of States and Provinces

2004-06-16 Thread Mickael
Hi All, Can someone point me to a link where I can download a list of all the US States and Canadian Provinces Ideally a delimited file of some kind where the actual Abbreviation is used like NY, New York Thanks in advance. Mike [Todays Threads] [This Message] [Subscription] [Fast

Re: Sorting for Reports

2004-06-10 Thread Mickael Elmalem
: Mickael Elmalem [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 5:23 PM To: CF-Talk Subject: Sorting for Reports Hello All, I need to create a page that displays files(viewlets) uploaded by users, by category.The users can create categories on their own then the files get

CFQUERY Timeout

2004-06-10 Thread Mickael
Hello All, My host has issues from time to time I get a CFQUERY timeout.But when I rerun the query it works (most times).What type of CFCATCH type would this be? Here is my error Error Occurred While Processing Request The request has exceeded the allowable time limit Tag: CFQUERY Thanks in

  1   2   3   >