Re: Break the block, and SURVIVE, any way?

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 03:23 am, ChunshenLi wrote: Which attribute of cfhttp is for referer headers? I've already tried user_agent to no avail (tried both static value and dynamic value [CGI.http_user_agent]). http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p59.htm#wp1100049

Re: mySQL date ?

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 07:42 am, [EMAIL PROTECTED] wrote: the db the date fiels is set to int ! Why not use a date/time type ? any suggestions? Use cfqueryparam around your variables :-) Otherwise sooner or later someone will enter mytitle';drop all;commit; as a book title. -- Tom Chiverton

RE: DB Stuff

2004-02-20 Thread Pascal Peters
That was me going too fast, nothing to do with no properties. You need to have all the fields from the select (exept aggregate functions) in the group by clause: CFQUERY NAME=GetAgentList datasource=020 SELECT pa.PropertyAgentID, pa.PropertyAgentCompanyName, pa.PropertyAgentContactSurname,

RE: MX Internals

2004-02-20 Thread John Beynon
Actually I've just published a CFC wrapper for handling CF mappings, download it from http://www.beynon.org.uk/downloads/mappings.zip It will allow you to add/delete/edit and list cf mappings programatically. John. -Original Message- From: Ramene Anthony [mailto:[EMAIL PROTECTED] Sent:

Re: mySQL date ?

2004-02-20 Thread Stephen Moretti
Couple of things... [EMAIL PROTECTED] wrote: cfset date=#Now()# Avoid using reserved words for variable names - date is a reserved word. Use something like thisDate instead.Plus you only need : cfset thisDate = Now() !--- do insert now --- CFQUERY NAME=qnews DATASOURCE=#dsn# USERNAME=#un#

RE: DB Stuff

2004-02-20 Thread Stuart Kidd
Thanks Pascal, that's perfect. At the moment I'm getting into that 10 mins book by Ben Forta (and SAMS publishing). Is that a good way to go? It's just that some of this stuff i find is a steep learning curve... the CFML general stuff i can always get my head around, but all this SQL stuff is

Re: mySQL date ?

2004-02-20 Thread cf
thanks but already been there.. done that in access i would set the db asa date/time and use either Now() or Date() as the default and it was fine but mysql when i do that enters the words not the values however, i didnt know that reserve words mattered in variables to, i thought it was just the

Re: mySQL date ?

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 09:58 am, [EMAIL PROTECTED] wrote: im using the field as an int because it works with the php (choke) date inserts using time() Well, yes, because that gets you seconds-since-epoch or something. Doesn't mean it's a good thing. but u'd think it wouldnt be a problem to

Stored Procedures

2004-02-20 Thread Allan Cliff - CFUG Spain
I am trying to move a query to a Stored Procedure. I want to add a LIKE to it but doesn't seem to work. It seems to find the first letter only and then if it finds that it works Example: Message Body: My name is Allan Search Text: a - Found 1 result Search Text: b - Found 0 results Search

Re: mySQL date ?

2004-02-20 Thread Stephen Moretti
[EMAIL PROTECTED] wrote: thanks but already been there.. done that in access i would set the db asa date/time and use either Now() or Date() as the default and it was fine but mysql when i do that enters the words not the values I'm not sure what you're getting at here.Are you saying that

Re: mySQL date ?

2004-02-20 Thread cf
actually all i want is the date, no time or anything, just the stupid friggin date, lol dam seems so basic and i may not know much but i thought i knew this. i just dont see why i cant set the Date() variable and insert is as reg text, it should work right but doesnt, go figure this is all i

Re: mySQL date ?

2004-02-20 Thread Stephen Moretti
any suggestions? Use cfqueryparam around your variables :-) Otherwise sooner or later someone will enter mytitle';drop all;commit; as a book title. I have an issue with people using cfqueryparam for this reason. You should be doing data validation long before you hit the query and a

Re: mySQL date ?

2004-02-20 Thread cf
right but thats the thing, i figured i could just use Now() and didnt think twice about it, until i ran it it choked. U'd think that would be properly formated so when i use !--- do insert now --- CFQUERY NAME=qnews DATASOURCE=#dsn# USERNAME=#un# PASSWORD=#pw# INSERT INTO guide (title, content,

RE: Stored Procedures

2004-02-20 Thread Mike Townend
try adding a size to the varchar CREATE PROC GetMessages @fromid int, @toid int, @searchtext varchar(100) should work HTH -Original Message- From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 10:25 To: CF-Talk Subject: Stored Procedures I am

RE: mySQL date ?

2004-02-20 Thread Craig Dudley
Isn't now() a function in mySql too? So you could just do . CFQUERY NAME=qnews DATASOURCE=#dsn# USERNAME=#un# PASSWORD=#pw# INSERT INTO guide (title, content, update) VALUES ('#title#', '#content#', now()) /CFQUERY Should work. -Original Message- From: [EMAIL PROTECTED]

Re: mySQL date ?

2004-02-20 Thread Stephen Moretti
right but thats the thing, i figured i could just use Now() and didnt think twice about it, until i ran it it choked. U'd think that would be properly formated so when i use !--- do insert now --- CFQUERY NAME=qnews DATASOURCE=#dsn# USERNAME=#un# PASSWORD=#pw# INSERT INTO guide (title,

Re: mySQL date ?

2004-02-20 Thread Oliver Tupman
[EMAIL PROTECTED] wrote: Try this: !--- do insert now --- CFQUERY NAME=qnews DATASOURCE=#dsn# USERNAME=#un# PASSWORD=#pw# INSERT INTO guide (title, content, update) VALUES ('#title#', '#content#', '#DateFormat(Now(), -MM-DD)#') /CFQUERY I may have the double quotes wrong, but that should

Re: session variables help

2004-02-20 Thread cf coder
I am not setting the sesion variables again and again. The code is inside a IF block. cfif isDefined(url.SEARCHBUTT) and url.SEARCHBUTT eq clicked cfloop collection=#url# item=iUrl cfif url[iURL] neq cflock scope=SESSION timeout=30 type=EXCLUSIVE cfset session.searchresults.#iUrl# = #url[iURL]#

Re: [cftalk] RE: Stored Procedures

2004-02-20 Thread Allan Cliff - CFUG Spain
I have simplified this to: But get error [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near 'a'. Any more help please? Allan -- CREATE PROC GetMessages2 @searchtext varchar (100) AS DECLARE @query varchar(1000) SET

RE: [cftalk] RE: Stored Procedures

2004-02-20 Thread Pascal Peters
You are missing sinle quotes after the like I think. Use what you did first. -Original Message- From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: vrijdag 20 februari 2004 11:57 To: CF-Talk Subject: Re: [cftalk] RE: Stored Procedures I have simplified this to: But

Re: mySQL date ?

2004-02-20 Thread cf
im using cfmx 6.1, xp pro ok when i do this !--- set form variables --- cfset title=trim(form.title) cfset content=trim(form.content) cfset insertDate=#CreateODBCDate(Now())# !--- do insert now --- CFQUERY NAME=qnews DATASOURCE=#dsn# USERNAME=#un# PASSWORD=#pw# INSERT INTO guide (title,

RE: [cftalk] RE: Stored Procedures

2004-02-20 Thread Mike Townend
try, SET @query = @query +' AND Message LIKE '+ '% + @searchtext + %' basically you are missing the quote around the like -Original Message- From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 10:57 To: CF-Talk Subject: Re: [cftalk] RE:

RE: [cftalk] RE: Stored Procedures

2004-02-20 Thread Craig Dudley
I'm not sure there is much point in using a stored proc to build a SQL string and execute it, you'll get no speed/efficiency benefit at all, in fact it will probably be slower. Having said that, try this.. CREATE PROC GetMessages2 @searchtext varchar (100) AS DECLARE @query varchar(1000)

Re: mySQL date ?

2004-02-20 Thread Stephen Moretti
[EMAIL PROTECTED] wrote: im using cfmx 6.1, xp pro Oh ok the way CF now() was showing up looking like this '2004- made me think you were on an older version of CF. ok when i do this !--- set form variables --- cfset title=trim(form.title) cfset content=trim(form.content) cfset

Re: [cftalk] RE: Stored Procedures

2004-02-20 Thread Allan Cliff - CFUG Spain
IF @searchtext '' SET @query = @query +' AND M.Message LIKE '''+ '%' + @searchtext + '%''' was the solution. Single Quotes Only. Thanks Allan - Original Message - From: Mike Townend To: CF-Talk Sent: Friday, February 20, 2004 12:03 PM Subject: RE: [cftalk] RE: Stored Procedures

Re: mySQL date ?

2004-02-20 Thread cf
i had already tried all those but 1 which is !--- do insert now --- CFQUERY NAME=qnews DATASOURCE=#dsn# USERNAME=#un# PASSWORD=#pw# INSERT INTO guide (title, content, update) VALUES ('#title#', '#content#', #createodbcdate(now())#) /CFQUERY and i get this Error Executing Database Query. Syntax

Re: mySQL date ?

2004-02-20 Thread Stephen Moretti
Duh!!! meant for me! UPDATE..thats a reserved word in SQL As in UPDATE tblname SET col = 123 WHERE tblID = 567 You need to change that column name to something other than 'update' even 'update_date' would be better! Damn it!!should have spotted that right off... Anyone would think it

RE: mySQL date ?

2004-02-20 Thread C. Hatton Humphrey
Error Executing Database Query. Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'update) VALUES ('test', 'f fdsf', '2004-02-20')' Your MySQL error isn't because of the

Re: mySQL date ? SOLVED

2004-02-20 Thread cf
Stephen, thanks 4 helping, everyone else too oh and yes I had thought all along that update was a reserved word but if that was the error I woulda got a different error message but i am suprised noone said anything, lol but ur gunna kick my *ss!! i had the wrong table called in the statement,

OT: from access to mssql

2004-02-20 Thread Critter
oi CF-Talk,!! wheniamimportingdatafromaccesstomssql,howdo i get it to transfer items such as autonumber (identity)..etc.. is that possible? /c -- =-=-=-=-=-=-=-=-=-=-=-=-=-[ Help me fight to keep my son in the US ]-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://keepmysoninthe.us ]-=

Re: OT: from access to mssql

2004-02-20 Thread cf
i bought a program from here http://www.dmsofttech.com/ called access2mysql worked great! now if i can just remember to put the right table names in my queries i will be golden ;) oi CF-Talk,!! wheniamimportingdatafromaccesstomssql,howdo i get it to transfer items such as autonumber

Re: OTish: Killing a session on a closed browser

2004-02-20 Thread cf coder
Does anybody know how to do this. I am trying to do the same thing but can't figure out how. Please help. cfcoder Hey all, Is there a way through _javascript_ or some other resource to detect when the browser window is closed so I can end a session? The problem is, this can only happen

RE: OTish: Killing a session on a closed browser

2004-02-20 Thread Pascal Peters
You can't do that AFAIK, but you can set the CF cookies to session cookies. The session will not dissapear when the browser closes, but it won't be accessible anymore because the cookies will be gone. Pascal -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: vrijdag

RE: OTish: Killing a session on a closed browser

2004-02-20 Thread Tangorre, Michael
You can make the cookies memory persistent only using the following code in your application.cfm file: cfif IsDefined(cookie.CFID) AND IsDefined(cookie.CFTOKEN) cfset localCFID = cookie.CFID / cfset localCFTOKEN = cookie.CFTOKEN / cfcookie name=CFID value=localCFID / cfcookie name=CFTOKEN

RE: from access to mssql

2004-02-20 Thread C. Hatton Humphrey
wheniamimportingdatafromaccesstomssql,how do i get it to transfer items such as autonumber (identity)..etc.. is that possible? It's possible to do with your insert statements, I don't think you have to turn off identity insert. Here's a snippet from a data dump I just got: DROP TABLE IF

RE: OTish: Killing a session on a closed browser

2004-02-20 Thread Dave Sueltenfuss
I use the following code in my Application.cfm This way,once the browser is closed, they can no longer access that specific session !---Sets CFID to Session variable--- cfif IsDefined(Cookie.CFID) cflock scope=session timeout=10 type=exclusive cfcookie name=CFID VALUE=#Session.cfid# /cflock

Re: OT: from access to mssql

2004-02-20 Thread Critter
oi cf!! aye, that would be cool... if it was mysql :) good link though, ta /c -- =-=-=-=-=-=-=-=-=-=-=-=-=-[ Help me fight to keep my son in the US ]-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://keepmysoninthe.us ]-= Friday, February 20, 2004, 7:29:25 AM, you wrote: cdc i bought a

Re: session variables help

2004-02-20 Thread cf coder
please can somebody help I am not setting the sesion variables again and again. The code is inside a IF block. cfif isDefined(url.SEARCHBUTT) and url.SEARCHBUTT eq clicked cfloop collection=#url# item=iUrl cfif url[iURL] neq cflock scope=SESSION timeout=30 type=EXCLUSIVE cfset

Re: OTish: Killing a session on a closed browser

2004-02-20 Thread cf coder
thanks guys, however I still can't figure out why my sessions are not being persistent across pages. I've described my problem in this thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=30647forumid=4count=2 If I set the SETCLIENTCOOKIES cfappliction attribute to Yes,

RE: OTish: Killing a session on a closed browser

2004-02-20 Thread Tangorre, Michael
Re-read my first post to you... In your application.cfm file you need to make the cookies (CFID and CFTOKEN) memory resident, so they are never written to disk. cfif IsDefined(cookie.CFID) AND IsDefined(cookie.CFTOKEN) cfset localCFID = cookie.CFID / cfset localCFTOKEN = cookie.CFTOKEN /

Re: OT: from access to mssql

2004-02-20 Thread cf
lol, ok i really need 2 go to bed never used this but i know of it http://ems-hitech.com/quickimport/ lots of good sql tools there oi cf!! aye, that would be cool... if it was mysql :) good link though, ta /c -- =-=-=-=-=-=-=-=-=-=-=-=-=-[ Help me fight to keep my son in the US ]-=

Scheduling using dynamic queries and cfmail

2004-02-20 Thread Craig Hadley
Hello, We have an app that sends email using cfmail. The user logs in, selects which receipts should receive the email (all, by legislative district, by assembly district, and or by interest area). Then the user pastes in the subject in a text box, pastes the body into a text area box, and hits

MySQL and CF 5

2004-02-20 Thread Bud
Hi. I just got this response to a support request from Crystal Tech. CF 5 does not support DSNs using MySQL. You have to specify a connection string. Obviously this isn't true. I can connect to their MySQL Server from here at home using the same driver (3.51). I tried to explain that the only

Re: MySQL and CF 5

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 13:50 pm, Bud wrote: [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 The error occurred while processing an element with a general identifier of

RE: MySQL and CF 5

2004-02-20 Thread Mike Townend
what does the query you are calling look like? -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 13:50 To: CF-Talk Subject: MySQL and CF 5 Hi. I just got this response to a support request from Crystal Tech. CF 5 does not support DSNs using MySQL.

Re: MySQL and CF 5

2004-02-20 Thread Stephen Moretti
Obviously this isn't true. I can connect to their MySQL Server from here at home using the same driver (3.51). I tried to explain that the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin. Annoyingly its only CF5 on windows that doesn't have the form for managing mySQL

Re: MySQL and CF 5

2004-02-20 Thread Doug White
Of course that is not correct.We have been supporting MySQL via DSN from CF 5.0 ever since 5.0 was released.Both on Windows and Linux platforms. CFMX 6.1 also supports MySQL DSNs. == Stop spam on your domain, Anti-spam solutions

Stored procedures, CF, and INFORMIX

2004-02-20 Thread G
I have not used stored procedures in conjunction with Cold Fusion since moving from SQL Server to INFORMIX. I know that in SQL Server, SP's were a powerful and efficient way to access the data. I've been told that INFORMIX is not as elegant when it comes to stored procedures, but have not heard

Delete structure?

2004-02-20 Thread John Ho
How to delete struct? when the struct no longer need, I want to delete it. Can I do that?. Thanks John __ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools [Todays Threads] [This Message] [Subscription]

RE: Delete structure?

2004-02-20 Thread Tangorre, Michael
Sure... StructDelete(structure, key) Example:#StructDelete(session,userSettings)# Mike _ From: John Ho [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 9:28 AM To: CF-Talk Subject: Delete structure? How to delete struct? when the struct no longer need, I want to delete it. Can

RE: Delete structure?

2004-02-20 Thread Douglas.Knudsen
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi18.htm#wp1099964 Doug -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 9:28 AM To: CF-Talk Subject: Delete structure? How to delete struct? when the struct no longer need, I want to

RE: Delete structure?

2004-02-20 Thread Pascal Peters
It depends on what version of CF you are CF6+: StructDelete(variables,mystruct) for all scopes CF4.5+: StructDelete(session,mystruct) for all scopes exposed as structures (except variables,client,server,caller,... and maybe some I forget) CF4.5-: not possible I think. Pascal -Original

Re: Delete structure?

2004-02-20 Thread John Ho
I use this function before but it seems struct have not deleted I create 5 struct in a cfloop like this cfloop cfset vulInfor = StructNew() cfset vulInfor.A = something cfset vulInfor.B = somethingelse ... cfset array[i] = vulInfor StructDelete(structure, A) /cfloop then I

OT: Configure 1 box with sql/cf together

2004-02-20 Thread Janine Jakim
I've been asked if we can put sql/cfmx all on one box.This is to be set outside our company firewall. (We currently have a best practices case set up behind the firewall on our intranet. This 2nd one would be for non-sensitve database information) I need to make a reply/case/recommendation on

CFMAIL Mailer ID?

2004-02-20 Thread Burns, John
Is there a set list of appropriate values that can be used in the mailerID attribute of CFMAIL in MX 6.1 or is this anything that I want to enter?I want to try to avoid being filtered as spam based on this field, so if anyone can give me a good value for this or other params I should set when

RE: Delete structure?

2004-02-20 Thread Pascal Peters
I don't see what you are doing and some code is missing, but from the code posted, you are not deleting anything (see comment inline). Maybe you can explain more clearly what you are trying to accomplish -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: vrijdag 20

RE: CFMAIL Mailer ID?

2004-02-20 Thread John Grubb
I need to send HTML content via email using CFMAIL, but I want to send the .jpg pictures with the email instead of pointing the img src= "" back to the web server. Anyone know how to include the pictures? Thanks, John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: MySQL and CF 5

2004-02-20 Thread Bud
On Friday 20 Feb 2004 13:50 pm, Bud wrote: [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 The error occurred while processing an element with a general identifier of

Re: MySQL and CF 5

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 15:35 pm, Bud wrote: On Friday 20 Feb 2004 13:50 pm, Bud wrote: [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 The error occurred while

Re: Delete structure?

2004-02-20 Thread John Ho
Thank you I try to store a structure in an array(array of structs). But since structs pass by reference then I can not delete these structs. Anyway just a learning experience. How do I delete struct vulInfor in this case? I don't see what you are doing and some code is missing, but from the code

RE: MySQL and CF 5

2004-02-20 Thread Bud
what does the query you are calling look like It's not the query. It's ALL queries. :) ? -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 13:50 To: CF-Talk Subject: MySQL and CF 5 Hi. I just got this response to a support request from Crystal Tech.

Re: MySQL and CF 5

2004-02-20 Thread Bud
Obviously this isn't true. I can connect to their MySQL Server from here at home using the same driver (3.51). I tried to explain that the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin. Annoyingly its only CF5 on windows that doesn't have the form for managing mySQL

Re: MySQL and CF 5

2004-02-20 Thread Bud
Of course that is not correct.We have been supporting MySQL via DSN from CF 5.0 ever since 5.0 was released.Both on Windows and Linux platforms. CFMX 6.1 also supports MySQL DSNs. They don't have a problem with MX. == Stop spam on your domain, Anti-spam

RE: MySQL and CF 5

2004-02-20 Thread Paul Lowton
Check your case...all tables need to be referenced lower case -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: 20 February 2004 15:49 To: CF-Talk Subject: Re: MySQL and CF 5 Of course that is not correct.We have been supporting MySQL via DSN from CF 5.0 ever since 5.0 was

RE: Configure 1 box with sql/cf together

2004-02-20 Thread Dave Watts
I've been asked if we can put sql/cfmx all on one box. This is to be set outside our company firewall. (We currently have a best practices case set up behind the firewall on our intranet. This 2nd one would be for non-sensitve database information) I need to make a

RE: OTish: Killing a session on a closed browser

2004-02-20 Thread Dave Watts
In your application.cfm file you need to make the cookies (CFID and CFTOKEN) memory resident, so they are never written to disk. cfif IsDefined(cookie.CFID) AND IsDefined(cookie.CFTOKEN) cfset localCFID = cookie.CFID / cfset localCFTOKEN = cookie.CFTOKEN / cfcookie name=CFID

RE: [cftalk] RE: Stored Procedures

2004-02-20 Thread Dave Watts
I'm not sure there is much point in using a stored proc to build a SQL string and execute it, you'll get no speed/efficiency benefit at all, in fact it will probably be slower. This is true, but if you use stored procedures exclusively for all database access, you may be able to tighten

Re: mySQL date ?

2004-02-20 Thread Jochem van Dieten
Stephen Moretti said: Use cfqueryparam around your variables :-) Otherwise sooner or later someone will enter mytitle';drop all;commit; as a book title. I have an issue with people using cfqueryparam for this reason. You should be doing data validation long before you hit the query But

RE: mySQL date ?

2004-02-20 Thread Dave Watts
Use cfqueryparam around your variables :-) Otherwise sooner or later someone will enter mytitle';drop all;commit; as a book title. I have an issue with people using cfqueryparam for this reason. You should be doing data validation long before you hit the query and a try/catch

RE: Delete structure?

2004-02-20 Thread Pascal Peters
Why do you want to delete it? In the next loop, you do cfset vulInfor = structNew(). This creates a new structure and loses te reference to the struct in the array. -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: vrijdag 20 februari 2004 15:45 To: CF-Talk Subject:

Re: Configure 1 box with sql/cf together

2004-02-20 Thread jjakim
Well the original solution included 2 new boxes outside the company firewall. One for a database one for the web server. We can find the money to do it. I then received an email saying to make it easier on everyone can we do it this way-one box with everything. I'm thinking that this may not be

Re: OTish: Killing a session on a closed browser

2004-02-20 Thread cf coder
I finally got it to work. I'm assigning client variables cfid and cftoken to the cfid and cftoken cookie variables CFCOOKIE name=CFID value=#Client.CFID# CFCOOKIE name=CFTOKEN value=#Client.CFTOKEN# and storing all client information in client variables. cfloop collection=#url# item=iUrl cfif

RE: Configure 1 box with sql/cf together

2004-02-20 Thread Dave Watts
Well the original solution included 2 new boxes outside the company firewall. One for a database one for the web server. We can find the money to do it. I then received an email saying to make it easier on everyone can we do it this way-one box with everything. I'm thinking that this may

Re: session variables help

2004-02-20 Thread cf coder
I finally got it to work. I'm assigning client variables cfid and cftoken to the cfid and cftoken cookie variables CFCOOKIE name=CFID value=#Client.CFID# CFCOOKIE name=CFTOKEN value=#Client.CFTOKEN# and storing all client information in client variables. cfloop collection=#url# item=iUrl cfif

Re: MySQL and CF 5

2004-02-20 Thread Bud
Can ou put the whole exception somewhere ? Either here or on a website ? Thanks Tom. In case you want to look: http://216.119.123.68/create.cfm But they've told me now that mySQL won't work with DSNs and CF 5 on their network. I think they just don't feel like looking into the problem since

Re: MySQL and CF 5

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 16:26 pm, Bud wrote: But they've told me now that mySQL won't work with DSNs and CF 5 on their network. Ahh well, all bets off then :-) DSNLESS Beware these are not supported except in CF5. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997

RE: MySQL and CF 5

2004-02-20 Thread Matt Robertson
on their network.A pretty convenient stone wall, that. DSN-less connections are a dead end.Can you get them to upgrade you to MX? Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com

Re: MySQL and CF 5

2004-02-20 Thread Jochem van Dieten
Bud wrote: Thanks Tom. In case you want to look: http://216.119.123.68/create.cfm But they've told me now that mySQL won't work with DSNs and CF 5 on their network. I think they just don't feel like looking into the problem since there is a workaround (DSNLESS connection). If you

Indexing a network drive with CF's Verity Engine

2004-02-20 Thread Frost, Brian A, CTR, Force Transformation
Does anyone have experience/suggestions on how to go about indexing a network drive.We have an Office drive that has numerous presentations that we'd like to be able to index, however that drive is on another server.The share is on a Windows 2000 server as is our Cold Fusion server. Thanks,

Re: Configure 1 box with sql/cf together

2004-02-20 Thread jjakim
I agree that we should go with 2 boxes. What I'm looking for is concrete reasons to give for the 2 box recommendation vs all on one box. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Indexing a network drive with CF's Verity Engine

2004-02-20 Thread Paul Vernon
Even if it is possible (and I don't know) I would think that this would be suicide in terms of performance. You'd probably be better off turning Index Server on on that server then using a query to query the Index Server. If you have a SQL Server DB you can even link in an Index server as a linked

RE: Configure 1 box with sql/cf together

2004-02-20 Thread C. Hatton Humphrey
I agree that we should go with 2 boxes. What I'm looking for is concrete reasons to give for the 2 box recommendation vs all on one box. If they are truly worried about security my suggestion would be to place a webserver within a DMZ on the firewall, only allowing those ports required

RE: Configure 1 box with sql/cf together

2004-02-20 Thread Dave Watts
I agree that we should go with 2 boxes. What I'm looking for is concrete reasons to give for the 2 box recommendation vs all on one box. 1. Performance. Running both on the same box may cause resource conflicts, as both require a certain amount of CPU and memory. This is especially true in

RE: Configure 1 box with sql/cf together

2004-02-20 Thread Paul Vernon
Load on CPUs will be much higher. Indexing tables, processing page requests handling all that I/O. Load on the disks will be astronomically high. All that DB access and page access for the web-server... Security. If the web-server is dual homed, you can put the database on a

Re: cookies and images

2004-02-20 Thread Andrew Grosset
I'm fairly certain it's not possible with cold fusion because cfcontent strips out all header info before sending the image file. An interesting explanation is here: http://www.webprofession.com/features/98-02/fea400.html where the author explains how it works and how it can be done using

RE: Indexing a network drive with CF's Verity Engine

2004-02-20 Thread Dave Watts
Does anyone have experience/suggestions on how to go about indexing a network drive. We have an Office drive that has numerous presentations that we'd like to be able to index, however that drive is on another server. The share is on a Windows 2000 server as is our Cold Fusion server.

RE: Configure 1 box with sql/cf together

2004-02-20 Thread Dave Watts
This would provide two things - the webserver, though open to some of the outside world traffic, would be relatively secured against NetBIOS attacks and the like. If it is compromised then the only thing lost would be that machine. Your database server (which is by and far the more

Re: MySQL and CF 5

2004-02-20 Thread Stan Winchester
Bud, I got the same error and then I looked to see if there were any illegal conventions, and found the database name had a hyphen “-“ in it and when I got rid of the hyphen, the error went away. Stan Hi. I just got this response to a support request from Crystal Tech. CF 5 does not support

RE: Configure 1 box with sql/cf together

2004-02-20 Thread Paul Vernon
To be fair, the database does not have to trust the web-server at all on a permissions basis, by setting up a particular user that can only access the DB and then restricting all other traffic between the two servers, you can protect the DB even further by placing a firewall between them to

Re: CFMX 6.1 Error (Cant Track the Error down)

2004-02-20 Thread Joe Eugene
I think i finally found where the problem is... We have another server (CF 5.0) using CFApplication setDomainCookies=Yes for some Unknown Process. Well the above creates a CFMAGIC Cookie and this seems to Conflict when the Client Session is created on the CFMX Application and its seems to

Re: Delete structure?

2004-02-20 Thread John Ho
What did I do wrong with this code cfset i = 1 cfoutput query=GetInforVul startrow=1 maxrows=#GetInforVul.recordcount# cfset vulInfor = StructNew() cfset vulInfor.ID = '#GetInforVul.ID#' cfset vulInfor.vulName = '#GetInforVul.vul_name#' cfset vulInfor.Desc = '#GetInforVul.description#' cfset

RE: CFMX 6.1 Error (Cant Track the Error down)

2004-02-20 Thread Dave Watts
I have tried to Delete the CFMAGIC Cookie and it doesnt seem to work unless you physically delete it from the browser. You mean you can't do something like this within your code? cfif IsDefined(Cookie.CFMAGIC) cfcookie name=CFMAGIC value= expires=NOW /cfif If not, you might want to try

CFC invocation performance

2004-02-20 Thread Kevin Marino
Hi, Was wondering if there is a noticeable performance difference between the two following methods; 1.Create an Object referencing CFC then calling functions (e.g. myObject.myfunction() ) on the page. 2.using cfinvoke when needed to call function. Hope I phrased that right. Thanks -Kevin

RE: CFC invocation performance

2004-02-20 Thread Hagan, Ryan Mr (Contractor ACI)
Yeah, there is.I created a CFC to handle a bunch of date processing functions when spidering our intranet.I have to run a format function on every date I run across on our pages.There's about 500 or so.Creating the object once and referencing the format function yields SIGNIFICANTLY better results

RE: CFC invocation performance

2004-02-20 Thread Nathan Strutz
Theoretically, there shouldn't be a difference between a single cfinvoke vs a single cfobject and function call. The real speed bonus comes when you reuse methods from your component because cfinvoke will reload the component every time and cfobject only needs to instantiate once. Then it gets

RE: CFC invocation performance

2004-02-20 Thread Raymond Camden
Others have answered you - but do not forget that you can also use CFINVOKE syntax on an instance of a CFC. This would be preferred if you are calling a CFC multiple times and don't want to recreate it each time. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

RE: CFC invocation performance

2004-02-20 Thread Kevin Marino
Thanks all for the responses. I just went back and reread docs after your suggestions, so have a much better understanding of what should be preferred practice. Thanks -Kevin Marino -- Webmaster - HealthObjects [EMAIL PROTECTED] -Original Message- From: Raymond

Question about Macromedia DRK subscription.

2004-02-20 Thread Ciliotta, Mario
Hi, I was wondering if anyone has subscribe to the DRK's. I was wondering if you could tell me are they worth the cost. I am interested in the CF content and the Flash content. Also does anyone know if there are plans to include some JSP content or maybe JSP tags that CF developers can use.

Re: Still looking for help using web service with php

2004-02-20 Thread Mauricio Giraldo
Hi Consuming the method CallMe from www.ws.com/webservice.cfc?wsdl which receives a numeric parameter using PHP via nuSOAP: ?php require_once('nusoap.php'); $parameters = 2004; $soapclient = new soapclient('http://www.ws.com/webservice.cfc?wsdl','wsdl'); $soapclient-call('CallMe',$parameters); ?

Email Headers listing?

2004-02-20 Thread Burns, John
Can anyone tell me where I can find a list of all of the standard and optional email headers?I'd like to know what all I can set by playing with those in CFMAIL.Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

  1   2   >