RE: SQL HELP!

2004-05-19 Thread Matthew Walker
SELECT stuff.*, person1.*, person2.*, person3.* FROM  ( ( stuff LEFT JOIN persons AS person1 ON stuff.first_person_id = persons.person_id ) LEFT JOIN persons AS person2 ON stuff.second_person_id = persons.person_id ) LEFT JOIN persons AS person3 ON stuff.third_person_id = persons.person_id)

SQL HELP!

2004-05-19 Thread brobborb
hey guys, i have a table named Stuff.  this table has the fields stuff_id, stuff_title, first_person_id, second_person_id, and third_person_id. The those last 3 fields refer to a table called "persons", and contains the person_id.  The table PERSONS contain the fields person_id, first_name, and la

RE: Sort #FORM# by value?

2004-05-19 Thread Charlie Griefer
Hi Morgan: Might be a better/more efficient way, but threw together a quick UDF that seems to work: function sortForm(stForm) { var formValueArray = arrayNew(1); var kArray = structKeyArray(stForm); for (i=1; i LTE arrayLen(kArray); i=i+1) { formValueArray[arrayLen(form

RE: Help with Regular expression

2004-05-19 Thread Matthew Walker
Why not simply use replaceList(). Str = replaceList(str, ".,1st,2nd,3rd,4th,5th,6th,7th,8th,9th,10th,&", " ,first,second,third,fourth,fifth,sixth,seventh,eighth,ninth,tenth, and ") then str = reReplaceNoCase(str, "^The[[:space:]]", "") then str = reReplace(str, "[^[:alnum:][:space:]]", "", "all"

Help with Regular expression

2004-05-19 Thread Thanh Nguyen
Hi All, I tried to do this regular _expression_, but having a hard time getting the result I want. So any help would be appreciated. Here's what I tried to achieve. 1. remove "The" from in at the beginning of the string. 2. replace period with space. 3. Numerals are treated as though spell

Cached queries

2004-05-19 Thread Les Irvin
I would like to carry query results across a number of pages as users move through the site without having to perform the query on each page.   I understand persistant queries with the "cachewithin" attribute but that's not possible with this query as it includes an embedded tag. What's the best

RE: oracle unique id or identity

2004-05-19 Thread Yexley Robert D Contr AFRL/PROE
Without actually being able to test it, that appears to me that it should work just fine. Dual is...hard to describe...so I'll leave it to the Oracle documentation to explain what it is, heh (see definition below). You may also want to consider making sure that you define the ID column as the prima

OT: Recovering a SQL Server 6.5 Device file?

2004-05-19 Thread Shawn Grover
Sorry for the off topic, but we've exhausted Google and MSDN on this issue, and the list just happens to have a bunch of experts on it, so I'm hoping We have an older database server that finally crashed it's motherboard.  This server was running NT4 with SQL Server 6.5.  Because it's NT4, I c

RE: Cached queries

2004-05-19 Thread Philip Arnold
> From: Les Irvin > > I would like to carry query results across a number of pages > as users move through the site without having to perform the > query on each page.   > > I understand persistant queries with the "cachewithin" > attribute but that's not possible with this query as it > incl

RE: Cached queries

2004-05-19 Thread Barney Boisvert
Just stick the query object in a shared scope.  If it's user specific, then the session scope would be the way to go, otherwise application.   SELECT ... Just keep in mind that the query will not expire until the application scope expired (two days without a request by default, I believe).  So

RE: return only 2 decimal places

2004-05-19 Thread Won Lee
At 16:49 5/19/2004 -0400, you wrote: >select cast(.01000 as decimal(18, 2)) Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: oracle unique id or identity

2004-05-19 Thread Jochem van Dieten
Daniel Kessler wrote: > I'm trying to make an auto-incrementing ID field in ORACLE.  In sql, > I believe that I make it have an attribute of IDENTITY. Use a sequence in Oracle. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Trim E-Mail Prefix

2004-05-19 Thread Jillian Carroll
Brain fart moment... how can I most easily/reliably trim the prefix from an e-mail address: [EMAIL PROTECTED] I want everything before the @... so: 'test'. -- Jillian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Macromedia JDBC driver class names

2004-05-19 Thread Jon Gunnip
I tested the JDBC batch submit versus using looping over CFQuery and the results were about the same: 9 seconds to insert 2000 rows into a 2-column table.  So, in my testing, it appears that the JDBC batch submit is no faster.  I was surprised. I was hoping it would be a lot faster to do the JDBC

RE: Trim E-Mail Prefix

2004-05-19 Thread Kev McCabe
Jillian, This Should do the trick for you #GetToken('[EMAIL PROTECTED]',  '1' ,  '@')# Cheers _ Mr Kev McCabe Senior ETV Developer, British Sky Broadcasting First Floor North East, West Cross House Grant Way Isleworth Middlesex TW7 5QD [EMAIL PROTECTED] http://www.sk

RE: Trim E-Mail Prefix

2004-05-19 Thread DURETTE, STEVEN J (AIT)
Why don't you try,   ? Steve -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 3:47 PM To: CF-Talk Subject: Trim E-Mail Prefix Brain fart moment... how can I most easily/reliably trim the prefix from an e-mail address: [EMAIL PROTECTED]

oracle unique id or identity

2004-05-19 Thread Daniel Kessler
I'm trying to make an auto-incrementing ID field in ORACLE.  In sql, I believe that I make it have an attribute of IDENTITY.  I can't seem to find how to do that in ORACLE.  Here's my latest attempt: create table hhp_calendar (  id INT unique id,  dateAdded date,  event_date date,   

RE: oracle unique id or identity

2004-05-19 Thread Yexley Robert D Contr AFRL/PROE
Oracle doesn't have any kind of unique-id or identity datatype for table columns. Instead, you need to use a "SEQUENCE" which is a standalone object inside an Oracle schema which generates unique numbers based on how you define the sequence when it's created. So, to use that in a table, you need to

Re: oracle unique id or identity

2004-05-19 Thread daniel kessler
ok, I'll look that up, thanks. >Use a sequence in Oracle. > >Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Netscape 7 and window.open

2004-05-19 Thread Bryan Stevenson
nope...they are allowed..thanks Barney Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com --

SOLVED: Image Maps and Netscape 7

2004-05-19 Thread Bryan Stevenson
I won't go into the technical issuesbut it was DHTML and the need to align the image used for the map "right" Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] -

SQL: return only 2 decimal places

2004-05-19 Thread Won Lee
Hello, Using SQL Server 2000. I want to keep as much work on the SQL server. I have a numeric value that I want to return as a 2 decimal place number. 10.98 1.34 03.45 .34 All valid returns.  How can I do this?  I can't run a substring on a numeric value.  Should I cast it then work on it?  Sho

Re: OT: Netscape 7 and window.open

2004-05-19 Thread Simon Riley
Bryan Stevenson wrote: > >Hey All, > >I'm banging my head against what should be a simple issue. > >I've got some code like so: > >> s,wi >dth=450,height=500');return false;"> > >which is pretty standard pop-up window opening code...been using it for >years.  I cannot for the life of me get it to w

RE: Netscape 7 and window.open

2004-05-19 Thread J E VanOver
I don't have a sure answer, but is there any reason you are using the "onClick" event rather than the href? You have > dth=450,height=500');return false;"> But you could use: href=""> lbars,width=450,height=500');return false;"> For some reason, I've always had more success putting this type

RE: oracle unique id or identity

2004-05-19 Thread CFDEV
Create sequence sequence_name increment by 1 start with 1; Pat   _   From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: May 19, 2004 16:15 To: CF-Talk Subject: Re: oracle unique id or identity Daniel Kessler wrote: > I'm trying to make an auto-incrementing ID field in ORACLE.  In sq

RE: oracle unique id or identity

2004-05-19 Thread CFDEV
you can also see the previous value with or the current one with   _   From: Yexley Robert D Contr AFRL/PROE [mailto:[EMAIL PROTECTED] Sent: May 19, 2004 16:25 To: CF-Talk Subject: RE: oracle unique id or identity Oracle doesn't have any kind of unique-id or identity datatype for table co

SOLVED: Netscape 7 and window.open

2004-05-19 Thread Bryan Stevenson
Arrrgggh...a reboot solved the problem...some days it doesn't pay to get out of bed ;-) Thanks all Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - M

RE: oracle unique id or identity

2004-05-19 Thread Jason.Gulledge
as well as the next value your_sequence_name.nextval -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 3:34 PM To: CF-Talk Subject: RE: oracle unique id or identity you can also see the previous value with or the current one with   _   From: Ye

OT: Image Maps and Netscape 7

2004-05-19 Thread Bryan Stevenson
Well now that the pop-up issue is solved in NS 7 I'm still having a problem with image maps. In IE6 the hand pointer appears as soon as I mouseover any target area of an image map.  With NS7 the hand displays intermittently on larger targets and is almost impossible to get it to show on smaller ta

RE: return only 2 decimal places

2004-05-19 Thread Jim Davis
Take a look in Books Online for the ROUND() function - it'll do everything you need. Jim Davis   _   From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 4:31 PM To: CF-Talk Subject: SQL: return only 2 decimal places Hello, Using SQL Server 2000. I want to keep as much wo

RE: return only 2 decimal places

2004-05-19 Thread DURETTE, STEVEN J (AIT)
Try select cast(.01000 as decimal(18, 2)) Steve -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 4:45 PM To: CF-Talk Subject: RE: return only 2 decimal places I tried round.  It seems it returns the same amount of decimal places as the nume

RE: Netscape 7 and window.open

2004-05-19 Thread Barney Boisvert
You got popup blocking enabled?  Shouldn't matter, because it's an onClick, but that might be it. Cheers, barneyb > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 19, 2004 12:34 PM > To: CF-Talk > Subject: OT: Netscape 7 and window.open > > H

Re: oracle unique id or identity

2004-05-19 Thread daniel kessler
Unfortunately I don't have the ref books and I am rooting through oracle.com.  In doing so I found a sequence that I think can be cobbled into  what I need, thought it has a reference to DUAL and I don't know what that is.  Here it is: create table hhp_calendar (     id NUMBER,     dateAdded date,

RE: cfmx not picking up spooled messages

2004-05-19 Thread Tom Jordahl
*   Sometimes the spool will get a zero byte message stuck at the top of the queue, and nothing behind it will send. CFMX 6.1 does not suffer from this problem. -- Tom Jordahl Macromedia Server Development -Original Message- From: Maureen [mailto:[EMAIL PROTECTED] Sent: Monday, M

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-19 Thread Barney Boisvert
Still not quite right: initial : 1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50 desired : 1-6,10-14,20,25,30-33,50 computed: 1-6,10-14,20-20,25-25,50    ^^ ^^ ^^   The code in my initial post works correctly, and is reposted (with slight optimizations) below:

RE: return only 2 decimal places

2004-05-19 Thread Won Lee
I tried round.  It seems it returns the same amount of decimal places as the numeric value working on. select round(.011344999555, 2) returns .0100 select round(.011344999555, 2, 1) - which is supposed to truncate returns .0100 At 16:39 5/19/2004 -0400, you wrote: >Take a look

Re: Netscape 7 and window.open

2004-05-19 Thread Bryan Stevenson
John said: >Is it because you're using the void() function in the HREF?  Maybe >that's cancelling out or something in NS7.1?  They could have made the >void function actually do something.  Besides that, everything looks >good to me.  That'd the only thing I can guess would cause a possible >proble

SOLVED: JasperReports / CFMX

2004-05-19 Thread Rick Root
If anyone is interested in using JasperReports as a full featured reporting tool from within Coldfusion MX, I finally got it working, and I wrote a little article in my blog about it. http://blog.rickroot.com/archives/2004/05/reporting_in_co.html I'll be using this knowledge myself to help conv

Re: ad weights

2004-05-19 Thread Jim McAtee
- Original Message - From: "Michael Dinowitz" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 1:03 AM Subject: Re: ad weights > Your first solution would run into the problem of having a huge amount of low > ads and few high ones. Lets say a banner syst

Sort #FORM# by value?

2004-05-19 Thread Morgan Senkal
Any ideas?  You would think that StructSort would be the answer but nope.   TIA! -Morgan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Netscape 7 and window.open

2004-05-19 Thread Burns, John D
Is it because you're using the void() function in the HREF?  Maybe that's cancelling out or something in NS7.1?  They could have made the void function actually do something.  Besides that, everything looks good to me.  That'd the only thing I can guess would cause a possible problem. John -

RE: modifying Word doc via CF

2004-05-19 Thread Dave Jones
Sam and Phillip, Thanks for the replies. DSOFile looks promising, but if I can't get it working quickly, I'll just have the client spring for Word. Dave Jones At 01:47 PM 5/19/04 -0400, you wrote: >What exactly are you modifying in the uploaded docs?  If it's just a small >piece of text then I w

OT: Netscape 7 and window.open

2004-05-19 Thread Bryan Stevenson
Hey All, I'm banging my head against what should be a simple issue. I've got some code like so: > dth=450,height=500');return false;"> which is pretty standard pop-up window opening code...been using it for years.  I cannot for the life of me get it to work in NS 7.1 and no errors are shown in

RE: SOT: Directory Tree crawler with file size sorting?

2004-05-19 Thread Burns, John D
Not a bad suggestion.  Is there any way (that you know of) to add a filter to only grab files larger than X? John Burns -Original Message- From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 3:06 PM To: CF-Talk Subject: RE: SOT: Directory Tree crawler with file

class files

2004-05-19 Thread Tony Weeg
hi there. I saw matt's http://devilm.com/archives/01.html (GREAT Spamming though, cool spammers) article on how to use java to determine the names of files that class's are on the cfusion server.   great if you're a java programmer. im not, and I just want to delete a file that a class fi

RE: SOT: Directory Tree crawler with file size sorting?

2004-05-19 Thread Nathan C. Smith
Are we so GUI-centric we have forgotten the old ways of doing things? Drop into a command prompt  Type this: dir /O-S /S |sort /+30 /r It will list all files on your system largest to smallest.  use dir /O-S /S |sort /+30 /r |more to see them a page at a time. -Nate -Original Messa

RE: Followup db query question (was XML/SOAP)

2004-05-19 Thread me
On Wed, 19 May 2004 14:25:35 -0400, "Dave Carabetta" wrote: > >I'm going to ditch using DOM and create my XML using a > bunch of CFSET > >calls in a query loop.  That said, is there any way > that I can dynamically > >determine the names of the recordset column names? My > DBA just told me > >the

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-19 Thread Steve Nelson
newgroup="#groupstart#-#lastitem#"> #va

RE: yahoo and selling fabric

2004-05-19 Thread nancy . tracy
We had some special needs that didn't allow us to use Yahoo's catalog (by catalog I mean where the shopper searches for products and puts them in the cart), so we were going to put together our own catalog and use their check-out services.  The rest of our web site was already built in ASP, so we d

RE: CFMX Hosting Providers

2004-05-19 Thread CFDEV
www.efree2net.com the cheapest CF 5 I know Pat   _   From: John Beynon [mailto:[EMAIL PROTECTED] Sent: May 19, 2004 09:34 To: CF-Talk Subject: RE: CFMX Hosting Providers Hostmysite.com Fast, efficient - excellent tech support (10-30 minute response time any time of day) Cffile/cfdirect

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-19 Thread Barney Boisvert
Steve, Here's the output I get from your code: initial : 1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50 desired : 1-6,10-14,20,25,30-33,50 computed: 0-0,2-0,3-0,4-0,5-0,6-0,10-0,11-0,12-0,13-0,14-0,20-0,25-0,30-0,31-0,32-0,33 -0 Cheers, barneyb > -Original Message- > From: Steve Nelson

Re: Ranges *WOW*!!!

2004-05-19 Thread Nathan R. Jessop
Thanks Pascal, It works beautifully! --Original Message Text--- From: Nathan R. Jessop Date: Wed, 19 May 2004 14:00:41 -0400 Hi Pascal, I'm afraid I've made it more difficult than it has to be. I'm trying to modify existing code and my experience is limited when it becomes this complicated. I

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-19 Thread Steve Nelson
Sorry about that... Here's my 3 minute attempt. I haven't tested it. At a second glance I think it screws up the first group. Steve Nelson   _   From: Steve Nelson [mailt

RE: Followup db query question (was XML/SOAP)

2004-05-19 Thread Dave Carabetta
>I'm going to ditch using DOM and create my XML using a bunch of CFSET >calls in a query loop.  That said, is there any way that I can dynamically >determine the names of the recordset column names?  My DBA just told me >there are changes coming down the pike and I don't want to change my code >for

Upgrading CF 4.5 to MX

2004-05-19 Thread Chad Nikirk
As the subject says, I want to upgrade a 4.5 server to MX.  I should mention that I am running in distributed mode.   Since the net listener runs as a service on 4.5 will this cause a problem when I upgrade?  Any other pitfalls to watch out for during this upgrade?  Thanks. [Todays Threads] [Th

Re: MX integration with Java

2004-05-19 Thread sudhakar ramaswamy
Hi I am doing something similar to what you have mentioned. 1. view,controller in CF and model in Java. All java classes are being called from CFCs. 2. For development I am using CF with inbuilt server on local machine. 3. The production environment is CFMX deployed on Websphere running on UNIX.

Re: MX integration with Java

2004-05-19 Thread sudhakar ramaswamy
Hi I am doing something similar to what you have mentioned. 1. view,controller in CF and model in Java. All java classes are being called from CFCs. 2. For development I am using CF with inbuilt server on local machine. 3. The production environment is CFMX deployed on Websphere running on UNIX.

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-19 Thread Barney Boisvert
First, your result list is incorrect.  It should start with "1-6,10-14" rather than "1-14".  Here's some code that'll do what you want (using your list): "-") /> initial : #var1# desired : 1-6,10-14,20,25,30-33,50 computed: #result# > -Original

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-19 Thread Steve Nelson
Here's my 3 minute attempt:   _   From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 1:57 PM To: CF-Talk Subject: RE: **UPDATE** Arrange sequential selections into ranges how to??? Maybe I've made it more difficult than it has to be. Ignore the stuff. Let's

Re: Followup db query question (was XML/SOAP)

2004-05-19 Thread me
On Wed, 19 May 2004 13:44:38 -0400 (EDT), "Joe Tseng" wrote: > I'm going to ditch using DOM and create my XML using a > bunch of CFSET > calls in a query loop.  That said, is there any way > that I can dynamically > determine the names of the recordset column names?  My > DBA just told me > there

RE: modifying Word doc via CF

2004-05-19 Thread Philip Arnold
> From: Dave Jones > > 2. is it sufficient to install Word to get > the COM object, or is Office required? Just to answer this You only need Word to get to the Word COM object [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Arrange sequential selections into ranges how to???

2004-05-19 Thread Pascal Peters
The hidden field doesn't need a value and can't be in the select. The reason that you are not seeing the correct value in the actionpage is that you don't call the function correctly in the onsubmit or that there is an error in the function. Maybe a wrong case somewhere. JS is case sensitive. I've

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-19 Thread Nathan R. Jessop
Maybe I've made it more difficult than it has to be. Ignore the stuff. Let's say I have a variable being passed to my action page that contains the following (this can vary): var1 = "1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50" How can I arrange the above variable into a range. Meaning...h

RE: yahoo and selling fabric

2004-05-19 Thread Jeremy
I thought the catalog was part of there app and you could upload/delelte/alter products through their web bases interface. Maybe that is not what you are tlaking about. If so fill me in on what you mean by catalog. Jeremy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT

RE: modifying Word doc via CF

2004-05-19 Thread Samuel R. Neff
What exactly are you modifying in the uploaded docs?  If it's just a small piece of text then I would suggest using fields linked to document properties and then you can read/update those properties via DSOFile.  This is much faster and more stable than automating Word and doesn't require any Offic

Followup db query question (was XML/SOAP)

2004-05-19 Thread Joe Tseng
I'm going to ditch using DOM and create my XML using a bunch of CFSET calls in a query loop.  That said, is there any way that I can dynamically determine the names of the recordset column names?  My DBA just told me there are changes coming down the pike and I don't want to change my code for ever

Re: Where are my java errors?

2004-05-19 Thread Rick Root
Rick Root wrote: > Unfortunately, I can't see the errors that it generates, because > either coldfusion isn't storing them, or I don't know where they're > being put.  They are *NOT* in any of the log files in the main log > directory. > Ah hah, I found them! /runtime/logs/default-err.log [

Where are my java errors?

2004-05-19 Thread Rick Root
Okay, so I'm working on implementing JasperReports, a free, java reporting tool (jasperreports.sourceforge.net) within CFMX 6.1 My code looks like this: jasperManager = CreateObject("java", "dori.jasper.engine.JasperManager"); jasperDesign = jasperManager.loadXmlDesign("E:\Inetpub\wwwroot\jasp

RE: MS SQL Syntax/Keyword

2004-05-19 Thread Philip Arnold
> From: Burns, John D >   > select * > from table > where #groupID# = groupID or #groupID# IN (sharedGroupIDs) If I understand what you want to do... ','+cast(sharedGroupIDs as varchar(4096))+',' like cfsqltype="CF_SQL_VARCHAR" value="%,#GroupID#,%"> What this will do is put a comma at either e

modifying Word doc via CF

2004-05-19 Thread Dave Jones
Hi, I have a client that would like to upload Word docs to a server via a CF app and have an associated ID value stored in the docs. I know how to do this using the Word COM object, but before I have the client install Word/Office on their server, I wanted to check if this is the only way. So,

RE: MS SQL Syntax/Operator

2004-05-19 Thread Mark A. Kruger - CFG
PS the CAST convert functions won't help here. The problem is in trying to treat a list of values in a single character column as if they were separate entities. SQL doesn't do "lists" like that. -mark   -Original Message-   From: Burns, John D [mailto:[EMAIL PROTECTED]   Sent: Wednesday

RE: MS SQL Syntax/Keyword

2004-05-19 Thread Mark A. Kruger - CFG
John, Your syntax would output like this: where 15 IN (sharedGroupIds) If I'm reading your right this is backwards - it should be "column IN  values" or sharedGroupIds IN (15) Unfortunatley the IN clause is not going to work for you with a column of values because it uses "equals" against each

RE: MS SQL Syntax/Operator

2004-05-19 Thread Burns, John D
I tried that as well...I tried: Select * >From table Where cast(#groupID# as varchar(50)) IN (sharedGroupIDs) Still no rows being returned. As an extra note, the original attempt worked fine when I only have a single value in the SharedGroupIDs column.  When I added multiple values is when it ha

Re: MS SQL Syntax/Operator

2004-05-19 Thread George Abraham
Use the CAST function available in T-SQL. At 12:23 PM 5/19/2004, Burns, John D wrote: >I have a table in MS SQL with a column that has a groupID value in it >(int) and a column that is sharedGroupIDs (varchar).  The groupID holds >an int of the group that the record belongs to.  The sharedGroupIDs

MS SQL Syntax/Keyword

2004-05-19 Thread Burns, John D
I have a table in MS SQL with a column that has a groupID value in it (int) and a column that is sharedGroupIDs (varchar).  The groupID holds an int of the group that the record belongs to.  The sharedGroupIDs holds a string of IDs that also can see the record.  I'm trying to use the IN operator to

RE: Arrange sequential selections into ranges how to???

2004-05-19 Thread Nathan R. Jessop
I was able to get the listing to display by putting the hidden field outside of the loop. For testing purposes I added a on my action page to see whats getting passed. For example. If I select the below pages: 1,2,3,4,5,6,7,8,9,15,16,17,18,19,25 When I submit the form I get the same output.

MS SQL Syntax/Operator

2004-05-19 Thread Burns, John D
I have a table in MS SQL with a column that has a groupID value in it (int) and a column that is sharedGroupIDs (varchar).  The groupID holds an int of the group that the record belongs to.  The sharedGroupIDs holds a string of IDs that also can see the record.  I'm trying to use the IN keyword to

RE: yahoo and selling fabric

2004-05-19 Thread nancy . tracy
I checked into a Yahoo store for my husband's business web site.  They only support PHP and Perl.  So, if you're planning on using ColdFusion to build your catalog, you need to look elsewhere. If you haven't already, you may want to check out www.fabric.com . Their navigation is the best of any

RE: Arrange sequential selections into ranges how to???

2004-05-19 Thread Nathan R. Jessop
Add a hidden field like this? It only displays the first folio. Seq: 1  Folio: 2201 and then lists all the other pages outside of the "))> "))> Seq: #sValNoComma#  Folio: #sDisp##spacer1# On Wed, 19 May 2004 17:41:35 +0200, Pascal Peters wrote: >Rename your select "filelistselect", >c

Sybase Adaptive Server ver 8

2004-05-19 Thread Kurt Knazek
Has anybody had success connecting to Sybase Adaptive Server ver 8 via cold fusion mx ? If you have could please explain what you had to do. /kurt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: passing a form field

2004-05-19 Thread Douglas.Knudsen
that would mean there is no form var called QTY2 in CF.  Try cfdump var="#form#" to see what's in your form scope.  Are you using #trim(form["qty" & count])# on teh CF page that received a form post? Doug -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, Ma

RE: SOT: Directory Tree crawler with file size sorting?

2004-05-19 Thread Burns, John D
OS level is fine.  This is more for server management than for specific use from within CF.  I am, however, trying to keep a certain set of directories in check because I'm serving files through CFCONTENT and don't want to server huge files through that. John -Original Message- From: Pet

RE: passing a form field

2004-05-19 Thread Pascal Peters
Form.qty2 doesn't exist. > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: woensdag 19 mei 2004 17:45 > To: CF-Talk > Subject: RE: passing a form field > > Thanks Doug and Pascal. >  Why though do I get this error? >   > An error occurred while evaluating the

RE: passing a form field

2004-05-19 Thread Robert Orlini
Thanks Doug and Pascal. Why though do I get this error? An error occurred while evaluating the _expression_: #trim(form["qty" & count])# The member "QTY2" in dimension 1 of object "form" cannot be found. Please, modify the member name. -Original Message- From: [EMAIL PROTECTED] [mailto

yahoo and selling fabric

2004-05-19 Thread Jeremy
Hello, I am looking at implementing an online store that will sell fabric, by the yard, for use in homes for things like furniture and drapery. I have been looking at setting up a "standard" store, as yahoo calls it on their site. The tools they have built in seem to make everything pretty easy

Re: CFMX Hosting Providers

2004-05-19 Thread Troy Montour
I'm a reseller for hostmysite. and I like there service as stated before very fast and I haven't had an issue yet with them. the user controls gives you fast responces when adding new sites Troy Montour -- Original Message -- From: Jeff Britts <[EMAIL PRO

RE: Arrange sequential selections into ranges how to???

2004-05-19 Thread Pascal Peters
Rename your select "filelistselect", create a hidden field named "filelist" and call this JS function in the onsubmit of the form: function makeList(thisform){ var opts = thisform.filelistselect.options,     val="",     i=0; for(;i if(opts[i].selected){ if(i==0 || !opts[i-1].selected){

CFHTTP problems!

2004-05-19 Thread Alexander Sherwood
Has anyone gotten CFHTTP to throw the "COM.Allaire.ColdFusion.HTTPAuthFailure" error? I can dump the CFHTTP result struct and plainly see that authentication is failing, but I cannot get CFHTTP to throw the "COM.Allaire.ColdFusion.HTTPAuthFailure" exception as annotated in the docs. Anyone else r

Re: MX integration with Java

2004-05-19 Thread sudhakar ramaswamy
Hi I am doing something similar to what you have mentioned. 1. view,controller in CF and model in Java. All java classes are being called from CFCs. 2. For development I am using CF with inbuilt server on local machine. 3. The production environment is CFMX deployed on Websphere running on UNIX. O

Re: SOT: Directory Tree crawler with file size sorting?

2004-05-19 Thread Pete Ruckelshaus - CFList
Are you looking for a utility to use from the OS level, or for something to use from within CF? Burns, John D wrote: > Does anyone know of a good free tool that will crawl a drive/directory > on a webserver and output a list of all of the files and directories and > the sizes of them and allow yo

Re: CFMX doc root as a Mounted Volume

2004-05-19 Thread Ian Sheridan
On May 19, 2004, at 10:11 AM, Thomas Chiverton wrote: > On Wednesday 19 May 2004 15:06 pm, Ian Sheridan wrote: >> files on a mounted volume so solve syncing. > > It'll run fine. Just watch the CF user has suitable permissions. > >> there be any performance issues? > > Network is slower than disk,

RE: CFMX Hosting Providers

2004-05-19 Thread Monique Boea
www.adonaihosting.com good service, good pricing, good support -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:11 AM To: CF-Talk Subject: Re: CFMX Hosting Providers >Looking to change shared hostswho do you recommend and why? Any on

Re: Version Management Inquiry

2004-05-19 Thread Massimo Foti
>  Is there a extension for DWMX 2k4 to use subversion? > I am not aware of any dedicated extension. I would use TortoisesSVN anyway, since DW's isn't the only editor I use Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dw

RE: Version Management Inquiry

2004-05-19 Thread Ben Densmore
Massimo, Is there a extension for DWMX 2k4 to use subversion? Thanks, Ben -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 9:26 AM To: CF-Talk Subject: Re: Version Management Inquiry > On one of my projects I am working with a fellow coldf

Re: CFMX Hosting Providers

2004-05-19 Thread Jeff Britts
>Looking to change shared hostswho do you recommend and why? Any one using a reseller package they are happy with? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Arrange sequential selections into ranges how to???

2004-05-19 Thread Nathan R. Jessop
On Wed, 19 May 2004 17:06:08 +0200, Pascal Peters wrote: >Do you need to pass it like this or can you transform the list on the >server to make the ranges? I need to pass it like  1-16,23-25,30,33,40-42,46-48 to the server. Is the list always in numerical order? Yes it is. > >> -Original

RE: Arrange sequential selections into ranges how to???

2004-05-19 Thread Pascal Peters
Do you need to pass it like this or can you transform the list on the server to make the ranges? Is the list always in numerical order? > -Original Message- > From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] > Sent: woensdag 19 mei 2004 17:00 > To: CF-Talk > Subject: re: Arrange sequenti

re: Arrange sequential selections into ranges how to???

2004-05-19 Thread Nathan R. Jessop
Hi, I'm reading in an external file and then passing the results to my action page by selecting all or individual selections. This is what the listing would like from the file I'm reading in (which is generated by a another program). 001>folio:  2201 . . . 274.00 points free 002>folio:  2251 . .

RE: Directory Tree crawler with file size sorting?

2004-05-19 Thread John Beynon
TreeSize Pro from http://www.jam-software.com/treesize/index.shtml Not sure if it's free but it's cheap if you do have to pay! Jb. -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 19 May 2004 15:55 To: CF-Talk Subject: SOT: Directory Tree crawler with file size sor

RE: passing a form field

2004-05-19 Thread Douglas.Knudsen
#trim(form["qty#count#"])# -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 10:37 AM To: CF-Talk Subject: passing a form field How do I pass a form field which is dynamic. I have qty#count# as the qunatity field. How do I pass this in a hidden

  1   2   >