Help with a SQL View?

2009-06-25 Thread Les Mizzell
I'm having a little trouble setting up a SQL Server VIEW to cut down on the amount of work CFQuery has to do. I need to pull in a number of tables for a newsletter system nl_master (master table containing newsletter title and such) nl_hed (a list of headers connected by the newsletter id "nl_id

Re: cf8 help with japanese characters

2009-06-12 Thread Paul Hastings
Paul Kukiel wrote: > It means I can insert all languages be it Japanese, Chinese, French > or any Indian dialect. uh, you *really* need to read jochem's blog post. the fact that his blog is called "it be bunnies" should be reason enough ;-) but seriously, read it.

Re: cf8 help with japanese characters

2009-06-12 Thread James Holmes
2009/6/13 Paul Kukiel : > > On 12/06/2009, at 11:34 AM, Paul Hastings wrote: >> >> >>> As fro MS SQL 2008 I have had no issues inserting all types of >>> languages. >> >> what does that mean? > > It means I can insert all languages be it Japanese, Chinese, French > or any Indian dialect. > > If yo

Re: cf8 help with japanese characters

2009-06-12 Thread Paul Kukiel
On 12/06/2009, at 11:34 AM, Paul Hastings wrote: > > >> As fro MS SQL 2008 I have had no issues inserting all types of >> languages. > > what does that mean? It means I can insert all languages be it Japanese, Chinese, French or any Indian dialect. If your having issues feel free to ping me of

Re: cf8 help with japanese characters

2009-06-12 Thread Paul Hastings
Paul Kukiel wrote: > Well dealing with non English char set's you should always be using > Actually there is really no excuse for not ever > using it. except of course when you can't or shouldn't. > As fro MS SQL 2008 I have had no issues inserting all types of > languages. what does th

Re: cf8 help with japanese characters

2009-06-11 Thread Paul Kukiel
Well dealing with non English char set's you should always be using Actually there is really no excuse for not ever using it. As fro MS SQL 2008 I have had no issues inserting all types of languages. Paul. On 11/06/2009, at 12:58 PM, Paul Hastings wrote: > > Paul Kukiel wrote: >> And w

Re: cf8 help with japanese characters

2009-06-11 Thread Paul Hastings
Paul Kukiel wrote: > And who isnt using that ;) oh wait, you might not know about the encoding mismatch issuejochem has an excellent explanation here: http://jochem.vandieten.net/2008/03/22/ms-sql-server-and-the-coldfusion-string-format-setting/

Re: cf8 help with japanese characters

2009-06-11 Thread Paul Hastings
Paul Kukiel wrote: > And who isnt using that ;) well lots of people but i wanted to point out that option didn't do anything outside of that tag. the description on the admin page implies so much more. ~| Want to reach the Cold

Re: cf8 help with japanese characters

2009-06-11 Thread Paul Kukiel
And who isnt using that ;) On Thu, Jun 11, 2009 at 11:51 AM, Paul Hastings wrote: > > Paul Kukiel wrote: >> String Format      -- Enable High ASCII characters and Unicode for >> data sources configured for non-Latin characters > > useful only for cfqueryparam. > > ~~

Re: cf8 help with japanese characters

2009-06-11 Thread Paul Hastings
Paul Kukiel wrote: > String Format -- Enable High ASCII characters and Unicode for > data sources configured for non-Latin characters useful only for cfqueryparam. ~| Want to reach the ColdFusion community with something th

Re: cf8 help with japanese characters

2009-06-11 Thread Paul Kukiel
se to try. > > I don't know if this matters but my computer has an english version of > Windows Vista .  I've set my region to Japan.  I've even set my IE browser > language to Japanese. > > If I can't get the Japanese characters into the database

Re: (ot) Little help with IIS URL Rewrite..

2009-06-10 Thread Les Mizzell
Peter Boughton wrote: > It's failing because it's expecting > http://mysite-test.myhost.net/net/wagon/red/small Finally got it to work: ^([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ Now if I've got my head around this correctly, and the logic flow I've already charted out is correct

Re: cf8 help with japanese characters

2009-06-10 Thread Jide Aliu
>Collation's not the problem, but the Data Type of your columns might be. >Make sure you're using nvarchar & ntext (not varchar and text) [SQL Server] >and ensure that both page and form encoding allow Unicode, like using >charset UTF-8. I'll +1 that, the data type is almost always the main c

Re: cf8 help with japanese characters

2009-06-10 Thread Shannon Peevey
lus, this link on UNICODE from the European Commission Information Provider's Guide, which discusses Coldfusion and encoding: http://ec.europa.eu/ipg/standards/other/standard_unicode_en.htm My blog entries on handling characters with diacritics may, or may not, be of any help: http://speeves.

Re: cf8 help with japanese characters

2009-06-10 Thread Jason Fisher
Collation's not the problem, but the Data Type of your columns might be. Make sure you're using nvarchar & ntext (not varchar and text) [SQL Server] and ensure that both page and form encoding allow Unicode, like using charset UTF-8.

Re: cf8 help with japanese characters

2009-06-10 Thread Paul Hastings
mike pop wrote: > using cf8 and either mysql server or microsoft sql server 2008 express (both > give me the same result), i am attempting to insert/update records containing > japanese text. and how are the columns holding the text defined? what db driver are you using? > the japanese text does

cf8 help with japanese characters

2009-06-10 Thread mike pop
nese characters into the database, I am totally screwed. I hope somebody knows how to fix this problem. It is probably very simple but I am overlooking the obvious. Please help ~| Want to reach the ColdFusion community wit

Re: (ot) Little help with IIS URL Rewrite..

2009-06-10 Thread Peter Boughton
It's failing because it's expecting http://mysite-test.myhost.net/net/wagon/red/small Start the expression with just ^/ instead of having net in there. ~| Want to reach the ColdFusion community with something they want? Let th

Re: (ot) Little help with IIS URL Rewrite..

2009-06-09 Thread Les Mizzell
> Try this: > ^com/([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ Hmmm I can get the rule to work like this: ^testpage/([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ So this URL will work: http://mysite-test.myhost.net/testpage/wagon/red/small But, I think the way the serve

Re: (ot) Little help with IIS URL Rewrite..

2009-06-09 Thread Peter Boughton
Try this: ^com/([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ It uses non-capturing groups and the optional quantifier to allow but not require the final two parts. And of course the less restrictive one is the same: ^com/([^/]+)(?:/([^/]+)(?:/([^/]+))?)?/?$

(ot) Little help with IIS URL Rewrite..

2009-06-09 Thread Les Mizzell
I'm trying to see if there's a way to basically set up one rule to run the site... So, I'm looking at URLs like: www.mysite.com/wagons/red/small Below works: Rule: ^com/([_0-9a-z-]+)/([_0-9a-z-]+)/([_0-9a-z-]+) ...or, a little more open ended: ^([^/]+)/([^/]+)/([^/]+)/?$ Map either to and i

RE: Need Regex help for finding and Hyperlinks words in String

2009-06-05 Thread Andy Matthews
Great. Glad to help. I def recommend you learn at least the basics of Regex. It's helpful in a wide range of applications. andy -Original Message- From: Mike Francisco [mailto:cfmike...@gmail.com] Sent: Friday, June 05, 2009 2:53 PM To: cf-talk Subject: RE: Need Regex help for fi

RE: Need Regex help for finding and Hyperlinks words in String

2009-06-05 Thread Mike Francisco
To: cf-talk > Subject: RE: Need Regex help for finding and Hyperlinks words in String > > > Mike... > > > > '@([[:alnum:]]+)', '@\1', 'ALL')> > > > > Just curious...how far did you get in your own testing? > > > a

RE: Need Regex help for finding and Hyperlinks words in String

2009-06-05 Thread Andy Matthews
Mike... @\1', 'ALL')> Just curious...how far did you get in your own testing? andy -Original Message- From: Mike Francisco [mailto:cfmike...@gmail.com] Sent: Friday, June 05, 2009 1:46 PM To: cf-talk Subject: Need Regex help for finding and Hyperlinks words

Need Regex help for finding and Hyperlinks words in String

2009-06-05 Thread Mike Francisco
Happy Friday everyone. I was hoping if anyone can help me with regex and a UDF. I have a string/paragraph which contains words beginning with a specific character. I'd like to find all those words and then assign a hyperlink URL to them. Example: If the string is: Lorem ipsum dolo

Re: Help ColdFusion Output URGENT

2009-06-01 Thread erik tom
Thanks. But what what you suggesting is not working. I need to display. 1 area manager on one line and get all the calculation on one line >You could do it better with aggregate functions, but this will work, too. >Just make the completionDate lookup part of your base query (note the LEFT >OU

RE: Help ColdFusion Output URGENT

2009-06-01 Thread Adrian Lynch
Come on dude, you've been told before, help us by asking better questions! What doesn't work? Format your code so it's easy for us to see what's going on, I can't be bothered to look through your code because it's all over the place. If the query is correct and

re: Help ColdFusion Output URGENT

2009-06-01 Thread Jason Fisher
You could do it better with aggregate functions, but this will work, too. Just make the completionDate lookup part of your base query (note the LEFT OUTER JOIN), and then use the GROUP attribute of the CFOUTPUT tag to do the looping for you in one go: Select distinct e.employeeid,

Help ColdFusion Output URGENT

2009-06-01 Thread erik tom
I have a query which list all the Team members, their Area MANagers, Region Managers, Locations and so on . What i need to do is to display each managers(name) column2: total number of people in their area column3: and total number of people completed the course in the area I came up with code

Re: Need help with dynamic form fields

2009-05-31 Thread Peter Boughton
Please post the actual HTML you're working with - otherwise any answers can only be making assumptions, which may just cause further confusion. ~| Want to reach the ColdFusion community with something they want? Let them know

Re: Need help with dynamic form fields

2009-05-30 Thread David McGuigan
A really easy way would be to just store it in a variable like so: userID = #url.idUser#; and then in your form validation just do: document.getElementById( 'compensationType_' + userID ) to get a reference to the form control itself, and read and manipulate the value as you please. If yo

Re: Need help with dynamic form fields

2009-05-30 Thread Don L
If memory serves, loop over the whole form set e = eachFormElement // just the idea then use the substring method, something like if e.substring(0,16) == "compensationType" alert (e.value); something like that. >hello > >I have an issue that I am stuck on. > >I need to check the value of dynamic

Re: Need help with dynamic form fields

2009-05-30 Thread Ryan Letulle
Not sure of what you are trying to do, but I usually use getelementbyid when I need to work with form fields. Very straightforward and lots of examples, just Google. w3schools etc -- Ryan On Sat, May 30, 2009 at 8:02 PM, Torrent Girl wrote: > > hello > > I have an issue that I am stuck on.

Need help with dynamic form fields

2009-05-30 Thread Torrent Girl
hello I have an issue that I am stuck on. I need to check the value of dynamic form fields with javascript and don't know how. Here is what the form fields look like: compensationType_userID (this is the field name) The userID will be the dynamic part. How do I check for the value in javasc

Re: Regex help...

2009-05-29 Thread Peter Boughton
> I'm trying to use REFind to get all of the anchor/href tags but I'm > coming up short. RegEx is not necessarily the ideal tool for this - try a DOM Parser. If you've got consistent/controlled input you can use regex, and here's a Java one that will work in most situations: ]+?\shref\s*+=\s

Re: Regex help...

2009-05-29 Thread Tom Chiverton
On Friday 29 May 2009, Tom Jones wrote: > If I use the following regular expression in a script it works fine, I just > dont know with CF, I have not used much RE in CF yet. http://txt2re.com/ -- Helping to globally grow world-class 24/7 unique partnerships as part of the IT team of the year,

RE: Regex help...

2009-05-29 Thread Che Vilnonis
Tom, you could try this... http://www.somedomain.com"; method="GET" result="theData"> ]*[^/]?)>", trim(theData.fileContent))> -Original Message- From: Tom Jones [mailto:tjo...@acworld.com] Sent: Friday, May 29, 2009 11:03 AM To: cf-talk Subjec

Re: Regex help...

2009-05-29 Thread Claude Schneegans
Hi, For this type of parsing, you should have a look at CF_REextract: http://customtags.internetique.com/REextract/testREextract.cfm ~| Want to reach the ColdFusion community with something they want? Let them know on the House

Regex help...

2009-05-29 Thread Tom Jones
Hello, I'm trying to use cfhttp to download and parse a directory listing from one of my sites. I can download the page but the parsing is a whole different story :-). I'm trying to use REFind to get all of the anchor/href tags but I'm coming up short. If I use the following regular expressio

Re: (ot) Little help with Ionic IsapiRewrite

2009-05-28 Thread Barney Boisvert
So what's the actual problem? Don't know if this is it, but it looks like you're missing a slash after the caret in your RewriteRule. Should be ^/att... not ^att... On Thu, May 28, 2009 at 5:24 PM, Les Mizzell wrote: > > Trying to get Ionic IsapRewrite working locally so I can develop locally

(ot) Little help with Ionic IsapiRewrite

2009-05-28 Thread Les Mizzell
Trying to get Ionic IsapRewrite working locally so I can develop locally without having to put every freaking thing out to the server... Running: XP Pro IIS 5.1 Stuff is set up thusly: 1. Since IIS 5.1 only allows one site, I've got my "default" site as the main wwwroot directory with everythi

Re: OT (maybe): Display additional info from a Select before Form is Submitted - little help needed

2009-05-14 Thread Gerald Guido
Try setting the bindOnLoad to false wrote: > > Almost working correctly. > > When the page first loads, I get an alert: > "The GROUPS_ID argument passed to the get is not of type numeric" > > If I dismiss the alert, then the page functions normally after that and > the correct description shows

Re: OT (maybe): Display additional info from a Select before Form is Submitted - little help needed

2009-05-14 Thread Les Mizzell
Almost working correctly. When the page first loads, I get an alert: "The GROUPS_ID argument passed to the get is not of type numeric" If I dismiss the alert, then the page functions normally after that and the correct description shows up depending on what you select in "sendGROUP". Ideas? H

Re: Help With Regular Expressions

2009-05-13 Thread Robert Nurse
I ended up using Replace to change ../geos/displayCountryData.cfm?countryCode=AS to ../geos/AS. Then I used REMatch("../geos/[A-Z]{2}",...) to find all occurrences of this resulting pattern. I then processed each match in the array REMatch returned with Replace(DBText, REMatchArrayEntry, REM

RE: Help With Regular Expressions

2009-05-12 Thread Andy Matthews
end of the link? If everything else is the same, and you just need the last two characters of a link: -Original Message- From: Robert Nurse [mailto:rnu...@gmail.com] Sent: Tuesday, May 12, 2009 11:20 AM To: cf-talk Subject: Help With Regular Expressions Hi All, I'm trying to fi

Re: Help With Regular Expressions

2009-05-12 Thread Barney Boisvert
This is untested, but should be close. REReplace(string, "[a-zA-Z0-9_-]+\.cfm\?code=([A-Z]{2})", "\1.html", "all") find zero or more a-zA-Z0-9_-, then ".cfm?code=", then any two A-Z and replace the whole thing with thos upper case letters plus ".html". If "someCFMFile.cfm" is static, you can re

Help With Regular Expressions

2009-05-12 Thread Robert Nurse
Hi All, I'm trying to find a way of using regular expressions to locate and replace text. My application reads in some text containing links from a DB: e.g. ../folderName/someCFMFile.cfm?code=AB. I want to change all occurrences of this to ../folderName/AB.html. Note that "code" can be any

RE: Need some WSDL Help

2009-04-28 Thread Mark Kruger
Give me the details and if I can help I will do so. If it turns out to be something that is time consuming we can talk about a maintenance contract. 1) What are the 2 end points (.NET and CF or CF and PHP etc...) 2) What is the object you are passing - an array, structure etc. Is the WSD and

RE: Need some WSDL Help

2009-04-28 Thread Adrian Lynch
Why don't you post the problem here? > -Original Message- > From: Rick Shapley [mailto:rs...@cade1.com] > Sent: 28 April 2009 18:03 > To: cf-talk > Subject: Need some WSDL Help > > > We are trying to connect some Cold Fusion Generated Data to a WSDL >

Need some WSDL Help

2009-04-28 Thread Rick Shapley
We are trying to connect some Cold Fusion Generated Data to a WSDL file. Can anyone help? Please e-mail me at rs...@cade1.com Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get

Re: help with a grey area

2009-04-17 Thread Richard White
thanks for all the replies. i agree that it is easier with this to go with the flow and stay within the guidelines that are set... after all the customer is always right.. and as it was mentioned CYA!!! thanks also for your comments roger, we will look into all these regulations too

Re: help with a grey area

2009-04-17 Thread Roger Austin
Richard White wrote: > our clients run tests on patients for research purposes. At this point, you have run into HIPAA, FDA/OECD GCP, and perhaps FISMA regulations. Oh yeah, then you have the human research subjects regulations also. You need to read these and understand them. At least, your c

Re: help with a grey area

2009-04-17 Thread Phillip Vector
The client pays you. So voice your concerns (if you fear legal issues coming from it, record yourself giving the concerns) and then do what they say. It's called CYA for a reason. :) On Fri, Apr 17, 2009 at 6:41 AM, Richard White wrote: > > hi > > our clients run tests on patients for research p

Re: help with a grey area

2009-04-17 Thread Al Musella, DPM
When it comes to something like this, the best approach is to just go along with it. It really isn't much trouble to separate out the personal information. Then, if there is ever any problem - you can say you took precautions. I do something similar and always have the personal info in a dif

Re: help with a grey area

2009-04-17 Thread Matt Quackenbush
I would suggest consulting the appropriate attorney(s). :-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive:

help with a grey area

2009-04-17 Thread Richard White
hi our clients run tests on patients for research purposes. As part of their data protection they are 'told' to not keep personal identifiers (patient first name, last name, dob etc...) in the same database as their test data. we have created a cf application that uses all cf security we kno

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
Thanks Peter I'll try these out ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.co

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
Can I add a set time to this. Like first day of the week at 12:00 AM? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
> Or better still, just go straight from the date... > > to="#parseDateTime(Now())#" step="7"> > > > ... > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Fr

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
wow that's perfect thanks! so will it increment to the next week everytime? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440

Re: Help requested - Syntax for GROUP BY with HAVING ... ommitted code

2009-03-24 Thread Brad Wood
I don't see how that SQL would work. You are using deptName in your select list and order by, but you aren't grouping by it. Unless MySQL allows you to do stuff that SQL Server doesn't, that should throw an error. Also, I had originally suggested placing the amount in the group by, but I hadn

Re: Help requested - Syntax for GROUP BY with HAVING ... ommitted code

2009-03-24 Thread BobSharp
Sorry, forgot to include the revised script ... = === OK, think I've got it now ... GROUP BY contains the main criteria for the query (not to be confused with ORDER BY) HAVING should contain any (both) conditions needed for the search. http://ttcfm.open

Re: Help requested - Syntax for GROUP BY with HAVING ...

2009-03-24 Thread BobSharp
that cover this kind of CFquery ? - Original Message - From: To: "cf-talk" Sent: Tuesday, March 24, 2009 10:19 PM Subject: RE: Help requested - Syntax for GROUP BY with HAVING ... > > Try putting a.Amount in your group by clause. Everything in your select > list s

Re: Need help with a concept

2009-03-24 Thread Peter Boughton
Or better still, just go straight from the date... ... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;20717267

RE: Help requested - Syntax for GROUP BY with HAVING ...

2009-03-24 Thread brad
let you do that, but you might be OK with MySQL. ~Brad Original Message ---- Subject: Help requested - Syntax for GROUP BY with HAVING ... From: "BobSharp" Date: Tue, March 24, 2009 4:56 pm To: cf-talk http://ttcfm.open.ac.uk/~bs3578/test1/Week9_Act6.cfm There is a pr

Re: Need help with a concept

2009-03-24 Thread Peter Boughton
Or better still, just go straight from the date... ... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;20717267

Re: Help requested - Syntax for GROUP BY with HAVING ...

2009-03-24 Thread Peter Boughton
Do this: SELECT d.DeptName AS dName, AVG(a.Amount) AS AverageAward, SUM(a.Amount) AS DeptTotal You can't select individual amounts if you're performing aggregates on that same column. Also, your SUM(a.Amount) > 5000 belongs probably needs to go in the HAVING clause. ~~~

Help requested - Syntax for GROUP BY with HAVING ...

2009-03-24 Thread BobSharp
http://ttcfm.open.ac.uk/~bs3578/test1/Week9_Act6.cfm There is a problem with this script ... any clues, or links to examples, would be appreciated. SELECT a.Amount AS aAmount, d.DeptName AS dName, AVG(a.Amount) AS AverageAward,

Re: Need help with a concept

2009-03-24 Thread John M Bliss
Something like...? #DateFormat(DateAdd("d", day, "12/31/2008"), "m/d/")# - #DateFormat(DateAdd("d", day + 6, "12/31/2008"), "m/d/")# On Tue, Mar 24, 2009 at 5:00 PM, Torrent Girl wrote: > > hi All > > I

Need help with a concept

2009-03-24 Thread Torrent Girl
hi All I need help with a CF concept that I have not been able to come up with a solution for. EX: I need to create a report which calculates the total scores for players for each play week. Each time the report is accessed it diplays calculations for the current week and all previous weeks

Re: Kludge to Clean; framework help

2009-03-23 Thread Tom Chiverton
On Friday 20 Mar 2009, Joshua O'Connor-Rose wrote: > Any ideas for a framework that can support this. Just about anything should support it, though you'll need some sort of bridge so users can log in to the old code base and the new one at the same time. If you keep all the new bits, using whate

Re: Kludge to Clean; framework help

2009-03-20 Thread s. isaac dealey
application. That should help since you can't afford to redesign your navigation or login. (I hear there's work on adding "event beans"(?) in an upcoming version of Fusebox that will allow it to work more like the onTap framework and make migrating to easier.) The framewo

Kludge to Clean; framework help

2009-03-20 Thread Joshua O'Connor-Rose
So we finally have CF8. We have been successful moving old Legacy Sites to CF8. I have a strong desire to start (well . . . continue) sneaking good code under the hood. I wondered what may be a good framework to use to accomplish two things. 1. Begin implementing a cleaner architecture 2. Reside

Re: (ot) IIS URL Rewrite help needed

2009-03-18 Thread Les Mizzell
Barney Boisvert wrote: > You need a dollar sign at the end of the regular expression. Then it > should work. ^RSVP/([_0-9a-z-]+)$ Yup, that did the trick. Thanks so much! I'm still trying to get regx down... >> So, the rule that currently works is: >> ^RSVP/([_0-9a-z-]+) ~~~

Re: (ot) IIS URL Rewrite help needed

2009-03-17 Thread Barney Boisvert
You need a dollar sign at the end of the regular expression. Then it should work. cheers, barneyb On Tue, Mar 17, 2009 at 4:08 PM, Les Mizzell wrote: > > Need a little hlep on a IIS URL Rewrite Rule: > > I've got the files: > > 1. RSVP/index.cfm - currently contains a jump menu that goes to: >

(ot) IIS URL Rewrite help needed

2009-03-17 Thread Les Mizzell
Need a little hlep on a IIS URL Rewrite Rule: I've got the files: 1. RSVP/index.cfm - currently contains a jump menu that goes to: 2. RSVP/rsvp_form.cfm?eventcode=#evntCODE# Clinet requested an IIS URL rewrite to go directly to the for in the format RSVP/#evntCODE# So, the rule that works is:

Re: php help (i know, offlist if you can... thanks!)

2009-03-10 Thread Joel Polsky
And people think CF is so out dated, and PHP is all that and a bag of chips.. Ha! Not that I have the answer, BUT I'm sure the answer to the problem would have been much easier if it was a CF application... On Tue, Mar 10, 2009 at 6:56 PM, Rastafari wrote: > > NEVERMIND :) i think i fixe

Re: php help (i know, offlist if you can... thanks!)

2009-03-10 Thread Rastafari
NEVERMIND :) i think i fixed it!! but im not sure of the security of the fix. but it works so far. ill be hardening it up if i need to... thanks! tony On Tue, Mar 10, 2009 at 6:52 PM, Rastafari wrote: > Yuliang... if you can go to this page: > http://www.morgantownpatiosunrooms.com/fileExists.p

Re: php help (i know, offlist if you can... thanks!)

2009-03-10 Thread Rastafari
Yuliang... if you can go to this page: http://www.morgantownpatiosunrooms.com/fileExists.php you will see that the file exists. the code is simple. then... the next link below... takes you to a page that has the code below in it... so, i can detect the files presence but not read it?? http://ww

Re: php help (i know, offlist if you can... thanks!)

2009-03-10 Thread Yuliang Ruan
so there is a "garagerefacing.xml" in the same directory as that php file that's running? it might also be something like a environment variable PATH or something. or the php file is not in the same directory as that XML file and there was a path variable set up before but now doesn't exist.

php help (i know, offlist if you can... thanks!)

2009-03-10 Thread Tony
with anything. forms work with php and all just perfectly. only problem is that ones created prior to me showing up do not help i feel fairly confident that its a permissions issue, but i guess i dont know how php handles that. "EVERYONE" has read access on

Re: php help (i know, offlist if you can... thanks!)

2009-03-10 Thread Tony
oday.  anyhow, ive personally > downloaded and installed coffeecup form builder, and ive > had no problem with anything.  forms work with php and all > just perfectly.  only problem is that ones created prior to me > showing up do not > > help > i feel fai

cfdocument putting part of the row on the bottom of page 1 and the other on the top of page 2. Please help!

2009-03-04 Thread cf coder
t there is a cfdocumentitem tpye pagebreak attribute () which I could use but how do I know when to use this given that the data is dynamic. Can anyone help? Regards, John ~| Adobe® ColdFusion® 8 software 8 is the most imp

Re: CF8 Multi Server Config Help

2009-02-26 Thread Dave Watts
> Dave, what would you recommend? > Clean up old mappings > Establish a naming > convention for the new stuff to avoid conflicts > when > complete, clean house and remove old mappings All of those sound good. Any documentation process you can use going forward to keep track of settings would prob

Re: (ot) Oracle 10g-- Collect function--HELP!

2009-02-10 Thread Dave Watts
> I have a sql server and mysql background. I am a total newbie with > using oracle packages so bear with me :) The DBA's here had not even > heard of the collect function so not getting much help here. The > package definition compiles fine (declaration). When I try to com

(ot) Oracle 10g-- Collect function--HELP!

2009-02-10 Thread Stone, Lori
I have a sql server and mysql background. I am a total newbie with using oracle packages so bear with me :) The DBA's here had not even heard of the collect function so not getting much help here. The package definition compiles fine (declaration). When I try to compile the body I

Re: Need ISAPI rewrite help...

2009-02-09 Thread Seb Duggan
On 9 Feb 2009, at 01:44, Will Tomlinson wrote: > Thanks Seb! > > So I could say: > > RewriteRule ^calendarDetails\.html/[A-Za-z]+/([0-9]+)$ / > calendarDetails.cfm? EID=$1 [NC] Make sure there's no space before the ? Yes, or even: RewriteRule ^calendarDetails\.html/([A-Za-z]+)/([0-9]+)$ / c

Re: Need ISAPI rewrite help...

2009-02-08 Thread Will Tomlinson
n error. http://staging.ac100.org/calendarDetails.html/EID/935 URL.EID should = 935, but it isn't. I restarted IIS, etc. Any ideas? Thanks for your help! Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic rele

Re: Need ISAPI rewrite help...

2009-02-08 Thread Will Tomlinson
>And this assumes that the files are at your site's root, and that it's >always an EID value you're matching. (If the key value in the >querystring varies, you could use a regex for that too). > Thanks Seb! So I could say: RewriteRule ^calendarDetails\.html/[A-Za-z]+/([0-9]+)$ /calendarDeta

Re: Need ISAPI rewrite help...

2009-02-08 Thread Seb Duggan
This should do the trick: RewriteRule ^calendarDetails\.html/EID/([0-9]+)$ /calendarDetails.cfm? EID=$1 [NC] [NC] is the equivalent of [I] in v2 (case insensitive match). And this assumes that the files are at your site's root, and that it's always an EID value you're matching. (If the key v

Re: Need ISAPI rewrite help...

2009-02-08 Thread Will Tomlinson
>What version of ISAPI Rewrite are you using? > >The tutorial looks as though it's written for v2; whereas in v3 it is >much more like the syntax of Apache's mod_rewrite. Which means that >the querystring is not actually seen as part of the URL in >RewriteRule, but can be accessed via a Rewr

Re: Need ISAPI rewrite help...

2009-02-08 Thread Seb Duggan
993 > > My URL var doesn't seem to be seen on the action page. > > http://staging.ac100.org/calendarDetails.html?/EID/935 > > I dump the value of URL.EID, and it's 0, which I had 'd. > > Here are my rewrite rules in httpd.ini. Thanks for any help someone >

Re: Need ISAPI rewrite help...

2009-02-07 Thread Will Tomlinson
>You know you don't have to use a rewrite tool to do that - you can just >map the .html extension to CF in IIS. > Well I'm eventually wanting to create friendly URL's. /someVolleyballShirt.html. >I think you might need to use the .html extension. I tried it with and without. No matter what

Re: Need ISAPI rewrite help...

2009-02-07 Thread Jim McAtee
- Original Message - From: "Will Tomlinson" To: "cf-talk" Sent: Saturday, February 07, 2009 10:21 AM Subject: Need ISAPI rewrite help... > > I'm attempting my first SES URL rewriting with the IIS ISAPI filter, and > having a few problems. > > I

Need ISAPI rewrite help...

2009-02-07 Thread Will Tomlinson
on page. http://staging.ac100.org/calendarDetails.html?/EID/935 I dump the value of URL.EID, and it's 0, which I had 'd. Here are my rewrite rules in httpd.ini. Thanks for any help someone could offer. RewriteRule (.*)/(.*)\.html(.*) /$2.cfm [I] #Convert SES URLs to standard UR

Re: Reorder Records for Navigation help

2009-02-05 Thread Gerald Guido
Yeah, np... I have one on back up... but the drive is at work. I can get it to you in the morning. G! On Thu, Feb 5, 2009 at 6:39 PM, Sin Tec wrote: > > I am having troubles getting this to work. Do you happen to have a working > example? > > >It would probably be best to use recursion to acco

Re: Reorder Records for Navigation help

2009-02-05 Thread Sin Tec
I am having troubles getting this to work. Do you happen to have a working example? >It would probably be best to use recursion to accomplish this. Recursion >made my head hurt (a lot) the first time I tried to get my head around it as >well. The idea is to use a parent ID to link sub menu items

Re: Help with Eclipse/CFEclipse

2009-02-05 Thread Tom Chiverton
On Wednesday 04 Feb 2009, N K wrote: > 2)"Eclipse Classic 3.4.1 (151 MB)" That one. 3.3 has broader support amongst other plugins, imho. -- Tom Chiverton Helping to continually harvest vertical meta-services This email is sent for and on be

Re: Help with Eclipse/CFEclipse

2009-02-04 Thread N K
Take a look at the following link ,might help http://groups.google.com/group/cfeclipse-users/browse_thread/thread/5734e5eba0468305/1b6670cb6cf3723e?hl=en&lnk=gst&q=install+#1b6670cb6cf3723e > Hi, > > I am still getting the same as before. I uninstalled and reinstalled >

Re: Help with Eclipse/CFEclipse

2009-02-04 Thread N K
Sent: Wednesday, February 04, 2009 12:48 PM > To: cf-talk > Subject: Re: Help with Eclipse/CFEclipse > > > Hi , > > Check out the following link > http://trac.cfeclipse.org/cfeclipse/wiki/InstallingCfeclipse > > The steps shown one by one are required in orde

<    4   5   6   7   8   9   10   11   12   13   >