RE: SQL HELP!
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) _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 May 2004 5:55 p.m. To: CF-Talk Subject: SQL HELP! 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 last_name Now I want to return all the rows in the STUFF table, but to replace the last 3 fields with names in the PERSONS table. THe fields first_person_id, second_person_id, and third_person_id links to the person_id field in the table PERSONS. Yes, I admit this DB is poorly designed, but it's too late too change it now and risk breaking up other stuff, so I just need a quick SQL solution. Please help! Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL HELP!
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 last_name Now I want to return all the rows in the STUFF table, but to replace the last 3 fields with names in the PERSONS table. THe fields first_person_id, second_person_id, and third_person_id links to the person_id field in the table PERSONS. Yes, I admit this DB is poorly designed, but it's too late too change it now and risk breaking up other stuff, so I just need a quick SQL solution. Please help! Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sort #FORM# by value?
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(formValueArray)+1] = stForm[kArray[i]];
}
temp = arraySort(formValueArray, 'text');
return formValueArray;
}
Hope that helps.
-Original Message-
From: Morgan Senkal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 12:41 PM
To: CF-Talk
Subject: Sort #FORM# by value?
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: Help with Regular expression
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") _ From: Thanh Nguyen [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 May 2004 1:35 p.m. To: CF-Talk Subject: Help with Regular _expression_ 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 spelled out. 4. the string '1st' through '10th' are treated as if spelled out (e.g first, second..) 5. Ampersands are treated as though spelled out as "and" and put spaces between the words and ampersands. 6. Remove nonalphanumeric characters. Thanh Nguyen _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help with Regular expression
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 spelled out. 4. the string '1st' through '10th' are treated as if spelled out (e.g first, second..) 5. Ampersands are treated as though spelled out as "and" and put spaces between the words and ampersands. 6. Remove nonalphanumeric characters. Thanh Nguyen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cached queries
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, least CPU-intensive solution to this problem? Thanks in advance for the help, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: oracle unique id or identity
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 primary key for your table. Selecting from the DUAL Table DUAL is a table automatically created by Oracle along with the data dictionary. DUAL is in the schema of the user SYS, but is accessible by the name DUAL to all users. It has one column, DUMMY, defined to be VARCHAR2(1), and contains one row with a value 'X'. Selecting from the DUAL table is useful for computing a constant _expression_ with the SELECT statement. Because DUAL has only one row, the constant is returned only once. Alternatively, you can select a constant, pseudocolumn, or _expression_ from any table, but the value will be returned as many times as there are rows in the table. <.YEX.> -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 4:58 PM To: CF-Talk Subject: Re: oracle unique id or identity 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, event_date date, header VARCHAR2(200), description VARCHAR2(3000), http VARCHAR2(100), image VARCHAR2(100), image_h INT, image_w INT ); CREATE SEQUENCE uniqueNum_s START WITH 1 INCREMENT BY 1; CREATE OR REPLACE TRIGGER hhp_calendar BEFORE INSERT ON id FOR EACH ROW DECLARE v_id id%type; BEGIN SELECT uniqueNum_s.nextval INTO v_id FROM DUAL; :new.id = v_id; END; > 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 create a sequence, and then create > your table with a column called something like "ID" with a NUMBER > datatype, and when you insert new records into that table, the ID > column value becomes something like > (without the <>s). For more information about it, lookup SEQUENCE in > the Oracle SQL Reference. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Recovering a SQL Server 6.5 Device file?
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 can't just drop the drive into a new box and hope it'll work (it won't). And I'm not too concerned about the OS anyways, but I am concerned about the database files. Unfortunately the tech who last worked on this server was only backing up the database device file - not the databases themselves. We've done a pretty thorough search of MSDN and Google trying to figure out how to access the database in the device file - all with no luck. I'm confident the data is intact and good, but we just can't get access to it. The data includes billing information, so is considered critical. Luckily we did find a backup of the database from two weeks prior to the crash (guess the tech did a manual backup), so we're not hurting t bad. But we do need the data after the backup up till the date of the crash. Anyone have any tips or suggestions? Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cached queries
> 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 > includes an embedded tag. > > What's the best, least CPU-intensive solution to this problem? Use the CFQUERYPARAM and then store the query in the Application scope Best of both worlds [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cached queries
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 you may want to store an additional value (myQueryCreateDate) that stores when it was created. Each request check that and see if it's more than X minutes (seconds, hours, days) ago, and if it is, rerun the query. Cheers, barneyb > -Original Message- > From: Les Irvin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 19, 2004 2:29 PM > To: CF-Talk > Subject: Cached queries > > 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, least CPU-intensive solution to this problem? > > Thanks in advance for the help, > Les > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: return only 2 decimal places
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
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
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
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 batch since the following 'SQL Hack' that sends the data as one large insert takes less than 1 second (thanks to someone on the CFCDev list for this suggestion): INSERT INTO JONTEST (ID, Age) SELECT , FROM DUAL UNION ALL Unfortunately, I know of no similar hack for doing random UPDATE's. Jon >>> [EMAIL PROTECTED] 5/19/2004 4:28:38 AM >>> On Tuesday 18 May 2004 19:11 pm, Jon Gunnip wrote: > PreparedStatement stmt = conn.prepareStatement( "INSERT INTO Users > VALUES(?,?)"); > User[ ] users = ...; > for(int i=0; i > stmt.setInt(1, users[i].getName()); > stmt.setInt(2, users[i].getAge()); > stmt.addBatch( ); > } >>I don't see that being better than a cfloop'ed cfqueryparam'ed cfquery inside >>a cftransaction block. >>We don't see any scale issues with Oracle here - what have you seen ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Trim E-Mail Prefix
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.sky.com
tel: +44 (0) 20 7941 5329
fax: +44 (0) 20 7941 5243
_
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: 19 May 2004 20:47
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]
I want everything before the @... so: 'test'.
--
Jillian
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Trim E-Mail Prefix
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] I want everything before the @... so: 'test'. -- Jillian _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
oracle unique id or identity
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, header VARCHAR2(200), description VARCHAR2(3000), http VARCHAR2(100), image VARCHAR2(100), image_h INT, image_w INT ) He-elp. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: oracle unique id or identity
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 create a sequence, and then create your table with a column called something like "ID" with a NUMBER datatype, and when you insert new records into that table, the ID column value becomes something like (without the <>s). For more information about it, lookup SEQUENCE in the Oracle SQL Reference. <.YEX.> -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 4:09 PM To: CF-Talk Subject: oracle unique id or identity 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, header VARCHAR2(200), description VARCHAR2(3000), http VARCHAR2(100), image VARCHAR2(100), image_h INT, image_w INT ) He-elp. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: oracle unique id or identity
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
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 - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Barney Boisvert To: CF-Talk Sent: Wednesday, May 19, 2004 1:14 PM Subject: RE: Netscape 7 and window.open 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 > > Hey All, > > I'm banging my head against what should be a simple issue. > > I've got some code like so: > > > > 'scrollbars,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 work in NS 7.1 > and no errors > are shown in the _javascript_ console!!' > > Any ideas?? > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOLVED: Image Maps and Netscape 7
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] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Bryan Stevenson To: CF-Talk Sent: Wednesday, May 19, 2004 1:37 PM Subject: OT: Image Maps and Netscape 7 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 targets. If the hand doesn't show then of course clicking does nothing!! Any ideas? (been a long while since I did any image maps...did them via HomeSite+) Cheers 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 - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL: return only 2 decimal places
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? Shouldn't there be an easier way? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Netscape 7 and window.open
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 work in NS 7.1 and no errors >are shown in the _javascript_ console!!' > >Any ideas?? > Have you tried this? > ,width=450,height=500');" target="faq"> While some pop-up blokcers will stop it, you should still open the page. Simon Riley [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7 and window.open
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 of thing into a function.
function myPopup(myURL,myWinName) {
window.open(MyURL,myWinName,'scrollbars,width=450,height=500');
return false;
}
-Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 1:15 PM To: CF-Talk Subject: RE: Netscape 7 and window.open 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 > > Hey All, > > I'm banging my head against what should be a simple issue. > > I've got some code like so: > > > > 'scrollbars,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 work in NS 7.1 > and no errors > are shown in the _javascript_ console!!' > > Any ideas?? > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: oracle unique id or identity
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 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]
RE: oracle unique id or identity
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 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 create a sequence, and then create your table with a column called something like "ID" with a NUMBER datatype, and when you insert new records into that table, the ID column value becomes something like (without the <>s). For more information about it, lookup SEQUENCE in the Oracle SQL Reference. <.YEX.> -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 4:09 PM To: CF-Talk Subject: oracle unique id or identity 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, header VARCHAR2(200), description VARCHAR2(3000), http VARCHAR2(100), image VARCHAR2(100), image_h INT, image_w INT ) He-elp. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOLVED: Netscape 7 and window.open
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] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Bryan Stevenson To: CF-Talk Sent: Wednesday, May 19, 2004 12:34 PM Subject: OT: Netscape 7 and window.open 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 the _javascript_ console!!' Any ideas?? TIA Cheers 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 - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: oracle unique id or identity
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: 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 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 create a sequence, and then create your table with a column called something like "ID" with a NUMBER datatype, and when you insert new records into that table, the ID column value becomes something like (without the <>s). For more information about it, lookup SEQUENCE in the Oracle SQL Reference. <.YEX.> -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 4:09 PM To: CF-Talk Subject: oracle unique id or identity 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, header VARCHAR2(200), description VARCHAR2(3000), http VARCHAR2(100), image VARCHAR2(100), image_h INT, image_w INT ) He-elp. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Image Maps and Netscape 7
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 targets. If the hand doesn't show then of course clicking does nothing!! Any ideas? (been a long while since I did any image maps...did them via HomeSite+) Cheers 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 - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: return only 2 decimal places
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 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? Shouldn't there be an easier way? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: return only 2 decimal places
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 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 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 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? Shouldn't there be an >easier way? > > _ > >-- >[Todays Threads] >[This Message] >[Subscription] >[Fa st >Unsubscribe] [User Settings] > >-- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7 and window.open
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 > > Hey All, > > I'm banging my head against what should be a simple issue. > > I've got some code like so: > > > > 'scrollbars,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 work in NS 7.1 > and no errors > are shown in the _javascript_ console!!' > > Any ideas?? > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: oracle unique id or identity
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, event_date date, header VARCHAR2(200), description VARCHAR2(3000), http VARCHAR2(100), image VARCHAR2(100), image_h INT, image_w INT ); CREATE SEQUENCE uniqueNum_s START WITH 1 INCREMENT BY 1; CREATE OR REPLACE TRIGGER hhp_calendar BEFORE INSERT ON id FOR EACH ROW DECLARE v_id id%type; BEGIN SELECT uniqueNum_s.nextval INTO v_id FROM DUAL; :new.id = v_id; END; > 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 create a sequence, and then create > your table with a column called something like "ID" with a NUMBER > datatype, and when you insert new records into that table, the ID > column value becomes something like > (without the <>s). For more information about it, lookup SEQUENCE in > the Oracle SQL Reference. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfmx not picking up spooled messages
* 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, May 17, 2004 10:42 AM To: CF-Talk Subject: Re: cfmx not picking up spooled messages Sometimes the spool will get a zero byte message stuck at the top of the queue, and nothing behind it will send. Restarting may help, but you may have to go in and manually delete the junk message. At 10:39 AM 5/17/04, you wrote: > > All of the sudden on our production server (running CFMX 6.1) has > > stopped picking up spooled mail messages. There are no errors in the > > logs related to cfmail and no new entries in the mail log. In addition, > > new messages are being added to the spool folder and they are never > > moved into the undelivr folder, they just never send out. No settings > > have changed via the CF Administrator and everything is configured > > properly. Any ideas? Thanks. > > > > Mike > >We had the same problem: the spool dir got more and more messages, and no >spooler seemed to pick up any of them. > >Restart the CFMX service. Our spooler worked normally after this, and the >spool dir was empty in a minute. > >I guess CFMX 6.1 had reached an inconsistent state without reporting any >errors: I also found that after restarting the service we got a new >logfile "scheduled tasks", although I had defined several scheduled tasks >the day before. Without restarting the service they never would have been >started by CFMX. > >Dieter > >-- >[Todays Threads] >[This Message] >[Subscription] >[Fa st >Unsubscribe] [User Settings] > >-- >1d12e09.jpg _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: **UPDATE** Arrange sequential selections into ranges how to???
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: Cheers, barneyb > -Original Message- > From: Steve Nelson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 19, 2004 11:50 AM > To: CF-Talk > Subject: RE: **UPDATE** Arrange sequential selections into > ranges how to??? > > > > > > > > > > > > > > > > > > > > > > > newgroup="#groupstart#-#lastitem#"> > > > > > > > > > > > > > > > > #var2# > > > > I left out the lastitem=item > > > > Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: return only 2 decimal places
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 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 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? Shouldn't there be an >easier way? > > _ > >-- >[Todays Threads] >[This Message] >[Subscription] >[Fast >Unsubscribe] [User Settings] > >-- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Netscape 7 and window.open
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 >problem. Nope...I have also tried href="" and href="" (inside block thus the double #).thanks though ;-) 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 - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOLVED: JasperReports / CFMX
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 convert a Visual Basic application with embedded Crystal Reports and a shared Access database to using a web service for queries and report generation. Once we do that, we could probably relatively easily change the VB app to a Flash-based RIA and eliminate client installs completely =) - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ad weights
- 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 system has 8 free ads and 5 paying > ones. showing the paying ones multiple times (lets say 5 per) will result in 33 > total ads with the free ads having a 3% view rate and the pay having a 15%. Now > take it further. 90 free ads and 2 pay ads with the pay ads having the same 5 > per. This results in each free ad having 1% and the pay ads having 5%. Pay ads > are still higher, but if you look at the full numbers you see that 9 times out > of 10 a free ad will be shown. Not very economical. Neither were suggestions of how you should weight your ads, just how you might approach it. Probably the only monkey wrench in your situation are the free ads and the fact that a large number of them can take up a disproportianate percentage of your rotation. I think you've got two basic approaches. One, weight the paying ads very very heavily in relation to non-paying ads. For instance: Ad_ID Price Weight - -- -- 1 $0.00 1 2 $0.05 5000 3 $0.00 1 4 $0.01 1000 5 $5.00 50 6 $0.25 25000 But you can still run into the problem of a very large number of the free ads taking up perhaps more views in the rotation than you like. If that happened you'd have to go through and further bump up the weighting of the pay ads. The second approach (which you hinted at in your original posting) would be to make the weighting hierarchical. In your case you'd probably just need two levels. At the first level create two 'groups' - paying and non-paying ads. Throw all free ads into one group. You could weight the ads within the free group in relation to each other, but it's probably unnecessary and every ad could have an equal weight of '1'. Into the second group, have your paying ads, weighted relative only to other ads in the same group. Here you could probably just use a weighting in proportion to the price of each - a $1.00 ad with a weight 10x that of a $0.10 ad, for example. Then weight the groups relative to each other. Say paying ads 75%, non-paying 25% (or whatever). Then it doesn't matter how many non-paying ads you have, they always take up a known percentage of the views in your rotation. You're algorithm would make two picks - first select a group, then select an ad within the group. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Sort #FORM# by value?
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
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 -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 3:34 PM To: CF-Talk Subject: OT: Netscape 7 and window.open 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 work in NS 7.1 and no errors are shown in the _javascript_ console!!' Any ideas?? TIA Cheers 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 - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: modifying Word doc via CF
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 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 >Office products installed on the server (does require DSOFile, which is free >download from MS). > >Info and examples here: > >Integrating ColdFusion with Microsoft Office: Breezo and examples >http://www.rewindlife.com/archives/000118.cfm > >Best regards, > >Sam > > >Blog http://www.rewindlife.com >TeamMM http://www.macromedia.com/go/team > > > > -Original Message- > > From: Dave Jones [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, May 19, 2004 1:32 PM > > To: CF-Talk > > Subject: modifying Word doc via CF > > > > 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, my questions are: > > 1. does a solution exist which does not require using the > > Word COM object? > > 2. is it sufficient to install Word to get the COM object, or is > > Office required? > > > > TIA, > > Dave Jones > >-- >[Todays >Threads] >[This >Message] >[Subscription] >[Fast >Unsubscribe] [User Settings] > >-- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Netscape 7 and window.open
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 the _javascript_ console!!' Any ideas?? TIA Cheers 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 - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: Directory Tree crawler with file size sorting?
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 size sorting? 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 Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 10:53 AM To: CF-Talk Subject: RE: SOT: Directory Tree crawler with file size sorting? 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: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:25 AM To: CF-Talk Subject: Re: SOT: Directory Tree crawler with file size sorting? 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 you to sort by sizes, etc? > > My main goal is to find large files that exist on the drive that can > be deleted. Any tools or suggestions would be great. > > John Burns > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
class files
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 file has been made for, I found it, I think, I removed it, and now, I don't see the new code being generated. how does one do this? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: Directory Tree crawler with file size sorting?
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 Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 10:53 AM To: CF-Talk Subject: RE: SOT: Directory Tree crawler with file size sorting? 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: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:25 AM To: CF-Talk Subject: Re: SOT: Directory Tree crawler with file size sorting? 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 you to sort by sizes, etc? > > My main goal is to find large files that exist on the drive that can > be deleted. Any tools or suggestions would be great. > > John Burns > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Followup db query question (was XML/SOAP)
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 > >there are changes coming down the pike and I don't > want to change my code > >for every change in the tables. I was thinking of > something akin to > >Form.fieldnames/Form[field] for web forms. > > > > You can simply use queryName.ColumnList to get the > column names returned in > the set. Jezz I feel like a moron. I was mixing up getting the type (varchar etc) with the name :-/ good call Dave Embarrassingly, Rob O CH3 H3C || / \ / \ N N \/ \ | | // //\ / \ // O N N | CH3 http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: **UPDATE** Arrange sequential selections into ranges how to???
newgroup="#groupstart#-#lastitem#"> #var2# I left out the lastitem=item Steve _ From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 2:37 PM To: CF-Talk Subject: RE: **UPDATE** Arrange sequential selections into ranges how to??? 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 [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 19, 2004 11:26 AM > To: CF-Talk > Subject: RE: **UPDATE** Arrange sequential selections into > ranges how to??? > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: yahoo and selling fabric
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 decided to not use Yahoo and stick with who we had. As to control over look and design, I believe it's pretty flexible that way. It looked good to us until we found we couldn't customize the functionality of the catalog the way we wanted it. We should probably take this discussion off-list if you have more to ask me. Nancy -Original Message- From: Jeremy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:47 AM To: CF-Talk Subject: RE: yahoo and selling fabric 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 PROTECTED] Sent: Wednesday, May 19, 2004 12:18 PM To: CF-Talk Subject: RE: yahoo and selling fabric 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 of the online fabrics stores that I've used. Good luck and let me know when it's up. I'll definitely check it out. Nancy -Original Message- From: Jeremy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 9:43 AM To: CF-Talk Subject: yahoo and selling fabric 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 and it will most definitely be a huge time saver as compared to building it from scratch. And the price is right at 40 a month. I was wondering if anyone has had recent experience with setting up a yahoo store and if so how much control will I have over the look and design. This is my first solo stab at ecommerce and any comments would be great. Thanks a lot.. Jeremy Bunton www.jeremybunton.com _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Hosting Providers
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/cfdirectory/cfobject usable if requested Flash remoting available SQL 2000 on $30 per month plan -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: 19 May 2004 14:32 To: CF-Talk Subject: CFMX Hosting Providers Looking to change shared hostswho do you recommend and why? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: **UPDATE** Arrange sequential selections into ranges how to???
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 [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 19, 2004 11:26 AM > To: CF-Talk > Subject: RE: **UPDATE** Arrange sequential selections into > ranges how to??? > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Ranges *WOW*!!!
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 sent an email back to CFtalk. Rather than mess with the option I guess I should have said is it easier to manipulate the variable I'm sending to my action page that contains the list of selections. 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...how can I take any input from the variable and basically create a new varaible with the following: var2 = "1-14,20,25,30-33,50" Notice that if the numbers run consequtively they are "grouped" starting with first then last separated by a hyphen. Is this possible? I know what I want to do but its how to implement it. --Original Message Text--- From: Pascal Peters Date: Wed, 19 May 2004 19:48:22 +0200 Her are the files I used for testing. Works like a charm. Pascal Peters Certified ColdFusion MX Advanced Developer Macromedia Certified Instructor LR Technologies Av. E. De Mot, 19 1000 BRUSSELS, BELGIUM Tel: +32 2 639 68 70 Fax: +32 2 639 68 99 Email: [EMAIL PROTECTED] Web: www.lrt.be --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: **UPDATE** Arrange sequential selections into ranges how to???
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 [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 2:04 PM
To: CF-Talk
Subject: RE: **UPDATE** Arrange sequential selections into ranges how to???
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 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...how can I take
any input from the variable and basically create a new varaible with the
following:
var2 = "1-14,20,25,30-33,50"
Notice that if the numbers run consequtively they are "grouped" starting
with first then last separated by a hyphen.
Is this possible? I know what I want to do but its how to implement it.
>> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
On Wed, 19 May 2004 17:41:35 +0200, Pascal Peters wrote:
>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){
> val += ((val.length>0)?",":"") +
>opts[i].value;
> }
> else if(i==opts.length-1 ||
>!opts[i+1].selected){
> val += "-" + opts[i].value;
> }
> }
> }
> thisform.filelist.value = val;
> thisform.filelistselect.disabled = true;
>}
>
>
>
>Pascal
>
>
>>
>>
>> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
>>
>> >>
>> >>
>> >>
>> >>
>> >> "))>
>> >>
>> >> "))>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> Seq:
>> >> #sValNoComma# Folio: #sDisp##spacer1#
>> >>
>> >>
>> >>
>> >>
>
>
>
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Followup db query question (was XML/SOAP)
>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 every change in the tables. I was thinking of something akin to >Form.fieldnames/Form[field] for web forms. > You can simply use queryName.ColumnList to get the column names returned in the set. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Upgrading CF 4.5 to MX
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] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MX integration with Java
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.
On my local machine(we have not deployed any code to the UNIX machine yet) I am not able to set my cf server to recognize class changes without restarting the server.
I did my TRUE According to this document.
http://www.macromedia.com/support/coldfusion/ts/documents/tn18228.htm
currently my jrun-web.xml looks liks this
TRUE
/WEB-INF
C:/CFusionMX/wwwroot/WEB-INF
Whenenver i copy a new jar file into the WEB-INF/lib folder i get a
method not found exception(The selected method X was not found). When I restart the CF server it works fine.
On searching more on MM I found this.
http://www.macromedia.com/support/jrun/ts/documents/cfmx_helper_reload.htm
>From this document it seems like that only Servlet and JSP helper classes can be reloaded automatically with the above setting.
So that means in my case I have to restart my CF server everytime i change a class file? Correct me if I am wrong.
>From your post I thought you were able to get automatic class reloading to work for Java classes being called from CFM files.
Can you please explain how you got reloading to work in your case.
> Bob,
> I've developed an application for a client using Mach-II with CF
> handling the View-Controller and Java handling the Model. Works
> great, but there were a few issues I had to untangle to get the
> pieces working together (note: my notes apply to CFMX Standard only):
>
> - the Java classes must reside in the CF web root, or possibly in
> a classpath defined in the CF administrator. That has a couple
> consequences:
> 1. you can't run your hybrid apps on a shared host
> 2. you have to be careful with naming conventions and shared
> classes between apps because all the classes will reside under
> the same root. Not as neat and tidy as pure Java web apps.
>
> - in addition, to get CF to recognize changes to the Java
> classes, you have to add
> true
> true
> to in webroot/WEB-INF/jrun-web.xml
>
> - CF uses log4j 1.1.3, so your Java code must too. Big bummer,
> particularly since log4j 1.3 purportedly will resolve a log
> archiving problem on Windows. Also, this suggests the possibility
> of big conflicts down the road. If my Java code uses a
> third-party library and a future release of CF incorporates a
> different version of that library, it seems very possible that my
> code will no longer work if the api of CF's version of the
> library is different.
>
> - unlike Tomcat, JRun/CF won't automatically locate your log4j
> properties file, so you need to manually specifiy its location,
> e.g.:
> PropertyConfigurator.
> configure("d:/CFusionMX/wwwroot/WEB-INF/classes/log4j.properties").
> (Note: this may be due to CF using its own log4j property file)
>
> - I never could get coldfusion.sql.QueryTable working properly in
> Java. If the resultSet contained 10 or more records, it threw a
> coldfusion.server.ServiceFactory$ServiceNotAvailableException.
> Instead, I wrote a UDF which converts the resultSets into a Query.
>
> - the lack of support of nulls is a pain. My workaround is to
> assign the results of a Java method call to a variable, then test
> is the variable exists. Seems to work, but I haven't tested it
> thoroughly.
>
> Good luck. Let me know if you have any questions. It may seem
> like a lot of work to get Java and CFMX working together, but
> once you get the kinks ironed out it runs smoothly and the
> benefits are well worth it.
>
> Dave Jones
> NetEffect
>
>
> At 10:07 AM 5/6/04 -0500, you wrote:
> >We're considering implementing an application that uses java on
> >the backend side (business logic, etc) and MX as the front end.
> >What issues have people come across with respect to MX's
> >integration with java? For example, since MX doesn't support
> >null values java methods should be written such that null
> >parameters aren't allowed (e.g. - if needed create a special
> >method setObjectToNull). Personally I think MX should support
> >null values, but that's an argument for another thread. On a
> >side note - in 6.0 I ran across a bug where MX didn't convert
> >null values to the empty string correctly. However, this has been
> fixed in 6.1.
> >
> >What other integration issues are out there?
> >
> >Thanks,
> >Bob
> >
> >--
> >[Todays
> >Threads]
> >[This
> >Message]
> >[Subscription]
> >[
> 1130.4>Fast
> >Unsubscribe] [User Settings]
> >
> >--
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: MX integration with Java
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. On my local machine(we have not deployed any code to the UNIX machine yet) I am not able to set my cf server to recognize class changes without restarting the server. I did my TRUE According to this document. http://www.macromedia.com/support/coldfusion/ts/documents/tn18228.htm currently my jrun-web.xml looks liks this TRUE /WEB-INF C:/CFusionMX/wwwroot/WEB-INF Whenenver i copy a new jar file into the WEB-INF/lib folder i get a method not found exception(The selected method X was not found). When I restart the CF server it works fine. On searching more on MM I found this. http://www.macromedia.com/support/jrun/ts/documents/cfmx_helper_reload.htm >From this document it seems like that only Servlet and JSP helper classes can be reloaded automatically with the above setting. So that means in my case I have to restart my CF server everytime i change a class file? Correct me if I am wrong. >From your post I thought you were able to get automatic class reloading to work for Java classes being called from CFM files. Can you please explain how you got reloading to work in your case. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: **UPDATE** Arrange sequential selections into ranges how to???
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 Message-
> From: Nathan R. Jessop [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 19, 2004 10:57 AM
> 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 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...how can I take any input from the variable and
> basically create a new varaible with the following:
>
>
> var2 = "1-14,20,25,30-33,50"
>
> Notice that if the numbers run consequtively they are
> "grouped" starting with first then last separated by a hyphen.
>
> Is this possible? I know what I want to do but its how to
> implement it.
>
>
>
> >> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
>
> On Wed, 19 May 2004 17:41:35 +0200, Pascal Peters wrote:
>
> >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){
> >val += ((val.length>0)?",":"") +
> >opts[i].value;
> > }
> > else if(i==opts.length-1 ||
> >!opts[i+1].selected){
> >val += "-" + opts[i].value;
> > }
> > }
> > }
> > thisform.filelist.value = val;
> > thisform.filelistselect.disabled = true;
> >}
> >
> >
> >
> >Pascal
> >
> >
> >>
> >>
> >> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
> >>
> >> >>
> class="dirlinks">
> >> >>
> >> >>
> TO="#ArrayLen(arPages)#">
> >> >>
> >> >> "))>
> >> >>
> >> >> "))>
> >> >>
> >> >>
> "99")>
> >> >>
> >> >>
> >> >>
> >> >> Seq:
> >> >> #sValNoComma# Folio: #sDisp##spacer1#
> >> >>
> >> >>
> >> >>
> >> >>
> >
> >
> >
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: **UPDATE** Arrange sequential selections into ranges how to???
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 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...how can I take
any input from the variable and basically create a new varaible with the
following:
var2 = "1-14,20,25,30-33,50"
Notice that if the numbers run consequtively they are "grouped" starting
with first then last separated by a hyphen.
Is this possible? I know what I want to do but its how to implement it.
>> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
On Wed, 19 May 2004 17:41:35 +0200, Pascal Peters wrote:
>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){
> val += ((val.length>0)?",":"") +
>opts[i].value;
> }
> else if(i==opts.length-1 ||
>!opts[i+1].selected){
> val += "-" + opts[i].value;
> }
> }
> }
> thisform.filelist.value = val;
> thisform.filelistselect.disabled = true;
>}
>
>
>
>Pascal
>
>
>>
>>
>> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
>>
>> >>
>> >>
>> >>
>> >>
>> >> "))>
>> >>
>> >> "))>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> Seq:
>> >> #sValNoComma# Folio: #sDisp##spacer1#
>> >>
>> >>
>> >>
>> >>
>
>
>
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Followup db query question (was XML/SOAP)
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 are changes coming down the pike and I don't want > to change my code > for every change in the tables. I was thinking of > something akin to > Form.fieldnames/Form[field] for web forms. What type of database are you using? Some databases have the ability to return queries as XML. M$SQL 2K has the "for xml" options and Oracle (I think) has something similar... just thought I'd throw that out there. Your looking for the query meta data btw that may help with your seaching. I've done it before but I dont have the code handy (here at work) so I am a bit useless on that front. O CH3 H3C || / \ / \ N N \/ \ | | // //\ / \ // O N N | CH3 http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: modifying Word doc via CF
> 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???
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 sent you a sample form and action page that worked for me off list. Pascal > -Original Message- > From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] > Sent: woensdag 19 mei 2004 18:27 > To: CF-Talk > Subject: RE: Arrange sequential selections into ranges how to??? > > 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. > > 1,2,3,4,5,6,7,8,9,15,16,17,18,19,25 > > What I want to appear is this: > > 1-9,15-19,25 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 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...how can I take any input from the variable and basically create a new varaible with the following:
var2 = "1-14,20,25,30-33,50"
Notice that if the numbers run consequtively they are "grouped" starting with first then last separated by a hyphen.
Is this possible? I know what I want to do but its how to implement it.
>> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
On Wed, 19 May 2004 17:41:35 +0200, Pascal Peters wrote:
>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){
>val += ((val.length>0)?",":"") +
>opts[i].value;
> }
> else if(i==opts.length-1 ||
>!opts[i+1].selected){
>val += "-" + opts[i].value;
> }
> }
> }
> thisform.filelist.value = val;
> thisform.filelistselect.disabled = true;
>}
>
>
>
>Pascal
>
>
>>
>>
>> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
>>
>> >>
>> >>
>> >>
>> >>
>> >> "))>
>> >>
>> >> "))>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> Seq:
>> >> #sValNoComma# Folio: #sDisp##spacer1#
>> >>
>> >>
>> >>
>> >>
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: yahoo and selling fabric
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 PROTECTED] Sent: Wednesday, May 19, 2004 12:18 PM To: CF-Talk Subject: RE: yahoo and selling fabric 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 of the online fabrics stores that I've used. Good luck and let me know when it's up. I'll definitely check it out. Nancy -Original Message- From: Jeremy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 9:43 AM To: CF-Talk Subject: yahoo and selling fabric 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 and it will most definitely be a huge time saver as compared to building it from scratch. And the price is right at 40 a month. I was wondering if anyone has had recent experience with setting up a yahoo store and if so how much control will I have over the look and design. This is my first solo stab at ecommerce and any comments would be great. Thanks a lot.. Jeremy Bunton www.jeremybunton.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: modifying Word doc via CF
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 Office products installed on the server (does require DSOFile, which is free download from MS). Info and examples here: Integrating ColdFusion with Microsoft Office: Breezo and examples http://www.rewindlife.com/archives/000118.cfm Best regards, Sam Blog http://www.rewindlife.com TeamMM http://www.macromedia.com/go/team > -Original Message- > From: Dave Jones [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 19, 2004 1:32 PM > To: CF-Talk > Subject: modifying Word doc via CF > > 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, my questions are: > 1. does a solution exist which does not require using the > Word COM object? > 2. is it sufficient to install Word to get the COM object, or is > Office required? > > TIA, > Dave Jones [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Followup db query question (was XML/SOAP)
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 every change in the tables. I was thinking of something akin to Form.fieldnames/Form[field] for web forms. Thx for the help... -- Joe Tseng Give a man a fish, he owes you one fish. Teach a man to fish, you give up your monopoly on fisheries. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Where are my java errors?
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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Where are my java errors?
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\jasperreports\ProfServFaq.xml");
jasperReport = jasperManager.compileReport(jasperDesign);
The jasperManager object is instantiated successfully.
The XML report design is loaded successfully.
Then, when compiling the report design, I get an error message, which is
at the end of this message. Basically it says compilation failed,
errors occurred. See errors above.
BUT THERE ARE NO ERRORS ABOVE.
When I compile the report using the iReports report designer tool, I saw
this same message in the output, but there were other error messages.
Presumably, stuff written to stdout or something like that, but they are
not actually exceptions, they're error messages printed out by the
compiler, and then the compiler throws an exception if there were any
errors.
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.
I know it's a stretch, but does anyone here have any idea how I might
find those errors?
(Yes, I will also ask on the jasper reports list)
- Rick
"Error","jrpp-0","05/19/04","13:06:04","ADSWEB","Errors were encountered
when compiling report expressions class file: See error messages above.
The specific sequence of files included or processed is:
E:\Inetpub\wwwroot\jasperreports\index.cfm "
dori.jasper.engine.JRException: Errors were encountered when compiling
report expressions class file:
See error messages above.
at
dori.jasper.engine.design.JRAbstractJavaCompiler.compileReport(JRAbstractJavaCompiler.java:154)
at
dori.jasper.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:136)
at
dori.jasper.engine.JasperCompileManager.compileReport(JasperCompileManager.java:196)
at dori.jasper.engine.JasperManager.compileReport(JasperManager.java:982)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:74)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1622)
at
cfindex2ecfm564073538.runPage(E:\Inetpub\wwwroot\jasperreports\index.cfm:37)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: MS SQL Syntax/Keyword
> 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 end, then compare your value with a comma at either end - if you just look for the number, then "1" will return anything that contains a "1" Oh, and CFQUERYPARAM!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
modifying Word doc via CF
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, my questions are: 1. does a solution exist which does not require using the Word COM object? 2. is it sufficient to install Word to get the COM object, or is Office required? TIA, Dave Jones NetEffect [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MS SQL Syntax/Operator
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, May 19, 2004 11:23 AM To: CF-Talk Subject: MS SQL Syntax/Operator 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 find all rows where the current GroupID is either the groupID on a row or is IN the sharedGroupIDs column for that row. Here's 2 separate syntaxes I've used and the results I've gotten: select * from table where #groupID# = groupID or #groupID# IN (sharedGroupIDs) The above returns an error because SQL says it can't convert the SharedGroupIDs column to type of INT. When reading about the IN keyword, it says that the datatypes you're comparing have to match, so I tried the following: select * from table where #groupID# = groupID or '#groupID#' IN (sharedGroupIDs) Notice the single quotes around #groupID# so that it should be seen as a string. This doesn't produce and error, but it does not return any records. A simple data test that I'm trying is #groupID# = 5 and in the SharedGroupIDs column I have this string: 15,7,5 Any ideas on why this isn't working? Any suggestions? Maybe another keyword or something I could use to produce these results? Also, just to stop unneeded responses, I can't use LIKE because if the value I'm searching for is 1 is and 15 is in the column, it will return true because there is a 1 and that's not what I'm looking for. Please help! :-) John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MS SQL Syntax/Keyword
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
value. Consider this scenario:
Groupids contains "15,17,7,9"
You have a single groupID of 17. You would think that groupids IN (17) would return true - nope..because "15,17,7,9"
does NOT equal "17". SQL is not going to treat a single column with delimited lists in it as if it were a query or
group of values. To SQL "15,17,7,9" is a single value - not 4 values.
Now, you can use "like" to maybe futz with this so you could do
where groupids LIKE ('%,17,%) OR groupids LIKE (17,%) or groupIds LIKE (%,17)
But that is a poor excuse for a query (ha). You have to account for wether the 17 is in the middle, end or
beginning...AND that is still not perfect.
A better choice would probably be a second table of groupids mapping your permissionsthen your query becomes
where groupid IN
(select groupId from relatedGroups where groupid IN (17,2,0) )
Or you can join it as well...
I hope this helps.
-Mark
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 11:24 AM
To: CF-Talk
Subject: MS SQL Syntax/Keyword
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 find all rows where the current GroupID is either the
groupID on a row or is IN the sharedGroupIDs column for that row.
Here's 2 separate syntaxes I've used and the results I've gotten:
select *
from table
where #groupID# = groupID or #groupID# IN (sharedGroupIDs)
The above returns an error because SQL says it can't convert the
SharedGroupIDs column to type of INT. When reading about the IN
operator, it says that the datatypes you're comparing have to match, so
I tried the following:
select *
from table
where #groupID# = groupID or '#groupID#' IN (sharedGroupIDs)
Notice the single quotes around #groupID# so that it should be seen as a
string. This doesn't produce and error, but it does not return any
records. A simple data test that I'm trying is #groupID# = 5 and in the
SharedGroupIDs column I have this string: 15,7,5
Any ideas on why this isn't working? Any suggestions? Maybe another
operator
Also, just to stop unneeded responses, I can't use LIKE because if the
value I'm searching for is 1 is and 15 is in the column, it will return
true because there is a 1 and that's not what I'm looking for.
Please help! :-)
John Burns
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: MS SQL Syntax/Operator
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 had problems. John -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 12:30 PM To: CF-Talk Subject: Re: MS SQL Syntax/Operator 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 >holds a string of IDs that also can see the record. I'm trying to use >the IN keyword to find all rows where the current GroupID is either the >groupID on a row or is IN the sharedGroupIDs column for that row. >Here's 2 separate syntaxes I've used and the results I've gotten: > >select * >from table >where #groupID# = groupID or #groupID# IN (sharedGroupIDs) > >The above returns an error because SQL says it can't convert the >SharedGroupIDs column to type of INT. When reading about the IN >keyword, it says that the datatypes you're comparing have to match, so >I tried the following: > >select * >from table >where #groupID# = groupID or '#groupID#' IN (sharedGroupIDs) > >Notice the single quotes around #groupID# so that it should be seen as >a string. This doesn't produce and error, but it does not return any >records. A simple data test that I'm trying is #groupID# = 5 and in >the SharedGroupIDs column I have this string: 15,7,5 > >Any ideas on why this isn't working? Any suggestions? Maybe another >keyword or something I could use to produce these results? > >Also, just to stop unneeded responses, I can't use LIKE because if the >value I'm searching for is 1 is and 15 is in the column, it will return >true because there is a 1 and that's not what I'm looking for. > >Please help! :-) > >John Burns > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MS SQL Syntax/Operator
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 >holds a string of IDs that also can see the record. I'm trying to use >the IN keyword to find all rows where the current GroupID is either the >groupID on a row or is IN the sharedGroupIDs column for that row. >Here's 2 separate syntaxes I've used and the results I've gotten: > >select * >from table >where #groupID# = groupID or #groupID# IN (sharedGroupIDs) > >The above returns an error because SQL says it can't convert the >SharedGroupIDs column to type of INT. When reading about the IN >keyword, it says that the datatypes you're comparing have to match, so I >tried the following: > >select * >from table >where #groupID# = groupID or '#groupID#' IN (sharedGroupIDs) > >Notice the single quotes around #groupID# so that it should be seen as a >string. This doesn't produce and error, but it does not return any >records. A simple data test that I'm trying is #groupID# = 5 and in the >SharedGroupIDs column I have this string: 15,7,5 > >Any ideas on why this isn't working? Any suggestions? Maybe another >keyword or something I could use to produce these results? > >Also, just to stop unneeded responses, I can't use LIKE because if the >value I'm searching for is 1 is and 15 is in the column, it will return >true because there is a 1 and that's not what I'm looking for. > >Please help! :-) > >John Burns > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MS SQL Syntax/Keyword
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 find all rows where the current GroupID is either the groupID on a row or is IN the sharedGroupIDs column for that row. Here's 2 separate syntaxes I've used and the results I've gotten: select * from table where #groupID# = groupID or #groupID# IN (sharedGroupIDs) The above returns an error because SQL says it can't convert the SharedGroupIDs column to type of INT. When reading about the IN operator, it says that the datatypes you're comparing have to match, so I tried the following: select * from table where #groupID# = groupID or '#groupID#' IN (sharedGroupIDs) Notice the single quotes around #groupID# so that it should be seen as a string. This doesn't produce and error, but it does not return any records. A simple data test that I'm trying is #groupID# = 5 and in the SharedGroupIDs column I have this string: 15,7,5 Any ideas on why this isn't working? Any suggestions? Maybe another operator Also, just to stop unneeded responses, I can't use LIKE because if the value I'm searching for is 1 is and 15 is in the column, it will return true because there is a 1 and that's not what I'm looking for. Please help! :-) John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Arrange sequential selections into ranges how to???
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.
1,2,3,4,5,6,7,8,9,15,16,17,18,19,25
What I want to appear is this:
1-9,15-19,25
On Wed, 19 May 2004 17:41:35 +0200, Pascal Peters wrote:
>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){
>val += ((val.length>0)?",":"") +
>opts[i].value;
> }
> else if(i==opts.length-1 ||
>!opts[i+1].selected){
>val += "-" + opts[i].value;
> }
> }
> }
> thisform.filelist.value = val;
> thisform.filelistselect.disabled = true;
>}
>
>
>
>Pascal
>
>
>>
>>
>> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
>>
>> >>
>> >>
>> >>
>> >>
>> >> "))>
>> >>
>> >> "))>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> Seq:
>> >> #sValNoComma# Folio: #sDisp##spacer1#
>> >>
>> >>
>> >>
>> >>
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
MS SQL Syntax/Operator
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 find all rows where the current GroupID is either the groupID on a row or is IN the sharedGroupIDs column for that row. Here's 2 separate syntaxes I've used and the results I've gotten: select * from table where #groupID# = groupID or #groupID# IN (sharedGroupIDs) The above returns an error because SQL says it can't convert the SharedGroupIDs column to type of INT. When reading about the IN keyword, it says that the datatypes you're comparing have to match, so I tried the following: select * from table where #groupID# = groupID or '#groupID#' IN (sharedGroupIDs) Notice the single quotes around #groupID# so that it should be seen as a string. This doesn't produce and error, but it does not return any records. A simple data test that I'm trying is #groupID# = 5 and in the SharedGroupIDs column I have this string: 15,7,5 Any ideas on why this isn't working? Any suggestions? Maybe another keyword or something I could use to produce these results? Also, just to stop unneeded responses, I can't use LIKE because if the value I'm searching for is 1 is and 15 is in the column, it will return true because there is a 1 and that's not what I'm looking for. Please help! :-) John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: yahoo and selling fabric
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 of the online fabrics stores that I've used. Good luck and let me know when it's up. I'll definitely check it out. Nancy -Original Message- From: Jeremy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 9:43 AM To: CF-Talk Subject: yahoo and selling fabric 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 and it will most definitely be a huge time saver as compared to building it from scratch. And the price is right at 40 a month. I was wondering if anyone has had recent experience with setting up a yahoo store and if so how much control will I have over the look and design. This is my first solo stab at ecommerce and any comments would be great. Thanks a lot.. Jeremy Bunton www.jeremybunton.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Arrange sequential selections into ranges how to???
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",
>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){
>val += ((val.length>0)?",":"") +
>opts[i].value;
> }
> else if(i==opts.length-1 ||
>!opts[i+1].selected){
>val += "-" + opts[i].value;
> }
> }
> }
> thisform.filelist.value = val;
> thisform.filelistselect.disabled = true;
>}
>
>
>
>Pascal
>
>
>>
>>
>> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
>>
>> >>
>> >>
>> >>
>> >>
>> >> "))>
>> >>
>> >> "))>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> Seq:
>> >> #sValNoComma# Folio: #sDisp##spacer1#
>> >>
>> >>
>> >>
>> >>
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Sybase Adaptive Server ver 8
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
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, May 19, 2004 11:45 AM 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 _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:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 10:56 AM To: CF-Talk Subject: RE: passing a form field #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 field to another form when the user clicks submit. I have it in a hidden field but of course this does not work: Tried: #Evaluate(count)# How would that fit in? Thx. Robert O. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: Directory Tree crawler with file size sorting?
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: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:25 AM To: CF-Talk Subject: Re: SOT: Directory Tree crawler with file size sorting? 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 you to sort by sizes, etc? > > My main goal is to find large files that exist on the drive that can > be deleted. Any tools or suggestions would be great. > > John Burns > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing a form field
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 _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:[EMAIL PROTECTED] > Sent: Wednesday, May 19, 2004 10:56 AM > To: CF-Talk > Subject: RE: passing a form field > > > #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 field to another form when the user clicks submit. I > have it in a hidden field but of course this does not work: > > name="qty#count#"> > > Tried: #Evaluate(count)# > > How would that fit in? > > Thx. > > Robert O. > _ > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing a form field
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:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 10:56 AM To: CF-Talk Subject: RE: passing a form field #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 field to another form when the user clicks submit. I have it in a hidden field but of course this does not work: Tried: #Evaluate(count)# How would that fit in? Thx. Robert O. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
yahoo and selling fabric
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 and it will most definitely be a huge time saver as compared to building it from scratch. And the price is right at 40 a month. I was wondering if anyone has had recent experience with setting up a yahoo store and if so how much control will I have over the look and design. This is my first solo stab at ecommerce and any comments would be great. Thanks a lot.. Jeremy Bunton www.jeremybunton.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Hosting Providers
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 PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 19 May 2004 11:10:52 -0400 >>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???
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){
val += ((val.length>0)?",":"") +
opts[i].value;
}
else if(i==opts.length-1 ||
!opts[i+1].selected){
val += "-" + opts[i].value;
}
}
}
thisform.filelist.value = val;
thisform.filelistselect.disabled = true;
}
Pascal
>
>
> I need to pass it like 1-16,23-25,30,33,40-42,46-48 to the server.
>
> >>
> >>
> >>
> >>
> >> "))>
> >>
> >> "))>
> >>
> >>
> >>
> >>
> >>
> >> Seq:
> >> #sValNoComma# Folio: #sDisp##spacer1#
> >>
> >>
> >>
> >>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CFHTTP problems!
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 run into this? -- Alex Sherwood PHS Collection Agency THE COLLECTORS P: 813-283-4579 F: 301.664.6834 W: www.phs-net.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MX integration with Java
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. On my local machine(we have not deployed any code to the UNIX machine yet) I am not able to set my cf server to recognize class changes without restarting the server. I did my TRUE According to this document. http://www.macromedia.com/support/coldfusion/ts/documents/tn18228.htm currently my jrun-web.xml looks liks this TRUE /WEB-INF C:/CFusionMX/wwwroot/WEB-INF Whenenver i copy a new jar file into the WEB-INF/lib folder i get a method not found exception(The selected method X was not found). When I restart the CF server it works fine. On searching more on MM I found this. http://www.macromedia.com/support/jrun/ts/documents/cfmx_helper_reload.htm >From this document it seems like that only Servlet and JSP helper classes can be reloaded automatically with the above setting. So that means in my case I have to restart my CF server everytime i change a class file? Correct me if I am wrong. >From your post I thought you were able to get automatic class reloading to work for Java classes being called from CFM files. Can you please explain how you got reloading to work in your case. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Directory Tree crawler with file size sorting?
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 you to sort by sizes, etc? > > My main goal is to find large files that exist on the drive that can be > deleted. Any tools or suggestions would be great. > > John Burns > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX doc root as a Mounted Volume
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, so yes, some, but raise the number of > cached > template files in the administrator to the number of templates in your > app > and it'll be OK. Well my next question is: If the file server goes down will CF continue to access the compiled versions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Hosting Providers
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 one using a reseller package they are happy with? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Version Management Inquiry
> 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.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Version Management Inquiry
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 coldfusion developer and I > am wondering how other small groups deal with the item of 2 or so > developers working on the same overall project. How does these small groups > make sure that files with changes do not get overwritten and have work > losts. At the present time, we are just communicating and blocking out time > where we will not be in a specific file or directory so the changes made > will not be lost or overwritten? Until a few months ago I was using CVS, but I am migrating to Subversion and I am superhappy: http://subversion.tigris.org/ I use this as GUI: http://tortoisesvn.tigris.org/ Fundamental reading: http://svnbook.red-bean.com/ Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Hosting Providers
>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???
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 Message- >> From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] >> Sent: woensdag 19 mei 2004 17:00 >> To: CF-Talk >> Subject: re: Arrange sequential selections into ranges how to??? >> >> 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 . . . 021.00 points free >> 003>folio: 2252 . . . 001.00 points free >> 004>folio: 2253 . . . 011.00 points free >> 005>folio: 2254 . . . 001.00 points free >> 006>folio: 2255 . . . 001.00 points free >> 007>folio: 2256 . . . 213.00 points free >> 008>folio: 2301 . . . 412.00 points free >> 009>folio: 2305 . . . 202.00 points free >> 010>folio: 2311 . . . 009.00 points free >> 011>folio: 2312 . . . 003.00 points free >> 012>folio: 2313 . . . 000.50 points free >> 013>folio: 2314 . . . 006.50 points free >> 014>folio: 2315 . . . 321.50 points free >> 015>folio: 2317 . . . 008.00 points free >> 016>folio: 2318 . . . 006.50 points free >> 017>folio: 2319 . . . 230.50 points free >> 018>folio: 2325 . . . 000.00 points free >> 019>folio: 2326 . . . 001.00 points free >> 020>folio: 2327 . . . 202.50 points free >> 021>folio: 2335 . . . 007.00 points free >> 022>folio: 2336 . . . 012.00 points free >> 023>folio: 2337 . . . 001.50 points free >> 024>folio: 2338 . . . 010.00 points free >> 025>folio: 2339 . . . 004.00 points free >> 026>folio: 2340 . . . 012.50 points free >> 027>folio: 2341 . . . 001.50 points free >> 028>folio: 2342 . . . 007.50 points free >> 029>folio: 2343 . . . 001.50 points free >> 030>folio: 2344 . . . 007.50 points free >> 031>folio: 2345 . . . 022.00 points free >> >> I then loop through the file and display the results in a . >> >> >> It would display something like this: >> >> Seq: 1 Folio: 2201 >> Seq: 2 Folio: 2202 >> Seq: 3 Folio: 2203 >> Seq: 4 Folio: 2204 >> Seq: 5 Folio: 2205 >> Seq: 6 Folio: 2206 >> Seq: 7 Folio: 2207 >> ...and so on... >> >> >> From here the user can select all the pages or individual >> selections using the Shift or Ctrl keys. The results are >> passed to my action page as a comma delimiited list >> (variable) and fed into the program. At times the user >> selsection can be VERY large and the program barfs because it >> can't handle such a large string. >> >> So this is my question. How can I arrange sequential >> selections into ranges. Meaning is a user selects the first >> 50 pages. Currently when the selection gets passed to my >> action page the results would be: >> >> 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24 >> ,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,4 >> 5,46,47,48,49,50 >> >> How can I make the above get passed as: >> >> 1-50? >> >> and if the selection happended to be: >> >> 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,23,24,25,30,33,40,41,42 >> ,46,47,48 >> >> How can I make the above get passed as this: >> >> 1-16,23-25,30,33,40-42,46-48 >> >> The below code generate the listing like: >> >> Seq: 1 Folio: 2201 >> Seq: 2 Folio: 2202 >> Seq: 3 Folio: 2203 >> Seq: 4 Folio: 2204 >> Seq: 5 Folio: 2205 >> Seq: 6 Folio: 2206 >> Seq: 7 Folio: 2207 >> ...and so on... >> >> >> >> >> >> "))> >> >> "))> >> >> >> >> >> >> Seq: >> #sValNoComma# Folio: #sDisp##spacer1# >> >> >> >> >> >> >> >> >> >> >> >> --- >> Colonel Nathan R. Jessop >> Commanding Officer >> Marine Ground Forces >> Guatanamo Bay, Cuba >> > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Arrange sequential selections into ranges how to???
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 sequential selections into ranges how to??? > > 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 . . . 021.00 points free > 003>folio: 2252 . . . 001.00 points free > 004>folio: 2253 . . . 011.00 points free > 005>folio: 2254 . . . 001.00 points free > 006>folio: 2255 . . . 001.00 points free > 007>folio: 2256 . . . 213.00 points free > 008>folio: 2301 . . . 412.00 points free > 009>folio: 2305 . . . 202.00 points free > 010>folio: 2311 . . . 009.00 points free > 011>folio: 2312 . . . 003.00 points free > 012>folio: 2313 . . . 000.50 points free > 013>folio: 2314 . . . 006.50 points free > 014>folio: 2315 . . . 321.50 points free > 015>folio: 2317 . . . 008.00 points free > 016>folio: 2318 . . . 006.50 points free > 017>folio: 2319 . . . 230.50 points free > 018>folio: 2325 . . . 000.00 points free > 019>folio: 2326 . . . 001.00 points free > 020>folio: 2327 . . . 202.50 points free > 021>folio: 2335 . . . 007.00 points free > 022>folio: 2336 . . . 012.00 points free > 023>folio: 2337 . . . 001.50 points free > 024>folio: 2338 . . . 010.00 points free > 025>folio: 2339 . . . 004.00 points free > 026>folio: 2340 . . . 012.50 points free > 027>folio: 2341 . . . 001.50 points free > 028>folio: 2342 . . . 007.50 points free > 029>folio: 2343 . . . 001.50 points free > 030>folio: 2344 . . . 007.50 points free > 031>folio: 2345 . . . 022.00 points free > > I then loop through the file and display the results in a . > > > It would display something like this: > > Seq: 1 Folio: 2201 > Seq: 2 Folio: 2202 > Seq: 3 Folio: 2203 > Seq: 4 Folio: 2204 > Seq: 5 Folio: 2205 > Seq: 6 Folio: 2206 > Seq: 7 Folio: 2207 > ...and so on... > > > From here the user can select all the pages or individual > selections using the Shift or Ctrl keys. The results are > passed to my action page as a comma delimiited list > (variable) and fed into the program. At times the user > selsection can be VERY large and the program barfs because it > can't handle such a large string. > > So this is my question. How can I arrange sequential > selections into ranges. Meaning is a user selects the first > 50 pages. Currently when the selection gets passed to my > action page the results would be: > > 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24 > ,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,4 > 5,46,47,48,49,50 > > How can I make the above get passed as: > > 1-50? > > and if the selection happended to be: > > 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,23,24,25,30,33,40,41,42 > ,46,47,48 > > How can I make the above get passed as this: > > 1-16,23-25,30,33,40-42,46-48 > > The below code generate the listing like: > > Seq: 1 Folio: 2201 > Seq: 2 Folio: 2202 > Seq: 3 Folio: 2203 > Seq: 4 Folio: 2204 > Seq: 5 Folio: 2205 > Seq: 6 Folio: 2206 > Seq: 7 Folio: 2207 > ...and so on... > > > > > > "))> > > "))> > > > > > > Seq: > #sValNoComma# Folio: #sDisp##spacer1# > > > > > > > > > > > > --- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: Arrange sequential selections into ranges how to???
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 . . . 021.00 points free 003>folio: 2252 . . . 001.00 points free 004>folio: 2253 . . . 011.00 points free 005>folio: 2254 . . . 001.00 points free 006>folio: 2255 . . . 001.00 points free 007>folio: 2256 . . . 213.00 points free 008>folio: 2301 . . . 412.00 points free 009>folio: 2305 . . . 202.00 points free 010>folio: 2311 . . . 009.00 points free 011>folio: 2312 . . . 003.00 points free 012>folio: 2313 . . . 000.50 points free 013>folio: 2314 . . . 006.50 points free 014>folio: 2315 . . . 321.50 points free 015>folio: 2317 . . . 008.00 points free 016>folio: 2318 . . . 006.50 points free 017>folio: 2319 . . . 230.50 points free 018>folio: 2325 . . . 000.00 points free 019>folio: 2326 . . . 001.00 points free 020>folio: 2327 . . . 202.50 points free 021>folio: 2335 . . . 007.00 points free 022>folio: 2336 . . . 012.00 points free 023>folio: 2337 . . . 001.50 points free 024>folio: 2338 . . . 010.00 points free 025>folio: 2339 . . . 004.00 points free 026>folio: 2340 . . . 012.50 points free 027>folio: 2341 . . . 001.50 points free 028>folio: 2342 . . . 007.50 points free 029>folio: 2343 . . . 001.50 points free 030>folio: 2344 . . . 007.50 points free 031>folio: 2345 . . . 022.00 points free I then loop through the file and display the results in a . It would display something like this: Seq: 1 Folio: 2201 Seq: 2 Folio: 2202 Seq: 3 Folio: 2203 Seq: 4 Folio: 2204 Seq: 5 Folio: 2205 Seq: 6 Folio: 2206 Seq: 7 Folio: 2207 ...and so on... >From here the user can select all the pages or individual selections using the Shift or Ctrl keys. The results are passed to my action page as a comma delimiited list (variable) and fed into the program. At times the user selsection can be VERY large and the program barfs because it can't handle such a large string. So this is my question. How can I arrange sequential selections into ranges. Meaning is a user selects the first 50 pages. Currently when the selection gets passed to my action page the results would be: 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50 How can I make the above get passed as: 1-50? and if the selection happended to be: 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,23,24,25,30,33,40,41,42,46,47,48 How can I make the above get passed as this: 1-16,23-25,30,33,40-42,46-48 The below code generate the listing like: Seq: 1 Folio: 2201 Seq: 2 Folio: 2202 Seq: 3 Folio: 2203 Seq: 4 Folio: 2204 Seq: 5 Folio: 2205 Seq: 6 Folio: 2206 Seq: 7 Folio: 2207 ...and so on... "))> "))> Seq: #sValNoComma# Folio: #sDisp##spacer1# --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Directory Tree crawler with file size sorting?
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 sorting? 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 you to sort by sizes, etc? My main goal is to find large files that exist on the drive that can be deleted. Any tools or suggestions would be great. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing a form field
#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 field to another form when the user clicks submit. I have it in a hidden field but of course this does not work: Tried: #Evaluate(count)# How would that fit in? Thx. Robert O. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
