Re: asynch cfml gateway - working example
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 script that runs in this parallel fashion, this would eat up more threads, eh? So, is it really beneficial? I suppose the answer is, 'it depends', but curious on thoughts on this. Well, yes, it depends. I've posted a series of three articles on my blog about asynchronous development that covers some of the issues that you can run into by over-parallelizing your applications: http://corfield.org/search/asynchronous+development Whether parallel execution will help or not depends on a lot of factors so there are very few hard rules in this area, I'm afraid. If it's any help, here's a couple of the things we're using the asynchronous gateway for: - fetching large files from one server to another - invoking slow web services to post data updates Neither of these need the calling code to wait for the result and in both cases the main line execution does not call the asynchronous task in all cases. -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208765 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208766 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
indexing verity... quagmire!
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 (document catalog) in collection e:\hosting\oursite.com\index\job_index\job_index\custom.. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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 2005 4:34 To: CF-Talk Subject: Re: Get New Record ID in ORACLE 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. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208768 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFLDAP - Attributes Empty
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# This message is sent in confidence for the addressee only. It may contain confidential or sensitive information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise us of any errors in transmission. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208769 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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 advantages does an SP in oracle(or whatever) have over queries for basic DB inserts? SPs don't have any benefits over queries specifically for inserts, but they have more general advantages that come into play here as well, like the fact that they automagically use bind variables (unless you use dynamic sql), etc. Contrary to popular belief, simple SPs are not markedly faster than simple SQL statements, assuming several things (like either correct use of cfqueryparam or repeating the same query over and over so it's exec plan is read from the cache). The real benefits are in things like code organization - keeping your sql separate from your CFML, the fact that other developers on a team are less likely to change a SP than a block of SQL in a cfm file - and even less likely to just copy and paste it somewhere else if they need something kinda like that. Also, in oracle, the db can warn you if your sp's become invalid, for example as a consequence of modifying a table, whereas with queries you'll discover that error at runtime. You can use sp's to enforce quite clever database security practices due to what's called the definer rights model (by default, sp's in oracle execute with the privs of the user who wrote them, not the user who's running them). Once you get into more complex db manipulations - the kind of things where you'd have several cfqueries in a row - then sp's offer the possibility to do all kinds of stuff in a single trip to the db, but then you're heading towards putting business logic in the db... not necessarily a bad thing, but something to keep in mind. I started using sp's because i had to, but now i think i would use them for anything but the very simplest of projects. /t -Original Message- Subject: Get New Record ID in ORACLE From: Jochem van Dieten [EMAIL PROTECTED] Date: Tue, 07 Jun 2005 10:33:57 +0200 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#208766 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208770 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
changing the default time of SQLServer
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 http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208771 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
changing the default time of SQLServer
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. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208772 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Web Application Security with Coldfusion
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 that using CFQUERYPARAM protects your site from users inserting SQL metacharacters and commands into web based input fields in order to manipulate the execution of back end sql queries (SQL Injection) ? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208773 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Application Security with Coldfusion
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 application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Application Security with Coldfusion
-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, don't forget to use JSStringFormat(). I've seen mountains of code from various sources that totally omits this one simple step. K. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCpYNemSWF0pzlQ04RAjzKAKDXBcQifSufHHuF21DaNVw5MYOuFgCfSBlp P2XQFrWiaivXQDngB/xsfWs= =3jfG -END PGP SIGNATURE- ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208775 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF equivalent to php's mysql_insert_id() function?
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 your other queries to ensure it gives you the right result. PHP doesn't have this requirement, because in PHP you manage your own connections, but in CF they are managed in a pool by CF itself. cheers, barneyb ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208776 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Calendar
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 I'm looking for a calendar of events... with an admin panel and pop up (or div over) for events that have a long description... I would also like recurrence and multi-language but it's not priority. Any ideas? Thanks Patrick Patrick, I have one I've released under a creative commons license. If interested send me an email and I'll send you a copy. larry ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208777 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
JOIN help
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 empower_local_case_studies,empower_registration WHERE page= (param 1) AND project = (param 2) AND empower_local_case_studies.local_case_study_id = empower_registration.registration_id ORDER BY empower_local_case_studies.local_case_study_id ASC the coded query: cfset session.user_consultation_db = 'empower_local_case_studies' CFQUERY NAME=get_record DATASOURCE=dch SELECT #session.user_consultation_db#.*,empower_registration.email FROM #session.user_consultation_db#,empower_registration WHERE page= cfqueryparam value=#url.page# cfsqltype=cf_sql_varchar AND project = cfqueryparam value=#session.project_id# cfsqltype=CF_SQL_NUMERIC AND #session.user_consultation_db#.local_case_study_id = empower_registration.registration_id ORDER BY #session.user_consultation_db#.#session.user_consultation_idfield# ASC /CFQUERY thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Actionscript equiv to decimalFormat()
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] = (a[1]+00).substr(0, 2);
return a.join(.);
};
// Usage
var price = 123.4;
var discount = 56.8;
price = price - discount;// 66.6
total = price.addCents();// 66.60
Sincerely,
Kevin
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Monday, June 06, 2005 2:36 PM
To: CF-Talk
Subject: Actionscript equiv to decimalFormat()
Is there one? I know that all numbers in AS are floating point numbers,
but I'm returning a value from a function like this:
(simplified code...)
y = Number(itemValue) * Number(quantity);
subTotalValue.text = y;
When the value is something like 29, I'd like it to show as 29.00
instead. It's very clear though, that this is not happening. My text box
shows 29 instead.
I'm sure that this is simple and one of you AS experts out there will
most likely read this and wonder how I can even figure out how to manage
breathing, but I am not an AS expert, so please don't hold it against me!
Thanks,
Ferg
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208779
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Neo-query.xml curruption on 6.1 updater
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 the CFMX Admin - even if you make no changes. Chris Norloff -- Original Message -- From: James Holmes [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Tue, 7 Jun 2005 12:40:49 +0800 Even with 6.1 updater (on CF Enterprise standalone, Solaris 8 on SPARC, Oracle datasources only), we still get regular corruption of neo-query.xml and we need to restore from backups to get the datasource service working. Has anyone made any progress in fixing this? James Holmes Divisional Web Interface Development Coordinator Engineering, Science and Computing x4864 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208780 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFLDAP - Attributes Empty
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 server=hc-dc1.halesowen.ac.uk http://hc-dc1.halesowen.ac.uk action=query name=auth attributes=sAMAccountName,cn,ou start=DC=halesowen, DC=ac, DC=uk cfdump var=#auth# This message is sent in confidence for the addressee only. It may contain confidential or sensitive information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise us of any errors in transmission. Thank you. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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, no? Also, they seem to complicate the ease of CF's cfquery tag too and place extra burden on SCM, IMHO. DK On 6/7/05, James Holmes [EMAIL PROTECTED] 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. Procedures are also often pre-compiled, so they may run faster, even the first time they are executed, although on an insert this probably doesn't make much difference. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June 2005 11:57 To: CF-Talk Subject: Re: Get New Record ID in ORACLE What type of advantages does an SP in oracle(or whatever) have over queries for basic DB inserts? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208782 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Neo-query.xml curruption on 6.1 updater
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 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 the CFMX Admin - even if you make no changes. Chris Norloff -- Original Message -- From: James Holmes [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Tue, 7 Jun 2005 12:40:49 +0800 Even with 6.1 updater (on CF Enterprise standalone, Solaris 8 on SPARC, Oracle datasources only), we still get regular corruption of neo-query.xml and we need to restore from backups to get the datasource service working. Has anyone made any progress in fixing this? James Holmes Divisional Web Interface Development Coordinator Engineering, Science and Computing x4864 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208783 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Google desktop search
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 -0700 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40529forumid=4#208548 Hum... is your code on your local machine or on a networked / shared drive? If it's not local you have to hack google to index your code http://www.robrohan.com/blog/index.cfm?mode=entryentry=662FD36 7-D5C5-08EE-BEFD1BC0B9CF83EF Otherwise, it might not do tags... I don't have any cfcode available at the minute to check ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208784 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: asynch cfml gateway - working example
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 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 would eat up more threads, eh? So, is it really beneficial? I suppose the answer is, 'it depends', but curious on thoughts on this. If I recall correctly, the gateway has its own thread pool, separate from the threads that are used to service regular requests. I suspect that all the threads are pooled within the single JRun process, however. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JOIN help
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 empower_local_case_studies,empower_registration WHERE page= (param 1) AND project = (param 2) AND empower_local_case_studies.local_case_study_id = empower_registration.registration_id ORDER BY empower_local_case_studies.local_case_study_id ASC 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. SELECT ecs.*,er.email FROM empower_local_case_studies ecs, empower_registration er WHERE ecs.page = (param 1) AND ecs.project = (param 2) AND (ecs.local_case_study_id = er.registration_id) ORDER BY ecs.local_case_study_id ASC 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. You might also want to try running this query in SQL+ ... Iirc the debugging in SQL+ is slightly improved over the error messages returned from Oracle to CF. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208786 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: asynch cfml gateway - working example
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 would eat up more threads, eh? So, is it really beneficial? I suppose the answer is, 'it depends', but curious on thoughts on this. The CF7 administrator allows you to assign the number of threads available to the gateways (all gateways share one pool, not just asynch), and the number of gateway requests to queue. By default it's 10 and 255 in developer mode. Not sure if the defaults are different for pro/ent. I suspect the thread pools are separate (one for gateways, another for http requests), though even if they share the same pool, the fact that the long running process(es) are passed off to a different thread should cause the spawning request to complete faster and thus release that thread sooner for the next request waiting in queue. In terms of mechanical efficiency there shouldn't be much difference -- the machine is performing the same tasks either way. But mechanical efficiency isn't really the purpose of asynch cfml -- it's purpose is to provide faster response times and as a result better experience to end-users. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208787 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
problem with including cfm pages with form fields inside cfform tags
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 action=#CGI.SCRIPT_NAME#?stepNum=#session.ofgr.stepNum# method=POST cfswitch expression=#session.ofgr.stepNum# cfcase value=1 cfinclude template=step1.cfm /cfswitch /cfform step1.cfm: cfinput name=firstName type=text value=#session.ofgr.firstName# size=40 maxlength=50 validateat=onSubmit required=yes message=Please enter your first name. / I have a 5 page application form that I need to split into multiple pages. So instead of listing all the code from all 5 pages, my intention is to just cfinclude them into the main cfm file (NewMovieWizard.cfm). The problem that happens is that when i get to the first cfcase=1, coldfusion gives me an error that the cfinput tag must be nested inside a cfform tag. As you can see the I have started off with a cfform but for some reason it is ignored with the included file. Can anyone offer a reason why this occurs? Is this a bug or am I crazy? Appreciate any help - THANKS!!! I did notice that if I use input instead of cfinput the error is not recognized for that field. hmm Of course the problem goes away if I just insert the actual code from the step1.cfm page into NewMovieWizard.cfm, but what I wanted is to organize the step pages into files. If it can't be done, oh well... AC ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208788 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFFORM - Can I start using it again?
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 to use again? Are people using it for non-Rich/XForm code? Is the JavaScript better? etc. etc I'm curious what people's experiences with it are. Thanks, Evan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Unicode and GetProfileString?
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 hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JOIN help
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 ecs, empower_registration er WHERE ecs.page = (param 1) AND ecs.project = (param 2) AND (ecs.local_case_study_id = er.registration_id) ORDER BY ecs.local_case_study_id ASC 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 tables. Really, I'm just trying to have the email address from the registration DB as part of the returned information. I was following a tutorial and it said to make sure the primary keys are =. Here's the tutorial I was using: http://www.w3schools.com/sql/sql_join.asp Is this not right? I'm always interested in learning. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
code/executable to highlight CF syntax?
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 file and produce an HTML version with various keywords/data highlighted different colors, like when you are editing the file in your IDE. I was using one such library previously for PHP/C++ code: http://www.beautifier.org/ For whatever reason, the CFML library is not working for me with this project. Does anyone know of another solution? I know that PHP itself provides a function to do this to PHP code. Does CF provide something simular that I am missing? -Chase Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | 617.464.2440 x119 | www.bullhorn.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208792 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JOIN help
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 = er.studyid Does that make sense? On 6/7/05, daniel kessler [EMAIL PROTECTED] wrote: 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 ecs, empower_registration er WHERE ecs.page = (param 1) AND ecs.project = (param 2) AND (ecs.local_case_study_id = er.registration_id) ORDER BY ecs.local_case_study_id ASC 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 tables. Really, I'm just trying to have the email address from the registration DB as part of the returned information. I was following a tutorial and it said to make sure the primary keys are =. Here's the tutorial I was using: http://www.w3schools.com/sql/sql_join.asp Is this not right? I'm always interested in learning. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208793 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFLDAP - Attributes Empty
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 Groups,DC=halesowen,DC=ac,DC=uk, CN=LESSON_OBS,OU=Intranet Groups,DC=halesowen,DC=ac,DC=uk, CN=STAFF_GROUP,OU=Intranet Groups,DC=halesowen,DC=ac,DC=uk, CN=webtest,CN=Users,DC=halesowen,DC=ac,DC=uk, CN=Account Operators,CN=Builtin,DC=halesowen,DC=ac,DC=uk, CN=Administrators,CN=Builtin,DC=halesowen,DC=ac,DC=uk, CN=web updaters,CN=Users,DC=halesowen,DC=ac,DC=uk, CN=webmaster,CN=Users,DC=halesowen,DC=ac,DC=uk, CN=Domain Admins,CN=Users,DC=halesowen,DC=ac,DC=uk ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208794 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Calendar
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 time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208795 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFSCRIPT / RequestTimeOut?
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, but I know I've hung the dev server a couple of times when a function couldn't properly exit (I was missing a return statement in one clause). I had to restart the service to get the threads to die. This was CF5, btw, so I don't know if this affects later versions. --Ben Adkins, Randy wrote: Does anyone know of an issue when using CFScript and if a function exceeds the RequestTimeOut variable set in the Administrator or as part of the URL, the server never seems to release it. I do not want to revert back to regular CF tags cause cfscript is a performance enhancement for us. Thanks! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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 cfquery, perhaps you could post an example? If you don't need to get this value, then you can rewrite your query as: cfquery ... insert into foo (a,b,c,pk) values (A,B,C, mysequence.nextval) /cfquery /t -Original Message- Subject: Get New Record ID in ORACLE From: Douglas Knudsen [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 08:59:07 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#208782 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, no? Also, they seem to complicate the ease of CF's cfquery tag too and place extra burden on SCM, IMHO. DK On 6/7/05, James Holmes [EMAIL PROTECTED] 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. Procedures are also often pre-compiled, so they may run faster, even the first time they are executed, although on an insert this probably doesn't make much difference. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June 2005 11:57 To: CF-Talk Subject: Re: Get New Record ID in ORACLE What type of advantages does an SP in oracle(or whatever) have over queries for basic DB inserts? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208797 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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 at all - I just give them execute access to the SP (which uses a trigger, simplifying the whole thing for everyone). I'm working on a project right now wherein I wish I'd used triggers for all my inserts (and other SQL), since another schema needs access to my tables without them. A rewrite is in order. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June 2005 10:18 To: CF-Talk Subject: RE: Get New Record ID in ORACLE 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 cfquery, perhaps you could post an example? If you don't need to get this value, then you can rewrite your query as: cfquery ... insert into foo (a,b,c,pk) values (A,B,C, mysequence.nextval) /cfquery ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208798 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 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 cfquery, perhaps you could post an example? If you don't need to get this value, then you can rewrite your query as: cfquery ... insert into foo (a,b,c,pk) values (A,B,C, mysequence.nextval) /cfquery /t -Original Message- Subject: Get New Record ID in ORACLE From: Douglas Knudsen [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 08:59:07 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#208782 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, no? Also, they seem to complicate the ease of CF's cfquery tag too and place extra burden on SCM, IMHO. DK On 6/7/05, James Holmes [EMAIL PROTECTED] 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. Procedures are also often pre-compiled, so they may run faster, even the first time they are executed, although on an insert this probably doesn't make much difference. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June 2005 11:57 To: CF-Talk Subject: Re: Get New Record ID in ORACLE What type of advantages does an SP in oracle(or whatever) have over queries for basic DB inserts? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 an implied transaction block that the _database_ manages. If your database supports the ability for transaction and locking, CF should really never be used. If you have multiple SQL statements to execute, when in a procedure, it one fails then the actions are not commited to the database. 3. Security. Security. Security. This is by far the biggest and most important aspect of procedures in my opinion. I can't sleep easy at night knowing an application's SQL statements (a roadmap diagraming your database) is stored in open text files on your web server (which is the server most commonly comprimised). Additionaly, with procedures and packages you can start to leverage the role based permission of your database. For instance, the only actions a user is allowed to perform in the database is to execute a certain set of methods. When the SQL is stored in CF, then the user must have permission to select, insert, update delete on every table in your database. (Unless you want to get into the enormous task of specifying each table/privelage seperately) 4. Inline SQL functions. The ability to call custom functions within a query. These are the first 4 that benefits that come to mind, but there are surely more. PL/SQL is a very very very simple language. You can read Oracle Press PL/SQL book in a weekend and become an expert. -Adam On 6/6/05, Aaron Rouse [EMAIL PROTECTED] wrote: What type of advantages does an SP in oracle(or whatever) have over queries for basic DB inserts? On 6/6/05, James Holmes [EMAIL PROTECTED] wrote: I agree here too - I've been writing stored procs (and other PL/SQL) for a few things and I'm eventually going to convert everything I have to them (portability is not an issue for us). A lot of things in PL/SQL are similar to CF, in fact - a PL/SQL table works in a similar way to a CF query for example. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June 2005 1:08 To: CF-Talk Subject: RE: Get New Record ID in ORACLE You don't need to use triggers at all if you use stored procedures: --setup.sql--- CREATE TABLE t ( ID INTEGER NOT NULL, NAME VARCHAR2(50) ); CREATE SEQUENCE s; CREATE OR REPLACE PROCEDURE t_insert (newname IN VARCHAR2, newid OUT INT) AS BEGIN INSERT INTO t (ID, NAME) VALUES (s.NEXTVAL, newname) RETURNING ID INTO newid; END; / --scribble.cfm cfloop collection=#cgi# item=header cfstoredproc procedure=t_insert datasource=trademak cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=newname value=#header# cfprocparam type=Out cfsqltype=CF_SQL_INTEGER dbvarname=newid variable=myNewId /cfstoredproc cfoutput#myNewId#: #header#br/cfoutput /cfloop plus, you can use packages to organize your procedures - either one per table with all CRUD code (many tools can auto generate this for you if you wish) or whatever (i'm a fuseboxer, so i create an [APPCODE]_QUERIES package for selects and an [APPCODE]_ACTIONS package for inserts, deletes, and updates). Many people shy away from stored procs because they think they are complicated, but they aren't and they have many benefits over plain cfquery (IMNERHO). /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208800 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFLDAP - Attributes Empty
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 in this file. (This is an old CFC so forgive any old coding techniques.) M!ke -Original Message- From: Matt Harris [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 9:03 AM To: CF-Talk Subject: Re: CFLDAP - Attributes Empty 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 Groups,DC=halesowen,DC=ac,DC=uk, CN=LESSON_OBS,OU=Intranet Groups,DC=halesowen,DC=ac,DC=uk, CN=STAFF_GROUP,OU=Intranet Groups,DC=halesowen,DC=ac,DC=uk, CN=webtest,CN=Users,DC=halesowen,DC=ac,DC=uk, CN=Account Operators,CN=Builtin,DC=halesowen,DC=ac,DC=uk, CN=Administrators,CN=Builtin,DC=halesowen,DC=ac,DC=uk, CN=web updaters,CN=Users,DC=halesowen,DC=ac,DC=uk, CN=webmaster,CN=Users,DC=halesowen,DC=ac,DC=uk, CN=Domain Admins,CN=Users,DC=halesowen,DC=ac,DC=uk ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208801 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: asynch cfml gateway - working example
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 probably have some place that could make use of such a capability to dramatically make the user experience better. I'm really curious on how this could be accomplished. How can you break up one long running query to run in parallel? The answer is you don't... What he's describing is either executing a long-running query without interrupting page delivery (if the query results aren't needed for display), and/or executing multiple queries simultanously (which may or may not be long running). But as the API for asynch doesn't natively provide the ability to return a response from the gateway to the calling page (something Sean's tools are designed to accomplish), the gateway isn't really designed with the intent of gathering content needed to deliver the current request. Rather it's designed primarily for features such as logging application activity to a database which can sometimes slow page delivery without providing any content for the user during the current request. In a nutshell, the asynch gateway is essentially designed as a fire and forget tool. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208802 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Opera and cookies grrrrrr
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 all cookies set for a domain is a new one (and a bad one IMHO). As a result the site that was having issue is blocking Opera users until we switch it to SESSION vars or another method later. That said there have only been 68 unique Opera visits since May 5, 2004 ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 03, 2005 4:16 PM Subject: Opera and cookies grr Hey All, I've got a situation where Opera won't set a cookie even when others are set.anybody seen it before? THE FLOW: -take form data -stuff into a query using QueryNew() and QuerySetCell() -serialize query using WDDX -stick WDDX packet in a cookie via CFCOOKIE -navigate to next page via CFLOCATION (cookie setting with CFLOCATION not an issue on CFMX 6.1) ISSUE WITH CODE BELOW: COOKIE.UserReg4 will not get set. The same issue arises in other forms with other cookies...code is the same. It all works fine in IE,Safari,FireFox,Netscape. The error does not occur when the cookie is set...just on the next page where it is de-serialized and read (get a not defined error because the cookie doesn't exist). SAMPLE CODE: !--- No errors = Set-up cookies to hold registration data --- cfset qRegInfo1 = QueryNew(Mode,DisCode,UserName,Password,SecurityQ,SecurityA,Salutation,FName,MName,LName,NameSuffix,Gender,Country,DOB) cfset qRegInfo2 = QueryNew(Salutation,FName,MName,LName,NameSuffix,Gender,Country,DOB) cfset qRegInfo3 = QueryNew(Address1,Address2,City,Region,RegionName,PostCode,DayPhone,DayPhoneExt,EvePhone,EvePhoneExt,CellPhone,OthPhone,OthPhoneExt,EMail,ReferralCode,PromoCode,ADTerm,ADFee,OptIn1,OptIn2,OptIn3) cfset qRegInfo4 = QueryNew(RegFee,DisCodeType,RefCredit,RefDiscount,PromoCodeDesc,PromoCredit,ReferringPlan,NewPlanRefCode,NewPlanRefExpiry,NewPlanRefCredit,NewPlanRefDiscount,TotalFees,RecurringBill,NewOrderID) cfset Temp=QueryAddRow(qRegInfo1,1) cfset Temp=QueryAddRow(qRegInfo2,1) cfset Temp=QueryAddRow(qRegInfo3,1) cfset Temp=QueryAddRow(qRegInfo4,1) !--- Set elements in registration cookies. Many elements are set to empty or dummy values since registration is for a TRIAL membership only --- cfset Temp=QuerySetCell(qRegInfo1,Mode,A) cfset Temp=QuerySetCell(qRegInfo1,DisCode,) cfset Temp=QuerySetCell(qRegInfo1,UserName,FORM.txtUName) cfset Temp=QuerySetCell(qRegInfo1,Password,EncPassword) cfset Temp=QuerySetCell(qRegInfo1,SecurityQ,FORM.txtSecurityQ) cfset Temp=QuerySetCell(qRegInfo1,SecurityA,FORM.txtSecurityA) cfset Temp=QuerySetCell(qRegInfo2,Salutation,1) cfset Temp=QuerySetCell(qRegInfo2,FName,Trial) cfset Temp=QuerySetCell(qRegInfo2,MName,) cfset Temp=QuerySetCell(qRegInfo2,LName,User) cfset Temp=QuerySetCell(qRegInfo2,NameSuffix,) cfset Temp=QuerySetCell(qRegInfo2,Gender,FORM.radGender) cfset Temp=QuerySetCell(qRegInfo2,DOB,CreateDate(1900, 1, 1)) cfset Temp=QuerySetCell(qRegInfo2,Country,255) cfset Temp=QuerySetCell(qRegInfo3,Address1,Trial Address) cfset Temp=QuerySetCell(qRegInfo3,Address2,) cfset Temp=QuerySetCell(qRegInfo3,City,) cfset Temp=QuerySetCell(qRegInfo3,Region,) cfset Temp=QuerySetCell(qRegInfo3,RegionName,) cfset Temp=QuerySetCell(qRegInfo3,PostCode,) cfset Temp=QuerySetCell(qRegInfo3,DayPhone,55) cfset Temp=QuerySetCell(qRegInfo3,DayPhoneExt,) cfset Temp=QuerySetCell(qRegInfo3,EvePhone,) cfset Temp=QuerySetCell(qRegInfo3,EvePhoneExt,) cfset Temp=QuerySetCell(qRegInfo3,CellPhone,) cfset Temp=QuerySetCell(qRegInfo3,OthPhone,) cfset Temp=QuerySetCell(qRegInfo3,OthPhoneExt,) cfset Temp=QuerySetCell(qRegInfo3,Email,FORM.txtEMail) cfset Temp=QuerySetCell(qRegInfo3,ReferralCode,) cfset Temp=QuerySetCell(qRegInfo3,PromoCode,) cfset Temp=QuerySetCell(qRegInfo3,ADTerm,1) cfset Temp=QuerySetCell(qRegInfo3,ADFee,0) cfset Temp=QuerySetCell(qRegInfo3,OptIn1,0) cfset Temp=QuerySetCell(qRegInfo3,OptIn2,0) cfset Temp=QuerySetCell(qRegInfo3,OptIn3,0) !--- Serialize registration information into cookies --- cfwddx action=cfml2wddx input=#qRegInfo1# output=reg1 cfwddx action=cfml2wddx input=#qRegInfo2# output=reg2 cfwddx action=cfml2wddx input=#qRegInfo3# output=reg3 cfwddx action=cfml2wddx input=#qRegInfo4# output=reg4 !--- Store serialized packets in cookies --- cfcookie
RE: Calendar
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: CF-Talk Subject: Re: Calendar 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 time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208804 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Unicode and GetProfileString?
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 application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208805 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Opera and cookies grrrrrr
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 are you exceeding 80Kb of cookie storage on the client or are you saying that Opera isn't respecting the 4Kb/20 cookies rule? BTW the only place I can find that backs up what I thought is here... http://www.cgisecurity.com/owasp/html/ch07.html#id2858662 AFAIK cookies are dumped on the LRU algorithm so the oldest one gets replaced every time you issue a new one... Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208806 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
-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 are using a sequence for your IDs, no? DK LOL. Yes i am using sequences for my IDs. I have a sequence called s. This code: cfquery name=nextval datasource=trademak select s.nextval into newid from dual /cfquery fails with error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00905: missing keyword This code: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery works just fine. So i am assuming that you insert a new row like this: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery cfquery name=testinsert datasource=trademak insert into t (id,name) values(#nextval.nextval#,'this is a test') /cfquery i was just wondering whether you had found a way to make select mysequence.nextval into newid from dual work in a cfquery block (like anonymous pl/sql or something). Have you? /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208807 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 wrapped around multiple queries and if one query failed then the others were not commited to the database or a rollback was done. I understand the reasons to the security and the roles, although really how things are setup with the data centers here, neither of them can really apply to us(not to imply that is a good thing). Not really following the inline function comment, probably due to lack of education on them on my part. I know in some cfqueries here there are custom Oracle functions called but it is a very rare thing to see done. On 6/7/05, Adrocknaphobia [EMAIL PROTECTED] wrote: 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 an implied transaction block that the _database_ manages. If your database supports the ability for transaction and locking, CF should really never be used. If you have multiple SQL statements to execute, when in a procedure, it one fails then the actions are not commited to the database. 3. Security. Security. Security. This is by far the biggest and most important aspect of procedures in my opinion. I can't sleep easy at night knowing an application's SQL statements (a roadmap diagraming your database) is stored in open text files on your web server (which is the server most commonly comprimised). Additionaly, with procedures and packages you can start to leverage the role based permission of your database. For instance, the only actions a user is allowed to perform in the database is to execute a certain set of methods. When the SQL is stored in CF, then the user must have permission to select, insert, update delete on every table in your database. (Unless you want to get into the enormous task of specifying each table/privelage seperately) 4. Inline SQL functions. The ability to call custom functions within a query. These are the first 4 that benefits that come to mind, but there are surely more. PL/SQL is a very very very simple language. You can read Oracle Press PL/SQL book in a weekend and become an expert. -Adam ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208808 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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, Aaron Rouse [EMAIL PROTECTED] wrote: 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 wrapped around multiple queries and if one query failed then the others were not commited to the database or a rollback was done. I understand the reasons to the security and the roles, although really how things are setup with the data centers here, neither of them can really apply to us(not to imply that is a good thing). Not really following the inline function comment, probably due to lack of education on them on my part. I know in some cfqueries here there are custom Oracle functions called but it is a very rare thing to see done. On 6/7/05, Adrocknaphobia [EMAIL PROTECTED] wrote: 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 an implied transaction block that the _database_ manages. If your database supports the ability for transaction and locking, CF should really never be used. If you have multiple SQL statements to execute, when in a procedure, it one fails then the actions are not commited to the database. 3. Security. Security. Security. This is by far the biggest and most important aspect of procedures in my opinion. I can't sleep easy at night knowing an application's SQL statements (a roadmap diagraming your database) is stored in open text files on your web server (which is the server most commonly comprimised). Additionaly, with procedures and packages you can start to leverage the role based permission of your database. For instance, the only actions a user is allowed to perform in the database is to execute a certain set of methods. When the SQL is stored in CF, then the user must have permission to select, insert, update delete on every table in your database. (Unless you want to get into the enormous task of specifying each table/privelage seperately) 4. Inline SQL functions. The ability to call custom functions within a query. These are the first 4 that benefits that come to mind, but there are surely more. PL/SQL is a very very very simple language. You can read Oracle Press PL/SQL book in a weekend and become an expert. -Adam ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208809 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF7 and ODBC Connections
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: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. Any ideas? jonese ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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 sql; stmt.execute( #sql# ); stmt.close(); conn.close(); /cfscript worth a try? -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: 07 June 2005 16:27 To: CF-Talk Subject: RE: Get New Record ID in ORACLE -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 are using a sequence for your IDs, no? DK LOL. Yes i am using sequences for my IDs. I have a sequence called s. This code: cfquery name=nextval datasource=trademak select s.nextval into newid from dual /cfquery fails with error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00905: missing keyword This code: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery works just fine. So i am assuming that you insert a new row like this: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery cfquery name=testinsert datasource=trademak insert into t (id,name) values(#nextval.nextval#,'this is a test') /cfquery i was just wondering whether you had found a way to make select mysequence.nextval into newid from dual work in a cfquery block (like anonymous pl/sql or something). Have you? /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208811 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Opera and cookies grrrrrr
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 are you exceeding 80Kb of cookie storage on the client or are you saying that Opera isn't respecting the 4Kb/20 cookies rule? BTW the only place I can find that backs up what I thought is here... http://www.cgisecurity.com/owasp/html/ch07.html#id2858662 AFAIK cookies are dumped on the LRU algorithm so the oldest one gets replaced every time you issue a new one... Paul Hey Paul, Not sure of exact sizes involvedall I can say is that Opera won't set some of the cookies that need to be setand that IE/Netscape/and many others don't have a problem. So I'm not sure if Opera is adhering to the rules or if the others are breaking them ;-) Each cookie holds a WDDX packet that contains either an empty recordset or a recordset with 1 record. It's all basic registration type info (contact info, promo code details, and some other fluff)so not huge data...but yes...enough to overload a single cookie (that's why it's broken into 4). So I'm nowhere near the max number of cookies. Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208812 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Session Timeout
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 SESSIONTIMEOUT=#CreateTimeSpan(0, 1, 0, 0)# CFIF NOT IsDefined(Session.LoggedIn) CFLOCATION URL=../index.cfm /CFIF Following code is executed when a user logs in. CFLOCK SCOPE=Session TIMEOUT=2 TYPE=EXCLUSIVE CFSET Session.LoggedIn = Yes /CFLOCK By the way, the default session timeout is 60 minutes on the server and I am using Coldfusion 5. Thanks. David ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208813 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Opera and cookies grrrrrr
-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 cookies per domain, therefore giving a total of 80Kb of cookie storage are you exceeding 80Kb of cookie storage on the client or are you saying that Opera isn't respecting the 4Kb/20 cookies rule? You've got that a bit backwards. To quote RFC 2965: 5.3 Implementation Limits Practical user agent implementations have limits on the number and size of cookies that they can store. In general, user agents' cookie support should have no fixed limits. They should strive to store as many frequently-used cookies as possible. Furthermore, general-use user agents SHOULD provide each of the following minimum capabilities individually, although not necessarily simultaneously: * at least 300 cookies * at least 4096 bytes per cookie (as measured by the characters that comprise the cookie non-terminal in the syntax description of the Set-Cookie2 header, and as received in the Set-Cookie2 header) * at least 20 cookies per unique host or domain name User agents created for specific purposes or for limited-capacity devices SHOULD provide at least 20 cookies of 4096 bytes, to ensure that the user can interact with a session-based origin server. The information in a Set-Cookie2 response header MUST be retained in its entirety. If for some reason there is inadequate space to store the cookie, it MUST be discarded, not truncated. Applications should use as few and as small cookies as possible, and they should cope gracefully with the loss of a cookie. 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. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCpcEdmSWF0pzlQ04RAp77AJ9/mI5gN+jMK6iuyg7ePEEVYx4OjgCgpMbm u+SAPGB8USdJXuF2O0Q4R0E= =Glx9 -END PGP SIGNATURE- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208814 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 complex in Oracle. We also do not have access to any of the administrative side of things, typically a web application has a user in Oracle that would appear to have full access to that tablespace, although I do know when I was tried to create a type it did not have permissions but their fix was simply to grant that permission to all users. That same user is what is used by the CF server connection. I do believe I was saying simple inserts and updates, I just have to wonder what in the world people are collecting through a web interface that requires complex inserts and updates. Now some of the select queries, such as for some of the reports I would not label simple, not sure if I would use complex either but that is why I tried not to specify select queries. I was just trying to verify on cftransaction, the first email implied to me that the only way it could be done was through a stored procedure. On 6/7/05, Adrocknaphobia [EMAIL PROTECTED] wrote: 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208815 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Opera and cookies grrrrrr
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 minimumbut I think it's a widely used minimum ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com/54 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208816 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 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 errors with Access because the cfsqltype in many cases is not the same for Access as it is for the other databases. For example: Using a data type: number field size: Long Integer throws an error Database reported: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented if the cfsqltype is CF_SQL_INTEGER. If I change the cfsqltype to CF_SQL_NUMERIC it works fine. Another example: 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. I know most will agree Access is from the database of choice, so my question is should we support Access considering the challenge, or drop support? To be honest, I cannot imagine a forum actually being used in a production environment using Access. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208817 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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 into newid from dual; etc END; but I don't know why you would bother. Since you need the PL/SQL block you may as well store the prodecure instead so you can get back the id, which was the point in the first place. Or just use the two queries like cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery cfquery name=testinsert datasource=trademak insert into t (id,name) values(#nextval.nextval#,'this is a test') /cfquery as mentioned earlier. -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June 2005 11:37 To: CF-Talk Subject: RE: Get New Record ID in ORACLE 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 sql; stmt.execute( #sql# ); stmt.close(); conn.close(); /cfscript worth a try? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208818 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 side will actually lock rows and the specific data being updated. CF doesnt have that level of power, all its basically doing is pausing all other requests, not locking rows. They are almost two completely different functions. -Adam On 6/7/05, Aaron Rouse [EMAIL PROTECTED] wrote: 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 complex in Oracle. We also do not have access to any of the administrative side of things, typically a web application has a user in Oracle that would appear to have full access to that tablespace, although I do know when I was tried to create a type it did not have permissions but their fix was simply to grant that permission to all users. That same user is what is used by the CF server connection. I do believe I was saying simple inserts and updates, I just have to wonder what in the world people are collecting through a web interface that requires complex inserts and updates. Now some of the select queries, such as for some of the reports I would not label simple, not sure if I would use complex either but that is why I tried not to specify select queries. I was just trying to verify on cftransaction, the first email implied to me that the only way it could be done was through a stored procedure. On 6/7/05, Adrocknaphobia [EMAIL PROTECTED] wrote: 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208820 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 have to use SP. I also use them for things like nested set models. I also have several custom functions that I use for formatting, for instance, an employee's name - something I do over and over and it's so much easier to just say formatfullname(personid) than the case statement it would otherwise require. A lot of the more complicated stuff goes unused around here, too. I think we'd use more of it if we had app developers dedicated to doing Oracle work. But, we don't. I'm about as close as it gets in our little shop, and I fully admit there's boatloads of stuff I don't know yet. On 6/7/05, Aaron Rouse [EMAIL PROTECTED] wrote: 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 complex in Oracle. We also do not have access to any of the administrative side of things, typically a web application has a user in Oracle that would appear to have full access to that tablespace, although I do know when I was tried to create a type it did not have permissions but their fix was simply to grant that permission to all users. That same user is what is used by the CF server connection. I do believe I was saying simple inserts and updates, I just have to wonder what in the world people are collecting through a web interface that requires complex inserts and updates. Now some of the select queries, such as for some of the reports I would not label simple, not sure if I would use complex either but that is why I tried not to specify select queries. I was just trying to verify on cftransaction, the first email implied to me that the only way it could be done was through a stored procedure. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208821 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session Timeout
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: Tuesday, 7 June 2005 11:46 To: CF-Talk Subject: Session Timeout 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 SESSIONTIMEOUT=#CreateTimeSpan(0, 1, 0, 0)# CFIF NOT IsDefined(Session.LoggedIn) CFLOCATION URL=../index.cfm /CFIF Following code is executed when a user logs in. CFLOCK SCOPE=Session TIMEOUT=2 TYPE=EXCLUSIVE CFSET Session.LoggedIn = Yes /CFLOCK By the way, the default session timeout is 60 minutes on the server and I am using Coldfusion 5. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208822 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Calendar
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 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: CF-Talk Subject: Re: Calendar 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 time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208823 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Should we support Access?
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 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 errors with Access because the cfsqltype in many cases is not the same for Access as it is for the other databases. For example: Using a data type: number field size: Long Integer throws an error Database reported: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented if the cfsqltype is CF_SQL_INTEGER. If I change the cfsqltype to CF_SQL_NUMERIC it works fine. Another example: 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. I know most will agree Access is from the database of choice, so my question is should we support Access considering the challenge, or drop support? To be honest, I cannot imagine a forum actually being used in a production environment using Access. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208824 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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 2005 12:06 To: CF-Talk Subject: Re: Get New Record ID in ORACLE 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 side will actually lock rows and the specific data being updated. CF doesnt have that level of power, all its basically doing is pausing all other requests, not locking rows. They are almost two completely different functions. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208825 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 PL/SQL block you may as well store the prodecure instead so you can get back the id, which was the point in the first place. Or just use the two queries like ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208826 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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: Wednesday, 8 June 2005 12:16 To: CF-Talk Subject: Re: Get New Record ID in ORACLE 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 PL/SQL block you may as well store the prodecure instead so you can get back the id, which was the point in the first place. Or just use the two queries like ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208827 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Should we support Access?
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 anyway, so why bother. After some thought, though, if it does not warrant a lot of development time, maybe you should. Here is an anlogy. Let's say I make golf balls. Would I want to design a golf ball that only works with pro-line golf clubs? Probably not. I would want it to work well with any type of equipment. After all, can one play golf with the $50 complete golf club set (with bag) from Wal-Mart? Yes. Is it more advantageous to use better equipment? Absolutely. Can one use Access for a web application? Yes Is it more advantageous to use a better DB? Absolutely. While Access may be misused as the backend for web applications, it is also the starting of point for a lot of developers, it might not be a good idea to segregate that part of the population. On 6/7/05, Stan Winchester [EMAIL PROTECTED] wrote: 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 errors with Access because the cfsqltype in many cases is not the same for Access as it is for the other databases. For example: Using a data type: number field size: Long Integer throws an error Database reported: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented if the cfsqltype is CF_SQL_INTEGER. If I change the cfsqltype to CF_SQL_NUMERIC it works fine. Another example: 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. I know most will agree Access is from the database of choice, so my question is should we support Access considering the challenge, or drop support? To be honest, I cannot imagine a forum actually being used in a production environment using Access. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208828 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JOIN help
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 tables. Really, I'm just trying to have the email address from the registration DB as part of the returned information. I was following a tutorial and it said to make sure the primary keys are =. Here's the tutorial I was using: http://www.w3schools.com/sql/sql_join.asp Is this not right? I'm always interested in learning. Ahh okay... you seem to have misread the tutorial a bit... I think Deanna Schneider already posted this, but here's my nutshell synopsis just in case you missed hers. The primary key (PK) on a given table uniquely identifies each record in that table with the purpose being that the PK can then be used for updates, deletions or foreign key references / constraints to that table. So when you want to join a second table, the 2nd table needs to have a foreign key (FK) column containing the same value as the PK column in the 1st table... So typically the join would look like this: cs.case_study_id = er.case_study_id You still want the registration_id (PK) in the ER table to uniquely identify the registration, but you need the extra er.case_study_id column (not a primary key) in order to create the cross-reference between ER and ECS... In simple terms, you can think of it as a parent-child sort of relationship (it's not, but bear with me), where the parent needs an identifying name (primary key) and the child also needs an identifying name (PK) so that when other people are talking about them, there's no confusion about whether the parent (Bruce) or the child (Brandon) is being referenced. Now when someoen asks who is Brandon's parent? of course, you don't answer Brandon, you answer Bruce. The foreign key column in the ER table is where you store that information about the other table -- the parent or, in this case Bruce Lee. Although -- to complicate matters. :) It sounds like you may actually be wanting a 3-table schema where ECS contains case studies, ER contains registrants and Empower_Case_Study_Registrants (ECSR) could indicate which registrants are registered to which case studies (since you don't want multiple records for each registrant if a registrant can participate in multiple studies). In this case the ECSR table would contain only the two foriegn key columns to both the ECS and ER tables. cs.case_study_id = ecsr.case_study_id er.registrant_id = ecsr.registrant_id This is what's called a many-to-many relationship, as opposed to the one-to-many relationship I described a minute ago re: parents... and is actually more like human parent-child relationships, as in a well-designed database, a child would have 0 or more guardians and each guardian would have 0 or more children. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208829 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Should we support Access?
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 few other things I'm forgetting (blocking?). I wouldn't bother to take them into account for something like this, but that's me. Matt Osbun Web Developer Health Systems, International -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 11:13 AM To: CF-Talk Subject: Should we support Access? I know most will agree Access is from the database of choice, so my question is should we support Access considering the challenge, or drop support? To be honest, I cannot imagine a forum actually being used in a production environment using Access. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208830 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: asynch cfml gateway - working example
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 applications, in fact, would probably have some place that could make use of such a capability to dramatically make the user experience better. I'm really curious on how this could be accomplished. How can you break up one long running query to run in parallel? The answer is you don't... What he's describing is either executing a long-running query without interrupting page delivery (if the query results aren't needed for display), and/or executing multiple queries simultanously (which may or may not be long running). But as the API for asynch doesn't natively provide the ability to return a response from the gateway to the calling page (something Sean's tools are designed to accomplish), the gateway isn't really designed with the intent of gathering content needed to deliver the current request. Rather it's designed primarily for features such as logging application activity to a database which can sometimes slow page delivery without providing any content for the user during the current request. In a nutshell, the asynch gateway is essentially designed as a fire and forget tool. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208832 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Should we support Access?
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 with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208831 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
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 excuse to use oracle and it's actually fun. Twisted and bizarre fun, but fun. If you're gonna work with it anyway, you might as well use the opportunity to beef up your cv, it never hurts. /t -Original Message- Subject: Get New Record ID in ORACLE From: Aaron Rouse [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 10:48:52 -0500 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#208815 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 complex in Oracle. We also do not have access to any of the administrative side of things, typically a web application has a user in Oracle that would appear to have full access to that tablespace, although I do know when I was tried to create a type it did not have permissions but their fix was simply to grant that permission to all users. That same user is what is used by the CF server connection. I do believe I was saying simple inserts and updates, I just have to wonder what in the world people are collecting through a web interface that requires complex inserts and updates. Now some of the select queries, such as for some of the reports I would not label simple, not sure if I would use complex either but that is why I tried not to specify select queries. I was just trying to verify on cftransaction, the first email implied to me that the only way it could be done was through a stored procedure. On 6/7/05, Adrocknaphobia [EMAIL PROTECTED] wrote: 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208833 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Should we support Access?
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 maxlengths at the db level -- i use them at the form level... and of course, you can easily left() those values before executing the query. I know most will agree Access is from the database of choice, so my question is should we support Access considering the challenge, or drop support? To be honest, I cannot imagine a forum actually being used in a production environment using Access. I loathe it... but I have seen it in use in production for more than just forums... I don't like contributing to the myth that it's generally okay to develop projects with Access... that being said, my framework still supports it. I haven't run into the issue with long-integer... when I create tables I generally create the tables with script using columnname int [not] null. I don't remember if Access treats that as a long integer... I support Access primarily because I don't want to alienate the people who use it -- though there's less need now that there's a free version of SQL Server. I will admit there are some squirrelly issues with the cfsqltype attribute of cfqueryparam. I created a function in the framework which accepts a number of different possible values as the target column type (clob,text,nvarchar,etc) and converts those values into the appropriate cfsqltype -- I haven't (yet) needed to declare different cfsqltype values per database server. But then the framework also gets db metadata from JDBC which is used to automate inserts and updates so I don't use any hand-coded ad-hoc SQL and so am never writing out cfqueryparam tags either. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208834 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX7 and COM
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: AutomationException: 0x80010105 - The server threw an exception.. Any ideas? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208835 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX7 and COM
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 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: AutomationException: 0x80010105 - The server threw an exception.. Any ideas? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208836 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 much intense with it from what I can tell. On 6/7/05, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: 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 excuse to use oracle and it's actually fun. Twisted and bizarre fun, but fun. If you're gonna work with it anyway, you might as well use the opportunity to beef up your cv, it never hurts. /t ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208837 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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 variables in CF, it has no effect on a database at all. Say you have a procedure that updates rows in a table. While that procedure is running, those rows are locked. Meaning if any request is made on those rows, that request must wait until the procedure completes (ie. issues a transparent commit). -Adam On 6/7/05, James Holmes [EMAIL PROTECTED] wrote: 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 2005 12:06 To: CF-Talk Subject: Re: Get New Record ID in ORACLE 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 side will actually lock rows and the specific data being updated. CF doesnt have that level of power, all its basically doing is pausing all other requests, not locking rows. They are almost two completely different functions. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208838 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get New Record ID in ORACLE
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- 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 are using a sequence for your IDs, no? DK LOL. Yes i am using sequences for my IDs. I have a sequence called s. This code: cfquery name=nextval datasource=trademak select s.nextval into newid from dual /cfquery fails with error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00905: missing keyword This code: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery works just fine. So i am assuming that you insert a new row like this: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery cfquery name=testinsert datasource=trademak insert into t (id,name) values(#nextval.nextval#,'this is a test') /cfquery i was just wondering whether you had found a way to make select mysequence.nextval into newid from dual work in a cfquery block (like anonymous pl/sql or something). Have you? /t ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208819 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFORM - Can I start using it again?
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: 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 to use again? Are people using it for non-Rich/XForm code? Is the JavaScript better? etc. etc I'm curious what people's experiences with it are. Thanks, Evan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208839 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Calendar
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 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 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: CF-Talk Subject: Re: Calendar 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... ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208840 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
FW: Get New Record ID in ORACLE
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 ORACLE -Original Message- Subject: Get New Record ID in ORACLE From: Adrocknaphobia [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 10:51:35 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#208800 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. That's not a completely fair or accurate point: the second execution of a stored procedure will be much faster than the second execution of a cfquery assuming that the cfquery doesn't use bind variables and is being run with different parameters. Otherwise, the db will reuse the stored query plan and the time difference won't be *that* great. The reason i want to point this out is that a lot of people think SP's are complicated but they're fast, so they tend to see them as a kind of optimization technique... and then they get disappointed when switching to SP's doesn't magically deliver much faster execution time. If all you're after is speed and scalability then a) spend some time learning how to write correct sql and b) use cfqueryparam. 2. Transaction and Locking. A procedure is an implied transaction block that the _database_ manages. If your database supports the ability for transaction and locking, CF should really never be used. If you have multiple SQL statements to execute, when in a procedure, it one fails then the actions are not commited to the database. True enough, but then again that's what cftransaction is for. You could counter with savepoints and autonomous transactions but then we're really getting into edge cases. 3. Security. Security. Security. This is by far the biggest and most important aspect of procedures in my opinion. I can't sleep easy at night knowing an application's SQL statements (a roadmap diagraming your database) is stored in open text files on your web server (which is the server most commonly comprimised). Additionaly, with procedures and packages you can start to leverage the role based permission of your database. For instance, the only actions a user is allowed to perform in the database is to execute a certain set of methods. When the SQL is stored in CF, then the user must have permission to select, insert, update delete on every table in your database. (Unless you want to get into the enormous task of specifying each table/privelage seperately) +1. The number of people who connect their web application to their database as a user with dba privs is amazing. There are two aspects to sql injection attacks: people putting junk data into your tables... and people damaging your database (dropping tables, deleting records, etc). In most cases, the user your web app connects as has no business being allowed to drop or create objects. SP's are a great way to grant explicit object level privs to the web app user without having to even use the db privs system: they can only do those things you gave them a proc to do. 4. Inline SQL functions. The ability to call custom functions within a query. yess, but: you could write functions in pl/sql and call them from within a query in a cfquery block. These are the first 4 that benefits that come to mind, but there are surely more. PL/SQL is a very very very simple language. You can read Oracle Press PL/SQL book in a weekend and become an expert. -Adam My favorite stored proc feature is that when i change a database table i immediately know which procs need to be updated at the press of a button, without having to test my whole web app. My second favorite feature is that i know where all my sql is. To be more explicit on the book end: check out the book Learning Oracle PL/SQL from O'Reilly and hold off on the two other fuerenstein books - you can easily read that in a weekend and it will cover everything almost everybody needs to know for a long long time. /t ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208841 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMX7 and COM
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: Paolo Piponi [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 11:54 AM To: CF-Talk Subject: CFMX7 and COM 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: AutomationException: 0x80010105 - The server threw an exception.. Any ideas? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208842 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFORM - Can I start using it again?
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: http://www.massimocorner.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208843 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JOIN help
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 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 = er.studyid Does that make sense? On 6/7/05, daniel kessler [EMAIL PROTECTED] wrote: ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208844 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Currency data type in access
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 and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208845 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Should we support Access?
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 Access and promote MySQL as the best option for the cheap option. Taken one step further, I would do all of my DB work using CFSTOREDPROC (which means only supporting MySQL 5), that way the database-specific portions of the app could stay with the database. Pete ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208846 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Hey. About your access post.
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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Currency data type in access
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 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 and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208848 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Hey. About your access post.
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, 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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208849 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Currency data type in access
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 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208850 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FW: Get New Record ID in ORACLE
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 Oracle through cfquery, whereas a stored proc call is alot less code. So network latency comes into play a bit. We havent mentioned database error handling which is another benefit of stored procs. User defined errors, strong datatyping and logging. That's not a completely fair or accurate point: the second execution of a stored procedure will be much faster than the second execution of a cfquery assuming that the cfquery doesn't use bind variables and is being run with different parameters. Otherwise, the db will reuse the stored query plan and the time difference won't be *that* great. The reason i want to point this out is that a lot of people think SP's are complicated but they're fast, so they tend to see them as a kind of optimization technique... and then they get disappointed when switching to SP's doesn't magically deliver much faster execution time. If all you're after is speed and scalability then a) spend some time learning how to write correct sql and b) use cfqueryparam. I've said this above, but cftransaction is drastically different than the transaction in a database. Plus it really doesnt fit well in an MVC pattern. Again, cftransaction doesnt give you row level locking. Which is pretty key in a database transaction. If you had two applications using the say schema. Both apps in CF, running seperate instances or using two seperate DSNs. They know nothing of each other transactions. You are going to end up with race conditions, which is what the transaction in the database will prevent. True enough, but then again that's what cftransaction is for. You could counter with savepoints and autonomous transactions but then we're really getting into edge cases. I know it's sad really. If you are using CFquery in that manner, if someone has access to execute code on your webserver, they can take complete control over your database (which may even be outside of a DMZ behind a firewall). I'm not saying I've done this, but once you gain access to the box, with a few lines of code you can either pull the u/p out of the dsn, or just execute whatever you want through that dsn. +1. The number of people who connect their web application to their database as a user with dba privs is amazing. There are two aspects to sql injection attacks: people putting junk data into your tables... and people damaging your database (dropping tables, deleting records, etc). In most cases, the user your web app connects as has no business being allowed to drop or create objects. SP's are a great way to grant explicit object level privs to the web app user without having to even use the db privs system: they can only do those things you gave them a proc to do. True enough. yess, but: you could write functions in pl/sql and call them from within a query in a cfquery block. One more thing I almost forgot that has just become second nature. Session state! When a user connects to oracle and calls any procedure in a package, the begin block of the package executes (much like init()) Each user gets thier own version of the entire package stored in session. There are also the OO benefits. -Adam ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208851 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Calendar
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 with a MSAccess 97 database. This calendar has a single user login to add/edit data. The FULL version offers the features of the LITE version and has many more features, like multiple users document uploading and the option to make events only appear for certain users. This one starts at $39.99 To view the demo go here: http://www.bensonITsolutions.com And click into the calendar demo. This also has more information on the differences between the LITE and FULL versions. Other notes: Currently the image display is not working in the lite version(on the demo only), but this does work in the full version. You can change the color style sheet to one of several preset ones by changing a variable in the application file. The directory path and data source info are also here for easy configuration. Both products are open source, non encrypted coldfusion calendars that are easy to modify and fit into your site. These have not been completely tested with cf7, but should work ok. Support for basic questions is available via email. Let me know if you have any questions, Greg ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208852 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFLOGIN TIMEOUT WARNING?
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. Thus, my problem appears if the user has multiple windows open. I was wondering if it is possible to display a warning to the user if they are inactive in all windows after a certain period of time. Any suggestions would be greatly appreciated. Thanks in advance, Daves ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208853 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Should we support Access?
-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 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 errors with Access because the cfsqltype in many cases is not the same for Access as it is for the other databases. For example: For me it would depend on how easy it is to change DBs. I prefer to put all my DB logic in distinct broker components - a separate library for each persistence layer. In this case, considering the problems you've described, I could just not use CFQUERY param for the Access brokers (or figure out the types) and it wouldn't affect anything else. By the same token you create a broker layer to access LDAP or XML files rather than a database if you wanted to - none of the other code changes. If possible I would try to support Access for a commercial project. For several reasons: 1) Before buying or implementing a lot of people like to set up a playground first - for a lot of Windows CF developers they use Access for this evaluation. 2) By the same token Access is often used as a cheap development environment. 3) There are still people building tiny intranet applications who use nothing but Access. To be honest there are still people building big Internet applications using Access. ;^) But if it's hard to add support then don't - wait for a request or three. Jim Davis ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208854 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
FEDEX and CF
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, check off the ones to ship, enter some details (everything to this point we will custom build), and then produce labels and get the orders into the FedEx system. We've had a quick look at these 2: 1. CFX_FEDEX from Adiabata. 2. The Fedex component from Apok Technology. Any opinions on the 2 above, or other suggestions are greatly appreciated. TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208855 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[best practice] altering arguments
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 newline, has a
and goes on till a newline or a carriage return. Other quote delimiters are not
taken into effect.
arguments.localbody=REReplace(arguments.localbody,
'[\n]+([^\n\r]*[\n\r]*){8,}', '', 'all');
Now here's the question. Is it better style and/or performance wise to create a
local variable to manipulate or to manipulate the argument directly?
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208856
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [best practice] altering arguments
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 declare a local variable with the same name
as an argument: it's already declared implicitly by CF.
I personally NEVER use the arguments qualifier, thereby ensuring that
I'm always dealing with the local variables. It's easier to spot
arguments. where it shouldn't be, than it is to spot a missing one.
You do have to use the arguments scope for structKeyExists calls for
non-required args that don't specify a default, but that's the only
place you need it, at least in my book.
cheers,
barneyb
On 6/7/05, Michael Dinowitz [EMAIL PROTECTED] wrote:
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 newline, has a
and goes on till a newline or a carriage return. Other quote delimiters are
not taken into effect.
arguments.localbody=REReplace(arguments.localbody,
'[\n]+([^\n\r]*[\n\r]*){8,}', '', 'all');
Now here's the question. Is it better style and/or performance wise to create
a local variable to manipulate or to manipulate the argument directly?
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 50 invites.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208857
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get New Record ID in ORACLE
-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 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. Not if you use bind variables - in fact, that's the whole point of bind variables: you are telling the db this is the same query i just ran, but for different values, so go ahead and re use the same query plan from the shared pool. snip I've said this above, but cftransaction is drastically different than the transaction in a database. Plus it really doesnt fit well in an MVC pattern. Again, cftransaction doesnt give you row level locking. Which is pretty key in a database transaction. If you had two applications using the say schema. Both apps in CF, running seperate instances or using two seperate DSNs. They know nothing of each other transactions. You are going to end up with race conditions, which is what the transaction in the database will prevent. not too sure i understand what you mean here. CF (used without cftransaction) has a dirty habit of committing after each and every cfquery, whereas as you pointed out cftransaction just delays the commit, which allows oracle to manage the transaction. Oracle will lock the rows you are updating and will place a ROW SHARE TABLE lock on the table to make sure nobody else can change the structure of the table. But if the two sessions want to change different rows in the same table there should be no problem. Are you sure you aren't thinking of deadlocks - where two sessions both need the other to commit before being able to continue - the famous user 1 updates A, user 2 updates B, user 1 updates B (has to wait for user 2 to commit - blocked but not deadlocked), user 2 updates A (has to wait for user 1 to commit... bingo deadlock)? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208858 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX 6.1 Mail Spooler Problem
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 (every 15 minutes). But does not fix the problem (whatever it is). The mail.log messages vary from Spooler Locked to 451 Timeout waiting for client input. There are also some normal messages like invalid address, etc. I have two hours worth of email (about 180 files) sitting in their right now. Any ideas what I should do here? Josen http://ww.gomotorbids.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208859 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Duplex Printing with ColdFusion
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! http://discover.yahoo.com/weekend.html ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208860 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Hey. About your access post.
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: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 1:36 PM To: CF-Talk Subject: Hey. About your access post. 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208861 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Should we support Access?
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 your code (most of which revolve around inserting conditional code that inserts the nextval of a sequence when creating a new record... no big deal. Plus you have to take care to adjust cfqueryparam so it uses the null parameter when appropriate rather than allowing an empty string). The point behind this is to open yourself up to as many potential -- paying -- customers as possible. The small guy just starting out has money just as green as the corporate guy. The same goes for the large university or public agency running Oracle. Both of those sales put your programming expertise and products in front of people who could perhaps use your services for additional work. Writing for Access is a bit of a challenge. Off the top of my head: values like record IDs are returned with a single decimal no matter what you do. Record ID 123 will arrive from Access as 123.0 no matter what your settings are in the db for the field. So as a habit I fix() every value where this can be an issue. Access will explode on contact with ANY date field when you try to use cfqueryparam on it. None of the cfsqltypes work so you have to write your code with this in mind and protect yourself in other ways. cf_sql_numeric is the safe cfsqltype to work with integer *and* decimal values for all four platforms except SQL Server, which requires cf_sql_decimal if decimals are in use. Otherwise cf_sql_numeric is universal. cf_sql_varchar is universal for ntext/varchar type fields on all platforms. cf_sql_longvarchar is the one for all memo/clob type long text fields. Just like Isaac, I never use the length parameter in cfqueryparam and enforce this in other ways. Thats not so much, really, when it comes to supporting Access. The only other element is I write auto-installers for my system, which include table/index/sequence builders. So I have to write Create Table statements for each platform, as well as Alter Table statements for the upgraders. The syntax for these varies quite a bit. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208862 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
My attempt at a shopping cart
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 i doing wrong? Thanks, Phil ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208863 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: My attempt at a shopping cart
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 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 i doing wrong? Thanks, Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
