RE: Re: Mail Merge Options

2002-04-30 Thread Costas Piliotis
Why not use crystal reports? You can export to word if needed... Works really well... Just don't call them through the cfreport tag. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 6:38 AM To: CF-Talk Subject: Re: Re: Mail Merge Options

RE: SQL Question

2002-04-29 Thread Costas Piliotis
Uhm... That's okay if it's microsoft Access... Generally NOW() is not an sql server function. Also, if your report spans more than 12 months, you want to use mm as the format. You get the order correct that way. There's probably a million ways to get that, but this works: SELECT

RE: Get list of tables from a SQL Server DB

2002-04-26 Thread Costas Piliotis
Uh... Isn't it: select [name] from sysobjects where xtype = 'U' -Original Message- From: Tim Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 9:58 PM To: CF-Talk Subject: RE: Get list of tables from a SQL Server DB CFQUERY name=getTables datasource=#dsdata# Select

RE: Get list of tables from a SQL Server DB

2002-04-26 Thread Costas Piliotis
, 2002 10:10 AM To: CF-Talk Subject: RE: Get list of tables from a SQL Server DB is it xtype?.I thiught it was just type but that's off the top of my head -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: 26 April 2002 18:07 To: CF-Talk Subject: RE: Get list

RE: OT: SQL Booger of a query

2002-04-24 Thread Costas Piliotis
Seems to mee like you're building a tree... You may want to consider looking at the nested tree model... I warn you though, it's not for the faint of heart... http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci801943,00.html -Original Message- From: Jochem van Dieten

RE: CF's Most Wanted ::

2002-04-23 Thread Costas Piliotis
Yeah, but and are kind of no-nos when you are using such a tag oriented language. I gather that's why they don't use that. I'd love the ECMA syntax too, but I understand why they don't use and . It makes their parsing engine work better... Guarantess that is the start of a tag and is the

RE: Access /SQL Server

2002-04-22 Thread Costas Piliotis
Also, watch the locking. Make sure if there's select statements that you use the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED to ensure a dirty read. You may be accidentally locking yourself out. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, April

RE: Dates ....NOW() to define a range

2002-04-22 Thread Costas Piliotis
Easy... Use a conditional CFLOOP: cfset currDate=dateadd('d', -14, now()) cfset endDate =dateadd('d', 14, now()) cfloop condition = #currDate# LESS THAN #enddate# cfoutput#currDate#/cfoutput cfset currDate = dateadd('d', 1, currDate) /cfloop -Original Message- From:

RE: Getdate() Date only no time.

2002-04-11 Thread Costas Piliotis
What you want to do is trim off the time... Try this: Cast(floor(cast(getdate() as float)) as smalldatetime) That'll trim the time off... -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 4:42 PM To: CF-Talk Subject: Getdate() Date only no

RE: SQL Help Needed!

2002-04-08 Thread Costas Piliotis
This will work in sql server. Don't think access supports compound outer joins... I could be mistaken though... Select * from Docmaster left outer join versions on docmaster.docnum = versions.docnumber and docmaster.version = versions.version Where verersions.docnumber is null

RE: IIS Log Tool

2002-04-08 Thread Costas Piliotis
You can always use the odbc connector built into iis for logging... And then just use some standard queries... -Original Message- From: Brunt, Michael [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 5:37 PM To: CF-Talk Subject: IIS Log Tool Anyone using a good tool for

RE: IIS Log Tool

2002-04-08 Thread Costas Piliotis
True... Adds an insert...into statement for each query... But then again, opening up a text file, adding a line, and closing it also has its toll, just less toll too... Can't remember if IIS keeps that file open... Alas... There's no mention either way in MSDN magazine... Nor on the IIS6

RE: Group By

2002-04-08 Thread Costas Piliotis
Correction. If sql server, looks like this: SELECT * FROM Something GROUP BY cast(floor(cast(thedate as float)) as smalldatetime) ORDER BY cast(floor(cast(thedate as float)) as smalldatetime) Dates convert to float. The integer is the date. The decimal is the time. Floor the value to get rid

RE: CF Will Not Start

2002-04-06 Thread Costas Piliotis
This may sound dumb, but ever thought of reinstalling cf server? If the thing won't start anyways, it may just be worth a shot... It may reinitialize that funky custom tag of yours... Clean up all the funky stuff left behind... Just save your settings of course... -Original Message-

RE: any jobs in orlando

2002-04-05 Thread Costas Piliotis
That's the crappiest mailing list I've seen. In a month that I've subscribed, I've seen a tonne of people looking for work, and the odd job posting here or there. Not too many leads to follow up on in there... -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent:

Strange QueryString

2002-03-27 Thread Costas Piliotis
Anyone ever seen this before: Template: G:\Inetpub\wwwroot\worp\AddNote.cfm Query String: name=notes¬etypeid=¬eclassid=doctypeid=4doctypevalue=9385refresh=0.857234 4947703243 This is directly from the error code. I can't even type a ¬! I've never seen anything like this. And we cannot

RE: join tables from 2 different databases

2002-03-27 Thread Costas Piliotis
Assuming you use sql server: Make sure the database is linked to the sql server your querying. Then: SELECT * FROM dbo.Table1 INNER JOIN [DatabaseServer2].[Database2].dbo.Table2 Table2 on table1.id = table2.id Just make sure you alias the table name, otherwise you'll end up

RE: PHPConfig

2002-03-01 Thread Costas Piliotis
Yeah... I think it's called notepad :-) -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 7:50 AM To: CF-Talk Subject: RE: PHPConfig There wouldn't happen to be one of those to edit apache? That's the only thing that stops me from using

RE: Bug Tracking Systems

2002-03-01 Thread Costas Piliotis
Very easy... The easiest thing to do is parse the logs, but that's a pain. In cf server, you can set a global error handling template. Here's the code because it's Friday and I feel like giving back: YAY! Free Code! link rel=stylesheet type=text/css href=/styles/worp.css cfparam

RE: Attaching CSS style sheet

2002-03-01 Thread Costas Piliotis
I think you also need a cfcontent type=text/css tag in ther, but I'm not sure... -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:52 PM To: CF-Talk Subject: RE: Attaching CSS style sheet If you are trying to dynamically assign a style

RE: Inserting a delimited list into a database

2002-02-27 Thread Costas Piliotis
Here's the function to parse a comma-delimited string: CREATE FUNCTION dbo.fnc_ParseDelimited ( @delimitedList VarChar(8000) ) RETURNS @tblSample TABLE (CounterID Int, FieldValue Varchar(100)) BEGIN Declare@CounterID VarChar(4) Declare

RE: Inserting a delimited list into a database

2002-02-27 Thread Costas Piliotis
Oh yeah... In sql server... Just pass the comma-delimited list to sql server and use this to parse it. Way less calls to the database... -Original Message- From: Costas Piliotis Sent: Wednesday, February 27, 2002 1:49 PM To: '[EMAIL PROTECTED]' Subject: RE: Inserting a delimited list

Database Client Variables

2002-02-26 Thread Costas Piliotis
Hi folks. I'm been looking at the idea of using client variables stored in the database so that I can transfer some variables between cold fusion and ASP.NET. Anyways, is there any way I can force the client variables to update in the database?

RE: dynamic input text/background color

2002-02-25 Thread Costas Piliotis
For nutscrape, use .styles instead... -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 4:50 PM To: CF-Talk Subject: RE: dynamic input text/background color Works great Steve... thanks! FYI: Netscape 4.7 chokes with a javascript

RE: cfqueryparam - order of where/and

2002-02-14 Thread Costas Piliotis
Yes the order of the clauses in the where statement matter. First, you want to use indexed fields. That way, you make full use of database optimizations. The execution plan *should* figure it out, but it's still good practice to use indexed fields first regardless. Dunno about the second

RE: CFLDAP Help

2002-02-08 Thread Costas Piliotis
Generally, you can't just request the username and password. That's kind of a security hole if you could. All you can do is attempt to authenticate. Set up that LDAP directory in the advanced security in CF Administrator and use this code: cftry cfauthenticate securitycontext=myDirectory

RE: distinct query

2002-02-06 Thread Costas Piliotis
Try these. They should work: SELECT ltrim(rtrim(Email)) AS Email, MIN(My_id) AS My_Id, MIN(MyDisplay) As MyDisplay, MIN(MyPassword) as MyPassword FROM EmailAccts GROUP BY ltrim(rtrim(Email)) If My_Id is the primary key for the EmailAccts Table: SELECT ltrim(rtrim(Email)) As Email,

OT: crystal reports vs... ?

2002-02-04 Thread Costas Piliotis
Good luck... I've built a report generator for us, and it's been a work in progress for the last year :) As far as I know, crystal 8.5 has its own scripting language now that *gasp* looks just like ASP. Working with 8 however, I've come up with a way of using stored procedures for my dynamic

Microsoft and Macromedia

2002-02-04 Thread Costas Piliotis
http://forum.fuckedcompany.com/phpcomments/index.php?newsid=82133page=1par entid=0crapfilter=1 Anyone know if there's any truth to this? (Pardon the language in the link - What else could I do?) __ Get Your Own Dedicated

RE: Microsoft and Macromedia

2002-02-04 Thread Costas Piliotis
To: CF-Talk Subject: RE: Microsoft and Macromedia Run Costas, Run!!! -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:56 PM To: CF-Talk Subject: Microsoft and Macromedia http://forum.fuckedcompany.com/phpcomments/index.php?newsid

RE: Microsoft and Macromedia

2002-02-04 Thread Costas Piliotis
so negative all the time. e. This is off topic, take it to cf-community. That's pretty much it, but I'm sure you'll get the same exact replies this week, so I'm sorry to fill up your inbox with redundancy. Just letting you know what to expect. Adam. -Original Message- From: Costas

RE: Include a Dynamic Page

2002-01-07 Thread Costas Piliotis
I'd also look into web services and seeing that if the site you're interested in already provides web services... CF6 is going to support them, but you can also get the jump and use MSSOAP toolkit and parse out the web services... Less programming than cfhttp, but also many more problems result

RE: Survey

2001-12-20 Thread Costas Piliotis
Really? I'm using IIS 5.1 on Windows XP :-) -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 1:08 PM To: CF-Talk Subject: RE: Survey Windows XP running IIS 5 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]]

RE: VNC vs PC Anywhere

2001-12-19 Thread Costas Piliotis
Actually, there's an activeX control for that as well... -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 9:24 AM To: CF-Talk Subject: Re: VNC vs PC Anywhere On Windows 2000, terminal services is the way to go unless you need access

RE: Exporting data to Excel

2001-12-19 Thread Costas Piliotis
In CFDJ this month, there was a really good article about using Internet Queries in Excel... You could consider doing an import instead... Or, if you're using SQL Server, consider creating a DTS package that will do the export for you. I've got a package that runs through DTS that works pretty

RE: PLEASE HELP - CFGrid does not show up in CF50 even after the HotFix is applied

2001-12-19 Thread Costas Piliotis
Make sure you're running Sun's version of JRE. Microsoft's doesn't work, and you need to be running the latest and greatest. Had the same problem. Went away when I upgraded. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:55 PM

RE: HTML EMAIL

2001-12-19 Thread Costas Piliotis
Try just using cfmail type=html... Html Goes her /cfmail As long as iSMail is an SMTP server, you should be fine... -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 4:28 PM To: CF-Talk Subject: HTML EMAIL Forgive the redundancy - I

RE: can an email link also include a subject

2001-12-19 Thread Costas Piliotis
Watch the length of the string though. In everything but IE 5.5 or better, you'll truncate after 255 chars... -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 4:00 PM To: CF-Talk Subject: RE: can an email link also include a

RE: OT(apologies)

2001-12-13 Thread Costas Piliotis
Dude. Don't post that in here. I don't really think that's appropriate... (Not that I care, but someone else just might...) -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 9:51 AM To: CF-Talk Subject: RE: OT(apologies) www.whitehouse.com

RE: a href target= question

2001-12-07 Thread Costas Piliotis
Here's a script you can use as well that works with Internet Explorer that opens a modal Pop-Up window: function openWindowm( pageToLoad, winName, width, height, center) { args = dialogWidth: + width + px; + dialogHeight: + height + px; + status:0; + help:0; +

RE: Slightly OT - Forcing Style Sheets

2001-12-07 Thread Costas Piliotis
You can also use a cold fusion file as a stylesheet as well. Doesn't look too great in the editor , but it works fantastic... in the stylesheet, just add cfcontent type=text/css in your stylesheet and you can use any cold fusion statement in there. Then, in the head section, just add: LINK

RE: Correct Usage of Stored Procedures

2001-12-07 Thread Costas Piliotis
Replace all if possible... Patches all security holes that way... If you have any queries that rely on parameters, you potentially run the risk of having someone alter your data. Also, the execution plan is saved, thus saving you time in parsing the query. Performance gain, security... Is

RE: Hi

2001-12-07 Thread Costas Piliotis
Right. How many developers does microsoft have that it can allocate to breaking into its software. How many hackers are there worldwide? I'll bet I'm not the first to admit that I've left features in my code as well. Sometimes, clients have a way of finding them that I never thought of.

RE: alternatives to MS SQL

2001-12-06 Thread Costas Piliotis
If they have a single licence for Office 2000 or XP, this gives them the ability to use MSDE, which upsizes perfectly to SQL Server when the budget allows for it. Costs nothing, and you still use an NT based database... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: custom tag that creates XML?

2001-12-06 Thread Costas Piliotis
Usually, when sending data from a form to a web service, you should consider using microsoft's soapclient. You're trying to create a soap envenlope, and that's actually a dtd within the xml specification. Here's some code to get you started: cftry cfobject action=CREATE type=COM

RE: Hi

2001-12-05 Thread Costas Piliotis
Dude. You're slagging Microsoft and you're site's hosted on an NT 4 Box? I love ppl who slag Microsoft. Chances are they have a site on MS, or they run Outlook, or IE... Guess you don't really care about your site getting hacked then... Everything is riddled with security holes. Locks are

RE: cfexecute

2001-12-04 Thread Costas Piliotis
net use -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 4:21 PM To: CF-Talk Subject: cfexecute I asked earlier but no one really helped. Does anyone know if you can map a drive via cf execute. Joshua Tipton

SOAP Methods

2001-11-29 Thread Costas Piliotis
Hi ppl. If anyone has worked with SOAP, I'm in desperate need of some help. I have some VB Code as follows: Dim SOAPClient As SOAPClient Set SOAPClient = New SOAPClient SOAPClient.mssoapinit (http://services.xmethods.net/soap/urn:xmethods-CurrencyExchange.wsdl;) MsgBox

RE: SOAP Methods

2001-11-29 Thread Costas Piliotis
. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 12:09 PM To: CF-Talk Subject: SOAP Methods Hi ppl. If anyone has worked with SOAP, I'm

RE: SOAP Methods

2001-11-29 Thread Costas Piliotis
find a lot of CF COM guru's is http://www.cfcomet.com you might want to post your question there. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Costas Piliotis

RE: CF and SQL money data type

2001-11-27 Thread Costas Piliotis
Only if you need more than four decimal places... May be a portability issue too... Check, but I don't think all databases have that data type. Generally though, I haven't found any issues... -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

RE: SELECT MAX(ID), Access SQL Server - confused!

2001-11-26 Thread Costas Piliotis
If you want to know the ID of the last insterted record, there is a variable called @@Identity. Be careful that there aren't any triggers firing on that table onto another with an identity field. No need to get more complicated than that. Using a stored procedure to do your inserts and an out

RE: SELECT MAX(ID), Access SQL Server - confused!

2001-11-26 Thread Costas Piliotis
I guess if I read the WHOLE thread :-) -Original Message- From: Costas Piliotis Sent: Monday, November 26, 2001 4:04 PM To: CF-Talk Subject: RE: SELECT MAX(ID), Access SQL Server - confused! If you want to know the ID of the last insterted record, there is a variable called

RE: Fusebox - opinions?

2001-11-20 Thread Costas Piliotis
That number was the one provided by www.fusebox.org, which I cited in my email. They make the damn product, which IMHO, that makes them more an authority than anyone else. Now lets compare that to http://php.weblogs.com/popularity Statistics. 900,000+ pages found with url.cfm . 6000

RE: cfsqltype=cf_sql_timestamp

2001-11-20 Thread Costas Piliotis
Try Using: #createodbcdate(attributes.contentTimeStamp)# CF function You may want to consider switching to datetime or smalldatetime... Check the MDAC documentation on what that supports. Everything supported in MDAC *should* be supported in cf... -Original Message- From: Steve Vosloo

RE: Question about CFGRID??

2001-11-20 Thread Costas Piliotis
You need jre 1.3 or better from sun. The Microsoft implementation may not work. As well, watch that applets aren't block at the browser level or alternatively at the firewall level. I know sysadmins block activeX controls from the firewall, so applets could also be blocked. -Original

RE: Fusebox - opinions?

2001-11-19 Thread Costas Piliotis
... -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 2:56 PM To: CF-Talk Subject: RE: Fusebox - opinions? Costas Piliotis, IMO, The Fusebox 3.0 methodology Rocks! http://fusebox.org Have you taken the time to read the spec or create any

RE: SQL To Sum data

2001-11-19 Thread Costas Piliotis
Dunno oracle well, but here's a couple of ideas: First, are there nulls in the field you're taking the sum of? This may case erratic results. Try SUM(ISNULL(tbldetailentry.reghrs),0) instead. Also, be careful with date comparisons. They don't trim off the time portion in sql server. Perhaps

RE: SQL To Sum data

2001-11-19 Thread Costas Piliotis
Oh yeah, one more thing... I think Oracle is now Ansi-92 compliant. Try putting your join in the FROM Clause instead: SELECT SUM(tbldetailentry.reghrs) AS Daystotals FROM tblMainEntry INNER JOIN TblDetailEntry ON tbldetailentry.MainID = tblMainEntry.MainID WHERE tblDetailEntry.recorddate

RE: Fusebox - opinions?

2001-11-19 Thread Costas Piliotis
Here's a quote from fusebox.org: Fusebox is a FREE web application standard in use by 6174 people from around the world 6174. Around the world. Hmmm... I know there's 100 or so active cfug members in Vancouver, BC. Given the amount of metropolitan areas in US and Canada, not to mention

RE: Fusebox - opinions?

2001-11-18 Thread Costas Piliotis
Since everyone has put their two pennies in... Fusebox is a nice idea. IMHO though, Cold Fusion was never intended for structured programming in the modern, object oriented terms. New will have cf classes and stuff, so fusebox may or may not be the way to go. Here's the best thing about cold

RE: CF Tree in windows XP - Cold Fusion 5

2001-11-16 Thread Costas Piliotis
Try upgrading to Sun Java Runtime Environment 1.3.1 or better. From what I understand, the applets were made to work under that flavor. Anything lower, be it Microsoft Java implementation or Sun and CF5 applets work properly... -Original Message- From: Irwan Kurniawan [mailto:[EMAIL

RE: CF code and Netscape Browser...

2001-11-15 Thread Costas Piliotis
Just a though... Have you tried closing the meta tag? Maybe that causes Netcrap to get stupid on you... -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 11:48 AM To: CF-Talk Subject: RE: CF code and Netscape

RE: convert from money to number

2001-11-15 Thread Costas Piliotis
Generally though, you want to cast(moneyfield as float) not int. int will strip off the cents... -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:20 PM To: CF-Talk Subject: Re: convert from money to number On Thursday, November 15,

RE: SQL Server And Datasource Authentication

2001-11-09 Thread Costas Piliotis
question regarded whether or not the username/password, not the data, were encrypted? Jim - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 08, 2001 11:27 AM Subject: RE: SQL Server And Datasource Authentication Go

RE: Tracking Computer Name ( Is It Possible?)

2001-11-09 Thread Costas Piliotis
All possible. None fool-proof... -Original Message- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 9:40 AM To: CF-Talk Subject: Re: Tracking Computer Name ( Is It Possible?) You could used forced OS authentication and capture auth_user. You could

RE: Upgrading to XP?

2001-11-01 Thread Costas Piliotis
Wow. Someone who actually purchases Microsoft Windows =) Too funny... -Original Message- From: Michael Bruce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 11:24 AM To: CF-Talk Subject: Upgrading to XP? Just thought I would share something with everyone.. I just

RE: SOAP - was BOOKS for XML

2001-11-01 Thread Costas Piliotis
In a nutshell, it's a way of envoking methods of remote objects. It's actually more like RPC's than DCOM... Here's what a SOAP reqeust looks like for a remote method HelloWorld(using ASP.NET Web Services) You can also Contact through HTTP GET and HTTP POST methods, however, using SOAP you

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Costas Piliotis
It's called msde. It comes with Office 2000/XP. Not Really a desktop edition but rather a scaled down implementation of SQL Server. As far as I know, if you have an Office 2000/XP licence, you have a MSDE licence as well. -Original Message- From: Mike Craig [mailto:[EMAIL PROTECTED]]

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Costas Piliotis
Ahhh... Ooops... I stand corrected. There's a first for everything =) Here's Microsoft's link to a comparison: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ ar_sa2_9gz4.asp -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Costas Piliotis
And for the most part, it looks like MSDE and Personal Edition are the same except the Desktop Edition comes with the Tools (EM, QA, Profiler). Desktop Engine is just the database. So I don't stand corrected :-) -Original Message- From: Costas Piliotis Sent: Tuesday, October 30

RE: ASP access to CF client vars

2001-10-25 Thread Costas Piliotis
You can also save the client variables in the database. Parsing them out is kind of a pain, but it's not too bad to pull them out. Updating them. Well that's a WHOLE other can of worms... -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23,

RE: CF and Excel

2001-10-24 Thread Costas Piliotis
www.cfcomet.com has some really good examples of using Excel as a datasource. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 21, 2001 1:19 PM To: CF-Talk Subject: Re: CF and Excel fairly low tech approach but I have set up an access database that

RE: CFPROCPARAM Not Working With MSSQL

2001-10-24 Thread Costas Piliotis
This is one of the most stupidest issues with mdac... You actually need to use cfsqltype=cf_sql_timestamp for SQL Servers. -Original Message- From: Dave Babbitt [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 8:21 AM To: CF-Talk Subject: CFPROCPARAM Not Working With MSSQL

RE: SQL Server Enterprise Manager alternatives?

2001-10-23 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: window format

2001-10-21 Thread Costas Piliotis
Why not open the window first, and use form name=whatever target=newWindowYhatYouWillOpen -Original Message- From: Leon Greeff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 4:00 AM To: CF-Talk Subject: window format Hi there, Does anyone of you have a script that will

RE: cfgrid

2001-10-21 Thread Costas Piliotis
There's been a couple of threads regarding this. A macromedia tech claimed that you should move to Flash instead of Java. Go figure. Try installing JRE 1.3 http://java.sun.com/products/plugin/ Me thinks that macromedia wrote the new cfgrid control to conform with Sun's Java and forgot to

RE: Check out what Gartner is recommending. Drop IIS!

2001-09-26 Thread Costas Piliotis
, they blame the OS. Its like raising a child. If you're not prepared to do it the right way, then abstain, wear protecion or stay celebate! hehe. Thanks for the opinions, bud. Rey... Benjamin - Original Message - From: Costas Piliotis [EMAIL PROTECTED

RE: Upgrading from v4.5 pro to v5.0 pro

2001-09-25 Thread Costas Piliotis
I've had issues with cfgrid loading... Don't quite know why. I've even applied the hot fix,and still the applet won't load... -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 9:53 AM To: CF-Talk Subject: RE: Upgrading from v4.5 pro to

RE: AND OR placement in SQL

2001-09-25 Thread Costas Piliotis
When using funky and and or clauses in the where clause, it's a really good idea to use parenthesis to control the flow. It won't muck up the query, but you may not necessarily get the results you want... -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: Protecting, a, images/pics, directory?

2001-09-25 Thread Costas Piliotis
Instead of using gif or jpeg files, have you considered using the cfcontent tag and using cfm files to verify the seucrity? You can use img src=somefile.cfm instead... Works like a charm. -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25,

RE: Check out what Gartner is recommending. Drop IIS!

2001-09-25 Thread Costas Piliotis
You know it's funny though. A quick search at www.securiteam.com shows that Apache and iPlanet have many vulnerabilities as well. Think perhaps that the research is simply political? Hackers seem to actually target IIS boxes likely for their hatred of Micro$oft. I think there's more to this

RE: Check list for securing IIS (WAS RE: Check out what Gartner i s recommending. Drop IIS!)

2001-09-25 Thread Costas Piliotis
Use the IIS Lockdown tool. http://www.microsoft.com/WINDOWS2000/downloads/recommended/iislockdown/defau lt.asp Apparantly good for users interested in locking down iis and not sure where to start. What you really should look at is MIME types. Most of what this tool does revolves around this.

RE: Pass content to/from ASP page

2001-09-20 Thread Costas Piliotis
I'd actually recommend using the following code in application.cfm to convert your session variables to client variables, and in cf adminstrator, save the client variables in the databse instead of the registry. cfloop collection=#session# item=myVar cfset CLIENT.SESSION.#myVar#

RE: Terrorism

2001-09-11 Thread Costas Piliotis
Right. Like people don't get mugged. Stores don't get robbed. Wow. The NRA has really brainwashed you. -Original Message- From: Freedom [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 2:34 PM To: CF-Talk Subject: Re: Terrorism While I have my own opinions on weapons,

RE: Strange problem with CFGrid

2001-09-10 Thread Costas Piliotis
I know when I turned on NT Challenge/response security in the /cfide/administrator part of my site that cfgrid did not work. Do you think perhaps that security was turned on on that directory and not all users have access? By the way, there is no IE 4.72. I recon you mean Netscape?

RE: Stored Procedure

2001-08-30 Thread Costas Piliotis
See though, it's not that simple for this problem. They're trying to parse a comma delimited list... They should use dynamic sql to do what they're trying to accomplish. -Original Message- From: Matthew W Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 2:37 PM To:

RE: CF and Windows 2000

2001-08-28 Thread Costas Piliotis
Actually, be sure to run 4.5.1 4.5 as far as I know cf server needs to be updated to 4.5.1 to run properly... -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 8:02 PM To: CF-Talk Subject: Re: CF and Windows 2000 On Mon, 27 Aug 2001

RE: Which FTP server for Win 2k

2001-08-28 Thread Costas Piliotis
War FTP Daemon is free, but it's a pain to set up. Serv-U is a great product, but it's not free. G6 (Now Bulletproof) is also quite the popular server. -Original Message- From: P Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 12:46 PM To: CF-Talk Subject: OT:

RE: Netscape Cookie Woes

2001-08-27 Thread Costas Piliotis
As far as I understandm session state is maintained through a cookie. CFID and CFTOKEN are stored as cookie values. The session state is destroyed when you destroy the cookies file. A new session is thus started and all of your session variables are lost. -Original Message- From:

RE: Zachary Bedell

2001-08-09 Thread Costas Piliotis
He man. Sending an email that 21 times is a bit unnecessary. You're no better than Bruce... -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 7:22 AM To: CF-Talk Subject: RE: Zachary Bedell Hey Bruce I got your message 3 times.

RE: Ben Forta and CF5 -- Coming to a CFUG Near You

2001-08-09 Thread Costas Piliotis
, was in Portland not that long ago. But Alaska, now THAT sounds like a trip I need to do. :-) --- Ben -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 7:13 PM To: CF-Talk Subject: RE: Ben Forta and CF5 -- Coming to a CFUG Near You I wouldn't

RE: Crystal Reports

2001-08-09 Thread Costas Piliotis
Depends what you're trying to do. A lot of what you would like to accomplish can be done through client side scripting - the server side is tough in cold fusion - you'll find yourself re-writing tonnes of asp code to coldfusion. If you have cf on an iis box, and have no need for tonnes of

RE: legal question?????

2001-08-09 Thread Costas Piliotis
Call a lawyer for legal advice, however, there's two schools of thought on this: Will this affect your professional standing in the community? Will you loose designations or certifications over this? Do you have the request in writing? Can you blame someone else? If you DO have the reqest in

RE: Ben Forta and CF5 -- Coming to a CFUG Near You

2001-08-08 Thread Costas Piliotis
I wouldn't mind an Alaska tour =) Jk... Seriously though, it would be nice to see Vancouver/Seattle/Portland... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2007 12:09 PM To: CF-Talk Subject: RE: Ben Forta and CF5 -- Coming to a

RE: web base reporting tools

2001-08-07 Thread Costas Piliotis
RR Report Writer. Used an older version of it with Btrieve that was okay. http://www.livewarepub.com/ They have an activeX contril. -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 9:53 AM To: CF-Talk Subject: RE: web base reporting tools

RE: oracle and coldfusion

2001-08-07 Thread Costas Piliotis
Yup. Why don't you look at cftransaction? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 10:14 AM To: CF-Talk Subject: oracle and coldfusion Here's the situation. I have this rather large and complex package of procedures, and I

RE: Cold Fusion Developer - beginner

2001-08-07 Thread Costas Piliotis
In his defence though, we all kind of work in a male dominated profession, and we appreciate some variety in though. Perhaps he should have made use of some euphemisms, but he's right. I'm kind of sick of working in an all male department myself, and would love nothing more than to have a

RE: POSTgreSQL

2001-08-03 Thread Costas Piliotis
Correct me if I'm wrong, but I don't think there's a Windows port of PostgreSQL. It's only available on Solaris and Linux and other Unix flavours... -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 8:36 AM To: CF-Talk Subject: RE:

RE: Address COM Object

2001-08-03 Thread Costas Piliotis
Check to see if the objects already been created. You may have to use action=CONNECT if the object's been created already: cftry cfobject type=COM action=CONNECT class=... cfcatch type=any cfobject type=COM action=CREATE class=...

<    1   2   3   4   >