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: Well dealing with non English char set's you should always be using cfqueryparam / 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.

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 off list.

Re: cf8 help with japanese characters

2009-06-12 Thread James Holmes
2009/6/13 Paul Kukiel pkuk...@gmail.com: 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

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-11 Thread Paul Kukiel
to Japan.  I've even set my IE browser language to Japanese. If I can't get the Japanese 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

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

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 Hastingsp...@sustainablegis.com 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: 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

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 Kukiel
Well dealing with non English char set's you should always be using cfqueryparam / 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

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

cf8 help with japanese characters

2009-06-10 Thread mike pop
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 with something they want? Let them know on the House of Fusion

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 doesn't

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 Shannon Peevey
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.erikin.com/2009/06/coldfusion-postgresql

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

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

(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

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/([^/]+)(?:/([^/]+)(?:/([^/]+))?)?/?$

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 server

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 dolor sit

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

2009-06-05 Thread Andy Matthews
/a', 'ALL') cfdump var=#VARIABLES# 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 in String Happy

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

2009-06-05 Thread Mike Francisco
: RE: Need Regex help for finding and Hyperlinks words in String Mike... cfset VARIABLES.oldstring = 'Lorem ipsum dolor sit amet, consectetur adipisicing. Elit @commadelimited sed do eiusmod tempor incididunt ut labore. Et dolore magnaaliqua. ' cfset VARIABLES.newstring = REReplaceNoCase

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 finding

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

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: cfquery name=getCareManagers

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 the problem lies in the output

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

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

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

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 torrentg...@gmail.com wrote: hello I have an issue

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 form

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: script userID = #url.idUser#; /script 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

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

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

RE: Regex help...

2009-05-29 Thread Che Vilnonis
To: cf-talk Subject: Regex help... 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

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 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:

(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

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 lesm...@bellsouth.net wrote: Trying to get Ionic IsapRewrite working locally so I

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?

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 cfdiv bindOnLoad=false. On Thu, May 14, 2009 at 8:06 AM, Les Mizzell lesm...@bellsouth.net 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

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,

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: 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 replace that

RE: Help With Regular Expressions

2009-05-12 Thread Andy Matthews
12, 2009 11:20 AM To: cf-talk Subject: Help With Regular Expressions 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

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: 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 file. Can anyone help? Please e-mail me

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

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

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:

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

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 rich...@j7is.co.uk wrote: hi our clients run tests on patients

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

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: 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

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
Or better still, just go straight from the date... cfloop index=CurDate from=#parseDateTime('1-Jan-2009')# to=#parseDateTime(Now())# step=7 cfset StartOfWeek = DateFormat( CurDate , 'dd ')/ cfset EndOfWeek = DateFormat( CurDate+6 , 'dd ')/ ... /cfloop

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
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:

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: Need help with a concept

2009-03-24 Thread John M Bliss
Something like...? cfloop index=day from=1 to=365 step=7 p#DateFormat(DateAdd(d, day, 12/31/2008), m/d/)# - #DateFormat(DateAdd(d, day + 6, 12/31/2008), m/d/)#/p /cfloop On Tue, Mar 24, 2009 at 5:00 PM, Torrent Girl torrentg...@gmail.com wrote: hi All I need help with a CF

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. CFquery name=DeptAverage datasource=bs3578 SELECT a.Amount AS aAmount, d.DeptName AS dName,

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.

Re: Need help with a concept

2009-03-24 Thread Peter Boughton
Or better still, just go straight from the date... cfloop index=CurDate from=#parseDateTime('1-Jan-2009')# to=#parseDateTime(Now())# step=7 cfset StartOfWeek = DateFormat( CurDate , 'dd ')/ cfset EndOfWeek = DateFormat( CurDate+6 , 'dd ')/ ... /cfloop

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

2009-03-24 Thread brad
might be OK with MySQL. ~Brad Original Message Subject: Help requested - Syntax for GROUP BY with HAVING ... From: BobSharp bobsh...@ntlworld.com Date: Tue, March 24, 2009 4:56 pm To: cf-talk cf-talk@houseoffusion.com http://ttcfm.open.ac.uk/~bs3578/test1/Week9_Act6.cfm

Re: Need help with a concept

2009-03-24 Thread Peter Boughton
Or better still, just go straight from the date... cfloop index=CurDate from=#parseDateTime('1-Jan-2009')# to=#parseDateTime(Now())# step=7 cfset StartOfWeek = DateFormat( CurDate , 'dd ')/ cfset EndOfWeek = DateFormat( CurDate+6 , 'dd ')/ ... /cfloop

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

2009-03-24 Thread BobSharp
that cover this kind of CFquery ? - Original Message - From: b...@bradwood.com To: cf-talk cf-talk@houseoffusion.com 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

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.

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

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

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.

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 framework does have its own

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-]+)

(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

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 lesm...@bellsouth.net 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

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

2009-03-10 Thread Tony
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 the server in that directory

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

2009-03-10 Thread Tony
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 the server in that directory... thanks. tony

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.

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??

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 rastaf...@gmail.com wrote: Yuliang... if you can go to this page:

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 rastaf...@gmail.com wrote: NEVERMIND

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
that there is a cfdocumentitem tpye pagebreak attribute (cfdocumentitem type = pagebreak/) 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

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 probably

(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 keep

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 compile the body I keep

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]+)$ /

Re: Need ISAPI rewrite help...

2009-02-08 Thread Seb Duggan
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 cfparam'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

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

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

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]+)$

Re: Need ISAPI rewrite help...

2009-02-08 Thread Will Tomlinson
/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 release to date Get the Free

Need ISAPI rewrite help...

2009-02-07 Thread Will Tomlinson
://staging.ac100.org/calendarDetails.html?/EID/935 I dump the value of URL.EID, and it's 0, which I had cfparam'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 URLs before passing them

Re: Need ISAPI rewrite help...

2009-02-07 Thread Jim McAtee
- Original Message - From: Will Tomlinson w...@wtomlinson.com To: cf-talk cf-talk@houseoffusion.com 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

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 I

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

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: 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 tooles...@gmail.com wrote: I am having troubles getting this to work. Do you happen to have a working example? It would probably be best to use

Help with Eclipse/CFEclipse

2009-02-04 Thread Ciliotta, Mario
Hi all, I was wondering if anyone can help with an issue I seem to be having running Eclipse/CFEclipse. I am running Eclipse 3.4.1 and CFEclipse 1.3.1.5 on Windows XP Pro. The problem that I am experiencing is that I cannot up open or show sub-folders in the file explorer view. I checked

CF8 Multi Server Config Help

2009-02-04 Thread Joel Polsky
On my local machine, I've installed CF8 with the Multi-Server features. I'm trying to set up a 2nd server that will serve up a brand new site, new mappings, new DB references etc.. I want to start clean (but still need to keep and maintain my current site etc.) I have the old site in c:

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