RE: Access to IIS objects from CFML?
This might be of use to you.
REM cscript adsutil.vbs delete w3svc/1/root/%1
cscript adsutil.vbs create_vdir w3svc/1/root/%1
cscript adsutil.vbs set w3svc/1/root/%1/path C:\inetpub\wwwroot\test
cscript adsutil.vbs set w3svc/1/root/%1/DefaultDoc "hikeoverview.cfm"
Creates vdir, sets path, sets document. This should be in the iisadmin
script folder. You would still need to use cfexecute though.
John
Want information on Hikes in Western Washington?
http://www.attrition.ws Check it out!
From: Vitaly Mankevich [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 6:21 PM
To: CF-Talk
Subject: Re:Access to IIS objects from CFML?
Hi Dave,
Thank you for comments...no, all I'm trying to achieve is the "/joe" in
the URL that maps to the same site. It's something that client wants.
Moreover, visitors should be able to create these directories to get
"their own site" or the idea that it's theirs. Some kind of referral
marketing ploy. I don't expect large volume of these virtual dirs, but
if I were the host, I'd think twice before allowing someone to do this
on a shared server. Dedicated goes way over budget.
Any ideas?
>I must confess that I am probably misunderstanding your question,
>because I don't see the need for virtual directories to achieve what
you
>want. From what you describe, it appears that you are merely
attempting
>to employ a login scheme with SES ("search-engine safe") URLs. No?
>
>Dave
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Google and Fusetalk?
We really like the Fusetalk forums and have decided to install them and use them on our sites. One aspect that is important to me is that Google can index our posts. I have visited numerous sites that use Fusetalk forums, including the macromedia.com site, and only about 2 out of 10 are indexed on Google. I look for posts that are a month or older and search for sentences on Google. It seems a couple sites have figured a way to be indexed on Google. If anyone can help me figure out the right configuration settings or modifications I need to make to make our Fusetalk forums "Google-friendly" I would be very grateful. It seems there could be HUGE value in adding all these pages to our site as far as Google is concerned. Thanks. David Matthews [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Access to IIS objects from CFML?
Hi Dave,
Thank you for comments...no, all I'm trying to achieve is the "/joe" in the URL that maps to the same site. It's something that client wants. Moreover, visitors should be able to create these directories to get "their own site" or the idea that it's theirs. Some kind of referral marketing ploy. I don't expect large volume of these virtual dirs, but if I were the host, I'd think twice before allowing someone to do this on a shared server. Dedicated goes way over budget.
Any ideas?
>I must confess that I am probably misunderstanding your question,
>because I don't see the need for virtual directories to achieve what you
>want. From what you describe, it appears that you are merely attempting
>to employ a login scheme with SES ("search-engine safe") URLs. No?
>
>Dave
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
MXDU 2004 Early bird special
MXDU2004 (Macromedia Downunder) is all about how to build and deliver the best experiences on the web, how to engage your customers, and deliver unprecedented returns to your business. Rich Internet Applications are these next generation of web applications that are built with MX, Macromedia's integrated family of tool, server and client technologies enabling these applications across major platforms and devices. MXDU 2003 was very well attended (actually it was a blast!) and next years conference, at Star City on Sydney Harbour, promises to be even better. The early bird $100 discount is available till 22 December 2003. MXDU 2004 is going to rock the kasbah! Visit http://www.mxdu.com for more info and to register. It will be great to finally meet Sean Corfield ;) Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion and PostgreSql
Tom Jordahl wrote: > > Is this something that can be supported using JDBC or ODBC? In theory, yes. Refcursors are exposed through JDBC: http://www.postgresql.org/docs/7.4/static/jdbc-callproc.html#AEN24355 Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion and PostgreSql
Is this something that can be supported using JDBC or ODBC? -- Tom Jordahl Macromedia Server Development -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 7:03 PM To: CF-Talk Subject: Re: ColdFusion and PostgreSql Emma S wrote: > > Does anybody know how to call PostgreSql function from ColdFusion, if > that function returns result set using cursor? I don't think anybody knows (and if somebody does, please speak up). You will have to revert to a Set Returning Function: http://techdocs.postgresql.org/guides/SetReturningFunctions Please fill out the Macromedia wishform to request support for refcursors in PostgreSQL (issue #52200): http://www.macromedia.com/go/wish/ Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: updating with a sub query
Would this work? UPDATE products SET products.dprice = dealerprice.price WHERE products.code = dealerprice.code -Original Message- From: Jim T [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 2:56 PM To: CF-Talk Subject: updating with a sub query Select Distinct(code) from dealerprice update products set dprice = (Select price from dealerprice where code = '#getcodes.code#') where code = '#getcodes.code#' ok the above code gets this error not sure why any help would be appreciated. Operation must use an updateable query. The Error Occurred in C:\Inetpub\wwwroot\tools\pricingupdate.cfm: line 10 8 : update products set dprice = (Select price from dealerprice where code = '#getcodes.code#') 9 : where code = '#getcodes.code#' 10 : 11 : ok [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Single Sign On (implemented in CF)
Thank you, Dave. I'll give them all a try and see which is the easiest to pick up. I appreciate the pointer. Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 10:35 AM To: CF-Talk Subject: RE: Single Sign On (implemented in CF) > > Just use the system with a recording proxy and see for > > yourself. > > Could you recommend one? I'd like to delve a little deeper > with the stuff we are using here. Jochem recommended a Mozilla extension, which is good, but if you want something browser-independent and you're using Windows, you might try Stretch: http://www.kestral.com.au/devtools/stretch/ > Also, could you(or anyone else) recommend a good http > sniffer? I'm not sure if they are the same thing, but I > would like to start playing with stuff like that. An HTTP sniffer (or a general network sniffer) can be used instead of a recording proxy. I like EffeTech HTTP Sniffer (http://www.effetech.com/), but it's a bit overpriced at $40 or so. You might just use something free like Ethereal (http://www.ethereal.com/) , which is a general-purpose network sniffer. 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: Single Sign On (implemented in CF)
I am currently using Mozilla for my default browser and am interested to see how these extension fit in with it. I'll give it a try. Thank you, Jochem. Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 9:35 AM To: CF-Talk Subject: Re: Single Sign On (implemented in CF) Smith, Matthew P -CONT(CSC) wrote: > >> Just use the system with a recording proxy and see for yourself. > > Could you recommend one? I'd like to delve a little deeper with the stuff we are using here. > > Also, could you(or anyone else) recommend a good http sniffer? I'm not sure if they are the same thing, but I would like to start playing with stuff like that. They serve the same purpose. I currently use Mozilla FireBird with the LiveHTTPHeaders extension: http://www.mozilla.org/ http://livehttpheaders.mozdev.org/ Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: queryNew / array functions
thanks guys, yeah this worked. I was building a query and passing it to cfchart, but wanted to give it's scalefrom and scaleto values based on the min/max values in my query. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:04 PM To: CF-Talk Subject: Re: queryNew / array functions Actually, you got me curious, so I tried it. Here tis the syntax: #arraymax(testquery["mycolumn"])# Hm...where could I find a use for thatthere has to be sometime when I've wanted to do that sort of thing -Deanna - Original Message - From: "Heald, Tim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 2:52 PM Subject: RE: queryNew / array functions > something like arrayMax(myQuery[myColumn]) should do the trick. > > > -- > Timothy Heald > Web Portfolio Manager > Overseas Security Advisory Council > U.S. Department of State > 571.345.2319 > > The opinions expressed here do not necessarily reflect those of the U.S. > Department of State or any affiliated organization(s). Nor have these > opinions been approved or sanctioned by these organizations. This e-mail is > unclassified based on the definitions in E.O. 12958. > > -Original Message- > From: Turetsky, Seth [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 3:49 PM > To: CF-Talk > Subject: queryNew / array functions > > > "Coldfusion queries are essentially arrays with named columns. You > therefore > can use any of the array functions with queries" -CFMX WACK > > How would I use say ArrayMax() to get the largest value in a specified > column > of a query I created using queryNew. > > I think my brain left work at lunch today > > -seth > _ > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: queryNew / array functions
Actually, you got me curious, so I tried it. Here tis the syntax: #arraymax(testquery["mycolumn"])# Hm...where could I find a use for thatthere has to be sometime when I've wanted to do that sort of thing -Deanna - Original Message - From: "Heald, Tim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 2:52 PM Subject: RE: queryNew / array functions > something like arrayMax(myQuery[myColumn]) should do the trick. > > > -- > Timothy Heald > Web Portfolio Manager > Overseas Security Advisory Council > U.S. Department of State > 571.345.2319 > > The opinions expressed here do not necessarily reflect those of the U.S. > Department of State or any affiliated organization(s). Nor have these > opinions been approved or sanctioned by these organizations. This e-mail is > unclassified based on the definitions in E.O. 12958. > > -Original Message- > From: Turetsky, Seth [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 3:49 PM > To: CF-Talk > Subject: queryNew / array functions > > > "Coldfusion queries are essentially arrays with named columns. You > therefore > can use any of the array functions with queries" -CFMX WACK > > How would I use say ArrayMax() to get the largest value in a specified > column > of a query I created using queryNew. > > I think my brain left work at lunch today > > -seth > _ > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
updating with a sub query
Select Distinct(code) from dealerprice update products set dprice = (Select price from dealerprice where code = '#getcodes.code#') where code = '#getcodes.code#' ok the above code gets this error not sure why any help would be appreciated. Operation must use an updateable query. The Error Occurred in C:\Inetpub\wwwroot\tools\pricingupdate.cfm: line 10 8 : update products set dprice = (Select price from dealerprice where code = '#getcodes.code#') 9 : where code = '#getcodes.code#' 10 : 11 : ok [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: queryNew / array functions
something like arrayMax(myQuery[myColumn]) should do the trick. -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s). Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. -Original Message- From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:49 PM To: CF-Talk Subject: queryNew / array functions "Coldfusion queries are essentially arrays with named columns. You therefore can use any of the array functions with queries" -CFMX WACK How would I use say ArrayMax() to get the largest value in a specified column of a query I created using queryNew. I think my brain left work at lunch today -seth _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: New at Loops
Robert, I'm not sure what you're trying to do, really. It looks like a lot of extraneous code. If you're just trying to output the first trialname in the query, you could just do this: SELECT * FROM trials Where expiredate = expiredate maxrows="1">#getexpiration.trialname# Or, if you just want to play with structure notation, you can do this: #getexpiration.trialname[1]# Queries already behave like structures. -d - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 2:33 PM Subject: New at Loops > I'm new at CFLOOP. My code below just loops thru the first instance of the table name in the datasource. I'm trying structures to hold the table names in a list, but I'm not sure this works. Any critiquing of my code is welcome. It only displays the first instance on screen when run. > > Thanks. > Robert O. > > > SELECT * FROM trials > Where expiredate = expiredate > > > > > > > > #i# > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
queryNew / array functions
"Coldfusion queries are essentially arrays with named columns. You therefore can use any of the array functions with queries" -CFMX WACK How would I use say ArrayMax() to get the largest value in a specified column of a query I created using queryNew. I think my brain left work at lunch today -seth [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: New at Loops
> I'm new at CFLOOP. My code below just loops thru the first > instance of the table name in the datasource. I'm trying > structures to hold the table names in a list, but I'm not > sure this works. Any critiquing of my code is welcome. It > only displays the first instance on screen when run. > > Thanks. > Robert O. > > > SELECT * FROM trials > Where expiredate = expiredate > > > > > > > > #i# > > First, a structure isn't a list, so you can't just substitute one for another. A list is a string, from which you've chosen one or more characters as delimiters. If you want to loop over a structure, there's a CFLOOP attribute just for that: ... ... Finally, I'm not sure what you're trying to accomplish. If you just want to loop over the query and display the trialname field value, you can do that with either CFOUTPUT: #trialname# or CFLOOP: #trialname# 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: Cybersource
Yep. In a CFMX 6.1 (win) and Fusebox 4 environment. Never really made much progress in accessing the web service directly, but the wrapper classes in their API can be modified pretty easily so that the returned information is accessible. Can contact me off list if you need more information. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Dan O'Keefe To: CF-Talk Sent: Friday, December 12, 2003 1:47 PM Subject: Cybersource Anybody here implemented one of the API's from Cybersource for a payment = gateway (Java,XML,COM)? Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
New at Loops
I'm new at CFLOOP. My code below just loops thru the first instance of the table name in the datasource. I'm trying structures to hold the table names in a list, but I'm not sure this works. Any critiquing of my code is welcome. It only displays the first instance on screen when run. Thanks. Robert O. SELECT * FROM trials Where expiredate = expiredate #i# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access to IIS objects from CFML?
> Well, see if I compliment YOU anymore! ;-> Well, I hope you've learned a valuable lesson! Yuk, yuk, yuk. > Actually, I suppose I earn the "Doh!" award for the day. I > could have sworn we created that mkwebdir.vbs script from > scratch, but apparently modified said sample. My bad! I wouldn't have known that if I hadn't been rewriting it yesterday, so you shouldn't feel bad about it. 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: Quotation marks in textfields
htmleditformat(#textareadata#) - Original Message - From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 2:08 PM Subject: Quotation marks in textfields > What is the easiest way to allow quotation marks in textfields without the > browser breaking the textfield at the quote mark? > > Brook > > At 08:43 AM 1/5/2004, you wrote: > >Mark > > > > > In the following query I want the email addresses from two different > >tables > > > to be grouped together (for sending in CFMail), can't get it to work, what > > > am I missing? (BTW: the individual queries work just not as a UNION) > > > >Try putting the column names in the same order in both parts of the union. > > > >Nick > > > >-- > >[ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Problem with CFC
Looks like your original post got cut. what does the code look it? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 2:04 PM To: CF-Talk Subject: Problem with CFC Okay... I obviously need another set of eyes here... FYI I'm running CFMX 6.1 on Win2k I've written a CFC that I'm trying to debug and so I've taken it down to the absolute simplest... it looks like this: _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Quotation marks in textfields
I use HTMLEditFormat() on values dumped to the value attribute. Doug -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:09 PM To: CF-Talk Subject: Quotation marks in textfields What is the easiest way to allow quotation marks in textfields without the browser breaking the textfield at the quote mark? Brook At 08:43 AM 1/5/2004, you wrote: >Mark > > > In the following query I want the email addresses from two different >tables > > to be grouped together (for sending in CFMail), can't get it to work, what > > am I missing? (BTW: the individual queries work just not as a UNION) > >Try putting the column names in the same order in both parts of the union. > >Nick > >-- >[ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access to IIS objects from CFML?
Well, see if I compliment YOU anymore! ;-> Actually, I suppose I earn the "Doh!" award for the day. I could have sworn we created that mkwebdir.vbs script from scratch, but apparently modified said sample. My bad! Thank you for the correction. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Dave Watts wrote: > > > You're absolutely right, Dave. The hosting customer would > > need not only access to CFExecute, but would also need to > > publish a mkwebdir.vbs or similar script as this is NOT > > included in the Microsoft-provided samples. > > Actually, mkwebdir.vbs is provided in the AdminScripts directory by > default. > I just used it this week as the starting point for a script that adds > a > virtual directory for all virtual servers. > > > I suspect that any such custom VBS scripts could be run from > > the hosting customer's own space, being that scripting > > permissions are already there for the CF templates. > > This will depend on the rights of the CF service, I think. By default, > the > CF service runs as SYSTEM on Windows, and would have rights to use > ADSI to > modify IIS. However, in a shared hosting environment, I'd hope that > the CF > service would run as a much less privileged user, and in that case > would not > have rights to modify IIS. > > 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]
Quotation marks in textfields
What is the easiest way to allow quotation marks in textfields without the browser breaking the textfield at the quote mark? Brook At 08:43 AM 1/5/2004, you wrote: >Mark > > > In the following query I want the email addresses from two different >tables > > to be grouped together (for sending in CFMail), can't get it to work, what > > am I missing? (BTW: the individual queries work just not as a UNION) > >Try putting the column names in the same order in both parts of the union. > >Nick > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Excel to database insertion
thanks Rick -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 2:25 PM To: CF-Talk Subject: Re: Excel to database insertion John Stanley wrote: > > Ive looked online, and only find the looping solution, is that the only way? Most likely... You can't do cross database queries or even cross-datasource queries via cold fusion. I use a tool with Oracle called "sqlldr" (SQL*Loader) to dump data from a delimited file into the database. Many databases have similar tools. - Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Excel to database insertion
John Stanley wrote: > > Ive looked online, and only find the looping solution, is that the only way? Most likely... You can't do cross database queries or even cross-datasource queries via cold fusion. I use a tool with Oracle called "sqlldr" (SQL*Loader) to dump data from a delimited file into the database. Many databases have similar tools. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Excel to database insertion
I must be having a brain fart I have created a datasource and am able to access the contents of a large Excel file (5000 rows -- the only way we can get the data) through a standard cfquery call. I have a table in a sql db I want to dump the data into and I cant figuire out the query syntax. The last resort is to loop through all 5000 rows of the data and make an insert for each row. Is there no way to do this using the SQL multiple row insert syntax Insert into tablename select * from this_table ? Ive looked online, and only find the looping solution, is that the only way? select this_column, that_column from `sheet1$` Insert into this_table values (this_column,that_column) John Stanley Web Application Developer www.activeaero.com 734-547-7277 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cybersource
I have implemented the Java API using CF 5. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 On Dec 12, 2003, at 1:47 PM, Dan O'Keefe wrote: > Anybody here implemented one of the API's from Cybersource for a > payment = > gateway (Java,XML,COM)? > > Dan > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with CFC
ANd, for what it's worth... it works if I take the CFARGUMENT tags out... but... those are kinda necessary. And they look valid to me too. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to alter just column name in MS SQL? Oracle?
Thx Paul and Nick, Just bought SQL Server dev edition for US$50. Gotta love that revised MS pricing. Will finally be able to really work the system instead of just pecking at it through cfquery. Haven't had an E-Mgr for 2 yrs. Cheers, --Matt-- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with CFC
Okay... I obviously need another set of eyes here... FYI I'm running CFMX 6.1 on Win2k I've written a CFC that I'm trying to debug and so I've taken it down to the absolute simplest... it looks like this: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cybersource
Anybody here implemented one of the API's from Cybersource for a payment = gateway (Java,XML,COM)? Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFC Function Invalid Parameter Type with NULL Date
For simplicity, I want to pass a null/empty date to a function even though the date may not be required. I hoped to avoid doing type checks such as IsDate for every parameter I passed. For example, I usually parameterize all my unrequired strings with empty string so I don't have to check for existence (just length). This doesn't work with date. What is the best practice for this? For example: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Advisory groups
Hi, all- Wanted to pass this note along from our internal teams ASAP: We are looking to form advisory groups to better understand the needs of developers and inform future product development (not only CF). Those participating will have direct contact with us and other advisory board members and be provided with free Macromedia software. If you are interested in participating, please complete an application found at http://www.surveymonkey.com/s.asp?u=68433340144. We are looking for developers from a wide variety of backgrounds and disciplines. -Scott Macromedia, Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL date conversion issue
Here is what I used and it still failed with the same error. Did I do something wrong? SELECT personid FROM persondemographic WHERE CASE RIGHT(demographicvaluedesc, 1) WHEN 'M' THEN convert(datetime, demographicvaluedesc,109) ELSE convert(datetime, demographicvaluedesc,101) END > getdate() AND DemographicGroupId = 8 AND DemographicItemId = 4 ORDER BY demographicvaluedesc -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 11:35 AM To: CF-Talk Subject: RE: SQL date conversion issue WHERE CASE RIGHT(demographicvaluedesc, 1) WHEN 'M' THEN convert(datetime, demographicvaluedesc, 109) ELSE convert(datetime, demographicvaluedesc, 101) end > getdate()-1 What that does is if the date ends in an "M" (AM or PM) then use the "mon dd hh:mi:ss:mmmAM (or PM)" conversion, otherwise use "mm/dd/yy" A complete list of the codes are here http://msdn.microsoft.com/library/default.asp?url=""> /ts_ca-co_2f3o.asp HTH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: LDAP, CF5.0 vs CFMX6.1
ah, good point, gonna try to do this. I know this CF5.0 box can connect to an LDAP store, a netscrape one I think. I just can't get it to connect to a M$ Exchange LDAP store. Also, Ihave tried this code on other CF5 boxes in my comapny and it bombs there too. I'm thinking something changed in the cfldap tag code in CFMX. I'm digging in the docs now. The error is not very informative CFLDAP Local error The error occurred while processing an element with a general identifier of (CFLDAP), occupying document position (54:3) to (90:5) in the template file c:\inetpub\wwwroot\corpdir_old2.cfm. Doug -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 1:02 PM To: CF-Talk Subject: RE: LDAP, CF5.0 vs CFMX6.1 > I have some code that does some M$ Exchange LDAP lookups that > works beautifully on a CFMX6.1 box, but bombs out on a CF5.0 > box. I'm not using anything that is CFMX specific, AFAIK. > But here is the code... anyone have any ideas? I'm no LDAP expert, but I don't see anything wrong with your code. Are you able to run any LDAP client on that machine and query the LDAP server successfully? 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: LDAP, CF5.0 vs CFMX6.1
> I have some code that does some M$ Exchange LDAP lookups that > works beautifully on a CFMX6.1 box, but bombs out on a CF5.0 > box. I'm not using anything that is CFMX specific, AFAIK. > But here is the code... anyone have any ideas? I'm no LDAP expert, but I don't see anything wrong with your code. Are you able to run any LDAP client on that machine and query the LDAP server successfully? 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: fusebox
> I think that books along with a free saturday morning is > documentation enough what is everyone exactly looking for?! I'm actually rather surprised you don't know what I'm looking for. You must have learned from (a) book(s) originally and never sat down with a copy of the core files and tried to figure it out from scratch. If I were going to report it as a "bug" in their documentation, the steps to reproduce the issue would be: 1) download the core files for FB3 2) open the fbx_circuits.cfm template 3) realize that there are no instructions That template is required by the framework and it doesn't work "out of the box", you _must_ put something in it, but from reading through the core files, _what_ needs to go there is a mystery. I know (more or less) what needs to go in that template : at least, I can make it work from scratch. When you know what that is, it's not very complicated, and I think the instructions wouldn't take more than about 10 minutes or so to write, which is what I find surprising about it. Oddly enough, that template actually has a fusedoc in it. Unfortunately the fusedoc doesn't provide any useful information. Actually even before getting to the fbx_circuits.cfm there's nothing in the fb3 core files like a readme.txt, etc. to tell you the fbx_circuits.cfm needs to be configured, so there's a bit of research and/or trial and error to get even to that point. Again -- I mean this as no disrespect to Hal and the rest of the folks behind the framework. It's just an area of weakness, like we all have in our work. I have noticed that the folks behind Mach-II have done a good job of providing readme's which explain the core files downloads. (Though from the website it's not obvious what the difference is between the core files and the application skeleton. I personally would have included the application skeleton in a subdirectory of the core files, but that's pretty much a style decision.) Actually the doc's in the Mach-II downloads are a good comparison to see what I think is missing from the FB3 download. I certainly don't think there's a need to go to the extreme that the onTap framework is taken for documentation, wherein, large amounts of web-ready documentation have been bundled with the core files. Actually the documentation is a sample application in its own right and is designed to be extended by additional 3rd-party libraries, "plug-ins" and other components. s. isaac dealey 214-823-9345 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap > _ > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 11, 2003 6:26 PM > To: CF-Talk > Subject: RE: fusebox > That's been a problem for a lot of frameworks - and for > FuseBox since the > beginning: incredibly smart guys building incredibly cool > tools who have a > complete, innate inability to explain anything to anyone. > ;^) > Jim Davis > _ > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 11, 2003 5:44 PM > To: CF-Talk > Subject: RE: fusebox >> Hi, >> I suppose the lack of documentation does tend to put >> people off a bit, but I >> don't fuss too much about buying the books. They are >> worth >> the small price >> and the guys that bring us Fusebox can't do everything >> for >> free... people >> have to eat ya know. I seem to remember everyone >> recommending CFWACK as >> "the" resource back in the day. :) The Techspedition >> books >> are pretty much >> the same caliber of resource for Fusebox. > Incidentaly, I hope my comments aren't seen as a > disrespect to the > guys who bring us the Fusebox framework. We all have areas > where our > work is either beautiful or in some way incomplete or > problematic. I > just feel like the documentation from fusebox.org at this > point is a > real weakness and that someone (who is really immaterial) > should take > the time to sit down and produce some basic "step 1) this > is how to > write an fbx_circuits.cfm" (or take it from another site > that has a > free tutorial) that will go in their core files download. > I understand > the info is likely available elsewhere for free also, i.e. > techspedition, the forums, etc. but some basic info I > think really > needs to be "up-front" and right now that's missing from > the core > files. I haven't looked at FB4 yet, so I can't comment on > documenation > for the new version. > Of course I always welcome criticism of my own > documentation as well > -- if you read through my blog, there've been several > cases of my > documentation for the onTap framework needing correction > for one > reason or another and I always try to get those cleared up > ASAP when I > find them or when someone points them out. > s. isaac dealey 214-823-9345 > team macromedia volunteer > http://www.macromedia.com/go/team > chief archit
RE: Access to IIS objects from CFML?
> You're absolutely right, Dave. The hosting customer would > need not only access to CFExecute, but would also need to > publish a mkwebdir.vbs or similar script as this is NOT > included in the Microsoft-provided samples. Actually, mkwebdir.vbs is provided in the AdminScripts directory by default. I just used it this week as the starting point for a script that adds a virtual directory for all virtual servers. > I suspect that any such custom VBS scripts could be run from > the hosting customer's own space, being that scripting > permissions are already there for the CF templates. This will depend on the rights of the CF service, I think. By default, the CF service runs as SYSTEM on Windows, and would have rights to use ADSI to modify IIS. However, in a shared hosting environment, I'd hope that the CF service would run as a much less privileged user, and in that case would not have rights to modify IIS. 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: SQL date conversion issue
I gotcha now. good idea. thanks I will give it a try -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 11:35 AM To: CF-Talk Subject: RE: SQL date conversion issue WHERE CASE RIGHT(demographicvaluedesc, 1) WHEN 'M' THEN convert(datetime, demographicvaluedesc, 109) ELSE convert(datetime, demographicvaluedesc, 101) end > getdate()-1 What that does is if the date ends in an "M" (AM or PM) then use the "mon dd hh:mi:ss:mmmAM (or PM)" conversion, otherwise use "mm/dd/yy" A complete list of the codes are here http://msdn.microsoft.com/library/default.asp?url=""> /ts_ca-co_2f3o.asp HTH > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 11:09 AM > To: CF-Talk > Subject: RE: SQL date conversion issue > > > How would suggest using it in this case (parson the pun)? > > -Original Message- > From: Philip Arnold [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 9:58 AM > To: CF-Talk > Subject: RE: SQL date conversion issue > > > Try using CASE to choose which type of conversion you want then > > You can use CASE in all sorts of places, like JOINs, SELECT, > WHERE and others - a damn useful command > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access to IIS objects from CFML?
You're absolutely right, Dave. The hosting customer would need not only access to CFExecute, but would also need to publish a mkwebdir.vbs or similar script as this is NOT included in the Microsoft-provided samples. I suspect that any such custom VBS scripts could be run from the hosting customer's own space, being that scripting permissions are already there for the CF templates. But, as we've both already suggested, this detail SHOULD be moot. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Dave Watts wrote: > > > > > arguments="C:\InetPub\AdminScripts\Circa3000\mkwebdir.vbs > > -c ""#Arg1#"" > > -w ""#Arg2#"" -v ""#Arg3#"",""#Arg4#""" > > timeout="30"> > > > > > > Thank you for the tip; would I be able to do this in hosted > > environment (permissions etc)? > > Assuming you're referring to shared hosting as opposed to dedicated > hosting, > I would certainly hope not! In addition, in a hosted environment, I > doubt > that the scripts would be in the same place (or even there at all). On > the > other hand, I don't do work in shared hosting environments often, so I > could > be completely wrong here. > > 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: SQL date conversion issue
WHERE CASE RIGHT(demographicvaluedesc, 1) WHEN 'M' THEN convert(datetime, demographicvaluedesc, 109) ELSE convert(datetime, demographicvaluedesc, 101) end > getdate()-1 What that does is if the date ends in an "M" (AM or PM) then use the "mon dd hh:mi:ss:mmmAM (or PM)" conversion, otherwise use "mm/dd/yy" A complete list of the codes are here http://msdn.microsoft.com/library/default.asp?url=""> /ts_ca-co_2f3o.asp HTH > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 11:09 AM > To: CF-Talk > Subject: RE: SQL date conversion issue > > > How would suggest using it in this case (parson the pun)? > > -Original Message- > From: Philip Arnold [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 9:58 AM > To: CF-Talk > Subject: RE: SQL date conversion issue > > > Try using CASE to choose which type of conversion you want then > > You can use CASE in all sorts of places, like JOINs, SELECT, > WHERE and others - a damn useful command > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access to IIS objects from CFML?
Of course, that depends on your host, but typically no, not on a shared
hosting server because CFExecute is (should be) secured. Dedicated
servers are typically a different story.
I must confess that I am probably misunderstanding your question,
because I don't see the need for virtual directories to achieve what you
want. From what you describe, it appears that you are merely attempting
to employ a login scheme with SES ("search-engine safe") URLs. No?
Dave
--
David M. Delbridge
Circa 3000
ColdFusion Hosting
http://www.circa3k.com
775-832-2445
Vitaly Mankevich wrote:
>
> Hi Dave,
>
>
> arguments="C:\InetPub\AdminScripts\Circa3000\mkwebdir.vbs -c
> ""#Arg1#""
> -w ""#Arg2#"" -v ""#Arg3#"",""#Arg4#"""
> timeout="30">
>
>
> Thank you for the tip; would I be able to do this in hosted
> environment (permissions etc)?
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Programmatically creating an outlook template file.
Just trying to scope out a problem atm. We have a list of leads generated by webforms, I want to allow a user to click on a lead and get it to create a new contact in Outlook. I've built an approach using vcards, i.e. create a vcf file and using cfcontent to open it. That's fine but ... What if I wanted to include some of the additional fields from the DB that are not handled in a vcf file? Now assuming I knew that a client had Outlook how can I programmatically create a an .otf file and populate custom fields with all the lovely data from the DB? i.e. User selects the lead CF creates the template file pops it open with a cfcontent and outlook opens it. I'm guessing that there would be a VB approach to this and have looked at CFComet and can do it through COM (would this require the server to have outlook installed ?) Any ideas ? Much appreciated, Darren [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Strange problem with Oracle/WordXP
Hi Steve, Big Fat Varchars! I'm pasting into a web form in a CF application. Cheers! -Frank >What are you pasting it into (Ektron, etc.)...Is this store in a BLOB, CLOB, >or a big fat VARCHAR. > >Steve > > >-Original Message- >From: Frank Mamone [mailto:[EMAIL PROTECTED] >Sent: Friday, December 12, 2003 10:34 AM >To: CF-Talk >Subject: Strange problem with Oracle/WordXP > >Hi, > >I have two servers one running CF 4.0 the other CF 5.0. > >They are running identical applications and connectiing to the same database >server with the same NLS setting. > >The problem is when I paste bulletted text copied from specifically Word XP >on the CF 5.0 application it changes the bullets to upside down question >marks. The problem does not occur on the CF 4.0 server. > >Can this be an ODBC driver problem or a setting withing CF5? > >Thanks! > >-Frank Mamone > _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
LDAP, CF5.0 vs CFMX6.1
I have some code that does some M$ Exchange LDAP lookups that works beautifully on a CFMX6.1 box, but bombs out on a CF5.0 box. I'm not using anything that is CFMX specific, AFAIK. But here is the code... anyone have any ideas? name="empl" attributes=" employeeID, mail, memberOf, st, name, sn, initials, telephoneNumber, postalCode, cn, title, mobile, givenName, displayName, sAMAccountName" start="dc=hoo,dc=loo" sort="sn ASC" server="litexchldap.alltel.com" port="389" filter="SN=Rotten" username="myDN" password="myPWD" > -- Douglas Knudsen Alltel ACI IT Rapid Response Team <> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strange problem with Oracle/WordXP
What are you pasting it into (Ektron, etc.)...Is this store in a BLOB, CLOB, or a big fat VARCHAR. Steve -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 10:34 AM To: CF-Talk Subject: Strange problem with Oracle/WordXP Hi, I have two servers one running CF 4.0 the other CF 5.0. They are running identical applications and connectiing to the same database server with the same NLS setting. The problem is when I paste bulletted text copied from specifically Word XP on the CF 5.0 application it changes the bullets to upside down question marks. The problem does not occur on the CF 4.0 server. Can this be an ODBC driver problem or a setting withing CF5? Thanks! -Frank Mamone _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access to IIS objects from CFML?
> > arguments="C:\InetPub\AdminScripts\Circa3000\mkwebdir.vbs > -c ""#Arg1#"" > -w ""#Arg2#"" -v ""#Arg3#"",""#Arg4#""" > timeout="30"> > > > Thank you for the tip; would I be able to do this in hosted > environment (permissions etc)? Assuming you're referring to shared hosting as opposed to dedicated hosting, I would certainly hope not! In addition, in a hosted environment, I doubt that the scripts would be in the same place (or even there at all). On the other hand, I don't do work in shared hosting environments often, so I could be completely wrong here. 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]
Strange problem with Oracle/WordXP
Hi, I have two servers one running CF 4.0 the other CF 5.0. They are running identical applications and connectiing to the same database server with the same NLS setting. The problem is when I paste bulletted text copied from specifically Word XP on the CF 5.0 application it changes the bullets to upside down question marks. The problem does not occur on the CF 4.0 server. Can this be an ODBC driver problem or a setting withing CF5? Thanks! -Frank Mamone [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: non-SSL for post to SSL - secure?
> If you have a form on a html page (not SSL) and it posts to a > page that *is* SSL...the data transmission is secured isn't it? Yes. 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: Single Sign On (implemented in CF)
> > Just use the system with a recording proxy and see for > > yourself. > > Could you recommend one? I'd like to delve a little deeper > with the stuff we are using here. Jochem recommended a Mozilla extension, which is good, but if you want something browser-independent and you're using Windows, you might try Stretch: http://www.kestral.com.au/devtools/stretch/ > Also, could you(or anyone else) recommend a good http > sniffer? I'm not sure if they are the same thing, but I > would like to start playing with stuff like that. An HTTP sniffer (or a general network sniffer) can be used instead of a recording proxy. I like EffeTech HTTP Sniffer (http://www.effetech.com/), but it's a bit overpriced at $40 or so. You might just use something free like Ethereal (http://www.ethereal.com/) , which is a general-purpose network sniffer. 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: [OT] Looking for some pre-build solutions
If you want a free solution then the best bbs is phpbb2 (http://www.phpbb.com/) If you have the money to spend I def recommend the new FuseTalk. The new version that is in beta is really nice. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 7:13 PM To: CF-Talk Subject: [OT] Looking for some pre-build solutions Before we go about re-inventing the wheel in my office, we'd like to find a couple of tools that would help us out a lot. First, does anyone know of a discussion board product similar to Phorum (PHP) or wwwboard (Perl)? We're using wwwboard right now, but we're not happy with its feature set or the security problems it introduces when working with our site. Second, how about a web-based project/task management or tracking tool? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL date conversion issue
How would suggest using it in this case (parson the pun)? -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 9:58 AM To: CF-Talk Subject: RE: SQL date conversion issue Try using CASE to choose which type of conversion you want then You can use CASE in all sorts of places, like JOINs, SELECT, WHERE and others - a damn useful command [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL date conversion issue
Try using CASE to choose which type of conversion you want then You can use CASE in all sorts of places, like JOINs, SELECT, WHERE and others - a damn useful command > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 10:48 AM > To: CF-Talk > Subject: RE: SQL date conversion issue > > > There are no NULL values but I think the problem may be the > fact that I have the dates stored in the table two different ways. > > Jan 31 1996 12:00AM > and > 1/31/1996 > > -Original Message- > From: Philip Arnold [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 9:22 AM > To: CF-Talk > Subject: RE: SQL date conversion issue > > > It looks like the value in the field isn't a valid "date" > > Are any of the entries NULL? That can cause problems too for > conversions like this > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL date conversion issue
There are no NULL values but I think the problem may be the fact that I have the dates stored in the table two different ways. Jan 31 1996 12:00AM and 1/31/1996 -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 9:22 AM To: CF-Talk Subject: RE: SQL date conversion issue It looks like the value in the field isn't a valid "date" Are any of the entries NULL? That can cause problems too for conversions like this [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and AS400
Thanks all for the info! -S _ From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 11:05 AM To: CF-Talk Subject: Re: CF and AS400 I do it all the time for one of my clients. If you're talking about native (non-DB2) file access, use the Client Access datasource to set up an ODBC DSN. You can then access the file like any other datasource. I suspect that with CFMX you can probably also use IBM's Java Toolbox, which is a great set of utilities for interfacing with the 400. I use it extensively with Java, but haven't yet tried it with CFMX. Dave Jones NetEffect At 08:41 AM 12/12/03 -0500, you wrote: >Anyone had experience with building a CF app that ties into an AS400? >Wondering if anyone knows of any resources, articles or books that cover >this topic. > >Thanks! > >Stace > >AVIS IMPORTANT: >--- >Les informations contenues dans le present document et ses >pieces jointes sont strictement confidentielles et reservees a >l'usage de la (des) personne(s) a qui il est adresse. Si vous >n'etes pas le destinataire, soyez avise que toute divulgation, >distribution, copie, ou autre utilisation de ces informations >est strictement prohibee. Si vous avez recu ce document par >erreur, veuillez s'il vous plait communiquer immediatement avec >l'expediteur et detruire ce document sans en faire de copie sous quelque forme. > >WARNING: >--- >The information contained in this document and attachments is >confidential and intended only for the person(s) named above. If >you are not the intended recipient you are hereby notified that >any disclosure, copying, distribution, or any other use of the >information is strictly prohibited. If you have received this >document by mistake, please notify the sender immediately and >destroy this document and attachments without making any copy of any kind. > >-- >[ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: non-SSL for post to SSL - secure?
Thanks. That was my assumption as well... Stace _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 10:05 AM To: CF-Talk Subject: RE: non-SSL for post to SSL - secure? Stace wrote: >> If you have a form on a html page (not SSL) and it posts to a page that >> *is* SSL...the data transmission is secured isn't it ? If this is true I'd >> still advise to use SSL on the login page...but this is for a unique situation. I asked Thawte this ages ago (so it's from a hazy memory) and they told me that the SSL tunnel is established before the sending of any data so I believe your data would be secure... Altho... from a user perpspective, it's always better to serve the form in SSL, they are all savvy to that little IE padlock and most want to see it before continuing -- -dc [ cf5, ora8.1.7, iis5 ] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and AS400
I haven't done this with the JDBC drivers, but I know you can use the client ODBC drivers and execute RPG files as if they were stored procedures. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 16:05 To: CF-Talk Subject: Re: CF and AS400 I do it all the time for one of my clients. If you're talking about native (non-DB2) file access, use the Client Access datasource to set up an ODBC DSN. You can then access the file like any other datasource. I suspect that with CFMX you can probably also use IBM's Java Toolbox, which is a great set of utilities for interfacing with the 400. I use it extensively with Java, but haven't yet tried it with CFMX. Dave Jones NetEffect At 08:41 AM 12/12/03 -0500, you wrote: >Anyone had experience with building a CF app that ties into an AS400? >Wondering if anyone knows of any resources, articles or books that cover >this topic. > >Thanks! > >Stace > >AVIS IMPORTANT: >--- >Les informations contenues dans le present document et ses >pieces jointes sont strictement confidentielles et reservees a >l'usage de la (des) personne(s) a qui il est adresse. Si vous >n'etes pas le destinataire, soyez avise que toute divulgation, >distribution, copie, ou autre utilisation de ces informations >est strictement prohibee. Si vous avez recu ce document par >erreur, veuillez s'il vous plait communiquer immediatement avec >l'expediteur et detruire ce document sans en faire de copie sous quelque forme. > >WARNING: >--- >The information contained in this document and attachments is >confidential and intended only for the person(s) named above. If >you are not the intended recipient you are hereby notified that >any disclosure, copying, distribution, or any other use of the >information is strictly prohibited. If you have received this >document by mistake, please notify the sender immediately and >destroy this document and attachments without making any copy of any kind. > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Single Sign On (implemented in CF)
Smith, Matthew P -CONT(CSC) wrote: > >> Just use the system with a recording proxy and see for yourself. > > Could you recommend one? I'd like to delve a little deeper with the stuff we are using here. > > Also, could you(or anyone else) recommend a good http sniffer? I'm not sure if they are the same thing, but I would like to start playing with stuff like that. They serve the same purpose. I currently use Mozilla FireBird with the LiveHTTPHeaders extension: http://www.mozilla.org/ http://livehttpheaders.mozdev.org/ Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF and AS400
I do it all the time for one of my clients. If you're talking about native (non-DB2) file access, use the Client Access datasource to set up an ODBC DSN. You can then access the file like any other datasource. I suspect that with CFMX you can probably also use IBM's Java Toolbox, which is a great set of utilities for interfacing with the 400. I use it extensively with Java, but haven't yet tried it with CFMX. Dave Jones NetEffect At 08:41 AM 12/12/03 -0500, you wrote: >Anyone had experience with building a CF app that ties into an AS400? >Wondering if anyone knows of any resources, articles or books that cover >this topic. > >Thanks! > >Stace > >AVIS IMPORTANT: >--- >Les informations contenues dans le present document et ses >pieces jointes sont strictement confidentielles et reservees a >l'usage de la (des) personne(s) a qui il est adresse. Si vous >n'etes pas le destinataire, soyez avise que toute divulgation, >distribution, copie, ou autre utilisation de ces informations >est strictement prohibee. Si vous avez recu ce document par >erreur, veuillez s'il vous plait communiquer immediatement avec >l'expediteur et detruire ce document sans en faire de copie sous quelque forme. > >WARNING: >--- >The information contained in this document and attachments is >confidential and intended only for the person(s) named above. If >you are not the intended recipient you are hereby notified that >any disclosure, copying, distribution, or any other use of the >information is strictly prohibited. If you have received this >document by mistake, please notify the sender immediately and >destroy this document and attachments without making any copy of any kind. > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Single Sign On (implemented in CF)
Jochem, > Just use the system with a recording proxy and see for yourself. Could you recommend one? I'd like to delve a little deeper with the stuff we are using here. Also, could you(or anyone else) recommend a good http sniffer? I'm not sure if they are the same thing, but I would like to start playing with stuff like that. Thanks, Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 11:16 AM To: CF-Talk Subject: Re: Single Sign On (implemented in CF) [EMAIL PROTECTED] wrote: >> >> Looking at Oracles Single Sign On Server (SSO Server) >> >> Seems to be saying that it can log into *any* external web app (given >> that it knows the username and password and it is an HTML form) and >> then remember the user upon return to the portal application as well >> as logging out of the external web app >> >> An explanation of implementing a PHP interface to the Oracle SSO >> server can be found here >> >> http://otn.oracle.com/oramag/webcolumns/2003/techarticles/bennett_php.html >> >> >> It seems to me it is either the SSO Server that is doing the logging >> in or the SSO server forces the client to do a transparent login over >> HTTP... anybody know which one? It looks like the visitor is redirected to the SSO server, which does authentication and then redirects the user back, probably with some identification URL variable. Just use the system with a recording proxy and see for yourself. >> If the SSO Server is forcing the client to login... how do they do it >> transparently? And securely? Ask Oracle. You might want to take a look at http://a-select.surfnet.nl/ which offers similar features and is available for free for non-profit organizations (it was developed for the Dutch national research and education network). They have a very extensive explanation of the authentication flow, and SSO undoubtedly uses something similar: http://a-select.surfnet.nl/functional_flows.html Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL date conversion issue
It looks like the value in the field isn't a valid "date" Are any of the entries NULL? That can cause problems too for conversions like this > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 10:17 AM > To: CF-Talk > Subject: SQL date conversion issue > > > Any pointers here. I have a varchar field that holds a date > value. I need to pull records where the date has yet to expire. > > If I run this query, it runs fine. > > SELECT * FROM Persondemographic > WHERE DemographicGroupId = 8 > AND DemographicItemId = 4 > AND convert (datetime,demographicvaluedesc)> getdate()-1 > > > However I need to run this query and it errors with "Server: > Msg 241 - Syntax error converting datetime from character string." > > SELECT personid FROM Persondemographic > WHERE DemographicGroupId = 8 > AND DemographicItemId = 4 > AND convert (datetime,demographicvaluedesc)> getdate()-1 > > > any help would be appreciated > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL date conversion issue
Any pointers here. I have a varchar field that holds a date value. I need to pull records where the date has yet to expire. If I run this query, it runs fine. SELECT * FROM Persondemographic WHERE DemographicGroupId = 8 AND DemographicItemId = 4 AND convert (datetime,demographicvaluedesc)> getdate()-1 However I need to run this query and it errors with "Server: Msg 241 - Syntax error converting datetime from character string." SELECT personid FROM Persondemographic WHERE DemographicGroupId = 8 AND DemographicItemId = 4 AND convert (datetime,demographicvaluedesc)> getdate()-1 any help would be appreciated [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT-Fusebox 4 freelancer in Toronto
Hello All, I am looking for a free lancer in the Toronto Area that has a good understanding and uses FB4 Please send me a note off list Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: seven days earlier
Thanks again Christian and Graham. All worked.
Robert O.
-Original Message-
From: Graham Pearson [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 9:52 AM
To: CF-Talk
Subject: RE: seven days earlier
DateFormat(DateString, "mm-dd-yy")
On Fri, 12 Dec 2003 09:43:48 -0500, Robert Orlini wrote
> That worked well thanks.
>
> One more thing: How do I convert the string: {ts '2003-12-05 09:37:09'} into 12-05-03 or any date string w/o the "{ts '" ?
>
> Robert O.
>
> -Original Message-
> From: BOUDOT Christian [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 12, 2003 8:54 AM
> To: CF-Talk
> Subject: RE: seven days earlier
>
> use the the DataAdd function
> DateAdd("d", -7, Now())
>
> -Original Message-
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: vendredi 12 décembre 2003 14:44
> To: CF-Talk
> Subject: seven days earlier
>
> I have a CF application that needs to check a date field in an Access column
> and send an email 7 days earlier than the date in that column.
> For example if the date in the column is 12/31/03, I would need to do a
> comparison. When the current date is 12/24/03 then send out an email.
>
> How would I code this using dateformat(now) for the current date? I guess I
> would need to use the CF scheduler for this or can I use this in a CF script
> alone?
>
> Thanks as always.
>
> Robert O.
> HWW
> _
> _
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Single Sign On (implemented in CF)
Yes, and there is also Netigrity. http://www.netegrity.com/ I believe(don't quote me on this) that oblix had better certification for government security requirements. It does not necessarily mean that Netegrity is less secure, they just haven't done the required paperwork as of yet. I do not know if that is an issue for you guys. Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Andrew Spear [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 12:28 PM To: CF-Talk Subject: Re:Single Sign On (implemented in CF) You may want to take a look at Oblix. I know it works with CF and just about any webserver... http://www.oblix.com/index.html _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: non-SSL for post to SSL - secure?
Stace wrote: >> If you have a form on a html page (not SSL) and it posts to a page that >> *is* SSL...the data transmission is secured isn't it ? If this is true I'd >> still advise to use SSL on the login page...but this is for a unique situation. I asked Thawte this ages ago (so it's from a hazy memory) and they told me that the SSL tunnel is established before the sending of any data so I believe your data would be secure... Altho... from a user perpspective, it's always better to serve the form in SSL, they are all savvy to that little IE padlock and most want to see it before continuing -- -dc [ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Adding remote datasource dynamically
Chunshen (Don) Li wrote: > Jochem, pls keep the ball rolling, thanks. I don't use passwords in datasource definitions so I didn't test it. Some people have reported that it worked, but I never bothered to find out the exact syntax and I don't keep IRC logs long enough to find out who reported that. Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: seven days earlier
LSDateFormat(now(),'mm-dd-yy')
cheers
Chris
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: vendredi 12 décembre 2003 15:44
To: CF-Talk
Subject: RE: seven days earlier
That worked well thanks.
One more thing: How do I convert the string: {ts '2003-12-05 09:37:09'} into
12-05-03 or any date string w/o the "{ts '" ?
Robert O.
-Original Message-
From: BOUDOT Christian [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 8:54 AM
To: CF-Talk
Subject: RE: seven days earlier
use the the DataAdd function
DateAdd("d", -7, Now())
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: vendredi 12 décembre 2003 14:44
To: CF-Talk
Subject: seven days earlier
I have a CF application that needs to check a date field in an Access column
and send an email 7 days earlier than the date in that column.
For example if the date in the column is 12/31/03, I would need to do a
comparison. When the current date is 12/24/03 then send out an email.
How would I code this using dateformat(now) for the current date? I guess I
would need to use the CF scheduler for this or can I use this in a CF script
alone?
Thanks as always.
Robert O.
HWW
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: seven days earlier
DateFormat(DateString, "mm-dd-yy")
On Fri, 12 Dec 2003 09:43:48 -0500, Robert Orlini wrote
> That worked well thanks.
>
> One more thing: How do I convert the string: {ts '2003-12-05 09:37:09'} into 12-05-03 or any date string w/o the "{ts '" ?
>
> Robert O.
>
> -Original Message-
> From: BOUDOT Christian [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 12, 2003 8:54 AM
> To: CF-Talk
> Subject: RE: seven days earlier
>
> use the the DataAdd function
> DateAdd("d", -7, Now())
>
> -Original Message-
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: vendredi 12 décembre 2003 14:44
> To: CF-Talk
> Subject: seven days earlier
>
> I have a CF application that needs to check a date field in an Access column
> and send an email 7 days earlier than the date in that column.
> For example if the date in the column is 12/31/03, I would need to do a
> comparison. When the current date is 12/24/03 then send out an email.
>
> How would I code this using dateformat(now) for the current date? I guess I
> would need to use the CF scheduler for this or can I use this in a CF script
> alone?
>
> Thanks as always.
>
> Robert O.
> HWW
> _
> _
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: seven days earlier
That worked well thanks.
One more thing: How do I convert the string: {ts '2003-12-05 09:37:09'} into 12-05-03 or any date string w/o the "{ts '" ?
Robert O.
-Original Message-
From: BOUDOT Christian [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 8:54 AM
To: CF-Talk
Subject: RE: seven days earlier
use the the DataAdd function
DateAdd("d", -7, Now())
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: vendredi 12 décembre 2003 14:44
To: CF-Talk
Subject: seven days earlier
I have a CF application that needs to check a date field in an Access column
and send an email 7 days earlier than the date in that column.
For example if the date in the column is 12/31/03, I would need to do a
comparison. When the current date is 12/24/03 then send out an email.
How would I code this using dateformat(now) for the current date? I guess I
would need to use the CF scheduler for this or can I use this in a CF script
alone?
Thanks as always.
Robert O.
HWW
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: How to make ColdFusion Verity/search better?
We use verity as well as some custom CFX tags to work with Lucene that are a bit more powerful than what was shipped in the DRK. Specifically, we like the ability to create "columns" in the search index beyond CUSTOM1 and CUSTOM2. Also, the ability to customize how the search is performed and ordered is useful. Most of our indexes are against databases, but every now and then we have searches that must include PDF and or Word documents. We've used K2 Server; it is much faster although a bit confusing to setup at first. We had a few stability problems as well where it would suddenly stop performing searches and just return an empty result set. Matt -Original Message- From: Tom Jordahl [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 10:03 AM To: CF-Talk Subject: How to make ColdFusion Verity/search better? I sent this out at the end of a longer thread and got 0 responses. Since that *never* happens on CF-Talk, I figured everyone just skipped the thread. :-) [EMAIL PROTECTED] wrote: > I agree with Matt. The Verity that comes with CF sucks. Hard. So. I am in the process of planning what Blackstone will have in terms of search technology. I am interested in hearing what people have to say about Verity in ColdFusion. If you want to make sure I see your feedback, you can CC me when you send your response to the list, hopefully with "Verity" or "search" in the subject somewhere. :-) Sample questions: - Do you use our Search? Another technology? Why? Why not? - Do you use a K2 server? Did you know it goes faster if you do? :-) - What document types do you index? - How many documents do you index? - How many collections do you have? - What features do you like? - What features are we missing? By the way, we just had a meeting with Verity last week. Their new 5.x (we currently ship version 2.6.1) stuff looks very nice. When I asked them about their indexing speed, they said something along the lines of "We are not the fastest indexing, but we are the fastest search technology hands down." We hope to enhance Blackstone in such a way that indexing speed will be improved, both with changes in our code and by updating the underlying search technology. So while "make it go faster" is a reasonable thing to ask, assume we will attempt to do this. -- Tom Jordahl Macromedia Server Development _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and AS400
At my previous job, we had an AS/400 Datasource that allowed us to query from the AS/400 just like a SQL database. I'm not 100% sure of the back-end setup, but I know that a user was created on the AS/400 and given proper permissions and then in the CF Administrator, we just entered the name of the AS/400 server, the username and password to connect with and then it was all set up. It seemed to be a pretty simple process. Then it's just a matter of knowing the database schema and all of that (which seems to be the more painful piece of the puzzle). John Burns -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 8:42 AM To: CF-Talk Subject: CF and AS400 Anyone had experience with building a CF app that ties into an AS400? Wondering if anyone knows of any resources, articles or books that cover this topic. Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: non-SSL for post to SSL - secure?
If you have a form on a html page (not SSL) and it posts to a page that *is* SSL...the data transmission is secured isn't it ? If this is true I'd still advise to use SSL on the login page...but this is for a unique situation. Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL and CFMX (OSX) Problem
Lola Lee wrote: > Jochem van Dieten wrote: > >> You have defined case-sensitive table names: >> http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS >> >> You should be able to query them as using: >> >> SELECT * >> FROM "SwaterType" >> >> >> But I would recommend dumping your schema, removing the double >> quotes and restoring. > > Thanks! I would never have thought of this. I looked in the Oreilly manual for PostgreSQL and didn't find any obvious information about schemas. Paper tends to be outdated pretty fast. > So, you mean, deleting the database and creating a new one? And make the tables all lowercase? Just dropping and recreating the tables would suffice. And you don't have to make them lowercase, use whatever case you want but don't use double quotes around identifiers. If you are adventurous, you could also try the following query that should fix this for you, but if you have defined views and triggers there might be side-effects: UPDATE pg_catalog.pg_class SET relname = Lower(relname) WHERE relkind = 'r' Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Adding remote datasource dynamically
Jochem, pls keep the ball rolling, thanks. Don > > Shouldn't you insert the password somewhere: > encryptPassword(form.password) > > Jochem > > -- > When you don't want to be surprised by the revolution > organize one yourself > - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:PostgreSQL and CFMX (OSX) Problem
Jochem van Dieten wrote: >You have defined case-sensitive table names: >http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS > >You should be able to query them as using: > >SELECT * >FROM "SwaterType" > > >But I would recommend dumping your schema, removing the double >quotes and restoring. > >Jochem Thanks! I would never have thought of this. I looked in the Oreilly manual for PostgreSQL and didn't find any obvious information about schemas. So, you mean, deleting the database and creating a new one? And make the tables all lowercase? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and AS400
Thanks. I had also heard about JDBC drivers for these legacy systems...anyone doing this to tie-in with CF directly? Stace _ From: Simon Horwith [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 8:46 AM To: CF-Talk Subject: RE: CF and AS400 in addition to other solutions, you can take a look at screensurfer. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 13:45 To: CF-Talk Subject: RE: CF and AS400 Way back in the beginning of my time with CF, we did this. We had the AS/400 write to a text file and then parsed that with CF. This was like five years ago, so there is probably an easier way to do it now, but if not at least you should be able to do that. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 8:42 AM To: CF-Talk Subject: CF and AS400 Anyone had experience with building a CF app that ties into an AS400? Wondering if anyone knows of any resources, articles or books that cover this topic. Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ektron CMS
We use their emPower software and like it. You just have to be real careful about how it is installed. We've had the best success by accepting all the defaults when installing. This allowed us to push all publishing to our admin/marketing department and IS doesn't do any of it any more. The only thing we as the IS department do is some of the special sections where security and registration is required. Then we write the code needed to run to validate the security and leave the rest up to the users to add the content in the page. You can checkout our website via the link below. Everything but the RFQ, MyEU and phone directory lookup pages are powered by emPower. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Ryan Sabir [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:41 AM To: CF-Talk Subject: Ektron CMS Hi Folks, Has anyone here implemented a site using the Ektron CMS product "CMS 300"? We use their eWebEditPro WYSIWYG editor a lot and find it great, but as yet haven't looked at their CMS products. What are they like from a developers point of view? Any major hassles working with it? What's the CF integration like? thanks, bye! --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: seven days earlier
use the the DataAdd function
DateAdd("d", -7, Now())
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: vendredi 12 décembre 2003 14:44
To: CF-Talk
Subject: seven days earlier
I have a CF application that needs to check a date field in an Access column
and send an email 7 days earlier than the date in that column.
For example if the date in the column is 12/31/03, I would need to do a
comparison. When the current date is 12/24/03 then send out an email.
How would I code this using dateformat(now) for the current date? I guess I
would need to use the CF scheduler for this or can I use this in a CF script
alone?
Thanks as always.
Robert O.
HWW
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: seven days earlier
You would use dateAdd() and add 7 days. -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s). Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 8:50 AM To: CF-Talk Subject: seven days earlier I have a CF application that needs to check a date field in an Access column and send an email 7 days earlier than the date in that column. For example if the date in the column is 12/31/03, I would need to do a comparison. When the current date is 12/24/03 then send out an email. How would I code this using dateformat(now) for the current date? I guess I would need to use the CF scheduler for this or can I use this in a CF script alone? Thanks as always. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
seven days earlier
I have a CF application that needs to check a date field in an Access column and send an email 7 days earlier than the date in that column. For example if the date in the column is 12/31/03, I would need to do a comparison. When the current date is 12/24/03 then send out an email. How would I code this using dateformat(now) for the current date? I guess I would need to use the CF scheduler for this or can I use this in a CF script alone? Thanks as always. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and AS400
in addition to other solutions, you can take a look at screensurfer. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 13:45 To: CF-Talk Subject: RE: CF and AS400 Way back in the beginning of my time with CF, we did this. We had the AS/400 write to a text file and then parsed that with CF. This was like five years ago, so there is probably an easier way to do it now, but if not at least you should be able to do that. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 8:42 AM To: CF-Talk Subject: CF and AS400 Anyone had experience with building a CF app that ties into an AS400? Wondering if anyone knows of any resources, articles or books that cover this topic. Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and AS400
Way back in the beginning of my time with CF, we did this. We had the AS/400 write to a text file and then parsed that with CF. This was like five years ago, so there is probably an easier way to do it now, but if not at least you should be able to do that. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 8:42 AM To: CF-Talk Subject: CF and AS400 Anyone had experience with building a CF app that ties into an AS400? Wondering if anyone knows of any resources, articles or books that cover this topic. Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF and AS400
Anyone had experience with building a CF app that ties into an AS400? Wondering if anyone knows of any resources, articles or books that cover this topic. Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PostgreSQL and CFMX (OSX) Problem
Lola Lee wrote: > Using this: > > > #get_sweatertype.table_schema#, #get_sweatertype.table_name# > > > Here's a partial output of the list: > public, Yarn > public, SweaterType You have defined case-sensitive table names: http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS You should be able to query them as using: SELECT * FROM "SwaterType" But I would recommend dumping your schema, removing the double quotes and restoring. Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to alter just column name in MS SQL? Oracle?
> Would SQL Server thus be no, sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name' [ , [ @objtype = ] 'object_type' ] for instance to rename customer.contactTitle to title use: EXEC sp_rename 'customers.contacttitle', 'title', 'COLUMN' be aware of stored procedures, views, indexes, etc. > I'm away from my test servers for the next few days and can't test the > theory. Does someone know off the top of their heads? i know nothing off the top of my head: sql server's books-on-line, never leave home without it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calculating Holidays
> > Thanks, that's very much what I'm looking for. Are you willing to share? the raw CFC & testbed code download link are now on the testbed page: http://www.sustainablegis.com/projects/calendars/holidaysTB.cfm you will need to download the icu4j lib (2.6.1) from http://oss.software.ibm.com/icu4j/ unpack the icu4j JAR from the archive & shove it into cf root/wwwroot/web-inf/lib all the weasel words still apply. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to alter just column name in MS SQL? Oracle?
Matt > I have a field name in a db that I'd like to rename from fieldname1 to > fieldname2 (leaving the data intact and fieldspecs the same) via a SQL > statement. MySQL is unusually obliging in this respect. IIRC in SQL Server you need to use sp_rename() to rename a column. I'm not at all sure this will work in Oracle either. You can do it in a fairly DBMS-independent way by using a temporary column. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How to alter just column name in MS SQL? Oracle?
I have a field name in a db that I'd like to rename from fieldname1 to fieldname2 (leaving the data intact and fieldspecs the same) via a SQL statement. I can do this in mySQL like so: ALTER TABLE filename CHANGE fieldname1 fieldname2 varchar(10) Would SQL Server thus be SET NOCOUNT ON ALTER TABLE [dbo].[filename] ALTER COLUMN [fieldname1] [fieldname2] [nvarchar(10)] NULL SET NOCOUNT OFF and Oracle: ALTER TABLE filename MODIFY ( fieldname1 fieldname2 VARCHAR2(10) ) I'm away from my test servers for the next few days and can't test the theory. Does someone know off the top of their heads? --Matt Robertson-- MSB Designs, Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
