Re: ot: distinct count query; mssql2k
No doubt there's a SQL way to do it, in which case it'll be better than my suggestion but you could loop through the results of your count query (it wont be a big database call - you only have 20 records to loop through) and run separate queries for each value of field1. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: alexander sicular <[EMAIL PROTECTED]> Date: Sun, 03 Oct 2004 19:08:29 -0400 Subject: ot: distinct count query; mssql2k To: CF-Talk <[EMAIL PROTECTED]> hi all, i am trying to query a table for most often inserted values and have stumbled into a roadblock. the query i have so far works as expected: select top 20 field1, COUNT(field1) AS Expr1 FROM tbl1 GROUP BY field1 order by expr1 desc the problem is that i would also like to return a second column that just so happens to be of text type. mssql2k will not accept a text type column in the group by clause and i have tried to cast it as a varchar with no luck. any thoughts? tia, alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ot: distinct count query; mssql2k
How about a subquery in the select list: select top 20 field1, COUNT(field1) AS Expr1, (SELECT whatever FROM something WHERE blah...) as TheNewField FROM ... If your DB supports it, this means the text-type column doesn't have to be grouped. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Server dropping zeros
SQL Server should in no way drop zeros in a VARCHAR field - what is the SQL you are using to enter the values? _ From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: 01 October 2004 22:58 To: CF-Talk Subject: SQL Server dropping zeros I had the strangest thing; I've got a varchar field in a SQL Server 2000 table that stores zip codes. When we import the zip codes leading and trailing zeros drop off when inserted, for example: 07080 will become 708. I thought what if I increased the field length from 10 to 12 (for zip-4), and for the insert I could add a leading and trailing space like this ' 07080 ', and guess what? The zeros did not get dropped. I thought what a stupid fix! What have others done to get around Microsoft telling me I don't need the zeros? Thanks, Stan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: free web design?
Even by comparison addr.com can be seen as expensive. My friend who was a freelancer had a couple of 3/4 page static jobs taken of him last year because they (the client) found a "cheaper alternative" which tended to be a Frontpage Template. Plus he even heard one client saying that it was going to cost £50/£60 for site! How do you compete with that. You don't. You just say here's my card incase you need me in the future. Andy - Original Message - From: Jim McAtee <[EMAIL PROTECTED]> Date: Sun, 3 Oct 2004 11:46:41 -0600 Subject: Re: free web design? To: CF-Talk <[EMAIL PROTECTED]> You still see plenty of Mom and Pop static sites out there done by some junior high school kid or by someone with Front Page. $500 from a starving graphic arts student can buy you a hell of a lot over those other options. - Original Message - From: "Dwayne Cole" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, October 03, 2004 4:21 AM Subject: Re: free web design? > This is Unbeleivable! No one worth their weight in salt would do a > thing like this. Plus I ask my business customer do they really want to > bet the business on a 499.00 website? > > > -- Original Message -- > From: Douglas Knudsen <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Fri, 1 Oct 2004 12:06:18 -0400 > >>reminds me... >>http://www.cubicleman.com/?id=19 >>someone here in Atlanta was advertising this. Have websites become >>such a commodity? LOL! >> >>Doug >> >> >>- Original Message - >>From: Ray Champagne <[EMAIL PROTECTED]> >>Date: Fri, 01 Oct 2004 11:03:19 -0400 >>Subject: RE: free web design? >>To: CF-Talk <[EMAIL PROTECTED]> >> >>Oh it definitely was SPAM. But SPAM that caught my attention :) >> >> >> >> At 11:00 AM 10/1/2004, you wrote: >> >Sounds like .SPAM SPAM SPAM SPAM >> > >> > >> > >> > _ >> > >> >From: Bryan Stevenson [mailto:[EMAIL PROTECTED] >> >Sent: 01 October 2004 16:00 >> >To: CF-Talk >> >Subject: Re: free web design? >> > >> > >> > >> >Been around for everjust template based cheesy sites I'm >> >sureall >> >kinds of ISPs offer it as a loss leader to their hosting packages >> > >> >Bryan Stevenson B.Comm. >> >VP & Director of E-Commerce Development >> >Electric Edge Systems Group Inc. >> >phone: 250.480.0642 >> >fax: 250.480.1264 >> >cell: 250.920.8830 >> >e-mail: [EMAIL PROTECTED] >> >web: www.electricedgesystems.com >> > >> > - Original Message - >> > From: Ray Champagne >> > To: CF-Talk >> > Sent: Friday, October 01, 2004 7:51 AM >> > Subject: free web design? >> > >> > I got an email from these folks today, saying that they will create >> > a <10 >> > page site for free, all you pay for is the hosting (9.95/mo). >> > There must >> > be a catch in this offer somewhere, but I don't see where. Anybody >> > ever >> > heard of these guys? >> > >> > http://www.addr.com/free-design/ >> > >> > How does one compete with *free*??? Not that these types of sites >> > are our >> > >> > main focus, but they did provide some nice side work! >> > >> > Ray >> > >> > = >> > Ray Champagne - Senior Application Developer >> > CrystalVision Web Site Design and Internet Services >> > 603.433.9559 >> > www.crystalvision.org >> > = >> > >> > The information contained in this transmission (including any >> > attached >> > files) is CONFIDENTIAL and is intended only for the person(s) named >> > above. If you received this transmission in error, please delete it >> > from your system and notify us immediately. If you are not an >> > intended >> > recipient, please note that any use or dissemination of the >> > information >> > contained in this transmission (including any attached files) and >> > the >> > copying, printing, or retransmission of that information is >> > strictly >> > prohibited. You can notify us by return email or by phone at >> > 603.433.9559. >> > Thank you. >> > >> > _ >> > >> > >> > >> > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: free web design?
One of the great truths of this web business is that no matter what you charge, there is always someone going to be willing to do it cheaper. Often (as in this case) a LOT cheaper. Thats why you have to sell VALUE not PRICE. Get them convinced that it's not just the amount of money you pay to the developer that counts, but the overall effect. If they're going to set up a retail store, do they go looking for the absolute cheapest shop to rent? Do they set up a shop in the cheapest slum or do they also look for other factors - neighbouring shops, traffic, atmosphere of the neighbourhood. Do they just buy second hand shop fittings or do they want the store to look nice and welcoming to the customers? Similar arguments apply to web sites. Do they want the cheapest they can get regardless? or would they rather have good value - sites that do what they want, are professional in appearance, not just cut-and-paste copies of other people's sites. I know it's not easy, but that's the only way to get around competitors who sell on price. Look at all the people who have managed to make arguments like this work: Microsoft, BMW, Nikon, Boeing, Compaq, IBM, Xerox to name a few. They all sell products at higher prices than their competitors. If you ask them they'll tell you it's the name that people buy, but I dont believe that. It's what the name represents - "I'm buying from someone who knows what he's doing" The price merchant is going to say "I'll do it just as good as him, and cheaper" and whether you win over him or not, will depend on how well you can convince the prospective customer that it's not "just as good". (and then feel happy that when this price guy competes for business he has no where to go when someone else comes around saying "I can do it even cheaper than him, and just as good". Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: Andy Jarrett <[EMAIL PROTECTED]> Date: Mon, 4 Oct 2004 09:53:52 +0100 Subject: Re: free web design? To: CF-Talk <[EMAIL PROTECTED]> Even by comparison addr.com can be seen as expensive. My friend who was a freelancer had a couple of 3/4 page static jobs taken of him last year because they (the client) found a "cheaper alternative" which tended to be a Frontpage Template. Plus he even heard one client saying that it was going to cost £50/£60 for site! How do you compete with that. You don't. You just say here's my card incase you need me in the future. Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Handling common access to pages and images for both http/https pages?
Before I go off in the wrong direction on this, I figured I'd see what others are doing... I'm building a couple of simple secure (https) pages on my site using the shared certificate provided by the hosting service (Crystal Tech). The URL that they provide point back to the same root that the rest of the website uses. I haven't had to do much in the past with https pages, and what I have done was the result of a lot of fumbling around. My pages all use a couple of common INCLUDE files for the top and left nav areas, and onrequestend.cfm for the bottom nav area, which include references to images and (obviously) other pages on the site. When I render the pages that are being called via https, I need for all external references on that page to be https, right? Otherwise the user will get warnings from the browser about mixed pages. What I'm thinking of doing is having the application.cfm look at the current url to see if it begins with "http" or "https" and then save that in a variable, and change all of the references in the INLCUDE files to use that reference. The kicker is that I don't want to have to use full "http://www.mysite.com/page.cfm" or src="" references to the rest of the site, because that makes it a royal pain when I want to copy the files to/from a testing area, because they would have those hard coded references to the production site in them. What about references to external pages that reside on other sites? Can I do that from a page that was called via https? I don't think I can use a link like "https://www.weather.com" on my https page! Does that mean that all references from my page have to remain within my site? All advice and hints appreciated! Thanks, reed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
no end date
I have a calendar of events. All events have a start date/time, but many of them don't have an end date/time. I can work around this by setting an obviously incorrect end date and checking for it (i.e. 12.17.66, my wife's birthday). However, I'd prefer to not set a date if there isn't one and check for that instead. So, what's the proper way of having no end date in the database? Also since this is editable information, I may have an entry with a date and need to set it to null or "no end date" so any suggestion should take this into account. I'm using the latest, greatest Oracle. good morning, and thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: no end date
Set it to NULL. _ From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: 04 October 2004 14:25 To: CF-Talk Subject: no end date I have a calendar of events. All events have a start date/time, but many of them don't have an end date/time. I can work around this by setting an obviously incorrect end date and checking for it (i.e. 12.17.66, my wife's birthday). However, I'd prefer to not set a date if there isn't one and check for that instead. So, what's the proper way of having no end date in the database? Also since this is editable information, I may have an entry with a date and need to set it to null or "no end date" so any suggestion should take this into account. I'm using the latest, greatest Oracle. good morning, and thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Using CFLOGIN framework to show certain info and not otherwise
I have an app where the client wants his customers to only see prices and "add to cart" icons if they're logged in. They'll see the "public" version of the site, with product images and descriptions only until they log in, then the pages will also show pricing and the links to add to the shopping cart. Also the shopping cart will be initialised when they log in. I can write my own security framework, but I want to understand the CFLOGIN stuff thats built into CFMX. All the examples I've seen for that are where entire pages or directories are barred from people who aren't logged in. How would I do it, using the CFLOGIN framework? Here's what i have done so far ... I have a folder called "Clients" where I hold the login procedures, also the lost password and update profile stuff, and the login page sends the user back to the site home page after logging in. That all works ok. And the same system also validates the client himself and grants him access to the admin area of the site. How do I handle the price column in the display tables? In my homegrown system, I'd just do something like: #price# How does it work where we want the page to display to people not logged in, but only certain parts showing to logged in users? I've tried but that doesnt work. Also a few other combinations around the getauthuser() function but nothing I've tried is the right thing. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Error - You cannot add or change a record because a related record is required in table...
I'm getting the following error: You cannot add or change a record because a related record is required in table tblTerm. I have a form with that is inserting records into the various tables and there's a one-to-many relationship between the tblterm and tblbilling tables and there is referential integrity turned on. All the tables are inserting fine but the tblbilling table, which generates the error above. Here is my insert code: INSERT INTO tblMasterClients (clientname, aliasname, infinity, svctype, acctstatus, siteid, authcode, pobox, poboxcombo, did, secdid, faxdid, eighthundreddid, faxext, url, prepareddate, terminationreason, terminationdesc, inactivedate, commencementanni, comments) VALUES ('#Form.clientname#', '#Form.aliasname#', '#Form.infinity#', '#Form.svctype#', '#Form.acctstatus#', '#Form.siteid#', '#Form.authcode#', '#Form.pobox#', '#Form.poboxcombo#', '#Form.did#', '#Form.secdid#', '#Form.faxdid#', '#Form.eighthundreddid#', '#Form.faxext#', '#Form.url#', '#Form.prepareddate#', '#Form.terminationreason#', '#Form.terminationdesc#', '#Form.inactivedate#', '#Form.commencementanni#', '#Form.comments#' ) INSERT INTO tbloccupants (clientname, occname) VALUES ('#Form.clientname#', '#Form.occname#' ) INSERT INTO tbllegaladdr (legalname, legalcontact) VALUES ('#Form.clientname#', '#Form.legalcontact#' ) select [client name] as clientname from tblbillingaddr INSERT INTO tblbillingaddr ([client name], billingcontact, billingemail) VALUES ('#Form.clientname#', '#Form.billingcontact#', '#Form.billingemail#' ) INSERT INTO tblterm (clientname, agrdate, agrstatus) VALUES ('#Form.clientname#', '#Form.agrdate#', '#Form.agrstatus#' ) INSERT INTO tblbillinglimits (clientname, conffreehrs, confrate) VALUES ('#Form.clientname#', '#Form.conffreehrs#', '#Form.confrate#' ) INSERT INTO tblbilling (lf, pcp) VALUES ('#Form.lf#', '#Form.pcp#' ) What's the magic required to insert the data into tblbilling? Do I need to get the ID from tblterm and add where clause to the insert query? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Using CFLOGIN framework to show certain info and not otherwise
There is no simple way to say if a user is logged in, but you can check to see if getAuthUser returns a value. If it returns an empty string, you are not logged in. I typically build a UDF like so: function isLoggedIn() { return getAuthUser() neq ""; } So, to display prices for logged in users, you could do... #price#Please login to view prices Note: You may think that a better name for the UDF would be, isAuthenticated. However, when Macromedia removed the Advanced Security functions (one of which was isAuthenticated), they made a "hook" for the old functions. This means you can't use a UDF with the same name as the old AS functions. On Mon, 4 Oct 2004 23:38:06 +1000, Mike Kear <[EMAIL PROTECTED]> wrote: > I have an app where the client wants his customers to only see prices > and "add to cart" icons if they're logged in. They'll see the > "public" version of the site, with product images and descriptions > only until they log in, then the pages will also show pricing and the > links to add to the shopping cart. Also the shopping cart will be > initialised when they log in. > > I can write my own security framework, but I want to understand the > CFLOGIN stuff thats built into CFMX. All the examples I've seen for > that are where entire pages or directories are barred from people who > aren't logged in. > > How would I do it, using the CFLOGIN framework? > > Here's what i have done so far ... > > I have a folder called "Clients" where I hold the login procedures, > also the lost password and update profile stuff, and the login page > sends the user back to the site home page after logging in. That > all works ok. And the same system also validates the client himself > and grants him access to the admin area of the site. > > How do I handle the price column in the display tables? In my > homegrown system, I'd just do something like: > > > #price# > > > How does it work where we want the page to display to people not > logged in, but only certain parts showing to logged in users? > > I've tried but that doesnt work. > Also a few other combinations around the getauthuser() function but > nothing I've tried is the right thing. > > Cheers > Mike Kear > Windsor, NSW, Australia > AFP Webworks > http://afpwebworks.com > .com,.net,.org domains from AUD$20/Year > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: no end date
You can have null in the enddate column. If you're using queryparams, it'd be something like this: Insert into mytable (datecolumn) values ( null="#yesNoFormat(NOT Len(trim(mydate)))#") I wouldn't use a fake end date - that'll come back to bite you later. - Original Message - From: "Daniel Kessler" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 04, 2004 8:24 AM Subject: no end date >I have a calendar of events. All events have a start date/time, but > many of them don't have an end date/time. I can work around this by > setting an obviously incorrect end date and checking for it (i.e. > 12.17.66, my wife's birthday). However, I'd prefer to not set a date > if there isn't one and check for that instead. > > So, what's the proper way of having no end date in the database? > Also since this is editable information, I may have an entry with a > date and need to set it to null or "no end date" so any suggestion > should take this into account. > > I'm using the latest, greatest Oracle. > > good morning, and thanks. > > -- > Daniel Kessler > > Department of Public and Community Health > University of Maryland > Suite 2387 Valley Drive > College Park, MD 20742-2611 > 301-405-2545 Phone > www.phi.umd.edu > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: no end date
>Set it to NULL. I tried this, but it said, "null is not defined": Leaving it blank is not an option because I may have to change a date into "no date". So, I hate to sound daft, but how do I set it to null? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: no end date
_ From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: 04 October 2004 14:55 To: CF-Talk Subject: Re: no end date >Set it to NULL. I tried this, but it said, "null is not defined": Leaving it blank is not an option because I may have to change a date into "no date". So, I hate to sound daft, but how do I set it to null? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: no end date
Daniel Kessler wrote: > I have a calendar of events. All events have a start date/time, but > many of them don't have an end date/time. I can work around this by > setting an obviously incorrect end date and checking for it (i.e. > 12.17.66, my wife's birthday). However, I'd prefer to not set a date > if there isn't one and check for that instead. Is it likely that if there isn't an end date, it is because the end date is the same as the start date? If this is true, why not simply insert the same date into start and end date? It'll make it easier when you need to know all the events that end between two dates :) Regards Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Templates..?
Sean Corfield wrote: >>Personally I recommend using a server-side scripting language (CF, PHP, >>etc) to do your templating rather than Dreamweaver's templates as I >>found them to be unreliable on larger sites. >> >> >Could you elaborate on that? We use DW templates across the majority >of macromedia.com's 40,000+ static pages with no reliability problems. > > I've seen (with DWMX, not used them with MX2004) where it would fail to update pages associated with templates correctly and fairly regularly too. Like I said I haven't used that feature with DWMX2004 as these days I write my own content management system and/or use a framework. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: no end date
There is no NULL in CF so that won't work. The idea is to set it NULL in the DB, which will return an empty (blank) value in the query in CF. Why is the blank a problem? -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, 4 October 2004 9:55 To: CF-Talk Subject: Re: no end date >Set it to NULL. I tried this, but it said, "null is not defined": Leaving it blank is not an option because I may have to change a date into "no date". So, I hate to sound daft, but how do I set it to null? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: no end date
Well, blank should really be treated as missing data.. its always best to use NULL. Best bet would be to set the end data in the DB as defaulting to NULL and that way you can pass an end date or not. _ From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 04 October 2004 15:01 To: CF-Talk Subject: RE: no end date There is no NULL in CF so that won't work. The idea is to set it NULL in the DB, which will return an empty (blank) value in the query in CF. Why is the blank a problem? -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, 4 October 2004 9:55 To: CF-Talk Subject: Re: no end date >Set it to NULL. I tried this, but it said, "null is not defined": Leaving it blank is not an option because I may have to change a date into "no date". So, I hate to sound daft, but how do I set it to null? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
index pdf
Good Monday morning, I have developed a spider for our site to collect links for indexing, the list of links is then looped and cfhttp is employed to get the content. We parse the tags out of the html pages and put the content into a table for a later query and into a Verity collection. I would like to include our Adobe .pdf and Word .doc files in our index. I would like to index the .pdf and .doc documents during the looping because the content is binary and is not easily parsed. I believe Verity will index .doc and .pdf pages, correct? Does anyone have a code sample that performs indexing on a pdf / doc file? Currently I am using: extensions=".pdf"> But it does not appear to be performing the indexing. TIA! Doug James IT Developer Hollings Cancer Center Medical University of SC http://hcc.musc.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: no end date
>There is no NULL in CF so that won't work. The idea is to set it NULL in the >DB, which will return an empty (blank) value in the query in CF. > >Why is the blank a problem? well if it's already set to a date and when I update it I leave it blank, then it'll keep the date. During the insert, I guess I can have a to leave it out, but it's still a problem for the update. Deanna, I looked up YesNoFormat, but I don't really get it as of yet. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: no end date
The DB should use NULL, not blank. To update a field to NULL, use CFQUERYPARAM with NULL="yes" -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, 4 October 2004 10:29 To: CF-Talk Subject: Re: no end date >There is no NULL in CF so that won't work. The idea is to set it NULL >in the DB, which will return an empty (blank) value in the query in CF. > >Why is the blank a problem? well if it's already set to a date and when I update it I leave it blank, then it'll keep the date. During the insert, I guess I can have a to leave it out, but it's still a problem for the update. Deanna, I looked up YesNoFormat, but I don't really get it as of yet. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: no end date
>Is it likely that if there isn't an end date, it is because the end date >is the same as the start date? No, it just might not end, or rather it might be a repeating event or the people entering just don't have an end date available to them. I used to have a fake end-date but I ran into some gotchas there so I am hoping for something more literal. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: no end date
ok, I've always said that I was gonna give cfqueryparam a better look. I guess today's the day. >The DB should use NULL, not blank. > >To update a field to NULL, use CFQUERYPARAM with NULL="yes" > >-Original Message- >From: daniel kessler [mailto:[EMAIL PROTECTED] >Sent: Monday, 4 October 2004 10:29 >To: CF-Talk >Subject: Re: no end date > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: no end date
Basically, that code says - if you're passing me a zero-length string, tell the database that you're inserting a null. > > Deanna, I looked up YesNoFormat, but I don't really get it as of yet. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: removing directories that are not empty
how about copying a directory and all of its contents, this is on CFMX. > Stephenie Hamilton wrote: > > does anyone know of a udf or custom tag that will easy remove > directories that are not empty? > > > Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT-MySql Newbiee
I just installed MSql 4.0 on my Win2K machine. I started it from the command line and opened another DOS window and did some querying. I want to create a database but I do not have administrative rights as my user. How can do I get these rights and cna I simply just log on as the SA (SQL2K) equivalent. ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: removing directories that are not empty
Xcopy if you are on Windows. -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Monday, 4 October 2004 10:47 To: CF-Talk Subject: Re: removing directories that are not empty how about copying a directory and all of its contents, this is on CFMX. > Stephenie Hamilton wrote: > > does anyone know of a udf or custom tag that will easy remove > directories that are not empty? > > > Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT-MySql Newbiee
>> I just installed MSql 4.0 on my Win2K machine. I started it from the command line and opened another DOS window and did some querying. i did this at the weekend and found these steps useful. install php install phpmyadmin use the winmysqladmin.exe in the bin dir of mysql to configure your database make sure you change your root password after setting up phpmyadmin to something other than blank (strange cause it always defaulted to blank for me) I was up and running in an hour or so... dunno if that helps -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Editing XMl
On Friday 01 Oct 2004 19:38 pm, [EMAIL PROTECTED] wrote: > the suite. What I need to do is delete and replace my section of the XML > document, with the XML that I've generated. Have you looked at the XML section of the CF documentation ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT-MySql Newbiee
thanks but I do not want to install PHP at this time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 10:02 AM To: CF-Talk Subject: RE: OT-MySql Newbiee >> I just installed MSql 4.0 on my Win2K machine. I started it from the command line and opened another DOS window and did some querying. i did this at the weekend and found these steps useful. install php install phpmyadmin use the winmysqladmin.exe in the bin dir of mysql to configure your database make sure you change your root password after setting up phpmyadmin to something other than blank (strange cause it always defaulted to blank for me) I was up and running in an hour or so... dunno if that helps -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT-MySql Newbiee
sure there's a cfmyadmin tool out there as well... http://www.cfmyadmin.com/ You'll still find it easier running the winmysqladmin.exe to configure the mysql server tho if not, good luck with the command line there's plenty of docs about it on the mysql website. me, I'm a windows baby unfortunately -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: no end date
Hey everyone, thanks for the help. I have it working and understand my choices better for the future. >I have a calendar of events. All events have a start date/time, but >many of them don't have an end date/time. I can work around this by >setting an obviously incorrect end date and checking for it (i.e. >12.17.66, my wife's birthday). However, I'd prefer to not set a date >if there isn't one and check for that instead. > >So, what's the proper way of having no end date in the database? >Also since this is editable information, I may have an entry with a >date and need to set it to null or "no end date" so any suggestion >should take this into account. > >I'm using the latest, greatest Oracle. > >good morning, and thanks. > >-- >Daniel Kessler > >Department of Public and Community Health >University of Maryland >Suite 2387 Valley Drive >College Park, MD 20742-2611 >301-405-2545 Phone >www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Encrypt Decrypt?
Jochem, Still with your code there is apparently some part of the code in the variable "encrypted" that confuses Cold Fusion. It appears that CF is interpreting something in the code as a tag ending. Thanks, Nick At 12:55 PM 10/3/2004, you wrote: >Nick Baker wrote: > > We need to Encrypt and email private info. Then using the same key decrypt > > on the receiving end. However, our Decrypt tag throws and error, not > liking > > some of the Encrypted code. The example below works under the same > > circumstances. Encrypting in one template and decrypting in another > > template (by > and > > error. The thing I can think of is there is something that is different in > > the encrypted code than appears to be visible and copy/pasted?? > >This can happen with multibyte encodings. Try putting a >ToBase64() in between: > > > > >Jochem > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT-MySql Newbiee
http://www.webyog.com/sqlyog/index.php best I have seen JT -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 8:05 AM To: CF-Talk Subject: RE: OT-MySql Newbiee thanks but I do not want to install PHP at this time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 10:02 AM To: CF-Talk Subject: RE: OT-MySql Newbiee >> I just installed MSql 4.0 on my Win2K machine. I started it from the command line and opened another DOS window and did some querying. i did this at the weekend and found these steps useful. install php install phpmyadmin use the winmysqladmin.exe in the bin dir of mysql to configure your database make sure you change your root password after setting up phpmyadmin to something other than blank (strange cause it always defaulted to blank for me) I was up and running in an hour or so... dunno if that helps -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT-MySql Newbiee
In the way of graphical GUI's you can also try for free MySQL Control Centre http://www.mysql.com/products/mysqlcc/ MySQL Query Browser http://dev.mysql.com/downloads/query-browser/ There are als some "paid for" version like which give free 30day eval MySQL Front http://www.mysqlfront.de/ SQLyog http://www.webyog.com/sqlyog/index.php Andy www.andyjarrett.co.uk - Original Message - From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Mon, 4 Oct 2004 16:21:21 +0100 Subject: RE: OT-MySql Newbiee To: CF-Talk <[EMAIL PROTECTED]> sure there's a cfmyadmin tool out there as well... http://www.cfmyadmin.com/ You'll still find it easier running the winmysqladmin.exe to configure the mysql server tho if not, good luck with the command line there's plenty of docs about it on the mysql website. me, I'm a windows baby unfortunately -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT-MySql Newbiee
I quiite like http://www.dbtools.com.br/EN/index.php _ From: Andy Jarrett [mailto:[EMAIL PROTECTED] Sent: 04 October 2004 16:33 To: CF-Talk Subject: Re: OT-MySql Newbiee In the way of graphical GUI's you can also try for free MySQL Control Centre http://www.mysql.com/products/mysqlcc/ MySQL Query Browser http://dev.mysql.com/downloads/query-browser/ There are als some "paid for" version like which give free 30day eval MySQL Front http://www.mysqlfront.de/ SQLyog http://www.webyog.com/sqlyog/index.php Andy www.andyjarrett.co.uk - Original Message - From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Mon, 4 Oct 2004 16:21:21 +0100 Subject: RE: OT-MySql Newbiee To: CF-Talk <[EMAIL PROTECTED]> sure there's a cfmyadmin tool out there as well... http://www.cfmyadmin.com/ You'll still find it easier running the winmysqladmin.exe to configure the mysql server tho if not, good luck with the command line there's plenty of docs about it on the mysql website. me, I'm a windows baby unfortunately -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
User to upload to their site
I have a client that wants to be able to copy formatted text from a web site (presumably with permission), and paste it into a text box or something easy to use so that he can update his current news page. He can barely do cut and paste, so putting in HTML codes would be too much for him. Rodger [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: User to upload to their site
Rodger wrote: > I have a client that wants to be able to copy formatted text from a web site > (presumably with permission), > and paste it into a text box or something easy to use so that he can update > his current news page. > He can barely do cut and paste, so putting in HTML codes would be too much > for him. check out fckeditor ... you can paste from word docs and such and it'll format to HTML and even clean up the nasty html that word generates. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: User to upload to their site
I agree. FCKEditor is pretty good and works with most browsers. I found a possible restriction in that the string buffer or content you put it is not really unlimited. It may simply be a _javascript_ issue or restrictions with string buffer. To see what I mean, enter large content. even though it states it was successfully updated in the database, it's cut off when u view it. in SQL server, the field is defined as nText type so it should fit. I've reported it to them a couple of weeks ago, but still haven't heard from them. anybody else found this out? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: User to upload to their site
Do you have a character cutoff limit in your datasource defined? If so, that's probably the problem. >I agree. FCKEditor is pretty good and works with most browsers. I found >a possible restriction in that the string buffer or content you put it >is not really unlimited. It may simply be a _javascript_ issue or >restrictions with string buffer. To see what I mean, enter large >content. even though it states it was successfully updated in the >database, it's cut off when u view it. in SQL server, the field is >defined as nText type so it should fit. I've reported it to them a >couple of weeks ago, but still haven't heard from them. > >anybody else found this out? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: User to upload to their site
nope. nada I just tested it for overflow conditions on my codes and just happen to notice this that's all. I can't remember what the character count I had but its pretty high so I don't think 99. % of the population would see it as a restriction/problem. L --- Lawrence Ng Web Manager Vancouver Community College Room 5060A 1155 East Broadway Vancouver, BC V5T 4V5 t: 604.871.7156 f: 604.871.7451 e: lng at vcc dot ca Vancouver Community College is British Columbia's No. 1 college, serving 25,000 full- and part-time students a year in health, hospitality, business, English as a Second Language, adult basic education, career access, trades and technology. "Empty your cup so that it may be filled; become devoid to gain totality." - Bruce Lee, Tao of Jeet Kune Do [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: User to upload to their site
I concur, I use FCKEditer and it does a wonderful job. I highly recommend it. I and my clients use it everyday. http://www.fckeditor.net/ Russell - Original Message - From: Rick Root To: CF-Talk Sent: Monday, October 04, 2004 11:22 AM Subject: Re: User to upload to their site Rodger wrote: > I have a client that wants to be able to copy formatted text from a web site > (presumably with permission), > and paste it into a text box or something easy to use so that he can update > his current news page. > He can barely do cut and paste, so putting in HTML codes would be too much > for him. check out fckeditor ... you can paste from word docs and such and it'll format to HTML and even clean up the nasty html that word generates. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Yet Another Simple Regex Q
I have this regex which works splendidly: [EMAIL PROTECTED] I want to make it so the string has no less than 6 and no more than 60 chars, but if I plug in {6,60} it seems to either error out or keep the regex from working no matter where or how I place it. What am I missing? Ben's regex book either doesn't talk about this or I can't find the reference. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Yet Another Simple Regex Q
[EMAIL PROTECTED],60}$ seemed to work for me in a quick test. What CF version, etc.? --Ben Matt Robertson wrote: > I have this regex which works splendidly: > > [EMAIL PROTECTED] > > I want to make it so the string has no less than 6 and no more than 60 > chars, but if I plug in {6,60} it seems to either error out or keep > the regex from working no matter where or how I place it. > > What am I missing? Ben's regex book either doesn't talk about this or > I can't find the reference. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Yet Another Simple Regex Q
>ben Doom wrote: >[EMAIL PROTECTED],60}$ Argh. I kept the plus sign when I was trying this before: [EMAIL PROTECTED],60}$ Works great now. Thanks! --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Strange query "bug" still in CFMX
Still using CF5 at my work, and using CFMX6.1 at home, I was a bit astonished this issue came up also in CFMX6.1? What causes this behaviour? I cannot imagine it is truly a bug, but I cannot figure out why this behaviour is in CFMX? When you loop over two query resultsets, the second nesting often cannot handle it's parent variables, despite it has been referenced with the query name, could someone enlighten me? The output this code gives is, and qryRootnodes.cultureid doesn't give the correct data back unless it is set into another variable, here set in culture_4225 - should be 4225 culture_4225 - should be 4225 culture_4225 - should be 4224 culture_4225 - should be 4224 SELECT RC.instanceid, I.Label, RC.cultureid, RC.handle FROM RootnodeConfiguration RC JOIN Instance I ON (I.instanceid = RC.instanceid) WHERE RC.departmentid = #session.departmentid# OR RC.userid = #session.userid# EXEC dbo.upu_Instance_GetChildren @ParentID = #session.domaininstanceid#, @ObjectType = #Request.Object.object_Culture.type#, @SortField = 'Label' culture_#qryRootnodes.cultureid# - should be #test# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ERROR
I am testing a site I switch from ACCESS to MySql and I ma getting the following error. ByteArray objects cannot be converted to strings. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Strange query "bug" still in CFMX
There's only one query-based psuedo-scope. So if you're inside two query loops, you can only dereference variables using the query name for the inner query. If you want access to the outer query, you have to either assign the columns to variables, or store the current row, and dereferece them with the full queryname.columnname[row] syntax. I'm not sure if it's a bug or it was intended this way. However, I do think it ought to change. cheers, barneyb On Mon, 4 Oct 2004 20:37:59 +0200, Micha Schopman <[EMAIL PROTECTED]> wrote: > Still using CF5 at my work, and using CFMX6.1 at home, I was a bit astonished this issue came up also in CFMX6.1? What causes this behaviour? I cannot imagine it is truly a bug, but I cannot figure out why this behaviour is in CFMX? > > When you loop over two query resultsets, the second nesting often cannot handle it's parent variables, despite it has been referenced with the query name, could someone enlighten me? > > The output this code gives is, and qryRootnodes.cultureid doesn't give the correct data back unless it is set into another variable, here set in > > culture_4225 - should be 4225 > culture_4225 - should be 4225 > culture_4225 - should be 4224 > culture_4225 - should be 4224 > > > > SELECT RC.instanceid, I.Label, RC.cultureid, RC.handle > FROM RootnodeConfiguration RC > JOIN Instance I ON (I.instanceid = RC.instanceid) > WHERE RC.departmentid = #session.departmentid# > OR RC.userid = #session.userid# > > > > EXEC dbo.upu_Instance_GetChildren > @ParentID = #session.domaininstanceid#, > @ObjectType = #Request.Object.object_Culture.type#, > @SortField = 'Label' > > > > > > > > > > > > culture_#qryRootnodes.cultureid# - should be #test# > > > > > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com I currently have 4 GMail invites for the taking [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Strange problem.
Can anybody give me a hint why we are getting this error? "The string "COOKIE.CFAUTHORIZATION_dev-infoweb" is not a valid ColdFusion variable name." I can see the problem; "dev-infoweb" has an illegal character, just as the error tells us. "dev-infoweb" is the name of the website where this code lives. But, why is the block trying to set this cookie for this website in this way. And if it needs to do this, why don't other websites "dev-mobilecalendar", "staging-mobilecalendar", "dev-cps", etcetera on the same server not cause any problem using basically identical code? ColdFusion MX 6,1,0,63958 Windows 2000 server. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: User to upload to their site
Lawrence Ng wrote: > I agree. FCKEditor is pretty good and works with most browsers. I found > a possible restriction in that the string buffer or content you put it > is not really unlimited. It may simply be a _javascript_ issue or > restrictions with string buffer. To see what I mean, enter large > content. even though it states it was successfully updated in the > database, it's cut off when u view it. in SQL server, the field is > defined as nText type so it should fit. I've reported it to them a > couple of weeks ago, but still haven't heard from them. > > anybody else found this out? I actually have had a similar problem but I've been unable to save the data... like when I click "Save", it just doesn't do anything. It only happens when I have a large amount of text (and really, not even that large... but most of the entries on this page have done it... fans.bobguiney.com/blog.php ... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Strange query
I thought of the scope yes, but then the dereferencing is more or less lazy because I can reference the query scope :) I can even dump it :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: User to upload to their site
or did it save only partial content? >>> [EMAIL PROTECTED] 10/4/2004 12:07:41 PM >>> Lawrence Ng wrote: > I agree. FCKEditor is pretty good and works with most browsers. I found > a possible restriction in that the string buffer or content you put it > is not really unlimited. It may simply be a _javascript_ issue or > restrictions with string buffer. To see what I mean, enter large > content. even though it states it was successfully updated in the > database, it's cut off when u view it. in SQL server, the field is > defined as nText type so it should fit. I've reported it to them a > couple of weeks ago, but still haven't heard from them. > > anybody else found this out? I actually have had a similar problem but I've been unable to save the data... like when I click "Save", it just doesn't do anything. It only happens when I have a large amount of text (and really, not even that large... but most of the entries on this page have done it... fans.bobguiney.com/blog.php ... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Directory Opus 8 released
I just wanted to pass along word that GP Software have released the latest edition of Directory Opus, aka DOpus, at their website http://www.dopus.com/. In skipping revision numbers from v6 to v8, DOpus has gained a vast amount of flexibility for viewing and managing different document types. Some of the highlights include: * Powerful File Manager & Explorer Replacement * User-definable File Display Views * User-definable Toolbars, Menus, File Types * Advanced built-in Image and File Viewers * Built-in ZIP and Advanced FTP * Visually Synchronize Files & Find Duplicates * Advanced Search and Rename Functions * More Configurable than any other program * Easy Slideshows...and much more.. It also has new image manipulation support for resizing and converting images, can send files via email, can automatically change the settings of the current window depending on the type of files contained including showing media meta data (think camera settings on images, etc), etc. Possibly the best thing about DOpus is that almost everything is configurable - all menus, toolbars, etc, etc. I suggest taking a look at the website (http://www.dopus.com/) to get an idea of what is possible, then download the 60-day evaluation copy for a trial-run. One thing I just realized is that one of the new features, the so called "flat view", opens up a directory structure in a similar way to Dreamweaver (or OSX) in that the directory structure is shown. What's cool about that is that you can open up a second window and connect to your FTP site... with the local directory listing everything you can select files from anywhere in the directory structure, hit the copy button and you will be asked if you would like to copy the files to the root of the destination directory or to re-create the directory structure! It is this last aspect that recreates Dreamweaver's nice 'n easy site management functionality. Want to make it even more powerful, open in dual-lister mode and you can recreate DW's dual-pane site manager. Nifty! Have fun :) Note: I'm just a happy customer, I don't work for them. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT-MySql Newbiee
I use Navicat for all MySQL needs. Don't know why anyone would use anything else. Free trial,, it's easier than Access to use, and it's el cheapo to buy. www.navicat.com The Game! >I quiite like http://www.dbtools.com.br/EN/index.php > > > > > > > > > _ > >From: Andy Jarrett [mailto:[EMAIL PROTECTED] >Sent: 04 October 2004 16:33 >To: CF-Talk >Subject: Re: OT-MySql Newbiee > > > >In the way of graphical GUI's you can also try for free > >MySQL Control Centre http://www.mysql.com/products/mysqlcc/ >MySQL Query Browser http://dev.mysql.com/downloads/query-browser/ > >There are als some "paid for" version like which give free 30day eval >MySQL Front http://www.mysqlfront.de/ >SQLyog http://www.webyog.com/sqlyog/index.php > >Andy >www.andyjarrett.co.uk > >- Original Message - >From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> >Date: Mon, 4 Oct 2004 16:21:21 +0100 >Subject: RE: OT-MySql Newbiee >To: CF-Talk <[EMAIL PROTECTED]> > >sure there's a cfmyadmin tool out there as well... > >http://www.cfmyadmin.com/ > >You'll still find it easier running the winmysqladmin.exe to configure >the mysql server tho > >if not, good luck with the command line there's plenty of docs about >it on the mysql website. > >me, I'm a windows baby unfortunately > >-- >dc > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Interacting with GoldMine data with ColdFusion
Goldmine can be either SQL server OR dbase... or in the case of a synch server a combination. Can you further describe your setup? -Mark -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Friday, October 01, 2004 5:02 PM To: CF-Talk Subject: Interacting with GoldMine data with ColdFusion Anyone have any experience with GoldMine? (http://www.frontrange.com/goldmine/) We're looking at using CF to get at the data (the web site says SQL Server, but it's really more SQL Server reading dBase files), which is supposed to be possible. But, I'm having trouble setting up a DSN (ODBC socket to a system DSN) in the administrator. Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Logging into CF App with NT Username and password
Sorry in advance - I'm a bit confused here. I am creating an intranet app and would like to make the log in process as simple for the user as possible by having them log in with their Windows username and password. I am looking for a solution that will provide for: 1. The user logging in with their Windows username and password, and 2. The capturing of that username and password Is this something commonly done? I'm not able to find anything like this while searching for CFMX's security framework. Up to now, my login information has been stored in SQL Server, so this approach is new to me. Thanks in advance for any assistance. Sincerely, Andrew Webmaster [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFSEARCH error
I'm using CF 4.5 and have 4 collections that my site searches from. Worked fine for months until today. Now whenever I try to query any of the collections using CFSEARCH, I get an error that says: Error occurred in tag CFSEARCH Unexpected error occurred while processing tag. I tried to repair the collection, but that did nothing. So then I deleted 1 of the collections. It was removed successfully. I then tried to re-create it using CFCOLLECTION, but that errors out with the same type error as above. Has anybody had this type problem before or know how to solve it? -Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT-MySql Newbiee
i used too use navicat but switched to mysql mystro like navicat just a lot nicer http://www.mysqlmaestro.com/products/maestro/ -- Original Message -- From: Will Tomlinson <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 04 Oct 2004 15:33:06 -0400 >I use Navicat for all MySQL needs. Don't know why anyone would use anything else. Free trial,, it's easier than Access to use, and it's el cheapo to buy. > >www.navicat.com > >The Game! > > > >>I quiite like http://www.dbtools.com.br/EN/index.php >> >> >> >> >> >> >> >> >> _ >> >>From: Andy Jarrett [mailto:[EMAIL PROTECTED] >>Sent: 04 October 2004 16:33 >>To: CF-Talk >>Subject: Re: OT-MySql Newbiee >> >> >> >>In the way of graphical GUI's you can also try for free >> >>MySQL Control Centre http://www.mysql.com/products/mysqlcc/ >>MySQL Query Browser http://dev.mysql.com/downloads/query-browser/ >> >>There are als some "paid for" version like which give free 30day eval >>MySQL Front http://www.mysqlfront.de/ >>SQLyog http://www.webyog.com/sqlyog/index.php >> >>Andy >>www.andyjarrett.co.uk >> >>- Original Message - >>From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> >>Date: Mon, 4 Oct 2004 16:21:21 +0100 >>Subject: RE: OT-MySql Newbiee >>To: CF-Talk <[EMAIL PROTECTED]> >> >>sure there's a cfmyadmin tool out there as well... >> >>http://www.cfmyadmin.com/ >> >>You'll still find it easier running the winmysqladmin.exe to configure >>the mysql server tho >> >>if not, good luck with the command line there's plenty of docs about >>it on the mysql website. >> >>me, I'm a windows baby unfortunately >> >>-- >>dc >> >> _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OO seems to have 2 eyes :)
OO (two) eyes is definitely better than one, probably in most cases, the following seems to demonstrate that. FYI, the test code is run under an app with session-enabled. Find a structure's key/value pair Note: an interesting thing about OO is that it is "spatial", for instance, the "internal" function may be placed below its caller while the traditional structured programming can't. Source Code:FORM: #aStructKeyValuePair(FORM)# SESSION: #aStructKeyValuePair(SESSION)# SERVER: #aStructKeyValuePair(SERVER)# Output: FORM: #aStructKeyValuePair(FORM)# SESSION: #aStructKeyValuePair(SESSION)# SERVER: #aStructKeyValuePair(SERVER)# returntype="string" access="private"> type="struct" required="true"> #a# -- #arguments.aS[a]#oops, complex data here [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support] #a# -- #arguments.aS[a]# oops, complex data here
RE: Logging into CF App with NT Username and password
We use the NT security CFC from Macromedia. http://www.macromedia.com/devnet/mx/coldfusion/articles/ntdomain.html [Article] http://download.macromedia.com/pub/devnet/downloads/ntsecurity.zip [ntsecurity.cfc] -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Templates..?
Yes, that's a documented "feature". Dreamweaver templates are not something to be recommended, if anything for the simple reason they don't offer anything that can't be done without them and tie the current (and future!) developers to Dreamweaver. That's a biggie, right there. My 2 cents. >Sean Corfield wrote: > >I've seen (with DWMX, not used them with MX2004) where it would fail to >update pages associated with templates correctly and fairly regularly >too. Like I said I haven't used that feature with DWMX2004 as these >days I write my own content management system and/or use a framework. >-- >*Damien McKenna* - Web Developer - [EMAIL PROTECTED] > >The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 >"Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Dynamic List/Menu
Brain fart for the day here goes... I have a dynamic list/menu & a submit button below, and I want to let the user select from the list, click the button, go to a page to display record details. Is it Monday or did I lose brain cells over the weekend? -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Dynamic List/Menu
By list, do you mean a form select box? _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 October 2004 10:11 a.m. To: CF-Talk Subject: Dynamic List/Menu Brain fart for the day here goes... I have a dynamic list/menu & a submit button below, and I want to let the user select from the list, click the button, go to a page to display record details. Is it Monday or did I lose brain cells over the weekend? -- Donna French [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Templates..?
> don't offer anything that can't be done without them and tie the current (and future!) developers to > Dreamweaver. That's a biggie, right there. I don't use DW templates myself, preferring instead DW library items or server side includes. However, both DW templates and library items can speed up production and don't tie anyone to DW. All you need do is strip out the DW specific comments from the HTML and the pages are no longer considered templates by DW or any other software. Simple search and replacing can do this, either within or outside DW. - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dynamic List/Menu
yes - Original Message - From: Matthew Walker <[EMAIL PROTECTED]> Date: Tue, 05 Oct 2004 10:14:05 +1300 Subject: RE: Dynamic List/Menu To: CF-Talk <[EMAIL PROTECTED]> By list, do you mean a form select box? _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 October 2004 10:11 a.m. To: CF-Talk Subject: Dynamic List/Menu Brain fart for the day here goes... I have a dynamic list/menu & a submit button below, and I want to let the user select from the list, click the button, go to a page to display record details. Is it Monday or did I lose brain cells over the weekend? -- Donna French [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Templates..?
>> don't offer anything that can't be done without them and tie the current >(and future!) developers to > > Dreamweaver. That's a biggie, right there. > >I don't use DW templates myself, preferring instead DW library items or >server side includes. However, both DW templates and library items can speed >up production and don't tie anyone to DW. All you need do is strip out the >DW specific comments from the HTML and the pages are no longer considered >templates by DW or any other software. Simple search and replacing can do >this, either within or outside DW. > >- >Regards, >Bob Haroche >O n P o i n t S o l u t i o n s >www.OnPointSolutions.com Why go through the trouble of a search and replace (another risky peroposition!)? I don't see how using Templates or Library Items can be any faster than using includes from the beginning, but your mileage might vary. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Dynamic List/Menu
choose >macromedia _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 October 2004 10:20 a.m. To: CF-Talk Subject: Re: Dynamic List/Menu yes - Original Message - From: Matthew Walker <[EMAIL PROTECTED]> Date: Tue, 05 Oct 2004 10:14:05 +1300 Subject: RE: Dynamic List/Menu To: CF-Talk <[EMAIL PROTECTED]> By list, do you mean a form select box? _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 October 2004 10:11 a.m. To: CF-Talk Subject: Dynamic List/Menu Brain fart for the day here goes... I have a dynamic list/menu & a submit button below, and I want to let the user select from the list, click the button, go to a page to display record details. Is it Monday or did I lose brain cells over the weekend? -- Donna French [EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dynamic List/Menu
Did you try to include a code sample, perhaps with a line of hyphens at the top? If so, try sending it again without the hyphens. If not, here is a simple pseudo-code example #label# Jerry Johnson >>> [EMAIL PROTECTED] 10/04/04 05:19PM >>> yes - Original Message - From: Matthew Walker <[EMAIL PROTECTED]> Date: Tue, 05 Oct 2004 10:14:05 +1300 Subject: RE: Dynamic List/Menu To: CF-Talk <[EMAIL PROTECTED]> By list, do you mean a form select box? _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 October 2004 10:11 a.m. To: CF-Talk Subject: Dynamic List/Menu Brain fart for the day here goes... I have a dynamic list/menu & a submit button below, and I want to let the user select from the list, click the button, go to a page to display record details. Is it Monday or did I lose brain cells over the weekend? -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Text driver for MX?
Hola - We've got some old user-administered text databases. Pipe- and comma-delimited and such. We're upgrading from 4.0 to MX on this box, and I can't figure out how to keep the datasources intact for these users. We'd previously use the Intersolv/FoxPro drivers to talk to flat text files, but there doesn't seem to be an equivalent for MX. Does anyone have any suggestions or insight? Thanks Shawn -- Shawn Lavelle Multimedia Analyst Interactive Multimedia Applications Group The George Washington University 202.994.6673 [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Dynamic List/Menu
Is it a mutli select? SELECT * FROM TABLE WHERE ID IN (#form.fieldname#) #query.fieldname# #query.anotherfield# GO BACK TO THE SELECT FORM - - - - - - -or- - - - - - - Is it a single select? SELECT * FROM TABLE WHERE ID = #val(form.fieldname)# #query.fieldname# #query.anotherfield# GO BACK TO THE SELECT FORM _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 5:11 PM To: CF-Talk Subject: Dynamic List/Menu Brain fart for the day here goes... I have a dynamic list/menu & a submit button below, and I want to let the user select from the list, click the button, go to a page to display record details. Is it Monday or did I lose brain cells over the weekend? -- Donna French [EMAIL PROTECTED] _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:180429"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] [HYPERLINK "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation s and Support] _ HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=34" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dynamic List/Menu
Of course I forgot the submit button. Feel free to include one. Jerry Johnson >>> [EMAIL PROTECTED] 10/04/04 05:30PM >>> Did you try to include a code sample, perhaps with a line of hyphens at the top? If so, try sending it again without the hyphens. If not, here is a simple pseudo-code example #label# Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dynamic List/Menu
yeah i think i should post the code Clients: #Client_LName#, #Client_FName# Offenders: #Offender_LName#, #Offender_FName# Total: #rsClients.RecordCount# Total: #rsOffenders.RecordCount# Thanks, Donna - Original Message - From: Jerry Johnson <[EMAIL PROTECTED]> Date: Mon, 04 Oct 2004 17:30:11 -0400 Subject: Re: Dynamic List/Menu To: CF-Talk <[EMAIL PROTECTED]> Did you try to include a code sample, perhaps with a line of hyphens at the top? If so, try sending it again without the hyphens. If not, here is a simple pseudo-code example #label# Jerry Johnson >>> [EMAIL PROTECTED] 10/04/04 05:19PM >>> yes - Original Message - From: Matthew Walker <[EMAIL PROTECTED]> Date: Tue, 05 Oct 2004 10:14:05 +1300 Subject: RE: Dynamic List/Menu To: CF-Talk <[EMAIL PROTECTED]> By list, do you mean a form select box? _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 October 2004 10:11 a.m. To: CF-Talk Subject: Dynamic List/Menu Brain fart for the day here goes... I have a dynamic list/menu & a submit button below, and I want to let the user select from the list, click the button, go to a page to display record details. Is it Monday or did I lose brain cells over the weekend? -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Templates..?
> I don't see how using Templates or Library Items can be any faster than using includes from the beginning, but your mileage might vary. This is how I find library items useful at least for HTML sites: I use library items for certain items I want to have consistent during development but know will change just before site launch. For example nav bars: Home | Products | About Us | Contact I place the library item on all pages. If the client wants to change "About Us" to "About" or change the graphics used for the rollover images, I change the library item once and the change is made on all pages containing that library item throughout the site. Just before launching the site, I go to each page, detach the library item and on the Home page, remove the link to home; on the Products page, I remove the link to products, etc. In other words, during the development I can easily keep the styles and verbiage consistent across pages and only need to deal with removing the links (so pages don't link to themselves) at the end. Yes, I still have to eventually deal with each page individually but I only do that once. Unless you're using some fancy server-side logic, you can't do this with SSI or cfincludes...and again, I typically do this with straight HTML (not CFM) sites. - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: User to upload to their site
Thanks, I installed it, but I don't see any doc on how to use it. The sample test file test.cfm, which has multiple text boxes, calls testsubmit.asp, written in ASP. Here is the relevant section of code, can anyone explain how it works in coldfusion? <% For Each sForm in Request.Form %> <%=sForm%> <%=Server.HTMLEncode( Request.Form(sForm) )%> <% Next %> Rodger _ From: Russell Patterson [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 9:44 AM To: CF-Talk Subject: Re: User to upload to their site I concur, I use FCKEditer and it does a wonderful job. I highly recommend it. I and my clients use it everyday. http://www.fckeditor.net/ Russell - Original Message - From: Rick Root To: CF-Talk Sent: Monday, October 04, 2004 11:22 AM Subject: Re: User to upload to their site Rodger wrote: > I have a client that wants to be able to copy formatted text from a web site > (presumably with permission), > and paste it into a text box or something easy to use so that he can update > his current news page. > He can barely do cut and paste, so putting in HTML codes would be too much > for him. check out fckeditor ... you can paste from word docs and such and it'll format to HTML and even clean up the nasty html that word generates. - Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: User to upload to their site
everyone seems to love the FCKEditer but probably just cause of the name ;) i could never get it to work in firefox so i went with tinymce http://tinymce.moxiecode.com/ much easier to add and works like a champ in every browser i tried it in -- Original Message -- From: "Rodger" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 4 Oct 2004 14:54:49 -0700 >Thanks, I installed it, but I don't see any doc on how to use it. >The sample test file test.cfm, which has multiple text boxes, calls >testsubmit.asp, written in ASP. >Here is the relevant section of code, can anyone explain how it works in >coldfusion? > > <% > For Each sForm in Request.Form > %> > > <%=sForm%> > <%=Server.HTMLEncode( Request.Form(sForm) )%> > > <% > Next > %> >Rodger > > > _ > >From: Russell Patterson [mailto:[EMAIL PROTECTED] >Sent: Monday, October 04, 2004 9:44 AM >To: CF-Talk >Subject: Re: User to upload to their site > > >I concur, I use FCKEditer and it does a wonderful job. I highly recommend >it. I and my clients use it everyday. > >http://www.fckeditor.net/ > >Russell > - Original Message - > From: Rick Root > To: CF-Talk > Sent: Monday, October 04, 2004 11:22 AM > Subject: Re: User to upload to their site > > Rodger wrote: > > > I have a client that wants to be able to copy formatted text from a web >site > > (presumably with permission), > > and paste it into a text box or something easy to use so that he can >update > > his current news page. > > He can barely do cut and paste, so putting in HTML codes would be too >much > > for him. > > check out fckeditor ... you can paste from word docs and such and it'll > format to HTML and even clean up the nasty html that word generates. > > - Rick > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: User to upload to their site
Hey that is a nice looking editor and doesn't suffer from the common "Firefox support will be added to the next version" problem (soEditor, htmlArea, FCKeditor). _ From: dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 October 2004 11:04 a.m. To: CF-Talk Subject: RE: User to upload to their site everyone seems to love the FCKEditer but probably just cause of the name ;) i could never get it to work in firefox so i went with tinymce http://tinymce.moxiecode.com/ much easier to add and works like a champ in every browser i tried it in -- Original Message -- From: "Rodger" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 4 Oct 2004 14:54:49 -0700 >Thanks, I installed it, but I don't see any doc on how to use it. >The sample test file test.cfm, which has multiple text boxes, calls >testsubmit.asp, written in ASP. >Here is the relevant section of code, can anyone explain how it works in >coldfusion? > > <% > For Each sForm in Request.Form > %> > > <%=sForm%> > <%=Server.HTMLEncode( Request.Form(sForm) )%> > > <% > Next > %> >Rodger > > > _ > >From: Russell Patterson [mailto:[EMAIL PROTECTED] >Sent: Monday, October 04, 2004 9:44 AM >To: CF-Talk >Subject: Re: User to upload to their site > > >I concur, I use FCKEditer and it does a wonderful job. I highly recommend >it. I and my clients use it everyday. > >http://www.fckeditor.net/ > >Russell > - Original Message - > From: Rick Root > To: CF-Talk > Sent: Monday, October 04, 2004 11:22 AM > Subject: Re: User to upload to their site > > Rodger wrote: > > > I have a client that wants to be able to copy formatted text from a web >site > > (presumably with permission), > > and paste it into a text box or something easy to use so that he can >update > > his current news page. > > He can barely do cut and paste, so putting in HTML codes would be too >much > > for him. > > check out fckeditor ... you can paste from word docs and such and it'll > format to HTML and even clean up the nasty html that word generates. > > - Rick > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Strange problem.
When all else fails, RTFM! It is COOKIE.CFAUTHORIZATION_[application name] Not COOKIE.CFAUTHORIZATION_[web site name] As I thought earlier, so once I corrected the application name to not use any illegal characters, such as "-", all was well. Ian "The string "COOKIE.CFAUTHORIZATION_dev-infoweb" is not a valid ColdFusion variable name." [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Text driver for MX?
> We've got some old user-administered text > databases. Pipe- and comma-delimited and such. We're > upgrading from 4.0 to MX on this box, and I can't figure out > how to keep the datasources intact for these users. We'd > previously use the Intersolv/FoxPro drivers to talk to flat > text files, but there doesn't seem to be an equivalent for MX. > Does anyone have any suggestions or insight? If you have existing ODBC drivers for text files, you can use them, and select "ODBC Socket" within CFMX when creating your CFMX datasource. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: User to upload to their site
yeah it really is plus setup is a snap i just take their folder, rip all the examples out and toss it in the sites root, then whenever i need it i just thow in the code below and presto granted this code will add it too all textareas on page, which is usually what i want