RE: Alternatives to Verity
Just so's you know: this Lindex (I posted about it a little while ago).The CFDJ article was working off the fact that it was shipped with the DevNet Resource Kit 3. Note that you don't NEED the DRK to use it (the product itself is open-source) but the DRK does have some nice tools and docs about it. Jim Davis -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 1:57 AM To: CF-Talk Subject: RE: Alternatives to Verity Eric, There have been a few articles in recent CFDJ's that discuss a JAVA alternative to VERITY.I don't recall the name of the program or the CFDJ issues off hand, but if you don't find the information on the CFDJ site (www.sys-con.com http://www.sys-con.com/ ) contact me off list and I'll try to dig up the information for you. Thank you, Jason Egan CFDynamics.com -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Sunday, October 12, 2003 1:16 PM To: CF-Talk Subject: Alternatives to Verity WE have been having terrible times with our Verity collections corrupting, being unable to update etc at our host and am looking for alternatives. It simply queries a database and a lot of fields, some quite lengthy...so not sure a simply SQL query is an option, but are there other solutions everyone is using for higher end and more robust searches of your sites? Thanks for any pointers in advance! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ACL database design
Hi, I am trying to set up a fairly advanced security/rights/permissions system for a web-app. I am having some trouble just to figure out how to set up the database with a list of rights, groups and users. I would to set up the groups in a parent/child relationship that inherit rights, and I would like the number of childs to be indefinate. Any tips? Thanks, Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Coldfusion VS Zope (Python) ... HELP!!
A factor to take into account: reuse. If you code in CF you might be able to reuse snippets/tags/udf:s/cfc/circuits/fuses, which you won't be able to if you shift to alternative technology X. If you shift your whole shop to Zope/Python, then it would make sense though (future apps would reuse the code/experiences from the first app). /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: brob [mailto:[EMAIL PROTECTED] | Sent: Friday, October 10, 2003 18:25 | To: CF-Talk | Subject: Re: Coldfusion VS Zope (Python) ... HELP!! | | | Not only is he non technical, but also non logical.Even if | it's true that you can build applications faster in Zope, you | still have to factor in the time it will take you/your team | to learn it and get to know the ins and outs of it. | |- Original Message - |From: Glen Salisbury |To: CF-Talk |Sent: Friday, October 10, 2003 9:50 AM |Subject: Coldfusion VS Zope (Python) ... HELP!! | | |Hey everyone. | |I've currently been asked by my boss to do a large | application in Zope. |(www.zope.org) | |We always done Coldfusion but despite the fact that he is | not technical, |he's certain that the project we are doing could be built faster in |Zope.Despite that I've already made a case that Zope | market is tiny, |(try doing a job search on it) and that none of the dev | team knows Python |(yet). |Does anyone have any pros / cons that are fact based that a | case could be |made |either way? | |Has anyone here coded in Python? If so which is faster to code in? | |Thanks for your input. | |- Glen Salisbury |Application Engineer | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date Picker
Yeps it is, and if you decide to use it, might I sugget you throw a donation his way? - Calvin - Original Message - From: Lists2 - TriPointTek To: CF-Talk Sent: Sunday, October 12, 2003 7:41 PM Subject: Re: Date Picker jon hall wrote: http://dynarch.com/mishoo/calendar.epl If you have any questions on how to make certain days unselectable let me know...I had to do it for this calendar recently. It has a built in way to enable it, but it's not obvious at first glance. -- That is a sweet calendar. Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ACL database design
ot that i have much experience in this, but here's a shot. I'm assuming that users dont have any rights unless they belong to a group.Also asumme that it's a 1 level parent/child scheme (like, just parent and many childs, not grandparents or great-great grandchildren).but that wont make a diffenrece.It's just my brain isn't evolved enough to understand how that works lol. Also using the table below, one user can belong to many groups. Rights id descr Users id--key to id in tbl_groups_rights f_name l_name other Info Groups id parent_id --key to id in tbl_groups (all top level groups (first parents) get parent_id 0) group_name description user_groups id ---key to id in group_rights users_id---key to id in tbl_users groups_id ---key to id in tbl_groups group_rights id ---key to id in user_groups rights_id --key to id in tbl_rights group_id ---key to id in tbl_groups description So lets say the user logs into the admin or whatever.you need to do 2 queries regarding the roles.you first query the ids of the groups it's in and get the rights_id belonging to that group. Append those ids to a session list or cookie or sumthin.Then you query for the Ids of the parents of that group (if the parent's ID is 0, then it means it has no parents), and get the rights belonging to those parents.Then append those ids to the previous list Now on your templates, you just need to write code to allow that person to do whatever according to what ids they have.That will mean u have to hard code the IDs to the conditions on those pages tho, which will be hard to maintain and keep track of.make another template that has all of the rights ID queried from tha databse) and assign them to variables.Then just include that template on your pages.And on those pages (or parts of the page), I would say if list doesn't contain X or Z, then don't show stuff below or goto error. - Original Message - From: Hugo Ahlenius To: CF-Talk Sent: Monday, October 13, 2003 2:18 AM Subject: ACL database design Hi, I am trying to set up a fairly advanced security/rights/permissions system for a web-app. I am having some trouble just to figure out how to set up the database with a list of rights, groups and users. I would to set up the groups in a parent/child relationship that inherit rights, and I would like the number of childs to be indefinate. Any tips? Thanks, Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Survey: Open Source CF Stuff (was
#5...I'd be happy to contribute to a worthwhile project., but I dont have enough time (or project management experience) to dedicate to managing a project. Almost all of the successful open source projects have some kind of corporate sponsorship, This only tends to be required for the larger, actively developed, code bases.Coordinating a lot of contributors and ensuring the quality of the contributions is time consuming.Smaller, more task specific projects never normally require these overheads. even if the original source was developed for a specific business reason, then open sourced, or a corporation wants to take advantage of the free labor. FarCry, Mozilla, Linux, OpenOffice, MySQL, etc., all have corporations backing them in one way or another to help manage the direction of the project. Who in the CF world has the motivation to invest the resources necessary? Well clearly our company does.Daemon manages all the resources behind FarCry CMS (http://farcry.daemon.com.au/).Seeing as it's more than likely the largest open source code base in our community I guess we have a particularly positiveview on CF community development. Another barrier is that CF itself is closed source, and developers have no clear cut guarantee that the platform will exist in the future. Unlike with PHP where developers know it will exist, or .Net where developers know MS isn't going anywhere. There is already a significant amount of CF opensource out there.Look at http://www.cflib.org/ or the MM Developers exchange.Look at the multitude of CF related blogs with there offering of tips and code: http://www.fullasagoog.com/But perhaps more significantly, CF developers can participate in most Java based open source projects. CF is in many respects much more feature complete than things like PHP and .NET. There are many things that just don't need building cos they already come out of the box -- many CF features already leverage open source community code: eg. XALAN (XML), AXIS (web services) and so on. This is an interesting thread... I'm surprised more people haven't weighed in. -- geoff bowers Daemon Internet Consultants Sydney, Australia http://www.daemon.com.au/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Creating Word Doc
Mr Forta's Advanced ColdFusion MX App Developement book has a good section on this sort of thing. Also I think there are some articles on Macromedia have a look. -Darren Adams -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 11 October 2003 20:57 To: CF-Talk Subject: Creating Word Doc I'm trying to use the information in the database to generate contracts in MS word.Can anyone here refer me to some tutorials or to some custom tags to help out with this process Dwayne Cole, MS in MIS, MBA Certified Advanced ColdFusion Developer 850-591-0212 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ACL database design
Thanks, I actually had in mind an unlimited parent/child relationships in the groups. So that the super-parent would be the Admin group, that all other groups are derived from, like superusers inherit the rights from the admin group, but with rights X,Y Z revoked. And the regular users group is a child of the superusers group, etc. In addition, a user should be able to have specific rights assigned to him. Hmm... it is getting complicated... - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: brob [mailto:[EMAIL PROTECTED] | Sent: Monday, October 13, 2003 11:26 | To: CF-Talk | Subject: Re: ACL database design | | | ot that i have much experience in this, but here's a shot. | | I'm assuming that users dont have any rights unless they | belong to a group.Also asumme that it's a 1 level | parent/child scheme (like, just parent and many childs, not | grandparents or great-great grandchildren).but that wont | make a diffenrece.It's just my brain isn't evolved enough | to understand how that works lol. Also using the table below, | one user can belong to many groups. | | | Rights | id | descr | | Users | id--key to id in tbl_groups_rights | f_name | l_name | other Info | | Groups | id | parent_id --key to id in tbl_groups (all top level groups | (first parents) get parent_id 0) | group_name | description | | | | user_groups | id ---key to id in group_rights | users_id---key to id in tbl_users | groups_id ---key to id in tbl_groups | | | group_rights | id ---key to id in user_groups | rights_id --key to id in tbl_rights | group_id ---key to id in tbl_groups | description | | | | | | So lets say the user logs into the admin or whatever.you | need to do 2 queries regarding the roles.you first query | the ids of the groups it's in and get the rights_id belonging | to that group. | Append those ids to a session list or cookie or sumthin. | Then you query for the Ids of the parents of that group (if | the parent's ID is 0, then it means it has no parents), and | get the rights belonging to those parents.Then append those | ids to the previous list | | Now on your templates, you just need to write code to allow | that person to do whatever according to what ids they have. | That will mean u have to hard code the IDs to the conditions | on those pages tho, which will be hard to maintain and keep | track of.make another template that has all of the rights | ID queried from tha databse) and assign them to variables. | Then just include that template on your pages.And on those | pages (or parts of the page), I would say if list doesn't | contain X or Z, then don't show stuff below or goto error. ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Coldfusion VS Zope (Python) ... HELP!!
Thanks for the feedback everyone. Zope doesn't sound as bad as it seems. Only issues is learning while architecting a large project. It's true learning on company time is a big perk. Does anyone see Python and/or Zope and professionally marketable skill? Python, absolutely. Zope, not so much at this point. But there's a difference between the two -- Python's a programming language and the other's an object-oriented CMS written in Python, so needs for the two are going to be completely different. Dave's absolutely right on this -- Zope was built as a CMS.Why not have a look at an opensource, object based, CMS written in CFMX?? FarCry CMS (http://farcry.daemon.com.au/) offers all the features you have described and more.The record installation time in the office is under 3mins.It installs as a fully functional web app -- you just customise and build out from there. FarCry v2 was released just in the last fortnight and is rock solid.But don't take my word for it.Join the developer list -- ask other CF developers working in the solution daily. Like Zope, FarCry is backed by a company that offers services and support (and we're not the only ones).Anyhoot... take the time to check it out -- you might be surprised at just how comprehensive a product it is. Best regards, Geoff Bowers Self-professed FarCry Evangelist :) http://farcry.daemon.com.au/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ACL database design
In addition, a user should be able to have specific rights assigned to him. That is possible.Just give him a group of his own, give it his own name or something. And the other stuff, it is possible with this design.Just that i can't conceptualize it in terms of a SQL query, to get someone's grandparent by only knowing the child.Lemme think for a little bit and i get back to you :)it's basically the same thing as a message board, where a new post can have a reply, and that reply has its own reply, and that own reply has 5 replies under it.If you wanted to know, i've never tried to write my own message board because of that ahahaha - Original Message - From: Hugo Ahlenius To: CF-Talk Sent: Monday, October 13, 2003 4:27 AM Subject: RE: ACL database design Thanks, I actually had in mind an unlimited parent/child relationships in the groups. So that the super-parent would be the Admin group, that all other groups are derived from, like superusers inherit the rights from the admin group, but with rights X,Y Z revoked. And the regular users group is a child of the superusers group, etc. In addition, a user should be able to have specific rights assigned to him. Hmm... it is getting complicated... - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: brob [mailto:[EMAIL PROTECTED] | Sent: Monday, October 13, 2003 11:26 | To: CF-Talk | Subject: Re: ACL database design | | | ot that i have much experience in this, but here's a shot. | | I'm assuming that users dont have any rights unless they | belong to a group.Also asumme that it's a 1 level | parent/child scheme (like, just parent and many childs, not | grandparents or great-great grandchildren).but that wont | make a diffenrece.It's just my brain isn't evolved enough | to understand how that works lol. Also using the table below, | one user can belong to many groups. | | | Rights | id | descr | | Users | id--key to id in tbl_groups_rights | f_name | l_name | other Info | | Groups | id | parent_id --key to id in tbl_groups (all top level groups | (first parents) get parent_id 0) | group_name | description | | | | user_groups | id ---key to id in group_rights | users_id---key to id in tbl_users | groups_id ---key to id in tbl_groups | | | group_rights | id ---key to id in user_groups | rights_id --key to id in tbl_rights | group_id ---key to id in tbl_groups | description | | | | | | So lets say the user logs into the admin or whatever.you | need to do 2 queries regarding the roles.you first query | the ids of the groups it's in and get the rights_id belonging | to that group. | Append those ids to a session list or cookie or sumthin. | Then you query for the Ids of the parents of that group (if | the parent's ID is 0, then it means it has no parents), and | get the rights belonging to those parents.Then append those | ids to the previous list | | Now on your templates, you just need to write code to allow | that person to do whatever according to what ids they have. | That will mean u have to hard code the IDs to the conditions | on those pages tho, which will be hard to maintain and keep | track of.make another template that has all of the rights | ID queried from tha databse) and assign them to variables. | Then just include that template on your pages.And on those | pages (or parts of the page), I would say if list doesn't | contain X or Z, then don't show stuff below or goto error. ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ACL database design
Hugo Ahlenius wrote: I actually had in mind an unlimited parent/child relationships in the groups. So that the super-parent would be the Admin group, that all other groups are derived from, like superusers inherit the rights from the admin group, but with rights X,Y Z revoked. And the regular users group is a child of the superusers group, etc. You do realize this is a fail open model? I.e., if somehing goes wrong the user defaults to being Admin, instead of being nobody. Most security systems are designed as fail close systems. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ACL database design
Can you explain please? - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Monday, October 13, 2003 4:48 AM Subject: RE: ACL database design Hugo Ahlenius wrote: I actually had in mind an unlimited parent/child relationships in the groups. So that the super-parent would be the Admin group, that all other groups are derived from, like superusers inherit the rights from the admin group, but with rights X,Y Z revoked. And the regular users group is a child of the superusers group, etc. You do realize this is a fail open model? I.e., if somehing goes wrong the user defaults to being Admin, instead of being nobody. Most security systems are designed as fail close systems. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ACL database design
| Hugo Ahlenius wrote: | | I actually had in mind an unlimited parent/child relationships in | the groups. So that the super-parent would be the Admin group, | that all other groups are derived from, like superusers inherit | the rights from the admin group, but with rights X,Y Z revoked. | And the regular users group is a child of the superusers group, | etc. | | You do realize this is a fail open model? I.e., if somehing goes | wrong the user defaults to being Admin, instead of being nobody. Most | security systems are designed as fail close systems. | | Jochem Mmm... I just realized that. I guess the alternative would be that all groups are inheriting from the guest/unpriviliged group (deny everything). But it could also be designed so that there is a setting do not inherit from parent for a group, and also so that a user defaults to being in no group at all (no rights to inherit). /H. ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ACL database design
brob said: From: Jochem van Dieten Hugo Ahlenius wrote: I actually had in mind an unlimited parent/child relationships in the groups. So that the super-parent would be the Admin group, that all other groups are derived from, like superusers inherit the rights from the admin group, but with rights X,Y Z revoked. And the regular users group is a child of the superusers group, etc. You do realize this is a fail open model? I.e., if somehing goes wrong the user defaults to being Admin, instead of being nobody. Most security systems are designed as fail close systems. Can you explain please? In this model all users are Admin by default. Suppose you are adding a new user. At that moment he is Admin. Only when you place him in different groups he gets certain rights revoked. But what if adding him to a different group fails? Could be because of a program error, or even because the person that is setting up the new account gets a phone call when he is working on it and forgets to finish it. Security systems should be designed in such a way that by default they deny access, not grant it. (Fail open and fail close are actually terms from engineering, if you are designing a refinery or nuclear installation you have to specify with every single valve if it should open or close in case of a power or controller failure.) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ACL database design
Were you referring to Hugo's post, or to the table scheme i posted? - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Monday, October 13, 2003 5:04 AM Subject: Re: ACL database design brob said: From: Jochem van Dieten Hugo Ahlenius wrote: I actually had in mind an unlimited parent/child relationships in the groups. So that the super-parent would be the Admin group, that all other groups are derived from, like superusers inherit the rights from the admin group, but with rights X,Y Z revoked. And the regular users group is a child of the superusers group, etc. You do realize this is a fail open model? I.e., if somehing goes wrong the user defaults to being Admin, instead of being nobody. Most security systems are designed as fail close systems. Can you explain please? In this model all users are Admin by default. Suppose you are adding a new user. At that moment he is Admin. Only when you place him in different groups he gets certain rights revoked. But what if adding him to a different group fails? Could be because of a program error, or even because the person that is setting up the new account gets a phone call when he is working on it and forgets to finish it. Security systems should be designed in such a way that by default they deny access, not grant it. (Fail open and fail close are actually terms from engineering, if you are designing a refinery or nuclear installation you have to specify with every single valve if it should open or close in case of a power or controller failure.) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ACL database design
Jochem, As the SQL guru, how do I design a query with a recursive table (unlimited parent/child relationships). So that i.e. a group has a foreign key to the parent group. So that I can, in one query get all the parents of a specific group (a recursive join?) /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Jochem van Dieten [mailto:[EMAIL PROTECTED] | Sent: Monday, October 13, 2003 12:04 | To: CF-Talk | Subject: Re: ACL database design | | | brob said: | From: Jochem van Dieten | Hugo Ahlenius wrote: | | I actually had in mind an unlimited parent/child relationships | in the groups. So that the super-parent would be the Admin | group, that all other groups are derived from, like superusers | inherit the rights from the admin group, but with rights X,Y Z | revoked. And the regular users group is a child of the | superusers group, etc. | | You do realize this is a fail open model? I.e., if somehing goes | wrong the user defaults to being Admin, instead of being nobody. | Most security systems are designed as fail close systems. | | Can you explain please? | | In this model all users are Admin by default. Suppose you are adding a | new user. At that moment he is Admin. Only when you place him in | different groups he gets certain rights revoked. But what if adding | him to a different group fails? Could be because of a program error, | or even because the person that is setting up the new account gets a | phone call when he is working on it and forgets to finish it. | | Security systems should be designed in such a way that by default they | deny access, not grant it. (Fail open and fail close are actually | terms from engineering, if you are designing a refinery or nuclear | installation you have to specify with every single valve if it should | open or close in case of a power or controller failure.) | | Jochem | | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:SQL Statement help!
Thank you everybody for your help. Tony, the code in your last post works just the way I want it to. Many Thanks again
Allan
first of all, whats this?
cfoutput#DateFormat(Now()-7,/mm/dd)# - #qTmp.DateTime#/cfoutput
dateAdd() needs to be in there for the -7 thing to work.
here is the below in correct format.
cfquery name=lQuery2 dbtype=query
SELECTUserName, SearchString, Count(SearchString) AS Occurences
FROMqTmp
WHERE '#dateFormat(dateAdd('d',Now(),-7),'mm/dd/')#'
'#dateFormat(dateTime,'mm/dd/')#'
GROUP BY UserName, SearchString
/cfquery
hth
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 11:59 AM
To: CF-Talk
Subject: Re:SQL Statement help!
I've tried this and it errors:
cfoutput#DateFormat(Now()-7,/mm/dd)# - #qTmp.DateTime#/cfoutput
cfquery name=lQuery2 dbtype=query
SELECTUserName, SearchString, Count(SearchString) AS Occurences
FROMqTmp
WHERE cfqueryparam cfsqltype=cf_sql_timestamp
value=#DateFormat(Now()-7,'/mm/dd')# DateTime
GROUP BY UserName, SearchString
/cfquery
ok so format that value, with dateFormat, enclose it in 's and you
should be good.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 10:31 AM
To: CF-Talk
Subject: Re:SQL Statement help!
I think this is what you mean
DateTime - 2003/09/01 11:52:16
Now - {ts '2003-10-10 15:28:19'}
whats the value of dateTime parse out to?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 9:32 AM
To: CF-Talk
Subject: Re:SQL Statement help!
I now get a different error
Query Of Queries runtime error.
Unsupported type comparison.
ColdFusion Programmer wrote:
Guys, I'm sorry for so many errors on my part. Jochem, the code
your posted throws an error,
Error Executing Database Query.
Query Of Queries syntax error.
Encountered { at line 0, column 0. Incorrect conditional
_expression_, Expected one of [like|null|between|in|comparison]
condition,
SELECTUserName,
SearchString,
Count(SearchString) AS Occurences
FROMqTmp
WHERE cfqueryparam cfsqltype=cf_sql_timestamp
value=#DateAdd(d,-7,Now())# DateTime GROUP BY UserName,
SearchString
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: ACL database design
Hugo Ahlenius said: As the SQL guru, how do I design a query with a recursive table (unlimited parent/child relationships). So that i.e. a group has a foreign key to the parent group. So that I can, in one query get all the parents of a specific group (a recursive join?) If you mean that a group should have multiple parents, and each of those parents should have multiple parents etc., you are going to end up with a stored procedure (unless you have a database that implements WITH ... RECURSIVE (Oracle does and there is an unofficial patch for PostgreSQL, but in both cases it is named CONNECT BY ... PRIOR)). If you mean that each group has one parent group, and each parent group has one other parent group etc., google for nested set model. Anyhow, I would probably set up permissions as a very large list of rights that can only be true or false (userInsertPriviledge, userUpdatePriviledge, userDeletePriviledge, updateSelfPriviledge etc.) and then use group membership as a template to assign these permissions, but not as the authorative list of permissions. That way it is easy to customize priviledges, and you can just query the database for a list of assigned permissions and use those as roles in you cfloginuser. There is an article on DevNet (by Ben Forta?) that explains this in more detail. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looking for Shared CF Hosting/ISP Services
Hi If you're looking for a list of CF hosting companies, please try our website. http://www.coldfusionhosts.net If there is anyone on the list who wants their press release or has any tips, please email them to me at [EMAIL PROTECTED] Regards coldfusionhosts.net Admin - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 10, 2003 8:00 PM Subject: Re: Looking for Shared CF Hosting/ISP Services Nick, Take a look at us: http://exciteworks.com/host_matrix.cfm We have great prices, can pretty much do everything you want, and provide top- notch support. We will gladly put together custom packages for you if you don't see exactly what you need in our predefined offerings. Thanks, Josh Trefethen Exciteworks, Inc http://exciteworks.com Quoting Nick Baker [EMAIL PROTECTED]: I realize this subject is brought up frequently. I did go back and research all CFTalk threads for 2003. Surprisingly there is only a very small number of CF hosting services that were mentioned. Maybe 25, or so. Forta.com lists close to 1,000 CF ISP's. Once you eliminate the host with negative references and services that restrict certain CF Tags, e.g., CFSCHEDULE, CFFILE, etc. there aren't many options. An important features is that we need to host several domains without the requirement to use redirecting scripts and having URL's in the browser window of the following format. http://www.domainname.com/directory We are using Shanje, which has good service and features (excepting a few tag restrictions), but they don't seem to be inclined to move beyond CF 4.5 Any good rec's would be appreciated. Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ACL database design
Hugo Ahlenius wrote: As the SQL guru, how do I design a query with a recursive table (unlimited parent/child relationships). So that i.e. a group has a foreign key to the parent group. So that I can, in one query get all the parents of a specific group (a recursive join?) Google joe celko nested tree model. This is a good start: http://www.intelligententerprise.com/001020/celko.shtml If you want to see this sort of thing in action we use it in FarCry CMS (http://farcry.daemon.com.au/) to manage the n-depth tree model we use for site management.We have a tree.cfc that wraps the code up in methods allowing you to getdescendants(): all nodes under a single parent to any depth, getAncestors(): all parents up the the root, and so on. Its great.Instead of traversing the tree (look up the parent and the parents parent, etc) you just need a single SELECT statement. Lightening fast. -- geoff bowers Managing Director Daemon Internet Consultants Macromedia Premier Solutions Partner http://www.daemon.com.au/ p. 02 9380 4162 f. 02 9380 4204 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Looking for Cold Fusion Forum similar to FuseTalk
Well you can always go here http://sourceforge.net/softwaremap/trove_list.php?form_cat=262 Then to break it down even further this is a great Forums project. http://sourceforge.net/projects/fbopenforums/ Bob Everland I'm looking for alternative Forums that are codedin Cold Fusion like FuseTalk but not as expensive. If anyone knows that would be great. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ACL database design
Thanks for this link! - Original Message - From: Geoff Bowers To: CF-Talk Sent: Monday, October 13, 2003 7:15 AM Subject: Re: ACL database design Hugo Ahlenius wrote: As the SQL guru, how do I design a query with a recursive table (unlimited parent/child relationships). So that i.e. a group has a foreign key to the parent group. So that I can, in one query get all the parents of a specific group (a recursive join?) Google joe celko nested tree model. This is a good start: http://www.intelligententerprise.com/001020/celko.shtml If you want to see this sort of thing in action we use it in FarCry CMS (http://farcry.daemon.com.au/) to manage the n-depth tree model we use for site management.We have a tree.cfc that wraps the code up in methods allowing you to getdescendants(): all nodes under a single parent to any depth, getAncestors(): all parents up the the root, and so on. Its great.Instead of traversing the tree (look up the parent and the parents parent, etc) you just need a single SELECT statement. Lightening fast. -- geoff bowers Managing Director Daemon Internet Consultants Macromedia Premier Solutions Partner http://www.daemon.com.au/ p. 02 9380 4162 f. 02 9380 4204 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
We have developed a suite of tags for working with an Apache Lucene index ( http://www.lucene.com).Our suite is far more robust than that offered by the DRK.For instance, we maintain an index of 100,000+ articles and it takes no more than a fraction of a second to search. We are also able to index any number of custom fields, which has proven to be very valuable.We are waiting for authorization from Apache to use the name Lucene in our documentation.Once recieved, this suite will be offered for free. It's really amazing how well this search engine works.It is far more flexible than Verity. For the time being, i would suggest getting a hold of Lindex from the DRK. -Ryan -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 2:54 AM To: CF-Talk Subject: RE: Alternatives to Verity Just so's you know: this Lindex (I posted about it a little while ago).The CFDJ article was working off the fact that it was shipped with the DevNet Resource Kit 3. Note that you don't NEED the DRK to use it (the product itself is open-source) but the DRK does have some nice tools and docs about it. Jim Davis -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 1:57 AM To: CF-Talk Subject: RE: Alternatives to Verity Eric, There have been a few articles in recent CFDJ's that discuss a JAVA alternative to VERITY.I don't recall the name of the program or the CFDJ issues off hand, but if you don't find the information on the CFDJ site (www.sys-con.com http://www.sys-con.com/ ) contact me off list and I'll try to dig up the information for you. Thank you, Jason Egan CFDynamics.com -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Sunday, October 12, 2003 1:16 PM To: CF-Talk Subject: Alternatives to Verity WE have been having terrible times with our Verity collections corrupting, being unable to update etc at our host and am looking for alternatives. It simply queries a database and a lot of fields, some quite lengthy...so not sure a simply SQL query is an option, but are there other solutions everyone is using for higher end and more robust searches of your sites? Thanks for any pointers in advance! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Alternatives to Verity
Ryan Emerle wrote: re: lucene It's really amazing how well this search engine works.It is far more flexible than Verity. What exactly is more flexible than Verity?I'm an old Verity hack from way back -- and I'm interested in Lucene but can't really see what it does that's so special. -- geoff bowers Daemonite -- http://blog.daemon.com.au/ Fullasagoog -- http://www.fullasagoog.com/ FarCry -- http://farcry.daemon.com.au/ ArsAura -- http://daemon.typepad.com/arsaura [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Odd XML parsing behavior
Maybe I'm just being a NAG here, but here's what's happening: I'm parsing 2 RSS feeds when a page loads with MX's xmlparse function. First thing I noticed was that even though the files were local, it wasn't very quick. I put some trace code in and noticed that the first time the xmlparse function is used (on the first RSS), it takes approx. 150-200 MS, the second time its used - it takes almost no time. Any ideas? And while we're on the topic: are there better alternatives to MX's native XML support? -Rich [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Odd XML parsing behavior
And while we're on the topic: are there better alternatives to MX's native XML support? You can call a Java parser directly and do pretty much whatever you want with it... BTW I have an old quote on this: I have yet to come across an XML system where the true performance bottleneck is XML parser speed. Moreover, the people I meet who are infatuated with parser speed are the same people who thought the Web would never work because HTTP was too slow or that Java would never succeed because it is too slow. Those old enough to have been there used to claim systems written in C rather than assembler would be too slow. -Sean McGrath :-))) Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
Mainly i will cite that it is open source which allows for nearly limitless flexibility.Indexing and searching can be crafted to your application.Outside of that, check out the lucene website (posted earlier) for a breakdown of what Lucene can do. I have found the following to be true of lucene and not necessarily with Verity: * Free/open source * Limitless indexed entities * Cross-platform compatibility * Full control over searching and indexing * Index portablility (can create an index anywhere and use it anywhere - web,cdrom,locally,etc) Verity is very flexible, i just happen to happen to enjoy the level of control and portability of Lucene over it.Use whatever works for you and your applications, though..I prefer to have an engine that works with my application, rather than an application that works with my search engine. I do urge anyone interested to draw their own conclusions based on their experiences :) HTH -Ryan -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 9:28 AM To: CF-Talk Subject: Re: Alternatives to Verity Ryan Emerle wrote: re: lucene It's really amazing how well this search engine works.It is far more flexible than Verity. What exactly is more flexible than Verity?I'm an old Verity hack from way back -- and I'm interested in Lucene but can't really see what it does that's so special. -- geoff bowers Daemonite -- http://blog.daemon.com.au/ Fullasagoog -- http://www.fullasagoog.com/ FarCry -- http://farcry.daemon.com.au/ ArsAura -- http://daemon.typepad.com/arsaura _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Alternatives to Verity
I have found the following to be true of lucene and not necessarily with Verity: does lucene handle unicode? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Setting Locale for Application
Paul, Yes, i can use Native Java Classes (GregorianCalender,TimeZone) to pull any Regional Date/Time. then what are you after with setLocale and LSDateFormat? I think u can convert the local time to GMT and +/- to get the desired Regional Date/Time using CF but I was under the impression (setLocale and other International functions) wouldallow you to dynamically set the Locale for the application using CFMX. Thanks, Joe Eugene - Original Message - From: Paul Hastings To: CF-Talk Sent: Sunday, October 12, 2003 4:11 AM Subject: Re: Setting Local for Application It returns Server Date/TimeNot the Locale Date/Time. then what are you after with setLocale and LSDateFormat? you're after the user's timezone? if so see this example: http://www.sustainablegis.com/tips/getClientTZ.cfmthere's also a timeZone CFC in the devnet gallery. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
Is Lucene for someone who has never coded in java ? -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 10:27 AM To: CF-Talk Subject: Re: Alternatives to Verity I have found the following to be true of lucene and not necessarily with Verity: does lucene handle unicode? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Setting Locale for Application
then what are you after with setLocale and LSDateFormat? I think u can convert the local time to GMT and +/- to get the desired Regional Date/Time using CF but I was under the impression (setLocale and other International functions) wouldallow you to dynamically set the Locale for the application using CFMX. yes it sets the locale. a locale isn't a timezone. what exactly do you want to do? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
Have you found there to be any downsides to it? Ade -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 14:41 To: CF-Talk Subject: RE: Alternatives to Verity Mainly i will cite that it is open source which allows for nearly limitless flexibility.Indexing and searching can be crafted to your application. Outside of that, check out the lucene website (posted earlier) for a breakdown of what Lucene can do. I have found the following to be true of lucene and not necessarily with Verity: * Free/open source * Limitless indexed entities * Cross-platform compatibility * Full control over searching and indexing * Index portablility (can create an index anywhere and use it anywhere - web,cdrom,locally,etc) Verity is very flexible, i just happen to happen to enjoy the level of control and portability of Lucene over it.Use whatever works for you and your applications, though..I prefer to have an engine that works with my application, rather than an application that works with my search engine. I do urge anyone interested to draw their own conclusions based on their experiences :) HTH -Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
multiple inserts, no solution
BACKGROUND INFO: I'm creating an admin form allowing a user to enter class schedules. Class Title, Class Description, Class Time, Class Price are all simple inserts. The problem comes in when entering the class dates. There are sometimes one class, sometimes two, four or six. Often times they will be one week apart, but not always. example: Class 1 will meet at 2PM on Tuesday the 1st, the 8th, the 15th, the 22nd. The admin page allows the user to put in the dates desired by clicking on the appropriate calendar day. PROBLEM: One click should allow the user to input 2 or more class dates. A straight loop cfloop from=1 to=#classQty# tries to input multiple class days into the classDate field. example of error below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) SOLUTION ???: I had thought that I could do something like the following cfoutput cfloop from=1 to=#FORM.number# index=getClassDate cfset date=#FORM.month##getClassDate#/#FORM.day1##getClassDate#/#FORM.year 1##getClassDate# cfquery name= datasource= INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '#FORM.classID#', '#FORM.classDay#', '#FORM.classSession#', '#date#', '#FORM.classTime#' ) /cfquery /cfloop /cfoutput I see why it doesn't work. So, how does one do multiple inserts of this kind? Gilbert Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Storing XML
Wow I'd be really surprised if cfhttp was quicker than cffile. Oddly enough, sometimes it is, when used to fetch a file from the local machine. I was very surprised by that myself, as it strikes me as counterintuitive, to say the least. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: deleted cfide directory
I'm new to CF and I am running CFMX 6.1 on Redhat 8. I've inadvertatntly deleted the CFIDE directory. Is there anyway to recreate it without re-installing cold fusion? I don't have the install disks, at this time I'm still using the evaluation version. Any help would be greatly appreciated! If you know someone else who has it installed, you can simply copy it to your machine. It's just a bunch of CFM files, basically. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Storing XML
I'd imagine that CFFILE has to read the entire file from the file system every time, while CFHTTP can make use of optimizations at the web server level.So if you have a good web server, it makes sense that it might be faster.Of course, using CFHTTP requires that your file be web accessible, which isn't always desirable. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 8:32 AM To: CF-Talk Subject: RE: Storing XML Wow I'd be really surprised if cfhttp was quicker than cffile. Oddly enough, sometimes it is, when used to fetch a file from the local machine. I was very surprised by that myself, as it strikes me as counterintuitive, to say the least. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
error: object expected
Hi everyone.Thanks to Lee and Ian for helping me last time with dynamic menus.I was able to get into the webmonkey tutorial Ian recommended and also have absorbed Lee's technique for meshing HTML form elements with cfinput tags.THanks guys.I am having another issue now.I keep getting a java run-time error on windows xp, and error:object expected on Win 2k.I'm not sure if mixing the form elements of CFML and HTML has caused the issue.I don't think so actually because they work really well.Here's what I've got for that: select name=countryoption value= selected--Select--/optionCFOUTPUT query=Countriesoption value=Country message=Enter your country.#Country#/option /CFOUTPUT/select Perhaps I shouldn't put the message attribute in the tag. The line where the error occurs is line 25 (char 2), which relates to a table tag.Can I put form elements inside of tables?Perhaps this is an IE thing? Thanks, Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
I'm gonna need some regular expression help here...
Got a cfinput, it's required, and the validation is a regular _expression_.
The Problem: The regular _expression_ isn't allowing a capital letter after
the '@'. I'm sure there are other faults with this regular _expression_, but
you see...I'm just not there yet when it comes to troubleshooting these
things, so I thought I'd paste the relevant portion here hoping for some,
miracle regular _expression_ person to jump in and gimme a hand.
Ready?
Here it is:
validate=regular_expression
pattern=^[_a-z0-9-]+(\.[_a-z0-9-]+)[EMAIL PROTECTED](\.[a-z0-9-]+)*\.(([a-z]{2,3
})|(aero|coop|info|museum|name))$
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: error: object expected
I think for xhtml you should look to put the form outside the table. As for the error, I doubt it is to do with the message attribute of your option tag. Forget about the html for a while and just output the query. Try using cfdump var=#yourQueryName# / to have a look at the query. Ade -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 16:38 To: CF-Talk Subject: error: object expected Hi everyone.Thanks to Lee and Ian for helping me last time with dynamic menus.I was able to get into the webmonkey tutorial Ian recommended and also have absorbed Lee's technique for meshing HTML form elements with cfinput tags.THanks guys.I am having another issue now.I keep getting a java run-time error on windows xp, and error:object expected on Win 2k.I'm not sure if mixing the form elements of CFML and HTML has caused the issue.I don't think so actually because they work really well.Here's what I've got for that: select name=countryoption value= selected--Select--/optionCFOUTPUT query=Countriesoption value=Country message=Enter your country.#Country#/option /CFOUTPUT/select Perhaps I shouldn't put the message attribute in the tag. The line where the error occurs is line 25 (char 2), which relates to a table tag.Can I put form elements inside of tables?Perhaps this is an IE thing? Thanks, Sam _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I'm gonna need some regular expression help here...
Here's a nice little _expression_ I use.
var chkEmail=
/^([\w-]+(?:\.[\w-]+)*)@((?:[\w-]+\.)*\w[\w-]{0,66})\.([a-z]{2,6}(?:\.[a-z]{
2})?)$/i;
if ((form.Email.value.length 6 ) || (chkEmail.test(form.Email.value) ==
false)) {
var msg= Email address entry error!\n\nPlease a valid email
address!\n\nClick OK to continue.;
alert (msg);
form.Email.focus();
return false;
}
~Dave
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 11:42 AM
To: CF-Talk
Subject: I'm gonna need some regular _expression_ help here...
Got a cfinput, it's required, and the validation is a regular _expression_.
The Problem: The regular _expression_ isn't allowing a capital letter after
the '@'. I'm sure there are other faults with this regular _expression_, but
you see...I'm just not there yet when it comes to troubleshooting these
things, so I thought I'd paste the relevant portion here hoping for some,
miracle regular _expression_ person to jump in and gimme a hand.
Ready?
Here it is:
validate=regular_expression
pattern=^[_a-z0-9-]+(\.[_a-z0-9-]+)[EMAIL PROTECTED](\.[a-z0-9-]+)*\.(([a-z]{2,3
})|(aero|coop|info|museum|name))$
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re:multiple inserts, no solution
Gilbert, 1) Use the CreateODBCDate function i.e CreateODBCDate(createdate(form.year,form.month,form.day)) This will fix the date formating problem 2) Think about using a seperate lookup table associating classes with times. This way you can CFLoop around the infoirmation and pull the dates into the database correctly using the CreateODBCDate function. This way you can have as many dates as needed for each class. You should be able to loop over the list and insert the transaction, as long as you have CFTRANSACTION tags and a CFTRY/CFCATCH block around the insert To pull the items from the database for the dates later all you'll need to do is use a inner join. 3) Are you calling CFSET statement correctly? cfset #FORM.month##getClassDate# ... outputs at 101102103. If you use cfset #evaluate(FORM.month#getClassDate#) This will output the variable you passing month1 correctly. In my pervious example it would be CreateODBCDate(createdate(evaluate(form.year#getClassDate#),evalaute(form.month#getClassDate#,evalaute(form.day#getClassDate#)) Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE BACKGROUND INFO: I'm creating an admin form allowing a user to enter class schedules. Class Title, Class Description, Class Time, Class Price are all simple inserts. The problem comes in when entering the class dates. There are sometimes one class, sometimes two, four or six. Often times they will be one week apart, but not always. example: Class 1 will meet at 2PM on Tuesday the 1st, the 8th, the 15th, the 22nd. The admin page allows the user to put in the dates desired by clicking on the appropriate calendar day. PROBLEM: One click should allow the user to input 2 or more class dates. A straight loop cfloop from=1 to=#classQty# tries to input multiple class days into the classDate field. example of error below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) SOLUTION ???: I had thought that I could do something like the following cfoutput cfloop from=1 to=#FORM.number# index=getClassDate cfset date=#FORM.month##getClassDate#/#FORM.day1##getClassDate#/#FORM.year 1##getClassDate# cfquery name= datasource= INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '#FORM.classID#', '#FORM.classDay#', '#FORM.classSession#', '#date#', '#FORM.classTime#' ) /cfquery /cfloop /cfoutput I see why it doesn't work. So, how does one do multiple inserts of this kind? Gilbert Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: I'm gonna need some regular expression help here...
This regex was intended to be used with a case-insensitive regular
_expression_ checker.To make it case insensitive, there are two things
you'll have to do.
replace a-z in brackets with a-zA-Z
replace each of aero, coop, info, museum, and name with EVERYPOSSIBLE
CAPITALIZATION POSSIBILITY.
If I were you, I would probably do my email format validation on the
backend.
--Ben Doom
Jeff wrote:
Got a cfinput, it's required, and the validation is a regular _expression_.
The Problem: The regular _expression_ isn't allowing a capital letter after
the '@'. I'm sure there are other faults with this regular _expression_, but
you see...I'm just not there yet when it comes to troubleshooting these
things, so I thought I'd paste the relevant portion here hoping for some,
miracle regular _expression_ person to jump in and gimme a hand.
Ready?
Here it is:
validate=regular_expression
pattern=^[_a-z0-9-]+(\.[_a-z0-9-]+)[EMAIL PROTECTED](\.[a-z0-9-]+)*\.(([a-z]{2,3
})|(aero|coop|info|museum|name))$
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: ACL database design
brob wrote: Were you referring to Hugo's post, or to the table scheme i posted? You should learn how to read email headers: References: [EMAIL PROTECTED] Would that be Hugo or you? Also it said: Hugo Ahlenius wrote: Please refer to RFC 1855, RFC 2646 and RFC 2822 if you are unfamiliar with quoting and email headers. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Setting Locale for Application
yes it sets the locale. a locale isn't a timezone. what exactly do you There isnt a direct way to Pull the Locale Time Zone in CFMX, you have use Native Classes to do this. dateConvert() is NOT a clean solution.. Lets say you want to pull the Date/Time for Australia/Melbourne(EST) To accomplish the above in the CFMX 1. Use dateConvert to GMT 2. Find the Time Difference and +/- to GMT to get the Date/Time for AUS - EST. OR Use Java Native Classes like tz = createObject(Java, java.util.TimeZone).getTimeZone(Australia/Melbourne); df= createObject(java, java.text.DateFormat).getDateTimeInstance(); df.setTimeZone(tz); writeOutput(df.format(now()); This should really be implemented in CFMX with dateFormat() as an Overloaded Method. dateFormat(now(), DD-MM-, Australia/Melbourne) Joe Eugene - Original Message - From: Paul Hastings To: CF-Talk Sent: Monday, October 13, 2003 10:35 AM Subject: Re: Setting Locale for Application then what are you after with setLocale and LSDateFormat? I think u can convert the local time to GMT and +/- to get the desired Regional Date/Time using CF but I was under the impression (setLocale and other International functions) wouldallow you to dynamically set the Locale for the application using CFMX. yes it sets the locale. a locale isn't a timezone. what exactly do you want to do? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: I'm gonna need some regular expression help here...
On Monday 13 Oct 2003 17:01 pm, Ben Doom wrote: replace each of aero, coop, info, museum, and name with EVERYPOSSIBLE CAPITALIZATION POSSIBILITY. Or alternatively, don't bother checking the TLD against a static list, because eventualy a new one will crop up, and you'll wind people up who have one. There are still sites I can't use with my .info address. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
Perhaps for non documents - SQL server's full text search may be another suggestion? Its *reported* to be easier to maintain. Kola -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 15:39 To: CF-Talk Subject: RE: Alternatives to Verity Have you found there to be any downsides to it? Ade -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 14:41 To: CF-Talk Subject: RE: Alternatives to Verity Mainly i will cite that it is open source which allows for nearly limitless flexibility.Indexing and searching can be crafted to your application. Outside of that, check out the lucene website (posted earlier) for a breakdown of what Lucene can do. I have found the following to be true of lucene and not necessarily with Verity: * Free/open source * Limitless indexed entities * Cross-platform compatibility * Full control over searching and indexing * Index portablility (can create an index anywhere and use it anywhere - web,cdrom,locally,etc) Verity is very flexible, i just happen to happen to enjoy the level of control and portability of Lucene over it.Use whatever works for you and your applications, though..I prefer to have an engine that works with my application, rather than an application that works with my search engine. I do urge anyone interested to draw their own conclusions based on their experiences :) HTH -Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: multiple inserts, no solution
Jeremy, when I insert one date at a time there is no problem.The problem comes when the user needs to insert multiple dates for a particular clas. classTitle: Guitar for Beginners (text box) classTime: 12:00-2:00PM (select list) classDate: user chooses Oct 1, Oct 8, Oct 15, Oct 22 OK now, with one click the user should be able to enter this class. On the database end I should have four records classDatesID (primary key) classID (foreign key) classDate classTime I haven't been able to loop through the inserts correctly. Presently it tries to stuff all the dates into the same field as seen below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) I'll look into the transaction tag but I thought it had more to do with multiple insertions by multiple people and ensuring that one transaction was finished before starting another. thx, Gil -Original Message- From: Jeremy Brodie [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 11:55 AM To: CF-Talk Subject: Re:multiple inserts, no solution Gilbert, 1) Use the CreateODBCDate function i.e CreateODBCDate(createdate(form.year,form.month,form.day)) This will fix the date formating problem 2) Think about using a seperate lookup table associating classes with times. This way you can CFLoop around the infoirmation and pull the dates into the database correctly using the CreateODBCDate function. This way you can have as many dates as needed for each class. You should be able to loop over the list and insert the transaction, as long as you have CFTRANSACTION tags and a CFTRY/CFCATCH block around the insert To pull the items from the database for the dates later all you'll need to do is use a inner join. 3) Are you calling CFSET statement correctly? cfset #FORM.month##getClassDate# ... outputs at 101102103. If you use cfset #evaluate(FORM.month#getClassDate#) This will output the variable you passing month1 correctly. In my pervious example it would be CreateODBCDate(createdate(evaluate(form.year#getClassDate#),evalaute(form .month#getClassDate#,evalaute(form.day#getClassDate#)) Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE BACKGROUND INFO: I'm creating an admin form allowing a user to enter class schedules. Class Title, Class Description, Class Time, Class Price are all simple inserts. The problem comes in when entering the class dates. There are sometimes one class, sometimes two, four or six. Often times they will be one week apart, but not always. example: Class 1 will meet at 2PM on Tuesday the 1st, the 8th, the 15th, the 22nd. The admin page allows the user to put in the dates desired by clicking on the appropriate calendar day. PROBLEM: One click should allow the user to input 2 or more class dates. A straight loop cfloop from=1 to=#classQty# tries to input multiple class days into the classDate field. example of error below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) SOLUTION ???: I had thought that I could do something like the following cfoutput cfloop from=1 to=#FORM.number# index=getClassDate cfset date=#FORM.month##getClassDate#/#FORM.day1##getClassDate#/#FORM.yea r 1##getClassDate# cfquery name= datasource= INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '#FORM.classID#', '#FORM.classDay#', '#FORM.classSession#', '#date#', '#FORM.classTime#' ) /cfquery /cfloop /cfoutput I see why it doesn't work. So, how does one do multiple inserts of this kind? Gilbert Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
Does Lucene index non-webpages as well? I.e. pdf, rtf, word etc? /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Adrian Lynch [mailto:[EMAIL PROTECTED] | Sent: Monday, October 13, 2003 16:39 | To: CF-Talk | Subject: RE: Alternatives to Verity | | | Have you found there to be any downsides to it? | | Ade | | -Original Message- | From: Ryan Emerle [mailto:[EMAIL PROTECTED] | Sent: 13 October 2003 14:41 | To: CF-Talk | Subject: RE: Alternatives to Verity | | | Mainly i will cite that it is open source which allows for | nearly limitless | flexibility.Indexing and searching can be crafted to your | application. | Outside of that, check out the lucene website (posted earlier) for a | breakdown of what Lucene can do. | | | I have found the following to be true of lucene and not | necessarily with | Verity: | * Free/open source | * Limitless indexed entities | * Cross-platform compatibility | * Full control over searching and indexing | * Index portablility (can create an index anywhere and use it | anywhere - | web,cdrom,locally,etc) | | | Verity is very flexible, i just happen to happen to enjoy the level of | control and portability of Lucene over it.Use whatever | works for you and | your applications, though..I prefer to have an engine that | works with my | application, rather than an application that works with my | search engine. | | | I do urge anyone interested to draw their own conclusions | based on their | experiences :) | | | HTH | | | -Ryan | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: I'm gonna need some regular expression help here...
I use:
^[a-zA-Z]([.]?([[:alnum:]_-]+[.]?)*[[:alnum:]_-])?@([[:alnum:]\-_]+\.)+[a-zA-Z]{2,4}$
which, admittedly, won't allow .museum addresses, but will match most
common emails.
--Ben Doom
Thomas Chiverton wrote:
On Monday 13 Oct 2003 17:01 pm, Ben Doom wrote:
replace each of aero, coop, info, museum, and name with EVERYPOSSIBLE
CAPITALIZATION POSSIBILITY.
Or alternatively, don't bother checking the TLD against a static list,
because
eventualy a new one will crop up, and you'll wind people up who have one.
There are still sites I can't use with my .info address.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Alternatives to Verity
Does Lucene index non-webpages as well? I.e. pdf, rtf, word etc? Try going here to answer these and other questions. It's a pretty comprehensive site: http://jakarta.apache.org/lucene/docs/index.html Regards, Dave. ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Web Services for MX
Can anyone point out a *good* tutorial they used to get up and a good handle on MX and Web Services??We need to springboard and want to make sure we are approaching properly. Thanks in advance!! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Setting Locale for Application
There isnt a direct way to Pull the Locale Time Zone in CFMX, you have use Native Classes to do this. dateConvert() is NOT a clean solution.. you've missed the whole point of that example. it grabs the timezone offset from the client's w/s silently passes it back to the server. from there you can do what needs to be done. dateConvert is server oriented is fine if thats all you need. the timeZoneCFC allows you to cast to other timezones provided you know which one (that's the purpose of that qForms example). if you combine that with the geoLocatorCFC you can pretty much pinpoint the user's exact timezone. that said, you should still offer the user a manual way to set their timezone. it seems you also don't understand what a locale is. maybe you better get that clear. tz = createObject(Java, java.util.TimeZone).getTimeZone(Australia/Melbourne); df= createObject(java, java.text.DateFormat).getDateTimeInstance(); df.setTimeZone(tz); writeOutput(df.format(now()); thats not going to give you an ozzy date format. you'll get an ozzy timezone but the server's default locale, if its en_US it will drive your ozzy users nuts. This should really be implemented in CFMX with dateFormat() as an Overloaded Method. well its not. dateFormat(now(), DD-MM-, Australia/Melbourne) since you're using numeric dates, this isn't going to matter for locales (if thats what you're on about) it will matter for boundary conditions (times that are +/- the timezone of next or previous day). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored
procedure call. Check your bindings against the stored procedure's
parameters.
The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc:
line 23
21 :cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
22 : cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
23 : cfprocresult name=p_rs /
24 :/cfstoredproc
25 :
--
I have tested the procedure outside of ColdFusion and it work
correctly.What am I missing here?According to all the documetation
and other List Messages, it appears to me that I am doing this right.
--
Here is the ColdFusion Code:
cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocresult name=p_rs /
/cfstoredproc
cfoutput#now()#/cfoutput
cfdump var=qry1 /
-
Here is the Strore Procedure definition:
(Specification)
CREATE OR REPLACE PACKAGE Iawa_Pkg AS
/* Programmer-Defined Records. */
-- Record Type for IAWA Page Records.
TYPE IAWAPage_RecTyp IS RECORD
(
LEVEL NUMBER,
pid IAWA.pid%TYPE,
IDIAWA.ID%TYPE,
page IAWA.page%TYPE,
code IAWA.code%TYPE,
description IAWA.description%TYPE,
sortorder IAWA.sortorder%TYPE
);
-- Strong Ref Cursor based on Programmer-Defined Record.
TYPE IAWAPage_CurTyp IS REF CURSOR RETURN IawaPage_RecTyp;
/* Weak Ref Cursor for general use. */
TYPE Generic_CurTyp IS REF CURSOR;
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2 DEFAULT 'A',
p_rs IN OUT IAWAPage_CurTyp
);
PROCEDURE TEST;
END;
/
(Body):
CREATE OR REPLACE PACKAGE BODY Iawa_Pkg AS
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2,
p_rs IN OUT IAWAPage_CurTyp
)
IS
/* Declaration section. */
BEGIN
-- Open Cursor. --
OPEN p_rs FOR
SELECT
LEVEL,
pid,
ID,
page,
code,
description,
sortorder
FROM
IAWA
WHERE
page = p_page
START WITH ID = 0
CONNECT BY PRIOR ID = pid
ORDER SIBLINGS BY sortorder;
END getIAWAPage;
//
/* Test Procedure. */
//
PROCEDURE TEST
IS
-- Declaration Section.
lc IAWAPage_CurTyp;
rec IAWAPage_RecTyp;
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
getIAWAPage('B', lc);
FETCH lc INTO rec;
WHILE lc%FOUND
LOOP
DBMS_OUTPUT.PUT_LINE(rec.ID || ' ' || rec.Page);
FETCH lc INTO rec;
END LOOP;
CLOSE lc;
END;
END;
/
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Alternatives to Verity
Not in my experience.The version we are using does not natively support anything other than plain text, but it is easy enough to build analyzers for PDF, Word, etc.. The only other thing i can think of is that version 1.2 final does not support range queries fully.So, for instance, you cannot perform a query between date ranges.Version 1.3 has this functionality, though it is only a release canidate right now. Im sure there are other downsides, but i haven't found any i couldn't work around with a few lines of code.Remember, it is more of an API than it is a product. -Ryan -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 10:39 AM To: CF-Talk Subject: RE: Alternatives to Verity Have you found there to be any downsides to it? Ade -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 14:41 To: CF-Talk Subject: RE: Alternatives to Verity Mainly i will cite that it is open source which allows for nearly limitless flexibility.Indexing and searching can be crafted to your application. Outside of that, check out the lucene website (posted earlier) for a breakdown of what Lucene can do. I have found the following to be true of lucene and not necessarily with Verity: * Free/open source * Limitless indexed entities * Cross-platform compatibility * Full control over searching and indexing * Index portablility (can create an index anywhere and use it anywhere - web,cdrom,locally,etc) Verity is very flexible, i just happen to happen to enjoy the level of control and portability of Lucene over it.Use whatever works for you and your applications, though..I prefer to have an engine that works with my application, rather than an application that works with my search engine. I do urge anyone interested to draw their own conclusions based on their experiences :) HTH -Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:multiple inserts, no solution
Gil, When you output getClassDate before going into the loop, what is the value of the variable? Is it 4? Is it 1? P.S. The CFTRANSACTION and CFTRY/CFCATCH block are to ensure the right data is going into the mutliple INSERT block Also, take a look at the evaluation function and the CreateOBDCDate functions. These will help you format the date correctly into the database! Jeremy, when I insert one date at a time there is no problem.The problem comes when the user needs to insert multiple dates for a particular clas. classTitle: Guitar for Beginners (text box) classTime: 12:00-2:00PM (select list) classDate: user chooses Oct 1, Oct 8, Oct 15, Oct 22 OK now, with one click the user should be able to enter this class. On the database end I should have four records classDatesID (primary key) classID (foreign key) classDate classTime I haven't been able to loop through the inserts correctly. Presently it tries to stuff all the dates into the same field as seen below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) I'll look into the transaction tag but I thought it had more to do with multiple insertions by multiple people and ensuring that one transaction was finished before starting another. thx, Gil [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Calling Oracle9i StoreProcedure from CFMX
As a guess, check you are sending the correct number of params and that they
are of the correct type for Oracle.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored
procedure call. Check your bindings against the stored procedure's
parameters.
The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc:
line 23
21 :cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
22 : cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
23 : cfprocresult name=p_rs /
24 :/cfstoredproc
25 :
--
I have tested the procedure outside of ColdFusion and it work
correctly.What am I missing here?According to all the documetation
and other List Messages, it appears to me that I am doing this right.
--
Here is the ColdFusion Code:
cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocresult name=p_rs /
/cfstoredproc
cfoutput#now()#/cfoutput
cfdump var=qry1 /
-
Here is the Strore Procedure definition:
(Specification)
CREATE OR REPLACE PACKAGE Iawa_Pkg AS
/* Programmer-Defined Records. */
-- Record Type for IAWA Page Records.
TYPE IAWAPage_RecTyp IS RECORD
(
LEVEL NUMBER,
pid IAWA.pid%TYPE,
IDIAWA.ID%TYPE,
page IAWA.page%TYPE,
code IAWA.code%TYPE,
description IAWA.description%TYPE,
sortorder IAWA.sortorder%TYPE
);
-- Strong Ref Cursor based on Programmer-Defined Record.
TYPE IAWAPage_CurTyp IS REF CURSOR RETURN IawaPage_RecTyp;
/* Weak Ref Cursor for general use. */
TYPE Generic_CurTyp IS REF CURSOR;
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2 DEFAULT 'A',
p_rs IN OUT IAWAPage_CurTyp
);
PROCEDURE TEST;
END;
/
(Body):
CREATE OR REPLACE PACKAGE BODY Iawa_Pkg AS
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2,
p_rs IN OUT IAWAPage_CurTyp
)
IS
/* Declaration section. */
BEGIN
-- Open Cursor. --
OPEN p_rs FOR
SELECT
LEVEL,
pid,
ID,
page,
code,
description,
sortorder
FROM
IAWA
WHERE
page = p_page
START WITH ID = 0
CONNECT BY PRIOR ID = pid
ORDER SIBLINGS BY sortorder;
END getIAWAPage;
//
/* Test Procedure. */
//
PROCEDURE TEST
IS
-- Declaration Section.
lc IAWAPage_CurTyp;
rec IAWAPage_RecTyp;
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
getIAWAPage('B', lc);
FETCH lc INTO rec;
WHILE lc%FOUND
LOOP
DBMS_OUTPUT.PUT_LINE(rec.ID || ' ' || rec.Page);
FETCH lc INTO rec;
END LOOP;
CLOSE lc;
END;
END;
/
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: multiple inserts, no solution
You can't insert multiple records with a single inset.You will want to loop over your date list doing a different insert each iteration. cfloop list=datelist index=date cfquery INSERT INTO table (field1,field2,field3) value1,value2,date /cfquery /cfloop Also, the CFTRANSACTION tag is useful when you have complex, multipart database transactions.It allows you to do several inserts or other database transactions, and if any one of them fail, they all fail.Helps prevent problems, where you might be inserting data first into Table A, then related data into Table B.With out a transaction block, the insert into table A could be successful, but then the insert into Table B fails for whatever reason, you would now have incomplete data only in table A.If they where both within a transaction block, then the failure of the insert into Table B, would cancel the insertion into Table A, maintaining the data integrity. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 9:33 AM To: CF-Talk Subject: RE: multiple inserts, no solution Jeremy, when I insert one date at a time there is no problem.The problem comes when the user needs to insert multiple dates for a particular clas. classTitle: Guitar for Beginners (text box) classTime: 12:00-2:00PM (select list) classDate: user chooses Oct 1, Oct 8, Oct 15, Oct 22 OK now, with one click the user should be able to enter this class. On the database end I should have four records classDatesID (primary key) classID (foreign key) classDate classTime I haven't been able to loop through the inserts correctly. Presently it tries to stuff all the dates into the same field as seen below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) I'll look into the transaction tag but I thought it had more to do with multiple insertions by multiple people and ensuring that one transaction was finished before starting another. thx, Gil -Original Message- From: Jeremy Brodie [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 11:55 AM To: CF-Talk Subject: Re:multiple inserts, no solution Gilbert, 1) Use the CreateODBCDate function i.e CreateODBCDate(createdate(form.year,form.month,form.day)) This will fix the date formating problem 2) Think about using a seperate lookup table associating classes with times. This way you can CFLoop around the infoirmation and pull the dates into the database correctly using the CreateODBCDate function. This way you can have as many dates as needed for each class. You should be able to loop over the list and insert the transaction, as long as you have CFTRANSACTION tags and a CFTRY/CFCATCH block around the insert To pull the items from the database for the dates later all you'll need to do is use a inner join. 3) Are you calling CFSET statement correctly? cfset #FORM.month##getClassDate# ... outputs at 101102103. If you use cfset #evaluate(FORM.month#getClassDate#) This will output the variable you passing month1 correctly. In my pervious example it would be CreateODBCDate(createdate(evaluate(form.year#getClassDate#),evalaute(form .month#getClassDate#,evalaute(form.day#getClassDate#)) Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE BACKGROUND INFO: I'm creating an admin form allowing a user to enter class schedules. Class Title, Class Description, Class Time, Class Price are all simple inserts. The problem comes in when entering the class dates. There are sometimes one class, sometimes two, four or six. Often times they will be one week apart, but not always. example: Class 1 will meet at 2PM on Tuesday the 1st, the 8th, the 15th, the 22nd. The admin page allows the user to put in the dates desired by clicking on the appropriate calendar day. PROBLEM: One click should allow the user to input 2 or more class dates. A straight loop cfloop from=1 to=#classQty# tries to input multiple class days into the classDate field. example of error below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) SOLUTION ???: I had thought that I could do something like the following cfoutput cfloop from=1 to=#FORM.number# index=getClassDate cfset date=#FORM.month##getClassDate#/#FORM.day1##getClassDate#/#FORM.yea r 1##getClassDate# cfquery name= datasource= INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '#FORM.classID#', '#FORM.classDay#', '#FORM.classSession#', '#date#', '#FORM.classTime#' ) /cfquery /cfloop /cfoutput I see why it doesn't work. So, how does one do multiple
RE: multiple inserts, no solution
jeremy, I'll give cftransaction,cftry/cfcatch; and everything another look. thx gil -Original Message- From: Jeremy Brodie [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 1:23 PM To: CF-Talk Subject: Re:multiple inserts, no solution Gil, When you output getClassDate before going into the loop, what is the value of the variable? Is it 4? Is it 1? P.S. The CFTRANSACTION and CFTRY/CFCATCH block are to ensure the right data is going into the mutliple INSERT block Also, take a look at the evaluation function and the CreateOBDCDate functions. These will help you format the date correctly into the database! Jeremy, when I insert one date at a time there is no problem.The problem comes when the user needs to insert multiple dates for a particular clas. classTitle: Guitar for Beginners (text box) classTime: 12:00-2:00PM (select list) classDate: user chooses Oct 1, Oct 8, Oct 15, Oct 22 OK now, with one click the user should be able to enter this class. On the database end I should have four records classDatesID (primary key) classID (foreign key) classDate classTime I haven't been able to loop through the inserts correctly. Presently it tries to stuff all the dates into the same field as seen below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) I'll look into the transaction tag but I thought it had more to do with multiple insertions by multiple people and ensuring that one transaction was finished before starting another. thx, Gil [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Calling Oracle9i StoreProcedure from CFMX
I don't really know much about Oracle, but from what you have posted in your
code you seem to have an in/out param in the SP, if that's the case wouldn't
you need another cfprocparam with type of inout? Just guessing mind.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored
procedure call. Check your bindings against the stored procedure's
parameters.
The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc:
line 23
21 :cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
22 : cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
23 : cfprocresult name=p_rs /
24 :/cfstoredproc
25 :
--
I have tested the procedure outside of ColdFusion and it work
correctly.What am I missing here?According to all the documetation
and other List Messages, it appears to me that I am doing this right.
--
Here is the ColdFusion Code:
cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocresult name=p_rs /
/cfstoredproc
cfoutput#now()#/cfoutput
cfdump var=qry1 /
-
Here is the Strore Procedure definition:
(Specification)
CREATE OR REPLACE PACKAGE Iawa_Pkg AS
/* Programmer-Defined Records. */
-- Record Type for IAWA Page Records.
TYPE IAWAPage_RecTyp IS RECORD
(
LEVEL NUMBER,
pid IAWA.pid%TYPE,
IDIAWA.ID%TYPE,
page IAWA.page%TYPE,
code IAWA.code%TYPE,
description IAWA.description%TYPE,
sortorder IAWA.sortorder%TYPE
);
-- Strong Ref Cursor based on Programmer-Defined Record.
TYPE IAWAPage_CurTyp IS REF CURSOR RETURN IawaPage_RecTyp;
/* Weak Ref Cursor for general use. */
TYPE Generic_CurTyp IS REF CURSOR;
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2 DEFAULT 'A',
p_rs IN OUT IAWAPage_CurTyp
);
PROCEDURE TEST;
END;
/
(Body):
CREATE OR REPLACE PACKAGE BODY Iawa_Pkg AS
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2,
p_rs IN OUT IAWAPage_CurTyp
)
IS
/* Declaration section. */
BEGIN
-- Open Cursor. --
OPEN p_rs FOR
SELECT
LEVEL,
pid,
ID,
page,
code,
description,
sortorder
FROM
IAWA
WHERE
page = p_page
START WITH ID = 0
CONNECT BY PRIOR ID = pid
ORDER SIBLINGS BY sortorder;
END getIAWAPage;
//
/* Test Procedure. */
//
PROCEDURE TEST
IS
-- Declaration Section.
lc IAWAPage_CurTyp;
rec IAWAPage_RecTyp;
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
getIAWAPage('B', lc);
FETCH lc INTO rec;
WHILE lc%FOUND
LOOP
DBMS_OUTPUT.PUT_LINE(rec.ID || ' ' || rec.Page);
FETCH lc INTO rec;
END LOOP;
CLOSE lc;
END;
END;
/
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Setting Locale for Application
you've missed the whole point of that example. it grabs the timezone offset from the client's w/s silently passes it back to the server. I understand the example grabs the TimeZone of User Browser to pass it back to the server. Doesnt the name(getClientTZ.cfm) itself imply that... duh!. The above is Not what i am trying to do..similar though (without using Client/Browser TimeZone). thats not going to give you an ozzy date format. you'll get an ozzy timezone but the server's default locale, if its en_US it will drive your ozzy users nuts. Yes, Typically.. u would use DateFormat.getDateTimeInstance(int dateStyle, int timeStyle, Locale aLocale) The code is an example of how native u have to go to grab a different TimeZone. My Point is Not everybody using CFMX knows how to leverage the Java Classes to do something simple as using different Time Zone's regardless of Server Time... So i think this is should be implemented as a Core function of CFMX (i.e. overload dateFormat()) Joe Eugene - Original Message - From: Paul Hastings To: CF-Talk Sent: Monday, October 13, 2003 1:10 PM Subject: Re: Setting Locale for Application There isnt a direct way to Pull the Locale Time Zone in CFMX, you have use Native Classes to do this. dateConvert() is NOT a clean solution.. you've missed the whole point of that example. it grabs the timezone offset from the client's w/s silently passes it back to the server. from there you can do what needs to be done. dateConvert is server oriented is fine if thats all you need. the timeZoneCFC allows you to cast to other timezones provided you know which one (that's the purpose of that qForms example). if you combine that with the geoLocatorCFC you can pretty much pinpoint the user's exact timezone. that said, you should still offer the user a manual way to set their timezone. it seems you also don't understand what a locale is. maybe you better get that clear. tz = createObject(Java, java.util.TimeZone).getTimeZone(Australia/Melbourne); df= createObject(java, java.text.DateFormat).getDateTimeInstance(); df.setTimeZone(tz); writeOutput(df.format(now()); thats not going to give you an ozzy date format. you'll get an ozzy timezone but the server's default locale, if its en_US it will drive your ozzy users nuts. This should really be implemented in CFMX with dateFormat() as an Overloaded Method. well its not. dateFormat(now(), DD-MM-, Australia/Melbourne) since you're using numeric dates, this isn't going to matter for locales (if thats what you're on about) it will matter for boundary conditions (times that are +/- the timezone of next or previous day). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Odd XML parsing behavior
Ouch. Heheh. Sorry I asked. It turned out to have been something else - this particular RSS (BBC feed in fact) was for whatever reason taking an extra long time to build. I tried it w/ a handful of other feeds and it seems fine now. Thanks, Rich -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 9:30 AM To: CF-Talk Subject: Re: Odd XML parsing behavior And while we're on the topic: are there better alternatives to MX's native XML support? You can call a Java parser directly and do pretty much whatever you want with it... BTW I have an old quote on this: I have yet to come across an XML system where the true performance bottleneck is XML parser speed. Moreover, the people I meet who are infatuated with parser speed are the same people who thought the Web would never work because HTTP was too slow or that Java would never succeed because it is too slow. Those old enough to have been there used to claim systems written in C rather than assembler would be too slow. -Sean McGrath :-))) Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Good way to search XML
What's the most efficient way to search through an XML to check - let's say - a user name password kept in an XML file of all users? I haven't dug into this yet - but I'm going to try pulling the XML and then Xpath? Any other approaches? -Rich [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Creating Word Doc
I do this all the time. It's relatively simple. Create what you want the document to look like in Word, then save it as an RTF. Open the RTF, figure out where your dynamic content is, and replace it with the variables you need. You do need to learn some very basic RTF syntax, but I've found that I can usually muck with it to get what I want. -d - Original Message - From: Dwayne Cole [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 12, 2003 4:43 AM Subject: RE: Creating Word Doc Thanks for the sugggestions. I may not need a word document. A RTF document will work fine.Here's the use casescenario: We have generic consulting agreement and I want to 'fill in the blanks' with data from the database. I want the user of the system to be able to modify parts of the agreement if necessary and save a copy to the local drive. Currently, I'm generating a HTML version of the consulting agreement. Occassionally, an extra condition or two may need to be added to or removed from the agreement and our HTML version is not very freindly to changes. Likewise with PDF. If I recall correctly, in Ben's advanced CF5 book, he began with a RTF file then had ColdFusion scan the file and perform some text replacement operations.I tried this approach a little more than a year ago and it worked OK. Some fields (date fields and fields that appeared more than once), however, were kinda iffy.So now I woundering if there are any smoother aproaches. Or if I should work out the kinks in the scan and replace approach. Ultimately I would like to create a component that enables the user to make their own decision about the agreement format. The cfcoment solutions seem fine for creating the .doc file, but I'm looking for informaiton that deals with the process of populating the a file with a mix of static and dynamic content then returning something that the user can edit. Dwayne Cole, MS in MIS, MBA Certified Advanced ColdFusion Developer 850-591-0212 It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing. The Fifth Discipline - Peter Senge -- Original Message -- From: Sandy Clark [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Sat, 11 Oct 2003 19:04:25 -0400 Sam Neff gave a presentation on creating Word Documents without COM at the Maryland CFUG earlier this year. You might want to check for his presentation on their site. _ From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Saturday, October 11, 2003 3:57 PM To: CF-Talk Subject: Creating Word Doc I'm trying to use the information in the database to generate contracts in MS word.Can anyone here refer me to some tutorials or to some custom tags to help out with this process Dwayne Cole, MS in MIS, MBA Certified Advanced ColdFusion Developer 850-591-0212 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calling Oracle9i StoreProcedure from CFMX
What would this other CFPROCPARAM look like?
Adrian Lynch wrote:
I don't really know much about Oracle, but from what you have posted
in your
code you seem to have an in/out param in the SP, if that's the case
wouldn't
you need another cfprocparam with type of inout? Just guessing mind.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored
procedure call. Check your bindings against the stored procedure's
parameters.
The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc:
line 23
21 :cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
22 : cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
23 : cfprocresult name=p_rs /
24 :/cfstoredproc
25 :
--
I have tested the procedure outside of ColdFusion and it work
correctly.What am I missing here?According to all the documetation
and other List Messages, it appears to me that I am doing this right.
--
Here is the ColdFusion Code:
cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocresult name=p_rs /
/cfstoredproc
cfoutput#now()#/cfoutput
cfdump var=qry1 /
-
Here is the Strore Procedure definition:
(Specification)
CREATE OR REPLACE PACKAGE Iawa_Pkg AS
/* Programmer-Defined Records. */
-- Record Type for IAWA Page Records.
TYPE IAWAPage_RecTyp IS RECORD
(
LEVEL NUMBER,
pid IAWA.pid%TYPE,
IDIAWA.ID%TYPE,
page IAWA.page%TYPE,
code IAWA.code%TYPE,
description IAWA.description%TYPE,
sortorder IAWA.sortorder%TYPE
);
-- Strong Ref Cursor based on Programmer-Defined Record.
TYPE IAWAPage_CurTyp IS REF CURSOR RETURN IawaPage_RecTyp;
/* Weak Ref Cursor for general use. */
TYPE Generic_CurTyp IS REF CURSOR;
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2 DEFAULT 'A',
p_rs IN OUT IAWAPage_CurTyp
);
PROCEDURE TEST;
END;
/
(Body):
CREATE OR REPLACE PACKAGE BODY Iawa_Pkg AS
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2,
p_rs IN OUT IAWAPage_CurTyp
)
IS
/* Declaration section. */
BEGIN
-- Open Cursor. --
OPEN p_rs FOR
SELECT
LEVEL,
pid,
ID,
page,
code,
description,
sortorder
FROM
IAWA
WHERE
page = p_page
START WITH ID = 0
CONNECT BY PRIOR ID = pid
ORDER SIBLINGS BY sortorder;
END getIAWAPage;
//
/* Test Procedure. */
//
PROCEDURE TEST
IS
-- Declaration Section.
lc IAWAPage_CurTyp;
rec IAWAPage_RecTyp;
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
getIAWAPage('B', lc);
FETCH lc INTO rec;
WHILE lc%FOUND
LOOP
DBMS_OUTPUT.PUT_LINE(rec.ID || ' ' || rec.Page);
FETCH lc INTO rec;
END LOOP;
CLOSE lc;
END;
END;
/
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
clustering cfmx
oi CF-Talk,!! knowing not much about clustering, is it possible to cluster cfmx if it is running as a standalone server, or does it need to be integrated with IIS (for example...) -- --- [This E-mail scanned for viruses by Declude Virus] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:multiple inserts, no solution
Agreed. The point I was trying t cftransaction cfloop list=datelist index=date cftry cfquery INSERT INTO table (field1,field2,field3) value1,value2,date /cfquery cfcatch Run error catching code cfabort /cfcatch /cftry /cfloop /cftranaction You can't insert multiple records with a single inset.You will want to loop over your date list doing a different insert each iteration. cfloop list=datelist index=date cfquery INSERT INTO table (field1,field2,field3) value1,value2,date /cfquery /cfloop Also, the CFTRANSACTION tag is useful when you have complex, multipart database transactions.It allows you to do several inserts or other database transactions, and if any one of them fail, they all fail.Helps prevent problems, where you might be inserting data first into Table A, then related data into Table B.With out a transaction block, the insert into table A could be successful, but then the insert into Table B fails for whatever reason, you would now have incomplete data only in table A.If they where both within a transaction block, then the failure of the insert into Table B, would cancel the insertion into Table A, maintaining the data integrity. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 9:33 AM To: CF-Talk Subject: RE: multiple inserts, no solution Jeremy, when I insert one date at a time there is no problem.The problem comes when the user needs to insert multiple dates for a particular clas. classTitle: Guitar for Beginners (text box) classTime: 12:00-2:00PM (select list) classDate: user chooses Oct 1, Oct 8, Oct 15, Oct 22 OK now, with one click the user should be able to enter this class. On the database end I should have four records classDatesID (primary key) classID (foreign key) classDate classTime I haven't been able to loop through the inserts correctly. Presently it tries to stuff all the dates into the same field as seen below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) I'll look into the transaction tag but I thought it had more to do with multiple insertions by multiple people and ensuring that one transaction was finished before starting another. thx, Gil -Original Message- From: Jeremy Brodie [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 11:55 AM To: CF-Talk Subject: Re:multiple inserts, no solution Gilbert, 1) Use the CreateODBCDate function i.e CreateODBCDate(createdate(form.year,form.month,form.day)) This will fix the date formating problem 2) Think about using a seperate lookup table associating classes with times. This way you can CFLoop around the infoirmation and pull the dates into the database correctly using the CreateODBCDate function. This way you can have as many dates as needed for each class. You should be able to loop over the list and insert the transaction, as long as you have CFTRANSACTION tags and a CFTRY/CFCATCH block around the insert To pull the items from the database for the dates later all you'll need to do is use a inner join. 3) Are you calling CFSET statement correctly? cfset #FORM.month##getClassDate# ... outputs at 101102103. If you use cfset #evaluate(FORM.month#getClassDate#) This will output the variable you passing month1 correctly. In my pervious example it would be CreateODBCDate(createdate(evaluate(form.year#getClassDate#),evalaute(form .month#getClassDate#,evalaute(form.day#getClassDate#)) Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE BACKGROUND INFO: I'm creating an admin form allowing a user to enter class schedules. Class Title, Class Description, Class Time, Class Price are all simple inserts. The problem comes in when entering the class dates. There are sometimes one class, sometimes two, four or six. Often times they will be one week apart, but not always. example: Class 1 will meet at 2PM on Tuesday the 1st, the 8th, the 15th, the 22nd. The admin page allows the user to put in the dates desired by clicking on the appropriate calendar day. PROBLEM: One click should allow the user to input 2 or more class dates. A straight loop cfloop from=1 to=#classQty# tries to input multiple class days into the classDate field. example of error below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) SOLUTION ???: I had thought that I could do something like the following cfoutput cfloop from=1 to=#FORM.number# index=getClassDate cfset date=#FORM.month##getClassDate#/#FORM.day1##getClassDate#/#FORM.yea r 1##getClassDate# cfquery name= datasource= INSERT INTO classDates ( classID,
RE: Good way to search XML
It depends on your XML file format.If you want the ability to search rapidly based on username, then structure your XML like this: user-list user username=barneyb nameBarney Boisvert/name passwordmyPass/password /username user-list Having the username as an attribute to the USER tag will allow you to pull just that node out with your XPath _expression_.You can obviusly add multple attributes to the tag.If you want to search that same snip by name, you have to use XPath to get the entire user list in a CF array, and then loop the array and search.Not nearly as effecient.This is similar in concept to how indexes work in a database.Like the database, there is a cost to having lots of attributes, though it's readability in this case, rather than insert/update/delete speed. barneyb -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 10:43 AM To: CF-Talk Subject: Good way to search XML What's the most efficient way to search through an XML to check - let's say - a user name password kept in an XML file of all users? I haven't dug into this yet - but I'm going to try pulling the XML and then Xpath? Any other approaches? -Rich [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Calling Oracle9i StoreProcedure from CFMX
cfstoredproc procedure=IAWA_PKG.getIAWAPage datasource=InsideWood
debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A null=no /
cfprocparam type=InOut cfsqltype=CF_SQL_?? value=Something
variable=SomethingElse /
/cfstoredproc
But then I've noticed the in/out param in the SQL is a custom type. Not sure
what to do with this :OS
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:55
To: CF-Talk
Subject: Re: Calling Oracle9i StoreProcedure from CFMX
What would this other CFPROCPARAM look like?
Adrian Lynch wrote:
I don't really know much about Oracle, but from what you have posted
in your
code you seem to have an in/out param in the SP, if that's the case
wouldn't
you need another cfprocparam with type of inout? Just guessing mind.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored
procedure call. Check your bindings against the stored procedure's
parameters.
The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc:
line 23
21 :cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
22 : cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
23 : cfprocresult name=p_rs /
24 :/cfstoredproc
25 :
--
I have tested the procedure outside of ColdFusion and it work
correctly.What am I missing here?According to all the documetation
and other List Messages, it appears to me that I am doing this right.
--
Here is the ColdFusion Code:
cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocresult name=p_rs /
/cfstoredproc
cfoutput#now()#/cfoutput
cfdump var=qry1 /
-
Here is the Strore Procedure definition:
(Specification)
CREATE OR REPLACE PACKAGE Iawa_Pkg AS
/* Programmer-Defined Records. */
-- Record Type for IAWA Page Records.
TYPE IAWAPage_RecTyp IS RECORD
(
LEVEL NUMBER,
pid IAWA.pid%TYPE,
IDIAWA.ID%TYPE,
page IAWA.page%TYPE,
code IAWA.code%TYPE,
description IAWA.description%TYPE,
sortorder IAWA.sortorder%TYPE
);
-- Strong Ref Cursor based on Programmer-Defined Record.
TYPE IAWAPage_CurTyp IS REF CURSOR RETURN IawaPage_RecTyp;
/* Weak Ref Cursor for general use. */
TYPE Generic_CurTyp IS REF CURSOR;
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2 DEFAULT 'A',
p_rs IN OUT IAWAPage_CurTyp
);
PROCEDURE TEST;
END;
/
(Body):
CREATE OR REPLACE PACKAGE BODY Iawa_Pkg AS
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2,
p_rs IN OUT IAWAPage_CurTyp
)
IS
/* Declaration section. */
BEGIN
-- Open Cursor. --
OPEN p_rs FOR
SELECT
LEVEL,
pid,
ID,
page,
code,
description,
sortorder
FROM
IAWA
WHERE
page = p_page
START WITH ID = 0
CONNECT BY PRIOR ID = pid
ORDER SIBLINGS BY sortorder;
END getIAWAPage;
//
/* Test Procedure. */
//
PROCEDURE TEST
IS
-- Declaration Section.
lc IAWAPage_CurTyp;
rec IAWAPage_RecTyp;
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
getIAWAPage('B', lc);
FETCH lc INTO rec;
WHILE lc%FOUND
LOOP
DBMS_OUTPUT.PUT_LINE(rec.ID || ' ' || rec.Page);
FETCH lc INTO rec;
END LOOP;
CLOSE lc;
END;
END;
/
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Setting Locale for Application
I understand the example grabs the TimeZone of User Browser to pass it back to the server. Doesnt the name(getClientTZ.cfm) itself imply that... duh!. no you don't. it gets the timezone _offset_, not the timezone. the other malarkey about timeZoneCFC, geoLocatorCFC, etc. is aimed at fixing that offset in a timezone, then you can get DST, etc. The above is Not what i am trying to do..similar though (without using Client/Browser TimeZone). there is no other way. locales (which you need to understand) are not equal to timezones. i'm in GMT+7 (bangkok) but i use en_US locale. these obviously aren't the same. en_US in fact might cover several timezones (if it actually meant somebody just the US). My Point is Not everybody using CFMX knows how to leverage the Java Classes to do something simple as using different Time Zone's regardless of Server Time... there are CFCs, custom tags, etc that do this already. So i think this is should be implemented as a Core function of CFMX (i.e. overload dateFormat()) there's a place for that kind of stuff. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calling Oracle9i StoreProcedure from CFMX
I do not believe this method is support in MX 6.1 as in previous version. But here is what I tried: --- cfstoredproc procedure=IAWA_PKG.getIAWAPage datasource=InsideWood debug=yes returncode=yes cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A null=no cfprocparam type=InOut cfsqltype=CF_SQL_REFCURSOR value=xxx cfprocresult name=p_rs resultset=1 /cfstoredproc Here is the Error I got back: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]The specified SQL type is not supported by this driver. The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc: line 25 23 : cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A null=no 24 : cfprocparam type=InOut cfsqltype=CF_SQL_REFCURSOR value=xxx 25 : cfprocresult name=p_rs resultset=1 26 :/cfstoredproc 27 : [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calling Oracle9i StoreProcedure from CFMX
I just can not seem to figure out what I am missing because I am doing
it exactly like this article on Macromedia's Web site:
http://www.macromedia.com/devnet/mx/coldfusion/articles/stored_procs.html
I wonder if this is a BUG that was introduced in CFMX 6.1.
Adrian Lynch wrote:
cfstoredproc procedure=IAWA_PKG.getIAWAPage datasource=InsideWood
debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocparam type=InOut cfsqltype=CF_SQL_?? value=Something
variable=SomethingElse /
/cfstoredproc
But then I've noticed the in/out param in the SQL is a custom type.
Not sure
what to do with this :OS
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:55
To: CF-Talk
Subject: Re: Calling Oracle9i StoreProcedure from CFMX
What would this other CFPROCPARAM look like?
Adrian Lynch wrote:
I don't really know much about Oracle, but from what you have posted
in your
code you seem to have an in/out param in the SP, if that's the case
wouldn't
you need another cfprocparam with type of inout? Just guessing mind.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored
procedure call. Check your bindings against the stored procedure's
parameters.
The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc:
line 23
21 :cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
22 : cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
23 : cfprocresult name=p_rs /
24 :/cfstoredproc
25 :
--
I have tested the procedure outside of ColdFusion and it work
correctly.What am I missing here?According to all the documetation
and other List Messages, it appears to me that I am doing this right.
--
Here is the ColdFusion Code:
cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocresult name=p_rs /
/cfstoredproc
cfoutput#now()#/cfoutput
cfdump var=qry1 /
-
Here is the Strore Procedure definition:
(Specification)
CREATE OR REPLACE PACKAGE Iawa_Pkg AS
/* Programmer-Defined Records. */
-- Record Type for IAWA Page Records.
TYPE IAWAPage_RecTyp IS RECORD
(
LEVEL NUMBER,
pid IAWA.pid%TYPE,
IDIAWA.ID%TYPE,
page IAWA.page%TYPE,
code IAWA.code%TYPE,
description IAWA.description%TYPE,
sortorder IAWA.sortorder%TYPE
);
-- Strong Ref Cursor based on Programmer-Defined Record.
TYPE IAWAPage_CurTyp IS REF CURSOR RETURN IawaPage_RecTyp;
/* Weak Ref Cursor for general use. */
TYPE Generic_CurTyp IS REF CURSOR;
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2 DEFAULT 'A',
p_rs IN OUT IAWAPage_CurTyp
);
PROCEDURE TEST;
END;
/
(Body):
CREATE OR REPLACE PACKAGE BODY Iawa_Pkg AS
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2,
p_rs IN OUT IAWAPage_CurTyp
)
IS
/* Declaration section. */
BEGIN
-- Open Cursor. --
OPEN p_rs FOR
SELECT
LEVEL,
pid,
ID,
page,
code,
description,
sortorder
FROM
IAWA
WHERE
page = p_page
START WITH ID = 0
CONNECT BY PRIOR ID = pid
ORDER SIBLINGS BY sortorder;
END getIAWAPage;
//
/* Test Procedure. */
//
PROCEDURE TEST
IS
-- Declaration Section.
lc IAWAPage_CurTyp;
rec IAWAPage_RecTyp;
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
getIAWAPage('B', lc);
FETCH lc INTO rec;
WHILE lc%FOUND
LOOP
DBMS_OUTPUT.PUT_LINE(rec.ID || ' ' || rec.Page);
FETCH lc INTO rec;
END LOOP;
CLOSE lc;
END;
END;
/
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Calling Oracle9i StoreProcedure from CFMX
ALL,
I believe I have FOUND the problem.
I removed the returncode attribute from the CFSTOREDPROC tag and
that seemed to fix the problem.
I guess this attribute is not supported in the ORACLE JDBC Driver.
Here is the Original Line:
cfstoredproc procedure=IAWA_PKG.getIAWAPage datasource=InsideWood
debug=yes returncode=yes
Here is the New Line:
cfstoredproc procedure=IAWA_PKG.getIAWAPage datasource=InsideWood
debug=yes
Thanks,
Troy
Adrian Lynch wrote:
cfstoredproc procedure=IAWA_PKG.getIAWAPage datasource=InsideWood
debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocparam type=InOut cfsqltype=CF_SQL_?? value=Something
variable=SomethingElse /
/cfstoredproc
But then I've noticed the in/out param in the SQL is a custom type.
Not sure
what to do with this :OS
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:55
To: CF-Talk
Subject: Re: Calling Oracle9i StoreProcedure from CFMX
What would this other CFPROCPARAM look like?
Adrian Lynch wrote:
I don't really know much about Oracle, but from what you have posted
in your
code you seem to have an in/out param in the SP, if that's the case
wouldn't
you need another cfprocparam with type of inout? Just guessing mind.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored
procedure call. Check your bindings against the stored procedure's
parameters.
The error occurred in C:\CFusionMX\wwwroot\InsideWood\model\iawa.cfc:
line 23
21 :cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
22 : cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
23 : cfprocresult name=p_rs /
24 :/cfstoredproc
25 :
--
I have tested the procedure outside of ColdFusion and it work
correctly.What am I missing here?According to all the documetation
and other List Messages, it appears to me that I am doing this right.
--
Here is the ColdFusion Code:
cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A
null=no /
cfprocresult name=p_rs /
/cfstoredproc
cfoutput#now()#/cfoutput
cfdump var=qry1 /
-
Here is the Strore Procedure definition:
(Specification)
CREATE OR REPLACE PACKAGE Iawa_Pkg AS
/* Programmer-Defined Records. */
-- Record Type for IAWA Page Records.
TYPE IAWAPage_RecTyp IS RECORD
(
LEVEL NUMBER,
pid IAWA.pid%TYPE,
IDIAWA.ID%TYPE,
page IAWA.page%TYPE,
code IAWA.code%TYPE,
description IAWA.description%TYPE,
sortorder IAWA.sortorder%TYPE
);
-- Strong Ref Cursor based on Programmer-Defined Record.
TYPE IAWAPage_CurTyp IS REF CURSOR RETURN IawaPage_RecTyp;
/* Weak Ref Cursor for general use. */
TYPE Generic_CurTyp IS REF CURSOR;
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2 DEFAULT 'A',
p_rs IN OUT IAWAPage_CurTyp
);
PROCEDURE TEST;
END;
/
(Body):
CREATE OR REPLACE PACKAGE BODY Iawa_Pkg AS
PROCEDURE getIAWAPage
(
p_page IN VARCHAR2,
p_rs IN OUT IAWAPage_CurTyp
)
IS
/* Declaration section. */
BEGIN
-- Open Cursor. --
OPEN p_rs FOR
SELECT
LEVEL,
pid,
ID,
page,
code,
description,
sortorder
FROM
IAWA
WHERE
page = p_page
START WITH ID = 0
CONNECT BY PRIOR ID = pid
ORDER SIBLINGS BY sortorder;
END getIAWAPage;
//
/* Test Procedure. */
//
PROCEDURE TEST
IS
-- Declaration Section.
lc IAWAPage_CurTyp;
rec IAWAPage_RecTyp;
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
getIAWAPage('B', lc);
FETCH lc INTO rec;
WHILE lc%FOUND
LOOP
DBMS_OUTPUT.PUT_LINE(rec.ID || ' ' || rec.Page);
FETCH lc INTO rec;
END LOOP;
CLOSE lc;
END;
END;
/
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Setting Locale for Application
there is no other way. locales (which you need to understand) are not equal to timezones. I never said TimeZone == Locale You can run the below code and check the output... --- TimeZone tz = TimeZone.getTimeZone(Europe/Berlin); DateFormat df= DateFormat.getDateTimeInstance(DateFormat.FULL,DateFormat.FULL,Locale.GERMANY); df.setTimeZone(tz); System.out.println(df.format(new Date())+ :+ tz.getDisplayName()); -- OUPUT : Montag, 13. Oktober 2003 21.10 Uhr CEST: Central European Time You can see the Date/Time for Berlin TimeZone Displayed in LOCAL GERMAN FORMAT. Joe Eugene - Original Message - From: Paul Hastings To: CF-Talk Sent: Monday, October 13, 2003 2:19 PM Subject: Re: Setting Locale for Application I understand the example grabs the TimeZone of User Browser to pass it back to the server. Doesnt the name(getClientTZ.cfm) itself imply that... duh!. no you don't. it gets the timezone _offset_, not the timezone. the other malarkey about timeZoneCFC, geoLocatorCFC, etc. is aimed at fixing that offset in a timezone, then you can get DST, etc. The above is Not what i am trying to do..similar though (without using Client/Browser TimeZone). there is no other way. locales (which you need to understand) are not equal to timezones. i'm in GMT+7 (bangkok) but i use en_US locale. these obviously aren't the same. en_US in fact might cover several timezones (if it actually meant somebody just the US). My Point is Not everybody using CFMX knows how to leverage the Java Classes to do something simple as using different Time Zone's regardless of Server Time... there are CFCs, custom tags, etc that do this already. So i think this is should be implemented as a Core function of CFMX (i.e. overload dateFormat()) there's a place for that kind of stuff. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: multiple inserts, no solution
You didn't mention what DB you are using.I have done exactly this on Oracle, using the following code: cfquery name=FaveItems datasource=#request.app.dsn# INSERT INTOtr_gui_favorites SELECT cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#REQUEST.CFA.REQUESTOR_ID#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#type_cd#, column_value FROM ( SELECT column_value from TABLE (cast(numTableType(cfqueryparam cfsqltype=CF_SQL_VARCHAR list=Yes value=#FaveItems# separator=,) as numTableType)) ) /cfquery Obviously, you'll need to make changes to this, but it might require firing the neurons up a bit. Pete - Original Message - From: mayo To: CF-Talk Sent: Monday, October 13, 2003 10:52 AM Subject: multiple inserts, no solution BACKGROUND INFO: I'm creating an admin form allowing a user to enter class schedules. Class Title, Class Description, Class Time, Class Price are all simple inserts. The problem comes in when entering the class dates. There are sometimes one class, sometimes two, four or six. Often times they will be one week apart, but not always. example: Class 1 will meet at 2PM on Tuesday the 1st, the 8th, the 15th, the 22nd. The admin page allows the user to put in the dates desired by clicking on the appropriate calendar day. PROBLEM: One click should allow the user to input 2 or more class dates. A straight loop cfloop from=1 to=#classQty# tries to input multiple class days into the classDate field. example of error below: INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '5', 'Mon', '1', '2003,2003,2003,2003/10,10,10,10/1,8,15,22', '12:00-2:00' ) SOLUTION ???: I had thought that I could do something like the following cfoutput cfloop from=1 to=#FORM.number# index=getClassDate cfset date=#FORM.month##getClassDate#/#FORM.day1##getClassDate#/#FORM.year 1##getClassDate# cfquery name= datasource= INSERT INTO classDates ( classID, classDay, classSession, classDates, classTime ) VALUES ( '#FORM.classID#', '#FORM.classDay#', '#FORM.classSession#', '#date#', '#FORM.classTime#' ) /cfquery /cfloop /cfoutput I see why it doesn't work. So, how does one do multiple inserts of this kind? Gilbert Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Setting Locale for Application
I never said TimeZone == Locale you started off this whole thing like that. OUPUT : Montag, 13. Oktober 2003 21.10 Uhr CEST: Central European Time You can see the Date/Time for Berlin TimeZone Displayed in LOCAL GERMAN FORMAT. so? here's hebrew dates w/hebrew calendar in thai or whatever: http://www.sustainablegis.com/projects/calendars/hebrewCalendarTB.cfm. is there some kind of point to this? are you again equating locales w/timezones? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: error: object expected
Thanks for the tip, Ade.Before I try cfdump, I wanted to let you know that the error does not occur in Netscape 7.1. -Sam - Original Message - From: Adrian Lynch To: CF-Talk Sent: Monday, October 13, 2003 11:43 AM Subject: RE: error: object expected I think for xhtml you should look to put the form outside the table. As for the error, I doubt it is to do with the message attribute of your option tag. Forget about the html for a while and just output the query. Try using cfdump var=#yourQueryName# / to have a look at the query. Ade -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 16:38 To: CF-Talk Subject: error: object expected Hi everyone.Thanks to Lee and Ian for helping me last time with dynamic menus.I was able to get into the webmonkey tutorial Ian recommended and also have absorbed Lee's technique for meshing HTML form elements with cfinput tags.THanks guys.I am having another issue now.I keep getting a java run-time error on windows xp, and error:object expected on Win 2k.I'm not sure if mixing the form elements of CFML and HTML has caused the issue.I don't think so actually because they work really well.Here's what I've got for that: select name=countryoption value= selected--Select--/optionCFOUTPUT query=Countriesoption value=Country message=Enter your country.#Country#/option /CFOUTPUT/select Perhaps I shouldn't put the message attribute in the tag. The line where the error occurs is line 25 (char 2), which relates to a table tag.Can I put form elements inside of tables?Perhaps this is an IE thing? Thanks, Sam _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Setting Locale for Application
OUPUT : Montag, 13. Oktober 2003 21.10 Uhr CEST: Central European Time You can see the Date/Time for Berlin TimeZone Displayed in LOCAL GERMAN FORMAT. Is the above hebrew? (Oktober = October). What is your point... Are u saying the below isNOT CORRECT? TimeZone tz = TimeZone.getTimeZone(Europe/Berlin); DateFormat df= DateFormat.getDateTimeInstance(DateFormat.FULL, DateFormat.FULL, Locale.GERMANY); df.setTimeZone(tz); System.out.println(df.format(new Date())+ :+ tz.getDisplayName()); --- Does the above code look like TimeZone == Locale ? IF the above is NOT Correct Do you have a correct way of displaying BERLIN TimeZone (Date/Time) + IN-GERMAN LOCALE? Joe Eugene - Original Message - From: Paul Hastings To: CF-Talk Sent: Monday, October 13, 2003 3:35 PM Subject: Re: Setting Locale for Application I never said TimeZone == Locale you started off this whole thing like that. OUPUT : Montag, 13. Oktober 2003 21.10 Uhr CEST: Central European Time You can see the Date/Time for Berlin TimeZone Displayed in LOCAL GERMAN FORMAT. so? here's hebrew dates w/hebrew calendar in thai or whatever: http://www.sustainablegis.com/projects/calendars/hebrewCalendarTB.cfm. is there some kind of point to this? are you again equating locales w/timezones? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Good way to search XML
user-list user username=barneyb name=Barney Boisvert password=myPass / user username=barneyb1 name=Barney Boisvert 1 password=myPass 1 / user-list Is the above (Attribute Centric XML) slower to search using XPATH than Element Centric ? Joe Eugene - Original Message - From: Barney Boisvert To: CF-Talk Sent: Monday, October 13, 2003 1:59 PM Subject: RE: Good way to search XML It depends on your XML file format.If you want the ability to search rapidly based on username, then structure your XML like this: user-list user username=barneyb nameBarney Boisvert/name passwordmyPass/password /username user-list Having the username as an attribute to the USER tag will allow you to pull just that node out with your XPath _expression_.You can obviusly add multple attributes to the tag.If you want to search that same snip by name, you have to use XPath to get the entire user list in a CF array, and then loop the array and search.Not nearly as effecient.This is similar in concept to how indexes work in a database.Like the database, there is a cost to having lots of attributes, though it's readability in this case, rather than insert/update/delete speed. barneyb -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 10:43 AM To: CF-Talk Subject: Good way to search XML What's the most efficient way to search through an XML to check - let's say - a user name password kept in an XML file of all users? I haven't dug into this yet - but I'm going to try pulling the XML and then Xpath? Any other approaches? -Rich [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Good way to search XML
I honestly don't know, but I doubt the difference is worth worrying about. Element heavy XML is easier to read and maintain, in my opinon, so I primarily go that route.Make it work first, and then if it's unacceptably slow, you can deal with it then.Don't bother spending time on it now unless you know you're going to have to make it faster (which probably means a proper database anyway). -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 1:46 PM To: CF-Talk Subject: Re: Good way to search XML user-list user username=barneyb name=Barney Boisvert password=myPass / user username=barneyb1 name=Barney Boisvert 1 password=myPass 1 / user-list Is the above (Attribute Centric XML) slower to search using XPATH than Element Centric ? Joe Eugene - Original Message - From: Barney Boisvert To: CF-Talk Sent: Monday, October 13, 2003 1:59 PM Subject: RE: Good way to search XML It depends on your XML file format.If you want the ability to search rapidly based on username, then structure your XML like this: user-list user username=barneyb nameBarney Boisvert/name passwordmyPass/password /username user-list Having the username as an attribute to the USER tag will allow you to pull just that node out with your XPath _expression_.You can obviusly add multple attributes to the tag.If you want to search that same snip by name, you have to use XPath to get the entire user list in a CF array, and then loop the array and search.Not nearly as effecient.This is similar in concept to how indexes work in a database.Like the database, there is a cost to having lots of attributes, though it's readability in this case, rather than insert/update/delete speed. barneyb -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 10:43 AM To: CF-Talk Subject: Good way to search XML What's the most efficient way to search through an XML to check - let's say - a user name password kept in an XML file of all users? I haven't dug into this yet - but I'm going to try pulling the XML and then Xpath? Any other approaches? -Rich [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
project/bug management system
Hello All, Could some of you refer me to a project/bug management system that isn't too expensive and comes with source code to customize?(Preferably CF) Thanks, Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: error: object expected
A couple of thoughts.Don't know if you copied your code or typed it into this email?But if you copied it, I suspect you really want option value =#country# otherwise all your selects will have the value of COUNTRY. Also, realize that the reference to the error (line 25, char 2) is for the GENERATED HTML OUTPUT and most likely does not have any relevance to the line numbers in your CFML code file.What I usually do, is View Source and cut and paste that into a new document in my IDE editor.Then I can find out what the Line 25, char 2 really refers to. Usually when I get that error.object.expected error, I am trying to do something to a variable or literal, that I thought referred to an DOM object, but actually doesn't, because I haven't mapped it properly.I would need to see more of your code to check that out, particularly the _javascript_ in question. But I'm out of here for the day, so probably won't get a chance to reply again till late tonight or sometime tomorrow. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 12:27 PM To: CF-Talk Subject: Re: error: object expected Thanks for the tip, Ade.Before I try cfdump, I wanted to let you know that the error does not occur in Netscape 7.1. -Sam - Original Message - From: Adrian Lynch To: CF-Talk Sent: Monday, October 13, 2003 11:43 AM Subject: RE: error: object expected I think for xhtml you should look to put the form outside the table. As for the error, I doubt it is to do with the message attribute of your option tag. Forget about the html for a while and just output the query. Try using cfdump var=#yourQueryName# / to have a look at the query. Ade -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 16:38 To: CF-Talk Subject: error: object expected Hi everyone.Thanks to Lee and Ian for helping me last time with dynamic menus.I was able to get into the webmonkey tutorial Ian recommended and also have absorbed Lee's technique for meshing HTML form elements with cfinput tags.THanks guys.I am having another issue now.I keep getting a java run-time error on windows xp, and error:object expected on Win 2k.I'm not sure if mixing the form elements of CFML and HTML has caused the issue.I don't think so actually because they work really well. Here's what I've got for that: select name=countryoption value= selected--Select--/optionCFOUTPUT query=Countriesoption value=Country message=Enter your country.#Country#/option /CFOUTPUT/select Perhaps I shouldn't put the message attribute in the tag. The line where the error occurs is line 25 (char 2), which relates to a table tag.Can I put form elements inside of tables?Perhaps this is an IE thing? Thanks, Sam _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Good way to search XML
Attribute Centric XML is ALOT Less Lines and Less Nesting. If you try to parse Element Centric XML in DOM, you will have to Jump through More EMPTY NODES VS NO Empty Text Node in Attribute Centric XML EMPTY NODES = \n (which creates more looping) user username=barneyb (Calling NodeList.item(0).getChildNodes() = 5-6 Items depending on \n) CFMX takes care of the Internal XML Parsing to Arrays/Structs... so you generally dont see whats involved. user username=barneyb name=Barney Boisvert password=myPass / Here there is NO Nesting and NO Empty Nodes/Text Nodes (NodeNamedMap nnm = Node.getAttributes() ) Havent timed any performance though on Attribute Vs Element (Centric XML) Joe Eugene - Original Message - From: Barney Boisvert To: CF-Talk Sent: Monday, October 13, 2003 4:51 PM Subject: RE: Good way to search XML I honestly don't know, but I doubt the difference is worth worrying about. Element heavy XML is easier to read and maintain, in my opinon, so I primarily go that route.Make it work first, and then if it's unacceptably slow, you can deal with it then.Don't bother spending time on it now unless you know you're going to have to make it faster (which probably means a proper database anyway). -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 1:46 PM To: CF-Talk Subject: Re: Good way to search XML user-list user username=barneyb name=Barney Boisvert password=myPass / user username=barneyb1 name=Barney Boisvert 1 password=myPass 1 / user-list Is the above (Attribute Centric XML) slower to search using XPATH than Element Centric ? Joe Eugene - Original Message - From: Barney Boisvert To: CF-Talk Sent: Monday, October 13, 2003 1:59 PM Subject: RE: Good way to search XML It depends on your XML file format.If you want the ability to search rapidly based on username, then structure your XML like this: user-list user username=barneyb nameBarney Boisvert/name passwordmyPass/password /username user-list Having the username as an attribute to the USER tag will allow you to pull just that node out with your XPath _expression_.You can obviusly add multple attributes to the tag.If you want to search that same snip by name, you have to use XPath to get the entire user list in a CF array, and then loop the array and search.Not nearly as effecient.This is similar in concept to how indexes work in a database.Like the database, there is a cost to having lots of attributes, though it's readability in this case, rather than insert/update/delete speed. barneyb -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 10:43 AM To: CF-Talk Subject: Good way to search XML What's the most efficient way to search through an XML to check - let's say - a user name password kept in an XML file of all users? I haven't dug into this yet - but I'm going to try pulling the XML and then Xpath? Any other approaches? -Rich [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Counting Mail Messages In A Folder
CF-Pros: We have several report utilities written in CF to report on our e-mail system, Ipswitches iMail. We've been asked to look into a utility (acquire/build) to count the number of messages in each folder. Questions: * What is the delimiter for messages in a folder (is it the same for all mail servers, or unique to a particular mailer, again, we use Ipswitches's iMail, latest version) * I believe some of you are iMail users, anyone aware of utility similar to what we are interested in ? Thank you. -Gerry Gerard T. Pauline Computer Systems, DoIT Pace University [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL DTS Question
I migrated servers this weekend. I have a few jobs scheduled that call DTS packages. The jobs keep failing and I think it is because the PACKAGE IDs are different. When I look through the JOBS and then select the STEP tab, then the step (there is only one) I get DTSRun /~Z0xD2CA57B69919D51B58DC38725C4E50C857A1B0EE72403EDE8004C6F227557875AD9EAAA7A3C5D3256DCE952015C1965F3522BAF7AFAC252234F58E9393E302003D8E72C07FBE2C97DE8FDE77454010E88AC43AC1C4C419A9B903299411228384C27B5C13B50278E50AF61F62D7043A94C5734E0E89F21BA03408730D97A4DD4E487DFC6755D28AD9349A9B68FD7434A6C677A228DEE40C5E05BC1D How can I figure out what DTS package it is trying to call? Thanks, Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
load testing RIA apps
Hello, I just received a project to do load testing on a Flash/CFMX6 RIA. Does anyone know of any tools that I can use to load test against Flash? Thanks in advance! --Josh This mail sent through exciteworks: http://exciteworks.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem upgrading CFMX to MX6.1 for JRun 4
According to the instructions for upgrading MX to MX 6.1, I must first undeploy Cold Fusion MX before deploying Cold Fusion MX 6.1; the instructions for undeploying say to simply delete the cfusion directory from your server. This confuses me, since that directory is where all of the Cold Fusion files for our website live; to delete the directory is to delete our website entirely. I feel like I've missed something very important.I have read and reread the documentation and cannot find any indication that Cold Fusion pages can be deployed anywhere but in the cfusion directory, but it doesn't make sense that you'd destroy your entire website to upgrade Cold Fusion. Any advice or assistance that anyone can offer would be greatly appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Symbolic links treated differently?
Hello - Just a quick question regarding cf_template_path and path_translated variables in CF 4.5 vs MX 6.1.We currently have both CF versions running on the same web server (Solaris 2.7 UNIX) but the values returned in the variables mentioned above is different, even though the environment and database has not been changed.Does MX somehow treat symbolic links differently and yield different values in the cf_template_path and path_translated variables?Is there a setting that might have been missed in the MX 6.1 set-up (doubtful, but possible) ? Im submitting this question for a co-worker, if you need more information i can provide it. Thanks much, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Problem upgrading CFMX to MX6.1 for JRun 4
According to the instructions for upgrading MX to MX 6.1, I must first undeploy Cold Fusion MX before deploying Cold Fusion MX 6.1; the instructions for undeploying say to simply delete the cfusion directory from your server. This confuses me, since that directory is where all of the Cold Fusion files for our website live; to delete the directory is to delete our website entirely. I feel like I've missed something very important. I have read and reread the documentation and cannot find any indication that Cold Fusion pages can be deployed anywhere but in the cfusion directory, but it doesn't make sense that you'd destroy your entire website to upgrade Cold Fusion. Depending on how your web server is configured, you may very well have CFM files in a directory outside of your ColdFusion directory. But since that's where you have them, you should copy them somewhere else first, then continue your undeployment. You might also want to export datasource settings and the like using the Archive Restore functionality from the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem upgrading CFMX to MX6.1 for JRun 4
According to the instructions for upgrading MX to MX 6.1, I must first undeploy Cold Fusion MX before deploying Cold Fusion MX 6.1; the instructions for undeploying say to simply delete the cfusion directory from your server. This confuses me, since that directory is where all of the Cold Fusion files for our website live; to delete the directory is to delete our website entirely. I feel like I've missed something very important.I have read and reread the documentation and cannot find any indication that Cold Fusion pages can be deployed anywhere but in the cfusion directory, but it doesn't make sense that you'd destroy your entire website to upgrade Cold Fusion. Any advice or assistance that anyone can offer would be greatly appreciated. When you run the installer and choose upgrade, it will ask you where to store the backup files. Part of the backup files will be your site if it's under the cfusion directory. So after the installer is run, delete the cfusion directory, deploy the new .war or .ear files (depending on what you selected), and then re-copy over the entire contents of the backup directory, and you'll be fine. As a side note, I'd suggest moving your site outside the JRun installation directory just for easier maintenance. This allows stuff like upgrading MX to occur without having to worry about losing my site! ;) Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Symbolic links treated differently?
Yes, this is exactly the case. CF4.5 didn't dereference symlinks, while CFMX does.I don't know about CF5.HUGE pain in the ass when we migrated, but it's a one-time headache, and MX's other features makes it well worth it. barneyb -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 3:18 PM To: CF-Talk Subject: Symbolic links treated differently? Hello - Just a quick question regarding cf_template_path and path_translated variables in CF 4.5 vs MX 6.1.We currently have both CF versions running on the same web server (Solaris 2.7 UNIX) but the values returned in the variables mentioned above is different, even though the environment and database has not been changed.Does MX somehow treat symbolic links differently and yield different values in the cf_template_path and path_translated variables?Is there a setting that might have been missed in the MX 6.1 set-up (doubtful, but possible) ? Im submitting this question for a co-worker, if you need more information i can provide it. Thanks much, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem upgrading CFMX to MX6.1 for JRun 4
Dave Carabetta wrote: As a side note, I'd suggest moving your site outside the JRun installation directory just for easier maintenance. This allows stuff like upgrading MX to occur without having to worry about losing my site! ;) I don't know why I was under the impression that the website files had to be located under the JRun directory; probably because I inherited this project who thought that way and I just never bothered to study up on it. Moving the files sounds like a worthy project to be undertaken when I've managed to finish migrating the databases.Ugh. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Setting Locale for Application
Do you have a correct way of displaying BERLIN TimeZone (Date/Time) + IN-GERMAN LOCALE? what's localized in java is hit miss. not everything's localized nor is it localized to the same level. and that is all i shall say on the subject. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Counting Mail Messages In A Folder
If you are using CFMX (maybe even prior versions - I am not sure, you can use the windows file system COM object to count the files and even get the total size etc. I am doing this on a project and it is working great. Try the below code, modify it for your needs. And I suggest doing some CFDUMP's of the COM object which will show you what methods are available. CFDUMP is the shit. Note, that in the below example I am counting the number of files in 2 folders and getting the total, you might not need to do that step. I also use this to count mail files for IMS, and use it to count up to 200,000 files or so all the time. !--- start code --- cfset Folder2Check1 = f:\ims\out\ cfset Folder2Check2= f:\ims\out\queued !--- Connect to the File System Object --- cflock timeout=30 throwontimeout=No name=#CreateUUID()# type=EXCLUSIVE cftry cfobject type=COM name=FSO class=Scripting.FileSystemObject action=""> /cfobject cfcatch cfobject type=COM name=FSO class=Scripting.FileSystemObject action=""> /cfobject /cfcatch /cftry /cflock cfscript objFolder= FSO.getFolder(Folder2Check1); objFolderSize = LSParseNumber(objFolder.size); objtest= objFolder.files; objfileCount1=objtest.count; objFolder= FSO.getFolder(Folder2Check2); objtest= objFolder.files; objfileCount2=objtest.count; /cfscript cfset total=objfileCount1+objfileCount2 cfoutput Total Files Used: #LSParseNumber(DecimalFormat(total))#BR Total Space Used: #LSParseNumber(DecimalFormat(Evaluate(objFolderSize / 100)))# /cfoutput !--- end code --- Brook Davies At 02:26 PM 10/13/2003, you wrote: CF-Pros: We have several report utilities written in CF to report on our e-mail system, Ipswitches iMail. We've been asked to look into a utility (acquire/build) to count the number of messages in each folder. Questions: * What is the delimiter for messages in a folder (is it the same for all mail servers, or unique to a particular mailer, again, we use Ipswitches's iMail, latest version) * I believe some of you are iMail users, anyone aware of utility similar to what we are interested in ? Thank you. -Gerry Gerard T. Pauline Computer Systems, DoIT Pace University -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Server Hardware
Hello, I'm looking into buying a new box and I was wondering if anyone has any comments/suggestions on the following: Price is an issue, so this is the main guts of the server I've been looking at... Intel Celeron 2.6GHz Processor 1GB PC2700 DDR Memory (2) 120GB ATA100 RAID Hard Drives ATA100 IDE RAID Controller Card This would be running on a Linux OS, probably either RedHat or Debian. I would also be purchasing a CFMX 6.1 license, our new project demands verity so I believe that eliminates BlueDragon(if I find out otherwise I will be looking at each as a possible option). Also, I would be using MySQL and/or PostgreSQL on this same box. Has anyone had experiencing running servers with Celeron processors? Would there be any difference between a Celeron processor or P4? (besides slight difference in processing speed) Anything at all? :-) There is another box that I've seen with a comparable price, with a P4 2.4GHz, slightly more expensive and with 512MB less RAM. That is probably my second option. TIA, Yves Arsenault Carrefour Infotech 5, Acadian Dr. Charlottetown, PEI C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Server Hardware
Unless you need all that disk space, I'd trade some of it for faster processors.It's easier to swap out disks for larger ones down the road than to upgrade your processors, especially with Celerons.I'd consider a gig of RAM a minimum, especially if you're running CF and a DB on one box, so that second box is questionable, though another 512 of RAM shouldn't be that much more. -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 6:29 PM To: CF-Talk Subject: OT: Server Hardware Hello, I'm looking into buying a new box and I was wondering if anyone has any comments/suggestions on the following: Price is an issue, so this is the main guts of the server I've been looking at... Intel Celeron 2.6GHz Processor 1GB PC2700 DDR Memory (2) 120GB ATA100 RAID Hard Drives ATA100 IDE RAID Controller Card This would be running on a Linux OS, probably either RedHat or Debian. I would also be purchasing a CFMX 6.1 license, our new project demands verity so I believe that eliminates BlueDragon(if I find out otherwise I will be looking at each as a possible option). Also, I would be using MySQL and/or PostgreSQL on this same box. Has anyone had experiencing running servers with Celeron processors? Would there be any difference between a Celeron processor or P4? (besides slight difference in processing speed) Anything at all? :-) There is another box that I've seen with a comparable price, with a P4 2.4GHz, slightly more expensive and with 512MB less RAM. That is probably my second option. TIA, Yves Arsenault Carrefour Infotech 5, Acadian Dr. Charlottetown, PEI C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Server Hardware
You might want to look at Dell dimension 4200 for your box, however I understand there are some issues with getting verity running on a Linux system. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Yves Arsenault [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 13, 2003 8:29 PM Subject: OT: Server Hardware | Hello, | | I'm looking into buying a new box and I was wondering if anyone has any | comments/suggestions on the following: | | Price is an issue, so this is the main guts of the server I've been | looking at... | | Intel Celeron 2.6GHz Processor | 1GB PC2700 DDR Memory | (2) 120GB ATA100 RAID Hard Drives | ATA100 IDE RAID Controller Card | | This would be running on a Linux OS, probably either RedHat or Debian. | I would also be purchasing a CFMX 6.1 license, our new project demands | verity so I believe that eliminates BlueDragon(if I find out otherwise I | will be looking at each as a possible option). | | Also, I would be using MySQL and/or PostgreSQL on this same box. | | Has anyone had experiencing running servers with Celeron processors? | Would there be any difference between a Celeron processor or P4? | (besides slight difference in processing speed) | | Anything at all? | | :-) | | There is another box that I've seen with a comparable price, with a P4 | 2.4GHz, slightly more expensive and with 512MB less RAM. That is | probably my second option. | | TIA, | | Yves Arsenault | Carrefour Infotech | 5, Acadian Dr. | Charlottetown, PEI | C1C 1M2 | [EMAIL PROTECTED] | (902)368-1895 ext.242 | | | | --- | Outgoing mail is certified Virus Free. | Checked by AVG anti-virus system (http://www.grisoft.com). | Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Server Hardware
The issue with Verity on Linux is that it doesn't work on anything above RedHat 7.2: http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_known_prob lems.html#verity chris From: Doug White [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 6:42 PM To: CF-Talk Subject: Re: Server Hardware You might want to look at Dell dimension 4200 for your box, however I understand there are some issues with getting verity running on a Linux system. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Yves Arsenault [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 13, 2003 8:29 PM Subject: OT: Server Hardware | Hello, | | I'm looking into buying a new box and I was wondering if anyone has any | comments/suggestions on the following: | | Price is an issue, so this is the main guts of the server I've been | looking at... | | Intel Celeron 2.6GHz Processor | 1GB PC2700 DDR Memory | (2) 120GB ATA100 RAID Hard Drives | ATA100 IDE RAID Controller Card | | This would be running on a Linux OS, probably either RedHat or Debian. | I would also be purchasing a CFMX 6.1 license, our new project demands | verity so I believe that eliminates BlueDragon(if I find out otherwise I | will be looking at each as a possible option). | | Also, I would be using MySQL and/or PostgreSQL on this same box. | | Has anyone had experiencing running servers with Celeron processors? | Would there be any difference between a Celeron processor or P4? | (besides slight difference in processing speed) | | Anything at all? | | :-) | | There is another box that I've seen with a comparable price, with a P4 | 2.4GHz, slightly more expensive and with 512MB less RAM. That is | probably my second option. | | TIA, | | Yves Arsenault | Carrefour Infotech | 5, Acadian Dr. | Charlottetown, PEI | C1C 1M2 | [EMAIL PROTECTED] | (902)368-1895 ext.242 | | | | --- | Outgoing mail is certified Virus Free. | Checked by AVG anti-virus system (http://www.grisoft.com). | Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
flash remoting and dotted directories
Hi I am developing a flash-based site that uses CFCs to communicate with a MySQL database under Windows (yea... I know it's a weird config). Right now we have the site under a name-based hosting provider (I know there are other CFMX ISPs out there... I didn't choose...). http://siteIP/flashservices/gateway is returning a blank page (good news... Remoting is up). However, our site is under something like H:/username/site.dot.com/ (note the dots in my directory name). The problem is: Do you have any tips for mapping my CFCs in Flash? I am trying something like: NetServices.setDefaultGatewayUrl(http://siteIP/flashservices/gateway); this.conn = NetServices.createGatewayConnection(); this.service = this.conn.getService(cfc.cfcname,this); Suppose there is a directory named cfc in which all CFCs are stored (cfc is inside site.dot.com). Any help will be appreciated Mauricio [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Server Hardware
Sounds like a winner to me - although if possible you might consider smaller disks and more RAM.Rarely have I seen web applications needs more than 20 Gig disks, but 2 Gig of RAM is always used.;^) You didn't mention the price, but you may also want to take a look at TigerDirect.com - they often have great deals on servers.You can often find dual PIII 1000's with Dual disks there in the $700 range.Dual PIII's 1000's run extremely well (and should do even better with Linux) and can often beat P4s - and you can get them at rock bottom prices. Jim Davis -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 9:29 PM To: CF-Talk Subject: OT: Server Hardware Hello, I'm looking into buying a new box and I was wondering if anyone has any comments/suggestions on the following: Price is an issue, so this is the main guts of the server I've been looking at... Intel Celeron 2.6GHz Processor 1GB PC2700 DDR Memory (2) 120GB ATA100 RAID Hard Drives ATA100 IDE RAID Controller Card This would be running on a Linux OS, probably either RedHat or Debian. I would also be purchasing a CFMX 6.1 license, our new project demands verity so I believe that eliminates BlueDragon(if I find out otherwise I will be looking at each as a possible option). Also, I would be using MySQL and/or PostgreSQL on this same box. Has anyone had experiencing running servers with Celeron processors? Would there be any difference between a Celeron processor or P4? (besides slight difference in processing speed) Anything at all? :-) There is another box that I've seen with a comparable price, with a P4 2.4GHz, slightly more expensive and with 512MB less RAM. That is probably my second option. TIA, Yves Arsenault Carrefour Infotech 5, Acadian Dr. Charlottetown, PEI C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
