RE: Query multiple databases

2004-07-06 Thread Mark A. Kruger - CFG
Phil, Try "db.username.tablename".  If the user is an aliased dbo (ms sql) use "db.dbo.tablename". -Mark   -Original Message-   From: Phill B [mailto:[EMAIL PROTECTED]   Sent: Tuesday, July 06, 2004 10:54 AM   To: CF-Talk   Subject: Query multiple databases   I need to write a join that

RE: Havent seen this error before...

2004-07-05 Thread Mark A. Kruger - CFG
Mike, Hey ... if your right that has to be a bug right? It must be because of the nested function.  I use "trim( )" all the time without issues.  Your saying that trim( ) combined with "Len( )" causes the inner function ref to be passed instead of the return value from both calls? -Mark   -O

RE: Havent seen this error before...

2004-07-05 Thread Mark A. Kruger - CFG
Greg, no - it would not.  What he's (probably) doing is staying away from a "data truncation" error - where the database chockes on a string that is too long for the field size definition.  In this case perhaps his field definition has a size of 100 - doing a "left(string,100)" makes sure that the

RE: Havent seen this error before...

2004-07-05 Thread Mark A. Kruger - CFG
eed single quotes inside the cfqueryparam. Specifying the   cfsqltype should take care of that for you right?   Greg   -Original Message-   From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   Sent: Monday, July 05, 2004 10:44 AM   To: CF-Talk   Subject: RE: Havent seen this error before.

RE: Havent seen this error before...(Resolved)

2004-07-05 Thread Mark A. Kruger - CFG
hehe... happens to me all the time.   -Original Message-   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]   Sent: Monday, July 05, 2004 10:06 AM   To: CF-Talk   Subject: RE: Havent seen this error before...(Resolved)   Too early the morning after with not enough coffee:) Turns out that

RE: Havent seen this error before...

2004-07-05 Thread Mark A. Kruger - CFG
Dan, I would check the following. Is it an exact type match? For example, is the field a "text" field and you are using varchar?  I would check to make sure that the field is nullable - since you are using the "null" attribute.  And I would try other types if you can. -Mark   -Original Messag

RE: Havent seen this error before...

2004-07-05 Thread Mark A. Kruger - CFG
Greg, I don't believe that is correct. The purpose of the single quotes is to identify character data. cfqueryparam makes them unnecessary by specifying the data type in advance.  In this case using a datatype binding (cfqueryparam) means the single quotes would be superflous.  the driver creates

RE: CFMX java.lang.OutOfMemoryError

2004-06-28 Thread Mark A. Kruger - CFG
Indeed, we adjust that value automatically when setting up a new installation. The default value (64mg I believe) is simply too low to support a busy application or multiple sites. -Mark   -Original Message-   From: Steven Erat [mailto:[EMAIL PROTECTED]   Sent: Monday, June 28, 2004 3:56

RE: Understanding/Defending Coldfusion connections

2004-06-23 Thread Mark A. Kruger - CFG
A lot depends on what datasources you are talking about - but any resource on JDBC and connection pooling will give you good information. The underlying service is not CF specific. The current version of CF uses drivers from datadirect. Just about everything about the connection is configurable thr

RE: Macromedia Style nav bar

2004-06-23 Thread Mark A. Kruger - CFG
Asim, I've been using "ghostwire" and I like it - easy to build  dynamic menus. http://www.ghostwire.com/ -Mark   -Original Message-   From: Asim Manzur [mailto:[EMAIL PROTECTED]   Sent: Wednesday, June 23, 2004 10:14 AM   To: CF-Talk   Subject: Macromedia Style nav bar   Hi,   I am lo

RE: Time Tracking

2004-06-23 Thread Mark A. Kruger - CFG
Ian, I would add that the current "anti-popup" climate has brought on a host of new pop-up blocking tools. If in your "onUnload" function you are calling another page, I suspect a popup blocker would take issue with that - no? -Mark   -Original Message-   From: Ian Skinner [mailto:[EMAIL

RE: ODBC Service Hangs on Query

2004-06-21 Thread Mark A. Kruger - CFG
First, make sure the query gives you what you want. Because you have no parenthasise this query is going to give you ALL records from the tables: tblbillingaddr, tblterm That's because the WHERE clause reads "Give me everything WHERE" where tblmasterclients.clientname = "tblbillingaddr.Client N

RE: Help with CF5 Queued Requests

2004-06-18 Thread Mark A. Kruger - CFG
Frank, You should be looking for code that "waits" for a response from a third party process. Culprits are (typically) db access, ftp, ldap, pop, file access (cffile), cfhttp etc.  All of these services must connect to a service or process "outside" the CF engine - cf awaits their response... some

question about "server" variable

2004-06-17 Thread Mark A. Kruger - CFG
What does the variable "server.Coldfusion.expiration" mean? I'm examining a users current host. -mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: Argh! Ram upgrade killed CF!

2004-06-15 Thread Mark A. Kruger - CFG
I'd say bad or mismatched memory is at fault. -mk   -Original Message-   From: Jack Dalaa [mailto:[EMAIL PROTECTED]   Sent: Monday, June 14, 2004 4:50 PM   To: CF-Talk   Subject: Re: Argh! Ram upgrade killed CF!   jvm.config is just default stuff:   # Arguments to VM java.args=-server -

RE: Message Board

2004-06-11 Thread Mark A. Kruger - CFG
Rick, yeah - me neither (dropping it)... plus I get so dang pompous when I'm arguing - it's not a side of me I like . -mk   -Original Message-   From: Rick Root [mailto:[EMAIL PROTECTED]   Sent: Friday, June 11, 2004 2:41 PM   To: CF-Talk   Subject: Re: Message Board   Mark

RE: Message Board

2004-06-11 Thread Mark A. Kruger - CFG
the gift of CF to the world - there are probably other things more deserving my charity. I'm more interested early retirement (hehe). -Mark   -Original Message-   From: Rick Root [mailto:[EMAIL PROTECTED]   Sent: Friday, June 11, 2004 2:01 PM   To: CF-Talk   Subject: Re: Message Boar

RE: Message Board

2004-06-11 Thread Mark A. Kruger - CFG
uh what?   -Original Message-   From: Rick Root [mailto:[EMAIL PROTECTED]   Sent: Friday, June 11, 2004 1:49 PM   To: CF-Talk   Subject: Re: Message Board   Calvin Ward wrote:   > I  don't agree with the need for free anything, especially something   > someone crafted.   That's an a

RE: Function for days and years...

2004-06-11 Thread Mark A. Kruger - CFG
Sorry, I was trying to send that to the guy who needed it. -Mark   -Original Message-   From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   Sent: Friday, June 11, 2004 1:13 PM   To: CF-Talk   Subject: Function for days and years...   This function makes sure that the days match the

Function for days and years...

2004-06-11 Thread Mark A. Kruger - CFG
uot;+aDate[1]);   if(eval(aDate[1])>daysInMonth(eval(aDate[2]),eval(aDate[0])))   return false;   return true;   }   > -Original Message-   > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   > Sent: vrijdag 11 juni 2004 18:41   > To: CF-Talk   > Subject: OT: Regula

RE: Regular expressions in JS (or in general) for dates

2004-06-11 Thread Mark A. Kruger - CFG
sInMonth(eval(aDate[2]),eval(aDate[0])))   return false;   return true;   }   > -Original Message-   > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   > Sent: vrijdag 11 juni 2004 18:41   > To: CF-Talk   > Subject: OT: Regular expressions in JS (or in general) for da

OT: Regular expressions in JS (or in general) for dates

2004-06-11 Thread Mark A. Kruger - CFG
Regex gurus, I have a string and I want to ensure that the date format is: xx/xx/ or x/x/ or x/x/xx (you get the idea) Does anyone have a stock regex for this?  Am I going to need more than 1 or can I look at everything (length, format and range of numbers) in 1 regex? -mark Mark A

RE: someone has to know this... MACROMEDIANS, anyone...cfdump 3rd post

2004-06-11 Thread Mark A. Kruger - CFG
Is there anything IN your servers/lib directory - and how did you figure out that this was the problem?? -Mark   -Original Message-   From: Tony Weeg [mailto:[EMAIL PROTECTED]   Sent: Friday, June 11, 2004 11:18 AM   To: CF-Talk   Subject: someone has to know this... MACROMEDIANS, anyone.

RE: Character encoding - CFMX and SQL

2004-06-11 Thread Mark A. Kruger - CFG
Paul, THAT is the answer I'm looking for -thanks! -Mark   -Original Message-   From: Paul Hastings [mailto:[EMAIL PROTECTED]   Sent: Friday, June 11, 2004 9:28 AM   To: CF-Talk   Subject: Re: Character encoding - CFMX and SQL   > language specific characters (Italian) it changes the ch

RE: Character encoding - CFMX and SQL

2004-06-11 Thread Mark A. Kruger - CFG
o: CF-Talk   Subject: Re: Character encoding - CFMX and SQL   you have to create the columns in MS SQL as nVarchar so that they can   cope with international chraracters...   Regards   On Fri, 11 Jun 2004 08:22:31 -0500, Mark A. Kruger - CFG   <[EMAIL PROTECTED]> wrote:   >   > Fo

Character encoding - CFMX and SQL

2004-06-11 Thread Mark A. Kruger - CFG
w it ends up in the database like this: Nel cominciare l?analisi In the application.cfm page we have the following directive: Any one have any helpful hints? -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays T

RE: CFQUERY - MySQL Chicken and Egg

2004-06-02 Thread Mark A. Kruger - CFG
nt database and set up a DNS to   it, I didn't want to confuse the issue.   Cheers,   barneyb   > -Original Message-   > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   > Sent: Tuesday, June 01, 2004 5:43 AM   > To: CF-Talk   > Subject: RE: CFQUERY - MySQL C

RE: CFQUERY - MySQL Chicken and Egg

2004-06-01 Thread Mark A. Kruger - CFG
Not exactly true that you have to use the "native interface" for all rdbms's.  In MsSQL (and other rdbms's)  if you have the proper permissions you can create multiple databases and use them from a single datasource. The reason it's not often done is that you must know something about the physical

RE: MS SQL Syntax/Operator

2004-05-19 Thread Mark A. Kruger - CFG
PS the CAST convert functions won't help here. The problem is in trying to treat a list of values in a single character column as if they were separate entities. SQL doesn't do "lists" like that. -mark   -Original Message-   From: Burns, John D [mailto:[EMAIL PROTECTED]   Sent: Wednesday

RE: MS SQL Syntax/Keyword

2004-05-19 Thread Mark A. Kruger - CFG
John, Your syntax would output like this: where 15 IN (sharedGroupIds) If I'm reading your right this is backwards - it should be "column IN  values" or sharedGroupIds IN (15) Unfortunatley the IN clause is not going to work for you with a column of values because it uses "equals" against each

RE: ColdFusion Developer Edition

2004-05-05 Thread Mark A. Kruger - CFG
Yes - but all the developers must have a subscription - right? -mk   -Original Message-   From: Dave Watts [mailto:[EMAIL PROTECTED]   Sent: Wednesday, May 05, 2004 8:21 AM   To: CF-Talk   Subject: RE: ColdFusion Developer Edition   > Ok I know there is a ColdFusion Developer edition, but

RE: Database error messages

2004-05-05 Thread Mark A. Kruger - CFG
Barney, I'd love that error handling code.  I'll give you a plug on my blog. -mark   -Original Message-   From: Barney Boisvert [mailto:[EMAIL PROTECTED]   Sent: Tuesday, May 04, 2004 5:48 PM   To: CF-Talk   Subject: RE: Database error messages   Whoops, no attachements on cf-talk.  Tha

RE: determining the correct version of MDAC

2004-04-21 Thread Mark A. Kruger - CFG
Dave, awesome - that's what I was looking for - thanks! -mark   -Original Message-   From: Dave Watts [mailto:[EMAIL PROTECTED]   Sent: Wednesday, April 21, 2004 3:29 PM   To: CF-Talk   Subject: RE: determining the correct version of MDAC   > Does anyone remember how to figure out what v

determining the correct version of MDAC

2004-04-21 Thread Mark A. Kruger - CFG
Does anyone remember how to figure out what version of MDAC is installed on their server? Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: SMTP

2004-04-21 Thread Mark A. Kruger - CFG
ere. http://www.pubforum.net/postsp4.htm Be careful when you run it - there is probably a reason it's only available from tech support . Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tu

RE: Latest Windows Updates

2004-04-16 Thread Mark A. Kruger - CFG
Bryan, Reboot and hit f8 - then choose "last known good configuration" from the screen - you may need to do this once or twice. -Mark   -Original Message-   From: Bryan Stevenson [mailto:[EMAIL PROTECTED]   Sent: Friday, April 16, 2004 2:01 PM   To: CF-Talk   Subject: Re: Latest Windows

RE: Importing Access to MSSQL

2004-04-07 Thread Mark A. Kruger - CFG
I use the DTS package designer wizard in SQL to create a DTS script for this.  If you must drop the tables each night then the procedure is: drop tables create tables (no indexes or constraints) copy data in     -AT this step can do many things including clean up the data, merge the data etc. Ru

RE: user agent checking and spidering...

2004-04-05 Thread Mark A. Kruger - CFG
user agent checking and spidering...   Mark A. Kruger - CFG wrote:   > Dave,   >   > That's not what I'm finding.  If you have a robots.txt file that says:   >   > disallow /search.cfm   >   > It will not index the search.cfm file from the root of the server. But   &g

RE: user agent checking and spidering...

2004-04-05 Thread Mark A. Kruger - CFG
P.S. Actually he had NO caching and that is our first step - and it has been quite successful. -Mark   -Original Message-   From: Dave Watts [mailto:[EMAIL PROTECTED]   Sent: Sunday, April 04, 2004 5:23 PM   To: CF-Talk   Subject: RE: user agent checking and spidering...   > Sequelink

RE: user agent checking and spidering...

2004-04-05 Thread Mark A. Kruger - CFG
Dave, That's not what I'm finding.  If you have a robots.txt file that says: disallow /search.cfm It will not index the search.cfm file from the root of the server. But I cannot find anywhere where you can put in something like this: disallow http://www.someothersite.com You see what I mean? T

RE: user agent checking and spidering...

2004-04-04 Thread Mark A. Kruger - CFG
dated database of agent information.  It'll   give you much more than just "isBot" but will also cost you.   Let me know if you want my database.   Jim Davis     _     From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   Sent: Sunday, April 04, 2004 2:06 PM   To: CF-Talk   S

user agent checking and spidering...

2004-04-04 Thread Mark A. Kruger - CFG
of the various user-agents I'm trying to look for. Any help will be appreciated - thanks! -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: creating 404 page for CFM and JSP files.

2004-04-01 Thread Mark A. Kruger - CFG
make sure and delete all the jsp files. What is probably happening is that CF (i.e. Jrun) is being tasked by IIS to serve the JSP pages, but you have the wrong version to do it (like CF professional).  Also, go into the site properties and make sure that CF is NOT tasked with serving JSP pages (cli

RE: IIS Custom Error Pages in CF?

2004-03-31 Thread Mark A. Kruger - CFG
- Original Message -----   From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>   To: "CF-Talk" <[EMAIL PROTECTED]>   Sent: Wednesday, March 31, 2004 6:38 AM   Subject: RE: IIS Custom Error Pages in CF?   > Yes you can.   >   > 1) Go into IIS properties fo

OT: Affiliate software

2004-03-31 Thread Mark A. Kruger - CFG
Deos anyone know of any software similar to: http://www.webscribble.com/products/webaffiliate/requirements.shtml That's runs on IIS and (possibly) CF? Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads]

RE: Cf puzzle

2004-03-31 Thread Mark A. Kruger - CFG
Gabriel, The web server already has to parse the header, determine if the file exists and point to the file (or 404 handler) - yes I would imagine that there is a bit more overhead than if the file/folder existed in the first place - but I have several sites doing this and similar things, some of

RE: Cf puzzle

2004-03-31 Thread Mark A. Kruger - CFG
If you are using IIS check out a thread from earlier today http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=31591&forumid=4 Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message--

RE: IIS Custom Error Pages in CF?

2004-03-31 Thread Mark A. Kruger - CFG
user to a customized page for login or whatever. A similar trick uses a wildcard entry on a DNS server to allow a user to go to "marySmith.blah.com" - both tricks are great for sales CRM tools, real estate sites and the like - any place where you want a use to have a "

RE: Sneaky Virus

2004-03-29 Thread Mark A. Kruger - CFG
That is sneaky...   -Original Message-   From: Brook Davies [mailto:[EMAIL PROTECTED]   Sent: Monday, March 29, 2004 12:11 PM   To: CF-Talk   Subject: OT: Sneaky Virus   I just got this sneaky ass virus. The link in the email looked like a URL   and it had my domain in it so I thought I w

RE: SQL grouped query help

2004-03-29 Thread Mark A. Kruger - CFG
You know... I love this idea - very cool I had not thought of that. -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be!   -Original Message-   From: Nick de Voil [mailto:[EMAIL PROTECTED]   Sent: Monday, March 29

RE: Upgrading Problem on CFMX

2004-03-26 Thread Mark A. Kruger - CFG
I believe this was a bug were the page length for compile can't be more than 64 k.  If I remember correctly it was fixed in 6.1 when the compiler was moved to "direct to bytecode" instead of creating intermediate source files and then compiling it. I could be way off... but are you on 6.1?   -O

RE: Okay, bear with me, I'm not even sure what I'm asking...

2004-03-25 Thread Mark A. Kruger - CFG
ark infringement. I hope this helps. Mark   -Original Message-   From: Jeff Small [mailto:[EMAIL PROTECTED]   Sent: Thursday, March 25, 2004 1:56 PM   To: CF-Talk   Subject: Re: Okay, bear with me, I'm not even sure what I'm asking...   - Original Message -   From: "

RE: Okay, bear with me, I'm not even sure what I'm asking...

2004-03-25 Thread Mark A. Kruger - CFG
Did I misunderstand this - I think he IS asking why he can't use exaclty like he uses ... why src="" works and why doesn't... right? I don't think he's asking how to use the image tag, I think he's asking how to get at the root using cfinclude - which IS germane to a cf mapping. -mk   -Orig

RE: Okay, bear with me, I'm not even sure what I'm asking...

2004-03-25 Thread Mark A. Kruger - CFG
server be careful because everyone can include from "your" directory now using the root mapping. savy? Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be!   -Original Message-   From: Jeff Small [mailto:[EMAIL PROTECT

RE: sql server

2004-03-22 Thread Mark A. Kruger - CFG
yes... just download the trial and install the client tools only. they do not expire.   -Original Message-   From: Jeremy [mailto:[EMAIL PROTECTED]   Sent: Monday, March 22, 2004 8:54 AM   To: CF-Talk   Subject: RE: sql server   Is that a free download.   -Original Message-   From

RE: HTTPS: what factors disable it?

2004-03-14 Thread Mark A. Kruger - CFG
?showImage=false I hope this helps you. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be!   -Original Message-   From: Reed Powell [mailto:[EMAIL PROTECTED]   Sent: Sunday, March 14, 2004 3:00 PM   To: CF-Talk   Subject: HTTP

RE: Quick SQL Question...

2004-03-14 Thread Mark A. Kruger - CFG
ECTED]   Sent: Friday, March 12, 2004 2:52 PM   To: CF-Talk   Subject: RE: Quick SQL Question...   mark, i see where you are coming from...alas, i still am having no luck. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday,

RE: Quick SQL Question...

2004-03-12 Thread Mark A. Kruger - CFG
TotalRefsPerDay, datepart(month,creationdate) + '-' + datepart(day,creationdate) + '-' + datepart(year,creationdate) AS datelabel group by datepart(dw,creationdate) order by datelabel or something similar.  The DateName( ) function would work as well - maybe better. It usally takes som

20 meg updater for DWMX 2004

2004-03-12 Thread Mark A. Kruger - CFG
Wow... that's a hefty updater. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: SQL custom Order by

2004-03-09 Thread Mark A. Kruger - CFG
David, Yes but this may OR may not return them in the order you are looking for. However, there IS an easy way to use the UNION operator this way (for ordering). You need to stop using the asterisk (stop it! bad programmer!!). Try this: -- SELECT col1,

RE: SQL Help

2004-03-09 Thread Mark A. Kruger - CFG
with what they gave me.   -Original Message-   From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   Sent: Tuesday, March 09, 2004 10:12 AM   To: CF-Talk   Subject: RE: SQL Help   How about:   WHERE  (name LIKE '%Open%'  or name LIKE '%Engineering%') AND

RE: SQL Help

2004-03-09 Thread Mark A. Kruger - CFG
How about: WHERE  (name LIKE '%Open%'  or name LIKE '%Engineering%') AND name NOT LIKE ('%closed%') Personally, this is probably not the best way to handle status.  I always have a status field - either an int or a small character field and use a constraint ('open','closed','pending') and always

RE: CFFLUSH Advantages / Disadvantages

2004-03-05 Thread Mark A. Kruger - CFG
 +46 733 467111  WWW:   http://www.grida.no   -    Original Message ----   From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>   To: "CF-Talk" <[EMAIL PROTECTED]>   Sent: Wednesday, March 0

RE: Oracle / Stored Proc Issues

2004-03-04 Thread Mark A. Kruger - CFG
Did you check all your database settings to ensure they are the same (clobs and blobs and select method etc)?  Have you tried creating a datasource on the test server that points to the live server then running your proc to see if it works? -mk   -Original Message-   From: Adrocknaphobia [

RE: CFFLUSH Advantages / Disadvantages

2004-03-03 Thread Mark A. Kruger - CFG
Nick, I've found cf flush to be useful when you are serving up long tabular report data.  If you are going to output several hundred rows, cfflush can help a lot.  One approach I've used that works great for intranet sites where the browser is a known item is a combination of a status bar, _javasc

RE: SQL Multiple Inserts

2004-03-01 Thread Mark A. Kruger - CFG
Stored procedures are not cached queries - they are compiled execution plans. The thing that makes the difference is the databinding. SQL knows what type a variable is prior to execution of the query. So it does not have to "check" in the system tables to see what type it should be using.  For exam

OT: freelancer

2004-02-25 Thread Mark A. Kruger - CFG
r anything else about it.  If any of you have any interest let me know and I will get you in contact with her. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://mxc.blogspot.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: still having a problem with insert

2004-02-25 Thread Mark A. Kruger - CFG
Steven, yes... if you use "createodbcdatetime()" or createodbcdate() to massage the variable "thisdate" into something that looks like {ts '2004-02-25 09:49:00'}   Then you must REMOVE the single quotes around that one... also, is the column name really "thisdate"?  Remember the name of the column

RE: still having a problem with insert

2004-02-25 Thread Mark A. Kruger - CFG
Steven, I would add one more thing. Rather than beat your head agains the wall in CF, get a quick book - the teach yourself SQL in  24 hours would do nicely - and use the query analyzer or some other "raw" tool where you can pass in queries and view results. Take a half a day and learn SELECT , IN

RE: still having a problem with insert

2004-02-25 Thread Mark A. Kruger - CFG
Steven, You need single quotes around all "char" data... as in '#form.subject#'. You will need to correctly format the date as well. Try using #createodbcdate(form.thisdate)#  for that item.  Also - as has been suggested a couple of times - using CFQUERYPARAM would be a good idea - faster, and saf

RE: total newbe question

2004-02-25 Thread Mark A. Kruger - CFG
basically insert into clntnote (thisdate,subject,note,type,compid) values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#) You will need to debug it of course. -Mark   -Original Message-   From: Steven Sharko [mailto:[EMAIL PROTECTED]   Sent: Wednesday,

RE: SOT: SQL question

2004-02-23 Thread Mark A. Kruger - CFG
Yes but Query of queries DOES support the union key word. -Mark   -Original Message-   From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]   Sent: Monday, February 23, 2004 2:01 PM   To: CF-Talk   Subject: Re: SOT: SQL question   As listed in the original post, my ISP is using MySQL 3.2

RE: EMERGENCY HELP NEEDED

2004-02-22 Thread Mark A. Kruger - CFG
A)  did you restart both IIS and the Cold fusion? B)  Can you resolve HTML  pages in the appropriate directories C) Did you (or did you consider) rerunning the remove/add connector script? -Mark   -Original Message-   From: Eric Creese [mailto:[EMAIL PROTECTED]   Sent: Sunday, February

RE: What could be wrong with this code ? Any expertise on this please??

2004-02-04 Thread Mark A. Kruger - CFG
Ian, one guess: username=#MM_Universe_Connection_USERNAME# password=#MM_Universe_Connection_PASSWORD#> Put quotes around the username and password and datasource:     username="#MM_Universe_Connection_USERNAME#" password="#MM_Universe_Connection_PASSWORD#"> If there are any weird cha

RE: flash remoting help: UPDATED

2004-01-06 Thread Mark A. Kruger - CFG
');   }   function sayHello_Result(result) {   trace(result);   trace('blah');   }   init();   stop();   And it made no difference!!   On 6/1/04 10:40 pm, "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> wrote:   > Ryan,   >   > Yeah - your function is using a var

RE: flash remoting help: UPDATED

2004-01-06 Thread Mark A. Kruger - CFG
Ryan, Yeah - your function is using a var to set your service.  The responder is out of scope. get rid of the var. -mark   -Original Message-   From: Ryan Mitchell [mailto:[EMAIL PROTECTED]   Sent: Tuesday, January 06, 2004 4:28 PM   To: CF-Talk   Subject: Re: flash remoting help: UPDATE

test

2003-12-15 Thread Mark A. Kruger - CFG
test message    Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://mxc.blogspot.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: IsDate( ) behaviour

2003-12-02 Thread Mark A. Kruger - CFG
Thanks for this - saves me 15 minutes of futzing with re... -mk   -Original Message-   From: Ubqtous [mailto:[EMAIL PROTECTED]   Sent: Tuesday, December 02, 2003 12:18 PM   To: CF-Talk   Subject: Re: IsDate( ) behaviour   Nick,   On 12/2/2003 at 13:09, you wrote:   NH> Yeah, I have run

RE: IsDate( ) behaviour

2003-12-02 Thread Mark A. Kruger - CFG
Nick, Yeah - I can do that I guess, but it seems like a pain.  It was my guess that the "inline" evaluation feature was the culprit.  In CFMX you an do variable arithmetic short hand as in: x = 1 y = 2 #x+y# ... outputs 3. I was guessing that the evaulater some how converts my sting into 1231 d

IsDate( ) behaviour

2003-12-02 Thread Mark A. Kruger - CFG
If I have this string: '1231/04' And I pass it to "IsDate( )" It returns True. IsDate(var) = TRUE If I pass it to DateFromat( ) it returns: 01-Apr-31 Can someone explain to me if this is expected behavior or if it's unusual? -Mark [Todays Threads] [This Message] [Subscription] [Fast

RE: 2 line charts

2003-11-17 Thread Mark A. Kruger - CFG
Dave, That's what I figured.  Ok - thanks. -Mark   -Original Message-   From: Dave Watts [mailto:[EMAIL PROTECTED]   Sent: Monday, November 17, 2003 11:27 AM   To: CF-Talk   Subject: RE: 2 line charts   > I'm trying to do a comparison chart using CFgraph in CF 5.     > I'd like to be ab

2 line charts

2003-11-17 Thread Mark A. Kruger - CFG
Folks, I'm trying to do a comparison chart using CFgraph in CF 5.  I'd like to be able to simply draw 2 lines on a single graph.  Does anyone know of a way to do this?  I can't seem to  get it done with cfgraphdata OR with a query. -Mark Mark A. Kruger, MCSE, CFG www

RE: CF4.5, CFHTTP, SSL.... anybody been able to get it to work?

2003-11-13 Thread Mark A. Kruger - CFG
Is it just me - or do I seem to remember that cf 4.5 only supported 40 bit encryption? I had an issue like this waaay back when and what sticks in my head is that 4.5 couldn't handle the encryption level. Anyway - I assume that you have verified that the URL can be opened in a browser on that 4.5

RE: QUERY TABLE DATA INFORMATION

2003-11-11 Thread Mark A. Kruger - CFG
sp_tables Returns tables with a qualifier for "user" and "system"... use q of a q to get at the "user" tables. -Mark   -Original Message-   From: Eric Creese [mailto:[EMAIL PROTECTED]   Sent: Tuesday, November 11, 2003 4:13 PM   To: CF-Talk   Subject: QUERY TABLE DATA INFORMATION   I am

RE: The Datasource service is not available error

2003-11-11 Thread Mark A. Kruger - CFG
Craig, how are you databases generally set up? JDBC etc? -Mark   -Original Message-   From: Craig Zingerline [mailto:[EMAIL PROTECTED]   Sent: Tuesday, November 11, 2003 12:04 PM   To: CF-Talk   Subject: The Datasource service is not available error   Hello All,   I'm running Coldfusio

RE: Deleteing a directory

2003-11-10 Thread Mark A. Kruger - CFG
Create a batch file and use RMDIR.  here's a link to syntax. http://www.easydos.com/rmdir.html You can also use to do this. -Mark -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:07 PM To: CF-Talk Subject: Re: Deleteing a directory   Can someon

RE: CFQUERYPARAM bug?

2003-11-07 Thread Mark A. Kruger - CFG
I'd wager that syntactically you would be stringing your variables together with your keywords as in "WHERE the_id=?AND the_other_id=? no space between the q-mark and the "AND".  keywords are always delimited by spaces. When the driver does the "prepare" task it sees a bind placeholder abu

RE: Debug output order

2003-11-07 Thread Mark A. Kruger - CFG
des\VarLoad.cfm   5) C:\Inetpub\wwwroot\BAU\ForceLoadTool\global.cfm   6) C:\Inetpub\wwwroot\BAU\ForceLoadTool\CategoryDefine.cfm   Steve   -Original Message-----   From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   Sent: Friday, November 07, 2003 4:34 PM   To: CF-Talk   Subject: RE:

RE: RE: Debug output order

2003-11-07 Thread Mark A. Kruger - CFG
I hate to say this but 3.04 is easier than 4.x.  If you see 4.x for CFMX run.  And whatever you do - don't upgrade! -Mark   -Original Message-   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]   Sent: Friday, November 07, 2003 3:55 PM   To: CF-Talk   Subject: Re:RE: Debug output ord

RE: Debug output order

2003-11-07 Thread Mark A. Kruger - CFG
ssage-   From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]   Sent: Friday, November 07, 2003 4:16 PM   To: CF-Talk   Subject: RE: Debug output order   Jeff,   There's not a way in CF 5 - in CFMX there is an open template - and they   actually ARE in order by default.  What version   

RE: How to count sessions

2003-11-07 Thread Mark A. Kruger - CFG
wonderful... nice trick - very helpful. -Mark   -Original Message-   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]   Sent: Friday, November 07, 2003 2:58 PM   To: CF-Talk   Subject: RE: How to count sessions   actually there is...one way in CFMX is this quick stuff               

RE: Debug output order

2003-11-07 Thread Mark A. Kruger - CFG
Jeff, There's not a way in CF 5 - in CFMX there is an open template - and they actually ARE in order by default.  What version of ACB are you using? -Mark   -Original Message-   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]   Sent: Friday, November 07, 2003 2:22 PM   To: CF-Talk   Su

RE: Just Wondering Why

2003-11-07 Thread Mark A. Kruger - CFG
I'm with you guys. I not only separate into separate files, but I make a very good effort at separating Logic blocks, queries, thematic elements (styles etc) and display code. In addition, in the CFMX world, CFC's allow for an even greater level of abstraction because they can serve multiple purpos

RE: question...

2003-11-07 Thread Mark A. Kruger - CFG
I like this better: IF(StructKeyExists(form,Listgeat(fieldlist,i))    {         } One of the reasons I like using Cfscript is to get rid of pound signs and quotes  - seems more readable. Just my 02. -mark   -Original Message-   From: Che Vilnonis [mailto:[EMAIL PROTECTED]   Sent:

RE: Arden Weiss - virus sending messages to the list?

2003-11-06 Thread Mark A. Kruger - CFG
Isn't Arden Weiss the uncle from the sound of Music?   -Original Message-   From: Michael Dinowitz [mailto:[EMAIL PROTECTED]   Sent: Thursday, November 06, 2003 11:51 AM   To: CF-Talk   Subject: Re: Arden Weiss - virus sending messages to the list?   That would do it. He's not currently in

RE: CGI variable "SERVER_PORT_SECURE"

2003-11-03 Thread Mark A. Kruger - CFG
Ok... but if I know the web server is IIS 5 I can pretty much guarantee it will be there - right? -Mark   -Original Message-   From: Dave Watts [mailto:[EMAIL PROTECTED]   Sent: Monday, November 03, 2003 9:55 AM   To: CF-Talk   Subject: RE: CGI variable "SERVER_PORT_SECURE"   > > Does an

CGI variable "SERVER_PORT_SECURE"

2003-11-03 Thread Mark A. Kruger - CFG
Does anyone know if the variable: SERVER_PORT_SECURE Is reliably set on all browsers? -Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: OT: Video Rendering

2003-10-31 Thread Mark A. Kruger - CFG
Thanks - I'll pass that along.   -Original Message-   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]   Sent: Friday, October 31, 2003 3:35 PM   To: CF-Talk   Subject: Re: OT: Video Rendering   quicktime pro does a real good job of converting video   i also use sorenson squeeze, anyone d

RE: Video Rendering

2003-10-31 Thread Mark A. Kruger - CFG
I know the feeling. According to my spell-check I'm my own worst enema (hehe).   -Original Message-   From: Jim Davis [mailto:[EMAIL PROTECTED]   Sent: Friday, October 31, 2003 1:38 PM   To: CF-Talk   Subject: RE: Video Rendering   As far as spelling goes I am my own worst enemy.  ;^)   J

RE: Video Rendering

2003-10-31 Thread Mark A. Kruger - CFG
Thanks Jim - I'll pass that along (did you mean to say "defiantly" or is that attack of the spell checker ).   -Original Message-   From: Jim Davis [mailto:[EMAIL PROTECTED]   Sent: Friday, October 31, 2003 12:24 PM   To: CF-Talk   Subject: RE: Video Rendering   What are they using to

<    6   7   8   9   10   11   12   13   14   15   >