RE: SQL Server Enterprise Manager alternatives?

2004-05-13 Thread Costas Piliotis
Embarcaderro rapidsql is okay... www.embarcaderro.com Perhaps you could try query analyzer?CREATE TABLE works pretty good too... -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 23, 2001 10:06 AM To: CF-Talk Subject: RE: SQL Server

RE: SQL Competency Test

2003-08-11 Thread Costas Piliotis
http://www.brainbench.com/ These guys I believe have one for free... Pretty tough one too on sql theory actually... -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 12:26 PM To: CF-Talk Subject: OT: SQL Competency Test Good

RE: setting sql isolation levels within cfquery

2003-07-29 Thread Costas Piliotis
If in doubt, you can use lock hints instead: SELECT * FROM mytable (nolock) UPDATE mytable WITH (rowlock) set field = value Etc... In cfquery blocks it may be safer than isolation level statements... -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, July

Majordomo archives

2003-07-28 Thread Costas Piliotis
I haven't got a clue where to begin on this. A client of mine wants to get a mailing list going, and we're leaning towards Majordomo or Listserv. Problem is that I don't know what the heck the archives look like. He was intersted in mhonarc to parse the archives, but that looks to be more

RE: Help!

2003-07-28 Thread Costas Piliotis
Easiest thing to do is not use MS Access... Your GAL should be accessible through LDAP. Consider using CFLDAP to access instead. Added bonus is that you don't have to use two layers...Check with your exchange admin about using LDAP to access the GAL. Here's an article on it:

SOT: Canadian Latitudes/Longitudes postal codes

2003-07-23 Thread Costas Piliotis
I'm building a site that's gonna need the the distance between two points... I hypothersize that I can get this with Latitudes and Longitudes for a given location. I'll know the postal codes. I can get the addresses or postal codes... Anyone know where I can get a list for Canada? It appears

RE: Canadian Latitudes/Longitudes postal codes

2003-07-23 Thread Costas Piliotis
recently. We sourced the DB here... http://www.zipinfo.com/ --David - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:49 PM Subject: SOT: Canadian Latitudes/Longitudes postal codes I'm building a site that's gonna

RE: Think you are a SQL GURU? Try figuring this one out.

2003-07-17 Thread Costas Piliotis
Actually, there's a dll you can get to add regex support to sql server too. http://databasepronews.com/articles/0220df.html I rule. -Original Message- From: Wjatscheslaw Kravtchenko [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 4:25 PM To: CF-Talk Subject: OT: Think you are

RE: Stored Procedure not found

2003-07-17 Thread Costas Piliotis
Can you call stored procedures inside a cfscript tag? I thought those operations had to be outside a cfscript tag... -Original Message- From: Wjatscheslaw KRAVTCHENKO [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 12:12 PM To: CF-Talk Subject: Stored Procedure not found Hi

RE: CF Application Design

2003-07-11 Thread Costas Piliotis
I'd personally recommend Embarcadero's ER/Studio for database design. It has way better features than Visio, for it is specific... http://www.embarcadero.com/products/erstudio/index.asp I believe Sybase and Oracle also have good database design tools... Looks like Adalon though is a pretty

RE: I knew your name was Neo

2003-07-09 Thread Costas Piliotis
Yay! Redhat 8 and 9 support! Finally :) -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 9:50 AM To: CF-Talk Subject: Re: I knew your name was Neo On Wednesday, July 9, 2003, at 04:13 AM, Ben Koshy wrote: Updater 3 seems to have

RE: Array vs. temp table

2003-07-08 Thread Costas Piliotis
I know there aren't arrays in SQL Server... Dunno about Oracle. From what I understand, a 2-dimensional array is a table, so there's never been a need for array vars in sql server. And in sql server, you can have table variables which behave like temprary tables but are stored in memory, which

RE: IIS and making SES URLs work [WAS: Search Engine Optimization ]

2003-07-08 Thread Costas Piliotis
Dumb q... SES urls... Are they even required any more? I mean, the smarter engines follow links through your site, so is it really necessary? -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 2:26 PM To: CF-Talk Subject: IIS and making SES URLs

RE: Conditional SQL Query Not Working

2003-07-03 Thread Costas Piliotis
Wow... join conditions in the where clause... Haven't seen those for years :) Looks like you have a cartesian join between organizations and the rest of your dataset... Need to join organizations to something. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent:

RE: unnecessary jsessionid in the url

2003-07-03 Thread Costas Piliotis
AFAIK, addtoken=no in the cflocation tag should do it... At least in CF5 :) -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 4:25 PM To: CF-Talk Subject: unnecessary jsessionid in the url Hello All, I'm trying to do a cflocation and there is a

RE: Content Management System

2003-07-02 Thread Costas Piliotis
Tried this one yet? http://sourceforge.net/projects/cosmoscf/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:00 PM To: CF-Talk Subject: Re: Content Management System I should add that it should be cheap ( $500). I tried

RE: Content Management System

2003-07-02 Thread Costas Piliotis
Or this one? http://sourceforge.net/projects/modus/ -Original Message- From: Costas Piliotis Sent: Wednesday, July 02, 2003 4:06 PM To: CF-Talk Subject: RE: Content Management System Tried this one yet? http://sourceforge.net/projects/cosmoscf/ -Original Message- From

RE: CFX_IMAGE

2003-07-02 Thread Costas Piliotis
Hahahahahahahahahahahaha... Sorry... Had to do it... Looks nice... Really... -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 2:31 PM To: CF-Talk Subject: RE: CFX_IMAGE Who ever wants it, http://relativepath.net/cfximage/cfx_image.zip

RE: Hardware Disable Right-Click

2003-06-26 Thread Costas Piliotis
Watch out for the windows keys too... Dunno if they get disabled... Stuff like window key - d, ctrl-esc... And the stupid key next to the window key that we all wonder what exactly it does... That's also a right-click... Are there special Kiosk keyboards that are missing all the function

RE: Homesite + question

2003-06-26 Thread Costas Piliotis
There's plenty of information on this in the past... Forta has been quite vocal on that subject... Per Forta, MM depracated cf studio because they figured there's no point in maintaining three web development IDE's. I recon that MM actually felt that two was too many, although their user bases

RE: CFGURU Help Needed

2003-06-25 Thread Costas Piliotis
Ah yes. I had this too... Couple things... What version of Apache you using? Also, on redhat 9, when I did that, I had to chown root.root jrunserver.store to get it to start. Dunno if that'll help u or not... -Original Message- From: Jodie A [mailto:[EMAIL PROTECTED] Sent:

RE: CFGURU Help Needed

2003-06-25 Thread Costas Piliotis
Help Needed It's actually Netscape - no change with chown. Any other advice? From: Costas Piliotis [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CFGURU Help Needed Date: Wed, 25 Jun 2003 11:28:10 -0700 Ah yes. I had this too... Couple things... What

RE: Passing session from .aspx to .cfm and back

2003-06-23 Thread Costas Piliotis
Sorry to jump into this thread a bit late, but why not use client variables in cfmx, store them in a database, and write a .net object or function or whatever that parses those variables out into asp.not variables... And write another one to pass them back... Just use cdata / cglobal tables.

RE: List of all running applications?

2003-06-20 Thread Costas Piliotis
Why not point client variables to a database and just do a select distinct app from cdata Even if you don't use them, every session from every application gets an entry into that table... -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 3:11 AM

RE: CF or .net?

2003-06-20 Thread Costas Piliotis
In general, .net provides you with a whole new way of thinking about writing web apps. Lots of xml integration, very object oriented, tonnes of different language support: C#, vb.net, delhpi, etc etc... Forget everything you learned about writing a web app in ColdFusion. Dot Net is a whole new

RE: Problems with a query going from CF 5 to CFMX

2003-06-19 Thread Costas Piliotis
And dumb question here, but finnished? Isn't it finished (with only one n)? Maybe it's spelled correctly in the database and not in your code? =) Finnished... Is that a way of being made a person from Finland? Some kind of metamorphosis or something? -Original Message- From: Sean

RE: session variables vs client variables

2003-06-19 Thread Costas Piliotis
Been there. You'll benefit from all my pains here: In a nutshell, Crystal uses simple cookies instead of fancy cookies. Every report parameter is stored as a cookie. Real stupid setup if you ask me. There's a browser limitation on how many cookies a single site is allowed to set. There's

Switching to OLE DB

2003-06-18 Thread Costas Piliotis
Please, help... Our ColdFusion 5 services have been crashing and restarting lately, and I've been thinking of converting to OLEDB drivers instead of ODBC to see if the memory leak is related to the use of ODBC alone. It's not much, but it'll help I'm sure. So naturally, I piced the SQLOLEDB

RE: Switching to OLE DB

2003-06-18 Thread Costas Piliotis
Hmm... So oledb no work... That sux... -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:57 PM To: CF-Talk Subject: Re: Switching to OLE DB [whoops, newsgroup users, i posted to only the newsgroup the first time] When I tried

RE: SQL

2003-06-18 Thread Costas Piliotis
Don't think anyone really understand the question... -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 10:49 AM To: CF-Talk Subject: Re: SQL No takers?... :-) - Original Message - From: Michael T. Tangorre [EMAIL

RE: Switching to OLE DB

2003-06-18 Thread Costas Piliotis
Hmmm... I probably should have checked the archives first :-) -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:53 PM To: CF-Talk Subject: Re: Switching to OLE DB Well, I don't know if it's that clear cut, but I initially switched to

RE: Storing Credit Card Info

2003-06-18 Thread Costas Piliotis
If I'm not mistaken though, you can adhere to those rules by storing the authorization number. Much safer than storing the cc#... And still proof that you got the transaction. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:58 PM

RE: SQL

2003-06-18 Thread Costas Piliotis
Hmm... Correct me if I'm wrong, but are you your reports using a dirty read from the database? By default, sql server locks a record from a select statement. Not good for reporting. If you use appropriate nolock commands in the from clause or SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

RE: Switching to OLE DB

2003-06-18 Thread Costas Piliotis
, Flight 93 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:18 PM To: CF-Talk Subject: RE: Switching to OLE DB Hmmm... I probably should have checked the archives first :-) -Original Message- From: Jamie Jackson [mailto:[EMAIL

RE: Web-based telnet client?

2003-06-17 Thread Costas Piliotis
I think you're looking at the wrong technology imho... You can probably just find an ActiveX control or an Applet that'll do that... Probably don't need to use ColdFusion... Maybe some javascript with the applet or some vbscript with the activex control... A quick search on google gets you

RE: Hyphen in a variable name?

2003-06-13 Thread Costas Piliotis
...or why not just alias that column name in your query? Select [product-code] as productcode From Wouldn't that save some processing time? Keep the load off cf? Best practice to just avoid hyphens and spaces in column names. Use camelCase to denote extra words. -Original

RE: Hyphen in a variable name?

2003-06-13 Thread Costas Piliotis
Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 1:09 PM To: CF-Talk Subject: RE: Hyphen in a variable name? ...or why not just alias that column name in your query? Select [product-code] as productcode From Wouldn't that save some processing time? Keep

RE: CFMX on Cobalt RaQ550

2003-06-12 Thread Costas Piliotis
Nobody has I guess? -Original Message- From: Costas Piliotis Sent: Wednesday, June 11, 2003 11:53 AM To: CF-Talk Subject: CFMX on Cobalt RaQ550 I have a client of mine who has colocated his server, and the colo facility is having trouble installing cfmx onto that box running the Linux

RE: Pagination (Next n records) for an inner join and grouped out put...

2003-06-12 Thread Costas Piliotis
This is really one place SQL Server can learn from MySQL... A LIMIT function would be perfect... Why not just use the maxrows and startrow function in the cfquery tag? For the most part it works quite well actually... -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent:

RE: CF Not creating sessions???

2003-06-12 Thread Costas Piliotis
Have you created an application in IIS? If the site doesn't have an application name, IIS may not be sending the headers to write the cookie to keep the session... -Original Message- From: Staff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:22 PM To: CF-Talk Subject: CF

RE: CF Not creating sessions???

2003-06-12 Thread Costas Piliotis
In particular, check under the Home Directory tab of your site in IIS. Ensure there is an application name there. I think that may be the cause... Just a hunch though really... -Original Message- From: Costas Piliotis Sent: Thursday, June 12, 2003 3:26 PM To: CF-Talk Subject: RE: CF

RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output...

2003-06-12 Thread Costas Piliotis
Actually, in sql server, you can do this on one query using derived tables too... Kinda like doing two queries, but not quite... Same idea though... -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:32 PM To: CF-Talk Subject: RE:

RE: OT~ but a good laugh:)

2003-06-12 Thread Costas Piliotis
That was my favourite thing about interdev 6 ... pnbsp;/p all over the place. Ugliest code ever. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 2:37 PM To: CF-Talk Subject: RE: OT~ but a good laugh:) I have a couple of hosting clients who

CFMX on Cobalt RaQ550

2003-06-11 Thread Costas Piliotis
I have a client of mine who has colocated his server, and the colo facility is having trouble installing cfmx onto that box running the Linux 2.4 Multitasking operating systen as Sun calls it. They've apparantly installed it on other Cobalt servers, but are having major troubles with this one...

RE: Is there an END WHILE for CFLOOP?

2003-06-09 Thread Costas Piliotis
Sort of... cfif ArrayRows = 69 cfexit method=LOOP /cfif -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:42 PM To: CF-Talk Subject: Is there an END WHILE for CFLOOP? I'm looping over an array like so: cfloop from=1

RE: Is there an END WHILE for CFLOOP?

2003-06-09 Thread Costas Piliotis
Eww ick? Doesn't work? -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:52 PM To: CF-Talk Subject: RE: Is there an END WHILE for CFLOOP? Ewww ick... try cfbreak instead... :) Sort of... cfif ArrayRows = 69 cfexit method=LOOP

RE: Is there an END WHILE for CFLOOP?

2003-06-09 Thread Costas Piliotis
Oh... I need to RTFM again :) My bad -Original Message- From: Costas Piliotis Sent: Monday, June 09, 2003 4:39 PM To: CF-Talk Subject: RE: Is there an END WHILE for CFLOOP? Eww ick? Doesn't work? -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] Sent

RE: csv files

2003-06-06 Thread Costas Piliotis
Here. Convert query and filename as you like: cfquery datasource=#application.ds# name=test select branchid, branchname from tblbranches /cfquery cfoutput query=test cfset myvar = cfloop list=#test.columnlist# index=mycol cfset myvar = myvar , evaluate(test.

RE: csv files

2003-06-06 Thread Costas Piliotis
-Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:47 AM To: CF-Talk Subject: RE: csv files Here. Convert query and filename as you like: cfquery datasource=#application.ds# name=test select branchid, branchname from tblbranches

RE: RedHat 7.2 support (WAS Re: CFMX on Redhat 9 with Apache2 2.0 .46)

2003-06-05 Thread Costas Piliotis
So the only thing they are doing is adding Verity support to it then? Everything else seems to work like a charm (After HOURS of playing and researching the file I had to chown on to get it to work...) -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Wednesday, June

RE: Using CFOBJECT in CF50 to query LDAP?

2003-06-05 Thread Costas Piliotis
Why not just use cfldap or cfauthenticate (depending on what you need to do)? -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:44 PM To: CF-Talk Subject: Using CFOBJECT in CF50 to query LDAP? Has, anyone out there ever used CFOBJECT to

RE: Search Friendly URLs in CFMX

2003-06-05 Thread Costas Piliotis
Please correct me if I'm wrong, but aren't all urls now search engine friendly? I mean, I know Google's algorithm for spidering sites is pretty advanced. It doesn't just index every document, but rather follows links throughout your site instead... It doesn't index documents that don't have a

RE: SOT: URL length

2003-06-05 Thread Costas Piliotis
Older browsers only support URLS 255 characters or less. We found IE, up to 5.0 had this limit. IE 5.5 or better supports longer URL's. Not sure about nutscrape and opera though, but I recon the same constraint applies... I don't think it's IIS 5 that ignores the url's... We require on our

RE: JS help

2003-06-04 Thread Costas Piliotis
And btw... Limited nutscrape 4.xx support for that commmand btw... -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 8:30 AM To: CF-Talk Subject: RE: JS help innerText is what you are after. You'll need to locate the relevant anchor object

RE: RedHat 7.2 support (WAS Re: CFMX on Redhat 9 with Apache2 2.0 .46)

2003-06-04 Thread Costas Piliotis
Subject: RedHat 7.2 support (WAS Re: CFMX on Redhat 9 with Apache2 2.0.46) - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 31, 2003 1:42 PM Subject: CFMX on Redhat 9 with Apache2 2.0.46 Apparantly I'm not the only one having

RE: Signal 11 - Corrected

2003-06-03 Thread Costas Piliotis
You know, I had the same issue this weekend. I know I personally never capitalize unix file names, so this was an unwelcome surprise. Oh well. Only had to learn that lesson once I recon... -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003

RE: UNC / Share Path in CFFILE (CFMX)

2003-06-03 Thread Costas Piliotis
Have you tried reversing the slashes? Just a hunch, but if it's using file:// to access the file you should consider using regular slashes instead of backslashes... -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 9:58 AM To: CF-Talk

CFMX on Redhat 9 with Apache2 2.0.46

2003-06-01 Thread Costas Piliotis
Apparantly I'm not the only one having troubles with this. Everything installs fine, and the processes all start succesfully. Per this thread: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10threadid =589661 I went and commented out the following from httpd.conf:

RE: CFMX on Redhat 9 with Apache2 2.0.46

2003-06-01 Thread Costas Piliotis
And after reading this, I should clarify... It stalls unless I comment that line out in httpd.conf Everything SEEMS to work okay now with that line commented. Just wondering what the side-effects are of that... -Original Message- From: Costas Piliotis Sent: Saturday, May 31, 2003 10

RE: CFMX on Redhat 9 with Apache2 2.0.46

2003-06-01 Thread Costas Piliotis
- From: Costas Piliotis Sent: Saturday, May 31, 2003 10:54 AM To: CF-Talk Subject: RE: CFMX on Redhat 9 with Apache2 2.0.46 And after reading this, I should clarify... It stalls unless I comment that line out in httpd.conf Everything SEEMS to work okay now with that line commented. Just wondering

Redhat 9, Apache 2.0.40 Woes

2003-05-31 Thread Costas Piliotis
work :) Nonetheless, it's just for development, so I'm gonna run as standalone for now. Anyone got any suggestions what I can do to get it to run under apache2? Thanks in advance eh... Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F

RE: Redhat 9, Apache 2.0.40 Woes

2003-05-31 Thread Costas Piliotis
: 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 8:07 AM To: CF-Talk Subject: Redhat 9, Apache 2.0.40 Woes Argh... Caught in RPM hell! Anyways... Trying to install cfmx

RE: PHP Equiv of cfoutput group

2003-05-30 Thread Costas Piliotis
AFAIK I don't think there is one really... You'd probably just hafta do it manually: Something like: $checkvar = ; while ($row = mysql_fetch_object($result)) { if ($row-field1 != $checkvar) { //This would be your summary row. $checkvar = $row; }

MySQL Full text or Verity Search

2003-05-27 Thread Costas Piliotis
I have a choice to use one of thse. Which would you guys recommend? I know the MSSQL full text is buggy, so I use verity, but I haven't had any experience with mySQL Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F: 604.320.6568 E-Mail: mailto:[EMAIL

RE: Hiding JavaScript codes

2003-04-04 Thread Costas Piliotis
Okay okay... I know Dave... You're right of course... The browser has to read the file, ergo it can be downloaded and viewed. However that being said, it still somewhat helps, even a little... Any web developer with a modicum of common sense I have a modicum of common sense, I was just trying

RE: Outer Join

2003-04-04 Thread Costas Piliotis
Don't even need csite in that query then. Just write it like this: SELECT cp.payid, cp.name, cp.url, #url.id# as [id] FROM cpay cp LEFT OUTER JOIN cpayment p ON cp.payid = p.payid -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:42

Verity to index sql server.

2003-04-04 Thread Costas Piliotis
adding ?requesttimeout=1 and that works from a browser, and fails on the task... Thanks for any help... Costas Piliotis Application Developer Voyus Canada Inc. T: 604.630.5655 (direct line) F: 604.320.6568 E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] The information

RE: Verity to index sql server.

2003-04-04 Thread Costas Piliotis
, 2003 3:36 PM To: CF-Talk Subject: RE: Verity to index sql server. If you are using Cfschedule, there is a field for requesttimeout - j -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 6:31 PM To: CF-Talk Subject: Verity to index sql

RE: Verity to index sql server.

2003-04-04 Thread Costas Piliotis
is for request time out. Also, you should be able to put the RTO in the url for the url param just as you do in a browser. Hope that helps -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 3:31 PM To: CF-Talk Subject: Verity to index sql server. Hi folks

RE: Session state / cookies within frame???

2003-04-03 Thread Costas Piliotis
pretty neat stuff. -Justin Scott, Vice President Sceiron Interactive, Inc. http://www.sceiron.com [[: Creativity is not Obsolete :]] - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 8:23 PM Subject: Session state

RE: How can I ORDER BY RANDOM ?

2003-04-03 Thread Costas Piliotis
Nice! Great idea!!! Very clever... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:42 PM To: CF-Talk Subject: Re: How can I ORDER BY RANDOM ? I don't think I've seen this mentioned yet. Another way you can randomly order your

RE: Hiding JavaScript codes

2003-04-03 Thread Costas Piliotis
Actually, you kind of can I think... You can use a cfm file as a .js file to emulate a javascript file. Change the extension to .cfm... Careful, cf studio won't correctly parse it, but nonetheless it'll work... Just tested it. cfparam name=cgi.http_referer default= cfif cgi.http_referer eq

RE: Hiding JavaScript codes

2003-04-03 Thread Costas Piliotis
/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 7:40 PM To: CF-Talk

RE: Learned something today (Oracle)

2003-04-02 Thread Costas Piliotis
From what I know about SQL Server's behaviour, it will allow for that syntax until it reaches a character then it'll stop. In our Accpac database, we have invoices stored. Our older invoices have INV01 or whatever for invoice numbers. Now they're imported from the database I built and the

Session state / cookies within frame???

2003-04-02 Thread Costas Piliotis
Just noticed that a client of our wants our site within a frame from their own site. Normally, cf sets cookies on the client with the site information. We already disallow clients who block cookies (Flame on...), but I don't understand why IE disallows cookies from cross site frames. I'm now

RE: Session state / cookies within frame???

2003-04-02 Thread Costas Piliotis
of is that they are actually pulling your content from there server via a cfhttp (or lang equivalent) and pulling your content into a local frame of theirs is it a standard FrameSet with your URL in the src ? -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 April 2003 11

RE: Free SQL Server

2003-03-19 Thread Costas Piliotis
Have any of you ever considered MSDE? It comes on the Office CD's and is free with your MS Office licence. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:12 AM To: CF-Talk Subject: RE: Free SQL Server I don't like to see it either,

RE: Free SQL Server

2003-03-19 Thread Costas Piliotis
). This was the surrounding theme of the discussion and also how to get Enterprise Manager. I guess we're right back where we started. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 2:13 PM To: CF-Talk Subject: RE: Free SQL Server Have any

RE: My First CF Site (Critique Request)

2003-03-11 Thread Costas Piliotis
Also, the select box for navigating... Consider switching it to some DHTML navigation or something... There's a tonne of info in there that you could really explore. I agree... The menu at the top would work much better... Usually good is a small menu at the base with the same links repeated

RE: win 2000 professional for web server?

2003-03-04 Thread Costas Piliotis
Actually, win2k pro will give you glitches. IIS won't allow more than ten connections, and a web based connection DOES count. Consider trying Apache on win2k pro instead. That's a MUCH better work around. I've seen win2k pro deny connections on a web server before for too many concurrent

RE: OT: (cross post) SQL row numbering

2003-02-03 Thread Costas Piliotis
Sort of... SELECT IDENTITY(int,1,1) as ID_Num, [name], Age INTO #tempTbl FROM myTable SELECT * FROM #tempTbl That's the only way afaik... #tempTbl will be built automatically. No need to declare it or create it. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]

RE: OT: MM Suprises Wall Street - Can more be done?

2003-01-24 Thread Costas Piliotis
While I appreciate the fact that ASP.Net is a pretty decent platform, I have to disagree with certain ideas. First, ASP.Net has been slow to adopt. ASP developers are forced to re-learn everything. There are a lot of things that only took a few minutes in Asp that are downright tricky in .net.

RE: updating large verity collection

2003-01-21 Thread Costas Piliotis
A good start would be to view the estimated execution plan in query analyzer... It'll show which index you're using on that query... Chances are it's not the right query. Make sure it isn't doing a table scan... That's usually what slows it down... -Original Message- From: Jared

RE: SOT Javascript Navigation

2003-01-15 Thread Costas Piliotis
So for browser detection, it's pretty easy. Just use the variable http_user_info. Here's a list of all the possible values (not including spiders): http://www.zytrax.com/tech/web/browser_ids.htm Thing is, you can use CONTAINS and DOES NOT CONTAIN to pretty much determine OS and Browser. Write

RE: XML-type Syntax with CF Tags

2003-01-14 Thread Costas Piliotis
You could of course steer away from using cf_myCT and instead just use the cfmodule file=myCF tag... Not as eloquent, but if that's the only real rule breakdown, then you can disregard that feature... -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: unknown exception condition within cfstoredproc - win2k iis5 cf5 mssql2000

2003-01-14 Thread Costas Piliotis
Looks fine to me... I'd try double-checking the data types and paraeters as well... -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:23 PM To: CF-Talk Subject: unknown exception condition within cfstoredproc - win2k iis5 cf5

RE: web beacons

2003-01-13 Thread Costas Piliotis
Easy. cfcontent file=foo.gif type=application/whatever cfquery datasource=#application.ds# ...tracking query here... /cfquery You include the image, and some server-side code to process it. Done it a few times... -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]

RE: ASP to ColdFusion

2003-01-13 Thread Costas Piliotis
Woo hoo... Another convert :-) A quick search on google gets some good introductury tutorials... http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tutoria l2.html http://www.macromedia.com/support/coldfusion/tutorial_index.html http://kongtechnology.com/index.asp?im=cf1

RE: web beacons

2003-01-13 Thread Costas Piliotis
, something like this appears: cfcontent file=foo.gif type=application/whatever cfquery datasource=#application.ds# insert into someTable (employeeid, date) values (#val(url.id)#, getdate()) /cfquery -Original Message- From: Costas Piliotis Sent: Monday, January 13, 2003 10:00

RE: Query help!

2003-01-13 Thread Costas Piliotis
CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#createODBCDateTime(now())# type=cf_sql_timestamp /CFQUERY -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:21 AM To: CF-Talk

RE: web beacons

2003-01-13 Thread Costas Piliotis
- | From: Costas Piliotis [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 10:04 AM | To: CF-Talk | Subject: RE: web beacons | | | Oh yeah, and you can pass url parameters to that image as well... | So let's say you send an email to employeeid 145. | | You can add

RE: Top 10 Web App Security Flaws

2003-01-13 Thread Costas Piliotis
Very interesting... Don't know if I agree with the order of them, but still a pretty damn good read actually... -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:13 AM To: CF-Talk Subject: Top 10 Web App Security Flaws Interesting list

RE: web beacons

2003-01-13 Thread Costas Piliotis
I think that has to do with search engine friendly sites, not web beacons... -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:47 AM To: CF-Talk Subject: RE: web beacons Ben Forta wrote it. A Cure for Arachnophobia :

RE: web beacons (stop caching)

2003-01-13 Thread Costas Piliotis
Shouldn't really cache though if UserID is different for each time the beacon is called should it? -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:29 PM To: CF-Talk Subject: RE: web beacons (stop caching) Make it unique. For

RE: UNSUBSCRIBE

2003-01-09 Thread Costas Piliotis
Link seems to work fine for me... Maybe the internet is broken... -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 7:08 AM To: CF-Talk Subject: RE: UNSUBSCRIBE Nuts. The auto unsubscribe link at the bottom of the email isn't working.

RE: MS CF?

2002-12-23 Thread Costas Piliotis
Can we hold you you to that? Pretty bold statement IMHO... -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 2:12 AM To: CF-Talk Subject: RE: MS CF? : http://theregister.co.uk/content/4/28667.html I'll have to kill myself if this

RE: Issue: Change row color on mouse over in Netscape 4.7

2002-12-18 Thread Costas Piliotis
I actually think it's getting to be a good time to force them to upgrade. There was a time where websites started coming along that had a minimum Nutscrape 4/IE 4 requirement. Why not take a moment and raise the bar to IE 5 / Nutscrape 6 /Opera 6 / Mozilla 1.0... Makes sense to me...

RE: refresh iframe

2002-12-18 Thread Costas Piliotis
Just reload like you would a normal window... Make sure you use the id attribute of the tag, not the name attribute of it. iframeid.location.href.reload(); Yes, it's src, not href... Although an iframe is also a window, and a window has the href attribute, so I think you can use either...

RE: mySQL equivalent of MS Access Money fieldtype?

2002-12-17 Thread Costas Piliotis
If I'm not mistaken, there's a float or decimal data type in mysql... Trying to remember off the top of my head. Use that data type. Also, try this: #val(Form.UCPaymentAmount)# It will remove all unnecessary formatting and convert the form value to a number each time. Should work fine for what

RE: Issue: Change row color on mouse over in Netscape 4.7

2002-12-17 Thread Costas Piliotis
I'm not sure, but does nutscrape 4.7 even support dhtml? I'm not sure it supports the onmouseover/onmouseout events... Why bother? Nutscrape 4.xx users are fast on the decline, so if you make it look okay for them and great for everyone else, don't worry about it... There's a tonne of sites

  1   2   3   4   >