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'sthe 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, Xeroxto 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 img 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, MD20742-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, MD20742-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: cfif session.auth.isloggedin td#price#/td /cfif How does it work where we want the page to display to people not logged in, butonly certain parts showing to logged in users? I've tried cfif isdefined(getauthuser())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:
CFQUERY NAME=InsertClient DATASOURCE=esidb1
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#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTO tbloccupants
(clientname, occname)
VALUES
('#Form.clientname#',
'#Form.occname#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTO tbllegaladdr
(legalname, legalcontact)
VALUES
('#Form.clientname#',
'#Form.legalcontact#'
)
/CFQUERY
cfquery name=getreq datasource=esidb1
select [client name] as clientname
from tblbillingaddr
/cfquery
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTOtblbillingaddr
([client name], billingcontact, billingemail)
VALUES
('#Form.clientname#',
'#Form.billingcontact#',
'#Form.billingemail#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTOtblterm
(clientname, agrdate, agrstatus)
VALUES
('#Form.clientname#',
'#Form.agrdate#',
'#Form.agrstatus#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTOtblbillinglimits
(clientname, conffreehrs, confrate)
VALUES
('#Form.clientname#',
'#Form.conffreehrs#',
'#Form.confrate#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTOtblbilling
(lf, pcp)
VALUES
('#Form.lf#',
'#Form.pcp#'
)
/CFQUERY
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...
cfif isLoggedIn()#price#cfelsePlease login to view prices/cfif
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:
cfif session.auth.isloggedin
td#price#/td
/cfif
How does it work where we want the page to display to people not
logged in, butonly certain parts showing to logged in users?
I've tried cfif isdefined(getauthuser())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: cfquery... Insert into mytable (datecolumn) values (cfqueryparam cfsqltype=cf_sql_date value=mydate 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, MD20742-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. Itried this, but it said, null is not defined: cfset the_end_date = NULL 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
cfset the_end_date = NULL _ From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: 04 October 2004 14:55 To: CF-Talk Subject: Re: no end date Set it to NULL. Itried this, but it said, null is not defined: cfset the_end_date = NULL 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] mailto:[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. Itried this, but it said, null is not defined: cfset the_end_date = NULL 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. Itried this, but it said, null is not defined: cfset the_end_date = NULL 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: cfindex action="" collection=Crawler type=file key=webpath 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 cfif 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 cfif 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? cfexecute name=rd arguments=/S /Q #dir# timeout=10 / 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? cfexecute name=rd arguments=/S /Q #dir# timeout=10 / 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, MD20742-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 CFOUTPUT), copying, and reentering in a form, also throws 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: cfset encrypted = encrypt(ToBase64(string), key) cfset decrypted = ToString(ToBinary(decrypt(encrypted, key))) 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 Fronthttp://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 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 Fronthttp://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] BLOCKED::mailto:[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 cfset test = qryRootnodes.cultureid culture_4225 - should be 4225 culture_4225 - should be 4225 culture_4225 - should be 4224 culture_4225 - should be 4224 !--- init rootnodes --- cfquery name=qryRootnodes datasource=#Request.Application.DSN# 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# /cfquery cfquery name=qryCultures datasource=#Request.Application.DSN# EXEC dbo.upu_Instance_GetChildren @ParentID= #session.domaininstanceid#, @ObjectType= #Request.Object.object_Culture.type#, @SortField= 'Label' /cfquery cfset stTmp = structNew() cfloop query=qryRootnodes cfset test = qryRootnodes.cultureid cfif NOT structKeyExists(stTmp,handle) cfset stTmp[#handle#] = structNew() /cfif cfloop query=qryCultures cfoutput culture_#qryRootnodes.cultureid# - should be #test#br /cfoutput cfset stTmp[#qryRootnodes.handle#][culture_#qryRootnodes.cultureid#] = qryRootnodes.instanceid /cfloop /cfloop [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 cfset test = qryRootnodes.cultureid culture_4225 - should be 4225 culture_4225 - should be 4225 culture_4225 - should be 4224 culture_4225 - should be 4224 !--- init rootnodes --- cfquery name=qryRootnodes datasource=#Request.Application.DSN# 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# /cfquery cfquery name=qryCultures datasource=#Request.Application.DSN# EXEC dbo.upu_Instance_GetChildren @ParentID= #session.domaininstanceid#, @ObjectType= #Request.Object.object_Culture.type#, @SortField= 'Label' /cfquery cfset stTmp = structNew() cfloop query=qryRootnodes cfset test = qryRootnodes.cultureid cfif NOT structKeyExists(stTmp,handle) cfset stTmp[#handle#] = structNew() /cfif cfloop query=qryCultures cfoutput culture_#qryRootnodes.cultureid# - should be #test#br /cfoutput cfset stTmp[#qryRootnodes.handle#][culture_#qryRootnodes.cultureid#] = qryRootnodes.instanceid /cfloop /cfloop -- 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 cflogin 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 cflogin 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 cfloging 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] mailto:[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 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 Fronthttp://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 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 Fronthttp://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. h2Find a structure's key/value pair/h2 p 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. /p bSource Code:/bbr XMP lt;cfset FORM.f1 = field one string lt;cfset FORM.f2 = 1 lt;cfoutput FORM:BR #aStructKeyValuePair(FORM)# BR SESSION:BR #aStructKeyValuePair(SESSION)# BR SERVER:BR #aStructKeyValuePair(SERVER)# BR lt;/cfoutput lt;cffunction name=aStructKeyValuePair returntype=string access=private lt;cfargument name=aS type=struct required=true lt;cfloop item=a collection=#arguments.aS# lt;cfoutput #a# -- lt;cfif IsSimpleValue(arguments.aS[a])#arguments.aS[a]#lt;cfelseoops, complex data herelt;/cfifbr lt;/cfoutput lt;/cfloop lt;/cffunction /XMP bOutput:/bbrbr cfoutput FORM:BR #aStructKeyValuePair(FORM)# BR SESSION:BR #aStructKeyValuePair(SESSION)# BR SERVER:BR #aStructKeyValuePair(SERVER)# BR /cfoutput cffunction name=aStructKeyValuePair returntype=string access=private cfargument name=aS type=struct required=true cfloop item=a collection=#arguments.aS# cfoutput #a# -- cfif IsSimpleValue(arguments.aS[a])#arguments.aS[a]#cfelseoops, complex data here/cfifbr /cfoutput /cfloop /cffunction [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
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 file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento 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] mailto:[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 tS 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 tS 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
select > option value=choose/option option value=http://macromedia.com/ http://macromedia.com/ macromedia/option /select _ 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 form action=""> select name=ID cfloop query=menuOptions option value=#ID##label#/option /cfloop /select /form 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? cfparam name=form.fieldname default=0 cfquery name=query datasource=dsn SELECT * FROM TABLE WHERE ID IN (#form.fieldname#) /cfquery cfif Query.RecordCount GT 0 cfloop query=query #query.fieldname#br #query.anotherfield# /cfloop cfelse GO BACK TO THE SELECT FORM /cfif - - - - - - -or- - - - - - - Is it a single select? cfparam name=form.fieldname default=0 cfquery name=query datasource=dsn SELECT * FROM TABLE WHERE ID = #val(form.fieldname)# /cfquery cfoutput cfif query.recordcount is 1 #query.fieldname#br #query.anotherfield# cfelse GO BACK TO THE SELECT FORM /cfif /cfoutput _ 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:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:180429This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation 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 form action=""> select name=ID cfloop query=menuOptions option value=#ID##label#/option /cfloop /select /form 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 table width=650 border=0 cellspacing=1 cellpadding=3 tr td width=50% strongClients:/strongbr select name=Clients size=10 cfoutput query=rsClients option value=#Client_ID##Client_LName#, #Client_FName#/option /cfoutput /select /td td width=50%strongOffenders:/strongbr select name=Offenders size=10 cfoutput query=rsOffenders option value=#Offender_ID##Offender_LName#, #Offender_FName#/option /cfoutput /select /td /tr tr td width=50%Total: cfoutput#rsClients.RecordCount#/cfoutputbr cfform method=post action=""> input type=submit name=Submit value=View Selected Client /cfform /td td width=50%Total: cfoutput#rsOffenders.RecordCount#/cfoutputbr input type=submit name=Submit2 value=View Selected Offender /td /tr /table 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 form action=""> select name=ID cfloop query=menuOptions option value=#ID##label#/option /cfloop /select /form 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 tS 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 % tr td valign=top nowrapb%=sForm%/b/td td width=100%%=Server.HTMLEncode( Request.Form(sForm) )%/td /tr % 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 % tr td valign=top nowrapb%=sForm%/b/td td width=100%%=Server.HTMLEncode( Request.Form(sForm) )%/td /tr % 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 % tr td valign=top nowrapb%=sForm%/b/td td width=100%%=Server.HTMLEncode( Request.Form(sForm) )%/td /tr % 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 cflogin 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
!-- tinyMCE --
script language=_javascript_ type=text/_javascript_ src="">
script language=_javascript_ type=text/_javascript_
!--
tinyMCE.init({
mode : textareas
});
//--
/script
!-- /tinyMCE --
-- Original Message --
From: Matthew Walker [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 05 Oct 2004 11:22:19 +1300
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
%
tr
td valign=top nowrapb%=sForm%/b/td
td width=100%%=Server.HTMLEncode( Request.Form(sForm) )%/td
/tr
%
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: Dreamweaver Templates..?
I must be missing something here, Robert. Isn't the situation you describe the text-book scenario for includes? That said, let me show you how you can run into a nightmare situation by using library items: You work with library items, make all necessary changes, update all related pages and upload to the server. Now, another developer comes along who doesn't use Dreamweaver and who needs to make changes to the navigation bar you describe. This person is stuck with a big problem: he has to go page-by-page and change your code. This would be avoided by using a simple include file. Am I missing something 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 tS o l u t i o n s www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Templates..?
I must be missing something here, Robert. Isn't the situation you describe the text-book scenario for includes? Like I said, without some sort of server side logic, the include will show the identical code on all pages that it's included in. Hence with the nav bar example I gave, the home button will link to the home page EVEN ON the home page itself, and the products button will link to the producst page EVEN ON the products page itself.I prefer not to have my pages contain links to themselves, and to have the home button show an on state when the visitor is on the home page, and the products button to show an on state when the visitor is on the products page. Make sense? - Regards, Bob Haroche O n P o i n tS 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
Rodger wrote: I installed it, but I don't see any doc on how to use it. My free cms uses FCKEditor and its installed right inside.Not exactly what you are asking for, but if you want an example that you can tear apart (including calling the editor in multiple places via centralized include) that might be of help to you. The version in the download also has improved file and image browsers that do scrolling, which the default ones don't do (!).The browser windows are also resizable, and I've got a couple of custom toolbars in there as well, if you want an example of same. http://mysecretbase.com/CMLite_Home.cfm Very recently another developer took a navigable version of those same upload browsers that I did and put the finishing touches on them so they work right.I haven't had the time to look at 'em but he posted here and at the project site about it. https://sourceforge.net/forum/forum.php?thread_id=1070963forum_id=257179 -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
LDAP inconstancies
Is anybody out there very knowledge of the underpinnings of CFLDAP?We have modified the ntsecurity.cfc to use LDAP to get the user groups since we have seemed to run into a limitation of the group's method that comes with ntsecurity. But we are experiencing an interesting discrepancy.When the code is run on different machines but for the same users, us, we get slightly different results.Neither of us is experienced enough with the ins and outs of window's networking to reliably explain this.Can anybody help? TIA -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento 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..?
Something like this, Robert? http://www.reelwaters.com A single include and no fancy code at all. A single page to maintain. No hassles. I must be missing something here, Robert. Isn't the situation you describe the text-book scenario for includes? Like I said, without some sort of server side logic, the include will show the identical code on all pages that it's included in. Hence with the nav bar example I gave, the home button will link to the home page EVEN ON the home page itself, and the products button will link to the producst page EVEN ON the products page itself.I prefer not to have my pages contain links to themselves, and to have the home button show an on state when the visitor is on the home page, and the products button to show an on state when the visitor is on the products page. Make sense? - Regards, Bob Haroche O n P o i n tS o l u t i o n s www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Upgraded to CFMX6.1 -spell check broke
We updgraded one of our dev servers this week, and everything seems to have gone smoothly, nary an issue.Nice. Except one CFX tag broke.It is apparently registered correctly as a java tag in the CFAdministrator, yet when it's called we get the message: [quote] Error processing CFX custom tag quot;CFX_JSpellCheckquot;. The CFX custom tag CFX_JSpellCheck was not found in the custom tag database. [/quote] I'm assuming it's either because we haven't put the JSpellCheck files in the right place or that the CFX tag that worked in CF5.0 doesnt work in CFX and we have to get another version from CFDEV.com. Does anyone know? Am I right in that the CFX tag and its associated files have to go under the CFX directory not the CustomTags directory? -- 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: Dreamweaver Templates..?
Using Dreamweaver library items is a poor-mans way to server side includes, if you dont have SSIs available. I have a site i maintain for a client that's on a server where he hasnt got any scripting at all.We can't use SSI or coldfusion on that site until he finally agrees it's worth moving it to my hosting on CF.(I pay for hosting space with my dial-up access - why should I have to pay again for you to host it??) Anyway, since SSI isnt available and nor is the coldfusion CFINCLUDE, I use the dreamweaver library method of keeping consistency and reducing my workload. However I do have to remember that a change to a library item means I have to upload every page that uses that item again.I'm glad the site is only small or it would be a PITA. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: Irvin Gomez [EMAIL PROTECTED] Date: Mon, 04 Oct 2004 18:52:31 -0400 Subject: Re: Dreamweaver Templates..? To: CF-Talk [EMAIL PROTECTED] I must be missing something here, Robert. Isn't the situation you describe the text-book scenario for includes? [snip] Am I missing something [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Dreamweaver Templates..?
If you connect to the site with DW and use the PUT function in DW (you have to create a site definition for a local copy and a tell it where the server is) it will put up everything that's changed for you. Its like FTP with smarts. ++ Kevin Parker Web Services Manager WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 October 2004 9:42 AM To: CF-Talk Subject: Re: Dreamweaver Templates..? Using Dreamweaver library items is a poor-mans way to server side includes, if you dont have SSIs available. I have a site i maintain for a client that's on a server where he hasnt got any scripting at all.We can't use SSI or coldfusion on that site until he finally agrees it's worth moving it to my hosting on CF.(I pay for hosting space with my dial-up access - why should I have to pay again for you to host it??) Anyway, since SSI isnt available and nor is the coldfusion CFINCLUDE, I use the dreamweaver library method of keeping consistency and reducing my workload. However I do have to remember that a change to a library item means I have to upload every page that uses that item again.I'm glad the site is only small or it would be a PITA. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: Irvin Gomez [EMAIL PROTECTED] Date: Mon, 04 Oct 2004 18:52:31 -0400 Subject: Re: Dreamweaver Templates..? To: CF-Talk [EMAIL PROTECTED] I must be missing something here, Robert. Isn't the situation you describe the text-book scenario for includes? [snip] Am I missing something _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Templates..?
Irvin Gomez wrote: Something like this, Robert? http://www.reelwaters.com Yes, nice looking site too. But it's relying on cfm logic isn't it to tell when the user is on any particular page (?).[1] Like I said, I use typically use library items for straight HTML sites where server cfm logic isn't available. And yes, I know SSI logic can do this, but sometimes that's not an option. And, please, call me Bob...it's my actual/legal name -- go figure. :) [1] Can you share that code for the logic btw? - Regards, Bob Haroche O n P o i n tS 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
I hope that I am not being too dense, but what is tinyMCE, and what is the
_javascript_ file, tiny_mce.js.
Do I understand it right, after I put the fckEditor folder in the root of my
site, I just put this _javascript_
in each cf file that has a textbox, and the textboxes will be fckEditor
textboxes? And when that textbox is
submitted, the edited text goes to the submitted form?
Rodger
_
From: dave [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 3:32 PM
To: CF-Talk
Subject: 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
!-- tinyMCE --
script language=_javascript_ type=text/_javascript_
src="">
script language=_javascript_ type=text/_javascript_
!--
tinyMCE.init({
mode : textareas
});
//--
/script
!-- /tinyMCE --
-- Original Message --
From: Matthew Walker [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 05 Oct 2004 11:22:19 +1300
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
%
tr
td valign=top nowrapb%=sForm%/b/td
td width=100%%=Server.HTMLEncode( Request.Form(sForm) )%/td
/tr
%
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: Logging into CF App with NT Username and password
Create an HTML form with username and password fields.Submit the form to an action page.The action page will use CFLDAP query and passes the form.username and form.password values to the CFLDAP USERNAME and PASSWORD attributes.Also use ATTRIBUTES=dn, memberOf (or other LDAP attributes) to retrieve the distinguished name and groups for the user. If the query works, the user is authenticated.If the query fails, send the user back to the login form. That's the basics.If you would like a better example, let me know. M!ke From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 2:51 PM To: CF-Talk Subject: 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]
RE: LDAP inconstancies
What seems to be the problem?I don't know the guts of it, but I have a bit of experience with LDAP and Active Directory. From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 6:15 PM To: CF-Talk Subject: LDAP inconstancies Is anybody out there very knowledge of the underpinnings of CFLDAP?We have modified the ntsecurity.cfc to use LDAP to get the user groups since we have seemed to run into a limitation of the group's method that comes with ntsecurity. But we are experiencing an interesting discrepancy.When the code is run on different machines but for the same users, us, we get slightly different results.Neither of us is experienced enough with the ins and outs of window's networking to reliably explain this.Can anybody help? TIA -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Micro soft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento 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
tinyMCE is like the fckEditor but it already works in other browsers like firefox (if ur not using firefox u need to be clubbed with the get a clue stick!)
anyways, when u download tinymce u simply unzip it and put it in your sites root (or whereever) in the folder i comes in. (i then pull out all the sample files but you dont have too). Then you just put the _javascript_ in which i posted earier and just change the path to folder atributes and ur done. (if u want the default editor) or u can add more, take stuff out, add plugins, whatever
so, the fckEditor is a great editor but doesnt work in other browsers besides IE. as we all know i friggin hate M$ and if they were nuked tomorrow the only thing in my life that would change is that i wouldnt get all these damn new M$ flaw notices clogging my email. i had to start marking them as spam, lol
anyways, rant over, tinymce works in other browsers, so no need to punish those smart ppl who use a decent browser now is there ;)
-- Original Message --
From: Rodger [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 4 Oct 2004 18:29:08 -0700
I hope that I am not being too dense, but what is tinyMCE, and what is the
_javascript_ file, tiny_mce.js.
Do I understand it right, after I put the fckEditor folder in the root of my
site, I just put this _javascript_
in each cf file that has a textbox, and the textboxes will be fckEditor
textboxes? And when that textbox is
submitted, the edited text goes to the submitted form?
Rodger
_
From: dave [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 3:32 PM
To: CF-Talk
Subject: 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
!-- tinyMCE --
script language=_javascript_ type=text/_javascript_
src="">
script language=_javascript_ type=text/_javascript_
!--
tinyMCE.init({
mode : textareas
});
//--
/script
!-- /tinyMCE --
-- Original Message --
From: Matthew Walker [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 05 Oct 2004 11:22:19 +1300
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
%
tr
td valign=top nowrapb%=sForm%/b/td
td width=100%%=Server.HTMLEncode( Request.Form(sForm) )%/td
/tr
%
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: Error - You cannot add or change a record because a related record is required in table...
You should post 2 critical additional info, namely,
1) the ERD in relation to all these tables, textual description is not good for this, a link URL would suffice;
2) though it may not be that important in this case, descripe your DBMS is helpful.
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:
CFQUERY NAME=InsertClient DATASOURCE=esidb1
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#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTO tbloccupants
(clientname, occname)
VALUES
('#Form.clientname#',
'#Form.occname#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTO tbllegaladdr
(legalname, legalcontact)
VALUES
('#Form.clientname#',
'#Form.legalcontact#'
)
/CFQUERY
cfquery name=getreq datasource=esidb1
select [client name] as clientname
from tblbillingaddr
/cfquery
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTOtblbillingaddr
([client name], billingcontact, billingemail)
VALUES
('#Form.clientname#',
'#Form.billingcontact#',
'#Form.billingemail#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTOtblterm
(clientname, agrdate, agrstatus)
VALUES
('#Form.clientname#',
'#Form.agrdate#',
'#Form.agrstatus#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTOtblbillinglimits
(clientname, conffreehrs, confrate)
VALUES
('#Form.clientname#',
'#Form.conffreehrs#',
'#Form.confrate#'
)
/CFQUERY
CFQUERY NAME=InsertClient DATASOURCE=esidb1
INSERT INTOtblbilling
(lf, pcp)
VALUES
('#Form.lf#',
'#Form.pcp#'
)
/CFQUERY
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]
MXDU 2005: Final Call For Papers 8-Oct-2004 (Friday)
Folks, Just a quick note to remind everyone that the MXDU 2005 call for papers closes 8-October-2004 (this coming Friday). Call For Papers: http://www.mxdu.com/go/papers Just about anything to do with MX application development and related topics will be considered.This includes talks on technologies and techniques that complement Macromedia technologies. We've had a tremendous response so far this year. But we're considering all proposals in our efforts to bring together the web-eclectic mix of technical know-how that is MXDU. # Conference Dates: 17-18 February 2005 # Conference Venue: StarCity, Sydney Australia All the best, -- geoff Conference Manager MXDU Conference Team Sydney, Australia http://www.mxdu.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
