-vancouverisland.com
- Original Message -
From: Mickael
To: CF-Talk
Sent: Wednesday, December 17, 2003 1:08 PM
Subject: Help with Netscape 4.7
Hello All,
I have a client that uses Netscape 4.7 over their corporate lan and they access certain reports in an application that I had built
from CF is
The search key was not found in any record.
But if I look in the error window it show my statment as follows
Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110
from CF is
The search key was not found in any record.
But if I look in the error window it show my statment as follows
Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110
, December 16, 2003 12:48 PM
Subject: RE: SQL Problem
No need to post your question twice.. be patient, someone will respond if
they know the answer.:-)
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 12:42 PM
To: CF-Talk
Subject: SQL Problem
Hello
To: CF-Talk
Sent: Tuesday, December 16, 2003 12:55 PM
Subject: RE: SQL Problem
Try Trimming your vars especially since they were text before you
converted them. If it was char type text there might be some padding that
you don't see..
-Original Message-
From: Mickael [mailto:[EMAIL
especially since they were text before you
converted them. If it was char type text there might be some padding that
you don't see..
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 12:56 PM
To: CF-Talk
Subject: Re: SQL Problem
Hi Michael
IssueRegister_qr SET IssueStatus = 'Closed', Response =
'completed',
ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d
'2003-12-16'}
Where
IssueNumber = 1110
This look correct to me.So I tried running it in access's
query window
and
I get the same error, yet when I try to search the column
Hello All,
I am running in to a problem on something that I do locally on our intranet.I query one database(SYBASE) then load the data that I need in to an access database for a CF app that I have created.
There is section on the Sybase database where notes are entered then notes tables looks
Hello All,
I am running in to a problem on something that I do locally on our intranet.I query one database(SYBASE) then load the data that I need in to an access database for a CF app that I have created.
There is section on the sysbase database where notes are entered then notes tables looks
:
cfif isDate(act_date)#dateFormat(act_date,
mm/dd/)#cfelseNULL/cfif
Or
cfqueryparam cfsqltype=cf_sql_date value=#act_date# null=#NOT
isDate(act_date)# /
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 10:10 AM
To: CF-Talk
Subject: Problems
Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 12:06 PM
To: CF-Talk
Subject: Re: Problems with Nulls
Hi Barney,
Thanks for the tip.I keep getting this error
Request canceled or ignored by serverServer busy or unable to
fulfill request. The server
Hi,
Firstly I would recommend changing the title of your email to CFGRID is a problem!
I have had similar issues, I don't remember the exact article on Macromedia.But what I did was on my windows machine that was accessing the page.I went to c:\program files\java and renamed the folder
Hello All,
I am looking for a free lancer in the Toronto Area that has a good understanding and uses FB4
Please send me a note off list
Thanks
Mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hello All,
Firstly I would like to apologize on my clients behalf, they still use Netscape 4.79 across their corporation (can't upgrade them to IE or newer version of Netscape)
I have some code which works fine in IE but it causing me some headaches in netscape partly because of security reasons
Hello All,
I don't know if this is possible or not but I thought I would ask.I am using Access and I would like to know if it is possible to return along with my query the type of field that I am querying.
I am querying one database then inserting info in to another(access)
I guess what I am
Hi I don't really have that skill set, is that the only way to do this?
- Original Message -
From: Nick de Voil
To: CF-Talk
Sent: Monday, December 08, 2003 3:07 PM
Subject: Re: SQL col type
I don't know if this is possible or not but I thought I would ask.I am
using Access and I would
Hello All,
I have a strange request.I have a site that would like to create certain content for search engines then have certain content in flash.My question is, is there a way to create a page and link it to a search engine, have the link appear on the search engine.But have some code at the
Hi Jochem,
Does object work only for flash pages or can I use this to migrate visitors from older pages to new non flash pages?
- Original Message -
From: Jochem van Dieten
To: CF-Talk
Sent: Friday, December 05, 2003 10:37 AM
Subject: Re: Application.cfm maybe
Mickael wrote:
I have
Hi,
I am not sure if you can add a column or not, but a simple way to do it if you can add a column is create a column called TempCol or something
Then
Update TopStudents set tempcol = left(topstudents.studentdetails, len(topstudents.studentdetails)-12) 12 being the number of charters after
Hello All,
I am trying to run a query of a query and I am running into a little of SQL trouble.I keep getting this error Query Of Queries runtime error.
The aggregate function [SUM(_expression_)] cannot operate on an operand of type [VARCHAR].
Here is the code I am trying to run
cfquery
]
410.548.2337
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 8:33 AM
To: CF-Talk
Subject: Help with Q of Q
Hello All,
I am trying to run a query of a query and I am running into a little of SQL
trouble.I keep getting this error Query Of Queries
Hello All,
I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1.Is there anyone that has this working with their ISP or work for an ISP that can do it.I am looking to move my customers
==
If you are not satisfied with my service, my job isn't done!
- Original Message -
From: Mickael [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 7:43 AM
Subject: OT-SES and Fusebox on 6.1
| Hello All,
|
| I am presently hosting many site
/mx61_known_problems.html#generalserver
I can't post to the list at the moment, so if you want to forward this it might help anyone else who has come across this issue.
Cheers
Bert
- Original Message -
From: Mickael
To: CF-Talk
Sent: Tuesday, December 02, 2003 8:43 AM
Subject: OT-SES and Fusebox on 6.1
Hello
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP
==
If you are not satisfied with my service, my job isn't done!
- Original Message -
From: Mickael [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent
, 2003 10:19 AM
Subject: re: OT-SES and Fusebox on 6.1
Original Message:
From: Mickael [EMAIL PROTECTED]
I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1.Is there anyone that has
Hi Jochem,
Could you show me a statement where that is used, it sounds interesting just don't knowhow it is used.
Thanks
Mike
- Original Message -
From: Jochem van Dieten
To: CF-Talk
Sent: Tuesday, December 02, 2003 10:12 AM
Subject: Re: Date Range Query Issues
Candace Cottrell
Hello All,
I have a question that hopefully someone can point me in the right direction.I have read that the use of application.cfm is not needed any more with fusebox and that all my information should be in a fbx_settings.cfm.Firstly I was wondering if this is correct not to use
Sorry this is a Fusebox 3 question, I am still just reading about FB4.Do you recommend it?
- Original Message -
From: David Adams
To: CF-Talk
Sent: Monday, December 01, 2003 9:45 AM
Subject: Re:Application.cfm and Fusebox
Just to clarify, your question is a Fusebox 3 question and not
though...
Jb.
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 01 December 2003 15:28
To: CF-Talk
Subject: Application.cfm and Fusebox
Hello All,
I have a question that hopefully someone can point me in the right
direction.I have read that the use of application.cfm
Hello All,
I am not getting the results that I am looking for may query.
Here is my sql
Select Count(*) as TotalAccounts, Sum(Orig_amt) as SumOrig_AMT, Sum(Cur_Bal) as SumCurBal, Sum(Pmt_amt) as SUMPmtamt
from Client_debt
Left outer join Client_pmt on client_debt.debt_id = client_pmt.debt_id
how do I specify the tablename with the Count(*)?
- Original Message -
From: Scott Weikert
To: CF-Talk
Sent: Monday, December 01, 2003 1:37 PM
Subject: Re: SQL Help on Join
Mickael writes:
Select Count(*) as TotalAccounts, Sum(Orig_amt) as SumOrig_AMT, Sum(Cur_Bal) as SumCurBal, Sum
Hey Scott,
I am still getting the two records for an account, if there are the records in the client_pmt table,How does distinct work?
- Original Message -
From: Scott Weikert
To: CF-Talk
Sent: Monday, December 01, 2003 1:37 PM
Subject: Re: SQL Help on Join
Mickael writes:
Select
Hi Deanna
I guess I would have to do a sub-queryI always heard that a sub-query was not very efficient and that doing a join was always better.
Mike
- Original Message -
From: Deanna Schneider
To: CF-Talk
Sent: Monday, December 01, 2003 1:51 PM
Subject: Re: SQL Help on Join
Mickael
One the topic of the CF Certification, I am curious as to what value people that are certified get from the certification?Is it worth it?
- Original Message -
From: Dominic J. Doucet-Lorang
To: CF-Talk
Sent: Wednesday, November 26, 2003 1:41 PM
Subject: CF Certification
Hi,
I am
Hello All,
I have a memo field in SYBASE that contains phone numbers delimited by a comma.
I need to qualify telephone numbers that are in a group of area codes, using SQL only I can't use CF.
The is called phone_list and the values look like this 2125551212,213555-1212,2145551212
How could I
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 21 November 2003 17:23
To: CF-Talk
Subject: SQL Help
Hello All,
I have a memo field in SYBASE that contains phone numbers delimited by a
comma.
I need to qualify telephone numbers that are in a group of area codes,
using SQL
This site looks like it is using fusebox.And they renamed the fuseaction to just action.I could be wrong but it looks like fusebox
You can find info at fusebox.org
- Original Message -
From: John Munyan
To: CF-Talk
Sent: Friday, November 21, 2003 2:25 PM
Subject: Techniques (beginner)
I am Canadian
Sounds like our beer commercial
- Original Message -
From: Chunshen (Don) Li
To: CF-Talk
Sent: Thursday, November 20, 2003 1:18 PM
Subject: Any Canadians here?
Up front, my apology for off topic (this post is not of technical nature), probably it would be the last one of
Hello All,
I am having a little problem with writing a date in the format mm/dd/ to an access database.I have a text file that is uploaded to a server which I insert into a database, the file fields are is importing properly there is one field in my database for when the file is run.
So I do
And then just mask the display on the website?
- Original Message -
From: Pascal Peters
To: CF-Talk
Sent: Wednesday, November 19, 2003 9:40 AM
Subject: RE: Problem with Dates and Access
No dateformat. Just do CreateODBCDate(Now())
-Oorspronkelijk bericht-
Van: Mickael [mailto
Hello All,
Is there a way to set a scheduled task to run once a month on the last day of the month.How is this done using the CF5 admin?
TIA
Mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Thanks :)
- Original Message -
From: Pascal Peters
To: CF-Talk
Sent: Wednesday, November 19, 2003 10:56 AM
Subject: RE: Problem with Dates and Access
Yes, should work
-Oorspronkelijk bericht-
Van: Mickael [mailto:[EMAIL PROTECTED]
Verzonden: wo 19/11/2003 15:40
Aan: CF-Talk
Wouldn't left(account_id, 1) = 9 work?
- Original Message -
From: Dave Watts
To: CF-Talk
Sent: Monday, November 17, 2003 1:37 PM
Subject: RE: Access Bumeric datatype syntax
I have a numeric datatype Called Account_ID
I need to get all the accounts starting begins with
Account_ID 9
Hello All,
Does CFDIRECTORY work with Mapped drive letters?I am trying to view Network Share and having now luck.I went into the coldfusion service and checked off log on as and gave it a name with rights on the machine.Also I tried setting up a mapped drive and tried doing a list on my mapped
I have no problem using the UNC path, I am not able to view any of the files that are there.I just get an empty directory, and there is something in the directory.Is there a way to output debugging info for cfdirectory, like if there was a permission issue?
- Original Message -
From: Dave
Hi
I have used it on FB3 and found it very useful for some search engines. The only issue is that it is one more this to support with IIS if thre is a change, and it is sometime difficult to get working properly at shared hosting environment. The dummy file is not an actual file in your system
Thanks Dave and everyone
It works great!
- Original Message -
From: Dave Watts
To: CF-Talk
Sent: Thursday, November 13, 2003 8:37 AM
Subject: RE: Re[2]: Best Practices
I suppose it seems that since the url parameter is not
part of the form itself, isn't it a GET, even when you've
I use fusebox now.And url and form scopes becomes attributes. this makes things easy
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Thursday, November 13, 2003 9:37 AM
Subject: RE: Re[2]: Best Practices
sometimes better not to scope (admittedly not very often)
i.e.
Hello All,
I have a directory where files are getting uploaded (not via CF).I know how to get the contents of the directory with CFDIRECTORY how would I get changes to the directory?I would like to send an email out to a certain a group of people when ever a new file is uploaded.
How would I go
Sorry if this is a basic question.How do you store the contents of CFDirectory?
- Original Message -
From: Thomas Chiverton
To: CF-Talk
Sent: Thursday, November 13, 2003 12:04 PM
Subject: Re: Changes in a Directory CFDIRECTORY
On Thursday 13 Nov 2003 16:56 pm, Mickael wrote:
I have
Use HTMLEdit from http://www.interactivetools.com
Easy use
- Original Message -
From: Janine Jakim
To: CF-Talk
Sent: Thursday, November 13, 2003 12:30 PM
Subject: Users want to format text
Have an application with a bunch of input boxes.The users want to be able
to do snazzy things as
Thanks Greg
You made it a lot clearer now.
- Original Message -
From: Greg Luce
To: CF-Talk
Sent: Thursday, November 13, 2003 1:49 PM
Subject: RE: Changes in a Directory CFDIRECTORY
Mickael,
create a table in your db called Files_Last_Updated with the
field: dateLastModified
Hi Stace,
What are RIAs?
- Original Message -
From: Stacy Young
To: CF-Talk
Sent: Thursday, November 13, 2003 2:23 PM
Subject: RE: Adalon
Oh I've used it...and it does rock...just I fell off the CF face of the
earth for a year while I pursued RIAs...and when I came back to more CF
Hello,
I am in the middle of reworking an app and trying to eliminate many of the templates that were created by me (in my cut paste, make a new template days instead of making smarter templates)
What is have in essence are 6 reports that are practically the same the differences are they run the
Thanks
But my form method is post not get wouldn't that cause that to fail?
- Original Message -
From: Ubqtous
To: CF-Talk
Sent: Wednesday, November 12, 2003 6:26 PM
Subject: Re: Best Practices
Mickael,
On 11/12/2003 at 17:45, you wrote:
M So now this is what I am trying to do.When
Great thanks that helps!
- Original Message -
From: Dave Watts
To: CF-Talk
Sent: Wednesday, November 12, 2003 7:54 PM
Subject: RE: Best Practices
But my form method is post not get wouldn't that cause
that to fail?
I haven't followed the thread too closely, but if your question is
your SSL server or that all of your paths have
https and not http.
-Novak
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 9:36 PM
To: CF-Talk
Subject: SSL Newbie Question
Hello
I don't have much experience with SSL.I have a site using fusebox 3
Hello
I don't have much experience with SSL.I have a site using fusebox 3.The navigation through many pages are via forms.Prior to getting to the form where I would like to get their private info I use the following as the form action.
. If it wasn't that way, we would have a lot of trouble with includes and nested cfoutput.
There are some other tags that have to be in the same template. cfquery and cfqueryparam is an example.
Pascal
-Oorspronkelijk bericht-
Van: Mickael [mailto:[EMAIL PROTECTED]
Verzonden: vr 7/11/2003 4:52
Aan
/Developing_ColdFusion_MX_Applications_with_CFML/cfobject5.htm
Thanks,
Calvin
- Original Message -
From: Mickael
To: CF-Talk
Sent: Wednesday, November 05, 2003 6:15 PM
Subject: Re: Problems with CFMAIL
Hi Dave,
I have read that on the forums there.But I don't really know how to send HTML mail with CDONTs it looks like ASP
Hello
I am experiencing difficulties with CFGRID with my clients in an app that I build sometime back.It worked fine before but now many of them have moved to XP and after download the java (which was enough of an annoyance)they complain that many times when they are updating my tables via CFGRID
I have heard about the Flash Grid, I just don't have much experience withFlash and not sure how long it would take me to get up to speed in getting it started.
Mike
- Original Message -
From: Matt Robertson
To: CF-Talk
Sent: Thursday, November 06, 2003 4:31 PM
Subject: Re: CFGRID is a
Hello All,
Sorry if this is a novice question.I am trying to learn fusebox and find my self making smaller templates and and more includes (which I guess is good I haven't decided yet)
My question is this.Lets say that the value of myvariable is house
So when I do this
cfoutput
#myvariable#
Stockholm OfficeMobile:+46 733 467111
WWW: http://www.grida.no
-
| On Wednesday, November 05, 2003 05:50 [GMT+1=CET],
| Mickael [EMAIL PROTECTED] wrote:
| Hello All,
|
| This is not exactly a coldfusion
-
| From: Mickael [mailto:[EMAIL PROTECTED]
| Sent: Wednesday, 5 November 2003 9:36 PM
| To: CF-Talk
| Subject: Re: OT- Dynamic Page Layouts
|
|
| Hugo
|
| Thanks that is just what I needed.
|- Original Message -
|From: Hugo Ahlenius
|To: CF-Talk
|Sent: Wednesday, November 05, 2003 2:52
Hello,
I have few procedures that are running on CFMX that send information via cfmail from a form.The emails do not get sent out consistantly.Is there a way to make sure that the email actually went out in my code?I do not have a lot of access to the machine or the admin it is a shared box at
Hi Dave,
I have read that on the forums there.But I don't really know how to send HTML mail with CDONTs it looks like ASP and I am not familiar with ASP
How do you do it?
- Original Message -
From: Dave Jones
To: CF-Talk
Sent: Wednesday, November 05, 2003 5:23 PM
Subject: Re: Problems
Hello All,
This is not exactly a coldfusion question but does pertain to dynamic site.I have a site in CF that the client would like to include a standard footer at the bottom of the page.This works fine when the content that is returned is more than once screen in my explorer window at my
Just one thing is they don't support the language packs for 6.1.I am having problems with sites that I have to demote back to CF5 due to this.
Mike
- Original Message -
From: Tyler Clendenin
To: CF-Talk
Sent: Friday, October 31, 2003 9:56 AM
Subject: RE: Anybody have an opinion on
Hi Everyone,
Does anyone know what happened to CFCOMET?There was some great material on that site, that I could use today.
Is there another place where the tutorials are listed?
Thanks
Mickael
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hello All,
I need to import a tab delimited text file in to an access database.I know that this is possible just don't know how to go about it.One more thing is that sometimes the file may be empty.Can someone point me in the right direction?
Thanks
Mike
[Todays Threads]
[This Message]
ord.
Hope this helps point you in the right direction.
-Original Message-----
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 12:38 PM
To: CF-Talk
Subject: Import of Text File
Hello All,
I need to import a tab delimited text file in to an access datab
Hello Everyone.
I have had this error a few times on my development machine.I fix the problem by either deleting templates or whole directories then restoreing them.
Here is my error
Errors reported by Java compiler: Found 1 semantic error compiling
Hello All,
I have a strange situation happening.I have some code that displays a report and has a link to export the page to excel.
My link looks like this
a href="" to Excel/a
Then to action page has this
CFCONTENT TYPE=application/msexcel; name=trackingreport.xls
CFHEADER
--
Blog:http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 10:55 AM
To: CF-Talk
Subject: Problem Exporting to Excel
PROTECTED]
410.548.2337
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 11:38 AM
To: CF-Talk
Subject: Re: Problem Exporting to Excel on CFMX
Hi Sam,
I am not that is the case my file is only 14kb
I don't really have that much whitespace in my
architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 11:54 AM
To: CF-Talk
Subject: Re: Problem Exporting to Excel on CFMX
I am actually working on code that was inherited.I have tried
age-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 2:07 PM
To: CF-Talk
Subject: Re: Problem Exporting to Excel on CFMX
Yes I do,
there is not much to it.It is only a few templates
- Original Message -
From: Tony Weeg
To: CF-Talk
Sent: Tuesday, October 1
w.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 3:19 PM
To: CF-Talk
Subject: Re: Problem Exporting to Excel on CFMX
That is an interesting idea. I didn't even think of that.Sorry if I am
asking a dumb que
Hello All,
I have a couple of applications that were working fine on CF5 displaying hebrew.All of my pages used charset=windows1255 and everything worked great.I upgraded to CFMX in a shared hosting environment(crystal tech).Now all the Hebrew comes out as garbage.I also notice that the default
Hello All,
I am run into some issues using SES with a fusebox app that I have on windows 2003 on a shared hosting environment.I keep getting errors with IIS trying to locate the dummy file at the end of my url.
My question is has anyone run into this problem?And is SES needed anymore with the
Hi Bob,
Thanks for clearing that up.In regards to user friendliness I can always use redirects.
The links are easier to create with SES.
Mike
- Original Message -
From: Robert Everland III
To: CF-Talk
Sent: Friday, October 10, 2003 2:58 PM
Subject: Re:SES and Fusebox
There really
201 - 283 of 283 matches
Mail list logo