Re: asynch cfml gateway - working example

2005-06-07 Thread Sean Corfield
On 6/6/05, Douglas Knudsen [EMAIL PROTECTED] wrote: um, that's what I thought. Was chatting with coworkers today about this too. Their concern was thread use. Threads used in the async gateway are part of the pool in the JRun instance, no? So, if you have a box getting good load, introducing a

Re: Get New Record ID in ORACLE

2005-06-07 Thread Jochem van Dieten
James Holmes wrote: For one they get around the problem of getting the last id inserted into the table as per some of the discussion in the MySQL thread yesterday, without needing to use serializable transactions. But for that you can also use the INSERT .. RETURNING .. directly. Jochem

indexing verity... quagmire!

2005-06-07 Thread Protoculture
we have moved servers and now it seems we have lost an important verity index. I am trying to rebuild it manually, but I get the following error. No idea what it means. coldfusion.tagext.lang.CFIndexTagException: Error # -31 Error # -31 Error E3-0036 (VDK): Cannot load style.ddd schema

RE: Get New Record ID in ORACLE

2005-06-07 Thread James Holmes
Doing that without INTO gives an error regarding the missing INTO keyword - it needs to be returned into a declared or bound PL/SQL variable. Can CF get the value of a modified, bound variable? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June

CFLDAP - Attributes Empty

2005-06-07 Thread Matthew Harris
Hi, I'm using the code below to query my ldap server, I am getting results, but the problem is all the values are empty strings, can anybody help? cfldap server=hc-dc1.halesowen.ac.uk action=query name=auth attributes=sAMAccountName,cn,ou start=DC=halesowen, DC=ac, DC=uk cfdump var=#auth#

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
Jochem, I tried to make an example using the INSERT .. RETURNING syntax directly in a cfquery to make the example clearer, but i couldn't get it to work with straight SQL (didn't try things like anon pl/sql block). Do you have such an example you could share with us? Aaron, What type of

changing the default time of SQLServer

2005-06-07 Thread Protoculture
the ISP installed our sql server with US time when it needed to be UK time. Is there any way of altering this? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application

changing the default time of SQLServer

2005-06-07 Thread Protoculture
the ISP installed our sql server with US time when it needed to be UK time. Is there any way of altering this? That would be US and UK DATES DATETIME, not TIME. We need to change this ( after its already been installed ) to UK.

Web Application Security with Coldfusion

2005-06-07 Thread Ian Vaughan
How can Coldfusion be used to filter metacharacters to reduce XSS Cross Site Scripting attacks. I.E. Converting to lt; and gt; ( to #40; ) to #41; # to #35(#) to #38() Has anybody on the list implemented this in their Coldfusion apps to protect against XSS ? And am I correct in saying

RE: Web Application Security with Coldfusion

2005-06-07 Thread Paul Vernon
The easiest way is to use cfqueryparam when putting in and use HTMLEditFormat when displaying anything from the database that is user input. Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking

Re: Web Application Security with Coldfusion

2005-06-07 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul Vernon wrote: The easiest way is to use cfqueryparam when putting in and use HTMLEditFormat when displaying anything from the database that is user input. That, and if you're writing something from the database out to a JavaScript string,

Re: CF equivalent to php's mysql_insert_id() function?

2005-06-07 Thread Bob Flynn
Thanks, Barney. That's perfect. Bob cffunction name=mysql_insert_id() cfset var get = / cfquery datasource=#variables.my.dsn# name=get SELECT LAST_INSERT_ID() AS id /cfquery cfreturn get.id / /cffunction You'll want to call this function from within a transaction with

Re: Calendar

2005-06-07 Thread Chris Tilley
Larry, I would like to join the Me Too club as well. I have a javascript calendar on my site but it is very limited and would like to review your calendar for possible replacement. Thanks Chris On 6/6/05, Larry Lyons [EMAIL PROTECTED] wrote: Hi all, I'm sure it's been asked already but

JOIN help

2005-06-07 Thread Daniel Kessler
I am a bit new to JOINs and I am having trouble with this JOIN. I don't get an error until the last AND and then it says: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended SELECT empower_local_case_studies.*,empower_registration.email FROM

Re: Actionscript equiv to decimalFormat()

2005-06-07 Thread Ken Ferguson
Excellent Kevin, I'll give that a shot this afternoon. Thanks! Ferg Kevin Aebig wrote: Hey Ken, Theres not really a nice way to do this actually.Heres a prototype... it should do the trick. Number.prototype.addCents = function() { var a = ((Math.round(this*100)/100)+).split(.); a[1] =

RE: Neo-query.xml curruption on 6.1 updater

2005-06-07 Thread Chris Norloff
Not us. We just kept a backup of neo-query.xml in the same directory. For Production we made changes to neo-query.xml itself then copied it out to the servers, rather than risk using CFMX Admin on a Production system. neo-query.xml is written to every time you access the datasources menu in

Re: CFLDAP - Attributes Empty

2005-06-07 Thread Douglas Knudsen
try applying the filter attribute, like filter=sn=smith DK On 6/7/05, Matthew Harris [EMAIL PROTECTED] wrote: Hi, I'm using the code below to query my ldap server, I am getting results, but the problem is all the values are empty strings, can anybody help? cfldap

Re: Get New Record ID in ORACLE

2005-06-07 Thread Douglas Knudsen
what problem? I use this select mysequence.nextval into newid from dual insert into foo (a,b,c,pk) values (A,B,C, newid) do whatever else you want with newidcarry on. I have yet to really understand the need for doing everything via SPs. They are only really faster in complex situations,

Re: Neo-query.xml curruption on 6.1 updater

2005-06-07 Thread Douglas Knudsen
ditto here, we 'back that up' regularly. I have seen this corruption occur when the server is experiencing heavy load and I try to update a DSN. IIRC, this is not fixed in CF7 either. DK On 6/7/05, Chris Norloff [EMAIL PROTECTED] wrote: Not us. We just kept a backup of neo-query.xml in the

RE: CF Google desktop search

2005-06-07 Thread RADEMAKERS Tanguy
there's an existing plugin (Larry's Any Text File Indexer) that allows you to easily configure the extensions of any text based files you want GDS to index... most handy. /t -Original Message- Subject: CF Google desktop search From: Rob [EMAIL PROTECTED] Date: Fri, 3 Jun 2005 10:28:29

Re: asynch cfml gateway - working example

2005-06-07 Thread Douglas Knudsen
hmm, interesting, so something in jrun.xml should be managing thread count/ceilings, eh? Like the scheduler service. A quick perusal of this file doesn't indicate anything new, but I'm only one pair of eyes. DK On 6/6/05, Dave Watts [EMAIL PROTECTED] wrote: um, that's what I thought. Was

Re: JOIN help

2005-06-07 Thread S . Isaac Dealey
I am a bit new to JOINs and I am having trouble with this JOIN. I don't get an error until the last AND and then it says: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended SELECT empower_local_case_studies.*,empower_registration.email FROM

Re: asynch cfml gateway - working example

2005-06-07 Thread S . Isaac Dealey
um, that's what I thought. Was chatting with coworkers today about this too. Their concern was thread use. Threads used in the async gateway are part of the pool in the JRun instance, no? So, if you have a box getting good load, introducing a script that runs in this parallel fashion, this

problem with including cfm pages with form fields inside cfform tags

2005-06-07 Thread Anthony Crawford
Hi folks, this is my second post to HOF! I was referred to the site through the Hostmysite developer forum. I have a question with regards to CFFORM. I have two CFM pages structured like this (edited for this post) NewMovieWizard.cfm: cfform name=form1 format=html

CFFORM - Can I start using it again?

2005-06-07 Thread Evan Lavidor
For a long time I never used the CFFORM controls because they tended to write bloated JavaScript and non-standards compliant code. I'm now upgrading to CF7, and am looking at all the new cool things with Flash forms and XForms, which all require CFFORM. So, my basic questions are, is CFFORM safe

Unicode and GetProfileString?

2005-06-07 Thread Jake McKee
Is there a way to get the GetProfileString and SetProfileString functions to work in Unicode? Thanks! Jake ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting

Re: JOIN help

2005-06-07 Thread daniel kessler
You should probably qualify the columns in your where clause, and with table-names of this length, I would definately use aliases. See if this helps any. I was going to, but didn't remember right-off how to do so. I've done so now, thanks. SELECT ecs.*,er.email FROM empower_local_case_studies

code/executable to highlight CF syntax?

2005-06-07 Thread Chase Seibert
Hey guys, Does anyone know of a good tool to syntactically highlight CFML code? I'm developing a plugin for our source control system that will email checked in changes to the dev mailing list. However, the code is rather ugly in black and white. I would love to be able to take a cfm source

Re: JOIN help

2005-06-07 Thread Deanna Schneider
It's no the primary keys that need to be =. What you need is to have a foreign key in the table that holds the email. So, for example, you'd have: empower_local_case_studies studyid (PK) name etc empower_registration registrationid (PK) studyid (FK) etc. Then, you'd join: WHERE erc.studyid =

Re: CFLDAP - Attributes Empty

2005-06-07 Thread Matt Harris
try applying the filter attribute, like filter=sn=smith DK On 6/7/05, Matthew Harris [EMAIL PROTECTED] wrote: Thanks that works great. Do you know how I easily get the groups that the member is in? At the moment the memberof object contains: CN=WEBMODS,OU=Intranet

Re: Calendar

2005-06-07 Thread Rey Bango
For what it's worth guys, I've used this calendar in the past and it's worked great: http://www.bensonitsolutions.com/index.cfm For $20, you can't go wrong. Rey... ~| Logware (www.logware.us): a new and convenient web-based

RE: CFSCRIPT / RequestTimeOut?

2005-06-07 Thread Adkins, Randy
Actually we are having the problem with 6.1 Any one else have a similar issue?? -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, June 03, 2005 11:31 AM To: CF-Talk Subject: Re: CFSCRIPT / RequestTimeOut? I don't know about what happens if the app times out,

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
what problem? I use this select mysequence.nextval into newid from dual insert into foo (a,b,c,pk) values (A,B,C, newid) do whatever else you want with newidcarry on. Yes, but how do you retrieve the value of the just inserted id? I can't get the select ... into... syntax to work in a

RE: Get New Record ID in ORACLE

2005-06-07 Thread James Holmes
There's also the issue of other people. I know which sequence to use - but the person to whom I give the code might not bother to read the pages of docs over which I laboured (*cough*). I can also allow other schema to access my tables via the SP without having to give them any access to the table

Re: Get New Record ID in ORACLE

2005-06-07 Thread Douglas Knudsen
select mysequence.nextval into newid from dual You are using a sequence for your IDs, no? DK On 6/7/05, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: what problem? I use this select mysequence.nextval into newid from dual insert into foo (a,b,c,pk) values (A,B,C, newid) do whatever

Re: Get New Record ID in ORACLE

2005-06-07 Thread Adrocknaphobia
1. Performance (maybe not as much on insert, but updates an queries definitely faster). When running queries in Oracle, a plan is made on how to efficiently retrieve the data. The PL/SQL is precompiled and an action plan is made to optimize performance. 2. Transaction and Locking. A procedure is

RE: CFLDAP - Attributes Empty

2005-06-07 Thread Dawson, Michael
I have a zip file that contains a CFC related to Active Directory tasks. http://acelinkdev.evansville.edu/hoflists/ActiveDirectoryService.zip There are a few functions that will query the memberOf attribute and separate the group names into a query object. Search and replace evansville and edu

Re: asynch cfml gateway - working example

2005-06-07 Thread Douglas Knudsen
On 6/6/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: I have not been able to play with this stuff yet, but D. Cooper's blog entry had this Imagine spawning off long running DB queries in parallel, for example. Page response times for most existing CF applications, in fact, would

Re: Opera and cookies grrrrrr

2005-06-07 Thread Bryan Stevenson
Just an FYI folks It does appear that there is a maximum total cookie size in Opera (that's the total length of all cookies set for a domain). Whatever the upper limit is, it's pretty far below IE/Netscape/etc. I've only seen individual cookie size limits.but a total size limit for

RE: Calendar

2005-06-07 Thread Mark A Kruger
Rey, I'd say you might be right there. The full version is only 40.00 (not 20) - and it looks great. How skinnable is it - does it require a lot of work to change the look? -mark -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 9:12 AM To:

Re: Unicode and GetProfileString?

2005-06-07 Thread Paul Hastings
Jake McKee wrote: Is there a way to get the GetProfileString and SetProfileString functions to work in Unicode? nope. what are you trying to do? ~| Logware (www.logware.us): a new and convenient web-based time tracking

RE: Opera and cookies grrrrrr

2005-06-07 Thread Paul Vernon
I've missed most of this thread so I'm sorry if I'm off base or I'm repeating someone but I thought that the RFC's stated pretty clearly that the size of a cookie could be no more than 4K and that there could be no more than 20 cookies per domain, therefore giving a total of 80Kb of cookie storage

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
-Original Message- Subject: Get New Record ID in ORACLE From: Douglas Knudsen [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 10:41:52 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#208799 select mysequence.nextval into newid from dual You

Re: Get New Record ID in ORACLE

2005-06-07 Thread Aaron Rouse
I guess we just run too simple of insert/update queries to see how performance could ever need to be better or an issue. Although of the few ones that effect a lot of records they are sitting in SPs, but those statements are not what I would label basic either. I thought if a cftransaction was

Re: Get New Record ID in ORACLE

2005-06-07 Thread Adrocknaphobia
Hrmm, if you arent taking advantage of Oracle security and you are just running simple queries... then why invest in such an expensive database? As far as cftransaction, it does work that way, but that logic really belongs in the model (the database) not the controller (cf). -Adam On 6/7/05,

CF7 and ODBC Connections

2005-06-07 Thread jonese
I have a few excel files that users upload and then we process on our systems. I've setup the ODBC DSN on my server but when ever i try to create the DataSource in CF7 i get the following error: Connection verification failed for data source: customerUpload1 java.sql.SQLException:

RE: Get New Record ID in ORACLE

2005-06-07 Thread Kerry
I have managed to get some SQL that cfquery didnt like to work perfectly using this: cfscript factory = CreateObject( java, coldfusion.server.ServiceFactory ); ds = factory.getDataSourceService().getDatasource( yourdsn ); conn = ds.getConnection(); stmt = conn.createStatement(); sql = your funky

Re: Opera and cookies grrrrrr

2005-06-07 Thread Bryan Stevenson
I've missed most of this thread so I'm sorry if I'm off base or I'm repeating someone but I thought that the RFC's stated pretty clearly that the size of a cookie could be no more than 4K and that there could be no more than 20 cookies per domain, therefore giving a total of 80Kb of cookie

Session Timeout

2005-06-07 Thread David Ahn
Hi, All - From time to time, my application gets terminated before it reaches the session time-out set in application.cfm. In application.cfm CFAPPLICATION NAME=Outage SESSIONMANAGEMENT=Yes SETCLIENTCOOKIES=Yes

Re: Opera and cookies grrrrrr

2005-06-07 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul Vernon wrote: I've missed most of this thread so I'm sorry if I'm off base or I'm repeating someone but I thought that the RFC's stated pretty clearly that the size of a cookie could be no more than 4K and that there could be no more than 20

Re: Get New Record ID in ORACLE

2005-06-07 Thread Aaron Rouse
Because this is a big oilfield company that spent way too much money with Oracle and is looking for any excuse to just use it. They appear to not care if it is used right or not. The web applications do not do much more than simple queries, other groups might very well be doing things much more

Re: Opera and cookies grrrrrr

2005-06-07 Thread Bryan Stevenson
The 4kB/20 cookies rule is a *minimum*. There's no upper limit on how many cookies can be stored overall or per domain, nor on the size. K. Thanks for that Keithand FYIthe 20 cookie limit exists in IE for sure (an associate bumped into that one recently). So it may be a

Should we support Access?

2005-06-07 Thread Stan Winchester
As many of you know from my previous posts we have had a forums application in beta testing for a while. It was developed primarily using SQL Server and MySQL, but wanted to offer support for Access PostgreSQL, but have found Access a pain to support. The problem is with cfqueryparam throws

RE: Get New Record ID in ORACLE

2005-06-07 Thread James Holmes
EWW. No bind variables (i.e. cfqueryparam) so if there is user input the statement is susceptible to sql injection (another thing SP's take care of). Regardless, select s.nextval into newid from dual will still break. This would work in a cfquery: DECLARE newid NUMBER; BEGIN select s.nextval

Re: Get New Record ID in ORACLE

2005-06-07 Thread Adrocknaphobia
Well its not really the same. CFtransaction will prevent race conditions and rollbacks in CF, while CF has a lock and wont send similar requests until the transaction is complete. Another request could come in through cf that is not in a transaction that is executed. Transactions on the database

Re: Get New Record ID in ORACLE

2005-06-07 Thread Deanna Schneider
Generally, we just use straight up sql around here, too. But, we also found that an error was thrown (in the logs, not to the user) whenever a DSN was used that did not have an explicitly set username and password in the cfadmin, and which used a transaction. So, anytime we need a transaction, we

RE: Session Timeout

2005-06-07 Thread James Holmes
It may not be the issue, but since you are on CF 5 you need a readonly lock around CFIF NOT IsDefined(Session.LoggedIn) CFLOCATION URL=../index.cfm /CFIF as you are reading the scope in the IsDefined() check. -Original Message- From: David Ahn [mailto:[EMAIL PROTECTED] Sent:

Re: Calendar

2005-06-07 Thread Rey Bango
I used a very old version and it was difficult to skin at all. Just took some leg work. I'd use it again for sure. I emailed Greg so he'd reply on here and I'm going to cc him on this so he can answer your questions. Rey... Mark A Kruger wrote: Rey, I'd say you might be right there. The

RE: Should we support Access?

2005-06-07 Thread Craig Dudley
Drop it imho. PostgreSQL, MySQL and SQL Server should be more than enough for a forum app. -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: 07 June 2005 17:13 To: CF-Talk Subject: Should we support Access? As many of you know from my previous posts we have had

RE: Get New Record ID in ORACLE

2005-06-07 Thread James Holmes
Sorry that's not correct. CFTRANSACTION starts a db transaction like any other, including the ability to make the transaction SERIALIZABLE. That's what it's for. You may be thinking of CFLOCK. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 June

Re: Get New Record ID in ORACLE

2005-06-07 Thread Aaron Rouse
Syntax like that throws an error for me when tried in a cfquery. On 6/7/05, James Holmes [EMAIL PROTECTED] wrote: This would work in a cfquery: DECLARE newid NUMBER; BEGIN select s.nextval into newid from dual; etc END; but I don't know why you would bother. Since you need the

RE: Get New Record ID in ORACLE

2005-06-07 Thread James Holmes
Which version of Oracle and which driver are you using? We are on 9i and we use the native CF/Oracle JDBC driver (i.e. DataDirect) that comes with Enterprise. It may not work in the thin driver or other flavours. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent:

Re: Should we support Access?

2005-06-07 Thread Scott Stroz
Stan, My knee-jerk reaction is to say 'No'. By supporting Access, you could be propogating the myth that Access is a sufficient databse to use for web applications. In my opinion, Access would never be the DB of choice, other than to track my DVD collection...but I would never look at it

Re: JOIN help

2005-06-07 Thread S . Isaac Dealey
Does the registration_id really match the local_case_study_id? -- it looks like you're joining the primary key on both tables... not that doing that would have to be invalid, but this doesn't seem like the sort of situation where I would expect that. I thought that this is how I relate the

RE: Should we support Access?

2005-06-07 Thread Matt Osbun
Personally, I wouldn't bother with Access support, the issue of cfqueryparam being one of the reasons. That being said, I can do a lot more than imagine production systems running off of Access. I can point to a couple. Production Intranet, Online Training/Presentations, Forums, and probably a

Re: asynch cfml gateway - working example

2005-06-07 Thread S . Isaac Dealey
Hit the send button too soon? On 6/6/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: I have not been able to play with this stuff yet, but D. Cooper's blog entry had this Imagine spawning off long running DB queries in parallel, for example. Page response times for most existing CF

RE: Should we support Access?

2005-06-07 Thread James Holmes
At the absolute opposite end of the scale, have you considered Oracle support? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
Aaron, Read the concepts guide in the oracle docco, then check out the two books by Tom Kyte - expert one on one oracle (get it secondhand, it was written for 8i and the new edition will come out soon for 10g) and effective oracle by design. There are plenty of big companies looking for any

Re: Should we support Access?

2005-06-07 Thread S . Isaac Dealey
A SQL Server, MySQL, ect. field data type varchar(500) with cfqueryparam set as follows: cfqueryparam value=#Comments# cfsqltype=CF_SQL_VARCHAR maxlength=500 works fine in SQL Server, MySQL, ect., but breaks in Access. If I remove the maxlength=500 it works. Personally I don't use

CFMX7 and COM

2005-06-07 Thread Paolo Piponi
I am currently testing an upgrade from CF5 to CFMX7 and all went well except a major component of our website that uses COM. In accessing the COM with code that works fine in CF 5 we get: An exception occurred when instantiating a Com object. The cause of this exception was that:

Re: CFMX7 and COM

2005-06-07 Thread George Abraham
What object are you trying to instantiate? Does the account under which CFMX runs (usually system account) have permissions to access the COM object or to instantiate it? George On 6/7/05, Paolo Piponi [EMAIL PROTECTED] wrote: I am currently testing an upgrade from CF5 to CFMX7 and all went

Re: Get New Record ID in ORACLE

2005-06-07 Thread Aaron Rouse
I will have to add it to my list of books to one day read. I have a pretty big stack right now that I am slowly going through. Think I still have one or two Oracle related books in that stack actually. We actually have been running Oracle for many years now here, just not many people here do

Re: Get New Record ID in ORACLE

2005-06-07 Thread Adrocknaphobia
CFTransaction just delays the COMMIT statement in Oracle, and/or issues ROLLBACKs. Thats why Deanna noted the invalid login errors in the logs. Because they are seperate calls to the db. In a procedure not only do you have a true transaction, but you also have row level locking. CFLOCK only locks

Re: Get New Record ID in ORACLE

2005-06-07 Thread Douglas Knudsen
oh drat! my fault, its just select mysequence.nextval AS newid from dual then use #queryname.newid# when you need the id, yes. sorry about that. Can't use INTO in SQL in this case, have to use PL for that. DK On 6/7/05, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: -Original Message-

Re: CFFORM - Can I start using it again?

2005-06-07 Thread Calvin Ward
In particular I wouldn't rely on the serverside validation option as it requires client side code to trigger the validation, which of course defeats one purpose of true server side validation (which is not to rely on the client). - Calvin On 6/7/05 9:24 AM, Evan Lavidor [EMAIL PROTECTED] wrote:

Re: Calendar

2005-06-07 Thread Calvin Ward
Has anyone looked at Mishoo's jscalendar? Or was that already mentioned? - Calvin On 6/7/05 12:08 PM, Rey Bango [EMAIL PROTECTED] wrote: I used a very old version and it was difficult to skin at all. Just took some leg work. I'd use it again for sure. I emailed Greg so he'd reply on here

FW: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
aaargh - sorry, keep forgetting to turn off my digital signature. i think the server kicks the mail in that case? otherwise... sorry ;)) -Original Message- From: RADEMAKERS Tanguy Sent: Tuesday, June 07, 2005 6:33 PM To: 'cf-talk@houseoffusion.com' Subject: RE: Get New Record ID in

RE: CFMX7 and COM

2005-06-07 Thread Mark A Kruger
Paolo, If, as you say, a major component of the website uses COM, then I would be very cautious moving away from CF 5. CFMX is a mediocre COM platform at best. It's ok for CDONTs but I wouldn't site that is heavily dependent on COM on a CFMX server. -Mark -Original Message- From:

Re: CFFORM - Can I start using it again?

2005-06-07 Thread Massimo, Tiziana e Federica
If you are looking for client-side form validation, I wrote a dedicated library (I wanted a generic solution, not CF-only) that may be worth a try: http://www.massimocorner.com/validator/ Massimo Foti Tools for ColdFusion and Dreamweaver developers:

Re: JOIN help

2005-06-07 Thread daniel kessler
ah that's what I'm doing. I was doing it wrong, but went to a meeting and the wrong information displayed. I was aligning primary keys, you are right, and should've been doing a foreign key to a primary key. Thanks Deanna! It's no the primary keys that need to be =. What you need is to have

Currency data type in access

2005-06-07 Thread Phillip Perry
Hi, When I display the dollar amount in a web page the values come with extra 0's (ex: 19.9500). How do I get rid of the extra 0's? I tried replace() but that didn't pan out. Thanks, Phil ~| Logware (www.logware.us): a new

Re: Should we support Access?

2005-06-07 Thread Pete Ruckelshaus
My $.02 I am a SQL Server Oracle user/developer. I have dabbled with MySQL and have found it to be adequate for those sites I have used to build with it, albeit without SP support (which MySQL 5.0 adds). Given that there is a free RDBMS available (MySQL), I would drop any idea of supporting

Hey. About your access post.

2005-06-07 Thread Phillip Perry
Hi, How've you been. I just read your post on fusion about supporting access and I noticed you said that sql server has a free version. Would you happen to know where I can get my hands on it? I cant find one on the Microsoft website. Thanks Phil

Re: Currency data type in access

2005-06-07 Thread Charlie Griefer
try dollarFormat() or decimalFormat() fwiw, I don't use the currency datatype. i figure to a database, a number is a number is a number. if I need to format it as currency, i use the dollarFormat() function. On 6/7/05, Phillip Perry [EMAIL PROTECTED] wrote: Hi, When I display the dollar

RE: Hey. About your access post.

2005-06-07 Thread Phillip Perry
sorry that was supposed to be a direct question to someone. Dont know why it went right to this list, my apologies again Phil -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 1:36 PM To: CF-Talk Subject: Hey. About your access post. Hi,

RE: Currency data type in access

2005-06-07 Thread Kerry
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functa27.htm -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: 07 June 2005 18:22 To: CF-Talk Subject: Currency data type in access Hi, When I display the dollar amount in a web page the values come with extra

Re: FW: Get New Record ID in ORACLE

2005-06-07 Thread Adrocknaphobia
Well there are more (minor) speed benefits. Where as cfquery get compiled every time procedures do not. A stored procedure may be faster on the second run and the same speed following; cfquery will be as slow no matter how many times it's executed. Additionaly CF is sending the entire query to

Re: Calendar

2005-06-07 Thread Greg Benson
AS Rey posted here is information on my coldfusion calendar. Thanks for the post Rey! I have two web calendar products that have been developed and upgraded, since 2000. The Current version is 1WebCalendarV3.3 One is a LITE version for only $19.99. This supports cf 4.5 and above and comes

CFLOGIN TIMEOUT WARNING?

2005-06-07 Thread Aaron Judson
Hey everybody! I have a a question, and would like to know if there is a way to do this. I would like to have a warning popup window for a user if their session is going to timeout (in CFLOGIN) - I know this is possible with using javascript, but this counts the timeout on a per page basis.

RE: Should we support Access?

2005-06-07 Thread Jim Davis
-Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 12:13 PM To: CF-Talk Subject: Should we support Access? As many of you know from my previous posts we have had a forums application in beta testing for a while. It was developed

FEDEX and CF

2005-06-07 Thread Bryan Stevenson
Hey All, I'm trying to track down the best solution for entering shipping orders into the FedEx system and producing a shipping label (and retrieving the FedEx Tracking Number to pass along to the customer). This will be used by a fullfillment centre that will view a list of pending orders,

[best practice] altering arguments

2005-06-07 Thread Michael Dinowitz
I've got a function which takes in a string, runs it through a half dozen alterations and then returns the string. Currently I'm using a CFARGUMENT to accept/check/etc. the string and then each function works on that argument: //remove 8 or more quoted lines. a quoted line starts with a

Re: [best practice] altering arguments

2005-06-07 Thread Barney Boisvert
Doesn't matter. The argument is actually both already. If you reference it without a scope, it's a local variable. If you reference it with the 'arguments.' qualifier, it's an argument. And yes, there really is two copies of the string accessible in your function. That's also why you can't

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
-Original Message- Subject: FW: Get New Record ID in ORACLE From: Adrocknaphobia [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 13:57:35 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40594forumid=4#208851 Well there are more (minor) speed benefits. Where

CFMX 6.1 Mail Spooler Problem

2005-06-07 Thread Josen Ruiseco
I have been running CFMX 6.1 for about 18 months without any problem. Now for the past month my cfmail spooler has just locked up and refuses to send mail until I restart the services. I am using Rob Bilson and Cameron Childress' version 3 CF_ResendUndeliverableMail3 tag. It seems to run fine

Duplex Printing with ColdFusion

2005-06-07 Thread E C list
Can anyone think of a way to get ColdFusion (or say a ColdFusion PDF plugin) to force a printer to print duplex (double sided pages)? Thank you! __ Discover Yahoo! Find restaurants, movies, travel and more fun for the weekend. Check it out!

Re: Hey. About your access post.

2005-06-07 Thread Calvin Ward
The answer is MSDE and SQL Server 2005 Express though. - Calvin On 6/7/05 1:37 PM, Phillip Perry [EMAIL PROTECTED] wrote: sorry that was supposed to be a direct question to someone. Dont know why it went right to this list, my apologies again Phil -Original Message- From:

Re: Should we support Access?

2005-06-07 Thread Matt Robertson
I support SQL Server, mySQL, Access and Oracle for my ContentMonger Pro cms and have done so for some time so I feel your pain. Short answer: Do it. Its amazing how many people use Access for a variety of reasons. The same goes for Oracle, although you will indeed introduce more issues into

My attempt at a shopping cart

2005-06-07 Thread Phillip Perry
Hi, just 2 lines of code and i'm already hitting a wall. I'm using the following lines cfparam name=session.cart default=arrayNew() cfset session.cart = arrayAppend(session.cart, structnew()) and getting the error code: Object of type class java.lang.String cannot be used as an array What am

Re: My attempt at a shopping cart

2005-06-07 Thread Charlie Griefer
cfparam name=session.cart default=#arrayNew()# poundage makes it an array. lack of poundage makes it a string. On 6/7/05, Phillip Perry [EMAIL PROTECTED] wrote: Hi, just 2 lines of code and i'm already hitting a wall. I'm using the following lines cfparam name=session.cart

  1   2   >