Re: OT- netstat report
Yes I ping the domain from the same machine, and got response. I ping the external static ip, got response. I ping the internal ip, got response. I ping the computer name, got response. infact I ping outside the network and got response as well. thanks >On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: >> If I open it as a localhost from the same machine, yes then the website >> opened, but if I open it with domain, the website is not getting open from >> this machine, and rest of the world can open. > >Check the DNS. >Can this machine 'ping' it's own real world address (as both an IP and a >name) ? > >-- >Tom Chiverton >Advanced ColdFusion Programmer > >Tel: +44(0)1749 834997 >email: [EMAIL PROTECTED] >BlueFinger Limited >Underwood Business Park >Wookey Hole Road, WELLS. BA5 1AF >Tel: +44 (0)1749 834900 >Fax: +44 (0)1749 834901 >web: www.bluefinger.com >Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple >Quay, BRISTOL. BS1 6EG. >*** This E-mail contains confidential information for the addressee >only. If you are not the intended recipient, please notify us >immediately. You should not use, disclose, distribute or copy this >communication if received in error. No binding contract will result from >this e-mail until such time as a written document is signed on behalf of >the company. BlueFinger Limited cannot accept responsibility for the >completeness or accuracy of this message as it has been transmitted over >public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle "Unsupported Data Conversion"
I'd found that out, too, and ended up adding error catching in the PL/SQL to always make sure that I opened the ref cursor and passed it back, even if it was empty. - Original Message - From: "Adrocknaphobia" > ** this is a response to a post from 3/9/2004 which never seemed to be > resolved ** > > Explanation of CFMX Oracle JDBC database error "Unsupported Data Conversion" > > This issue occurs when using RefCursors to return queries from oracle > via a stored procedure. > > When you declare a RefCursor it is NULL until it is populated with the > OPEN ... FOR syntax. > > If any sort of error or premature return from the stored procedure > occurs, Oracle still passes the RefCursor to CFMX. CFMX cannot convert > the NULL RefCursor to an empty query. Now, if oracle performed and > OPEN...FOR on the cursor and no rows were returned, then the RefCursor > is successfully passed back to CFMX as it is no longer considered > NULL. > > This one can be a little tricky to debug, especially you have good > exception handling. In my case I was catching and returning an error > before it got to populate the RefCursor. But CFMX threw it's > "Unsupported Data Conversion" before it threw the actual error. > > This is def a driver/cfmx issue as you will not see this error in any > form in SQL*Plus. > > Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: > If I open it as a localhost from the same machine, yes then the website > opened, but if I open it with domain, the website is not getting open from > this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML parsing in ColdFusion
I have never tried to do it. I am hard pressed to think of why I would ever want to maybe MM developers were the same way. Any chance you could give me a real world application for this? Maybe I am missing out on some revolutionary concept :) Adam H On Thu, 2 Sep 2004 13:01:42 -0700, Rob <[EMAIL PROTECTED]> wrote: > It really is that difficult > > http://www-106.ibm.com/developerworks/xml/library/x-tipmvdom.html > > On Thu, 2 Sep 2004 12:39:53 -0700, Ian Skinner > <[EMAIL PROTECTED]> wrote: > > Thanks, that worked, now I just need to decide if I want to use undocumented features or an UDF. > > > > Is this really supposed to be this difficult? Or am I just being difficult again? > > > > -- > > Ian Skinner > > Web Programmer > > BloodSource > > www.BloodSource.org > > Sacramento, CA > > > > "C code. C code run. Run code run. Please!" > > - Cynthia Dunning > > > > Confidentiality Notice: This message including any > > attachments is for the sole use of the intended > > recipient(s) and may contain confidential and privileged > > information. Any unauthorized review, use, disclosure or > > distribution is prohibited. If you are not the > > intended recipient, please contact the sender and > > delete any copies of this message. > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML verity indexing problem
Judging by your paths I am going to guess that you are on Windows. You might want to take a look at the verity spider. Just a thought. Doug Charles Chen wrote: >Hi All. I'm a fairly new CF developer. I'm having weirdness indexing a website that is mostly a collection of XML pages. I'm really stumped. Can someone help me? > >If I create the verity collection via the colfusion administrator and add .XML to the extension types, it will properly create and index the site and the XML files will show up in my search. > >However, I need to use the programmatic method rather than the administrator because content on the site changes frequently and I want to schedule a CFM page to index the collection automatically at intervals. So, I programmed CFM pages to create a collection and then index it. In the cfindex, I have specified .xml as an extension type in addition to the standard HTML, CFM, etc. However, when I do a search the indexed collection only returns HTML files. even though XML and CFM has been declared as extensions to index as well. I tried using action="" and action="" I even tried action="" followed by action="" but no dice. Any idea why this is the case? I've cut and paste my code for creating an collection and for indexing it. > >Thank you for any generous help! > >- Charles > >Create collection action page (takes values from form): > > > > > >collection="#Form.CollectionName#" >path="c:\cfusionmx\verity\collections\"> >The collection #Form.CollectionName# is created. > > > > >collection="#Form.CollectionName#"> >The collection #Form.CollectionName# is repaired. > > > > >collection="#Form.CollectionName#"> >The collection #Form.CollectionName# is optimized. > > > > >collection="#Form.CollectionName#"> >Collection deleted. > > > > >Index collection page (takes collection name value from form): > > > action=""> > extensions=".htm, .html, .cfm, .cfml, .xml" > key="c:\InetPub\wwwroot\www.vsarts.org\" > type="path" > urlpath="http://www.vsarts.org" > recurse="Yes" > language="English"> > > > The collection #Form.IndexColl# has been indexed. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
With a bit of experimenting... SELECT CAST(DATE_FORMAT((MessageDate + INTERVAL 9 HOUR),'%d/%m/%Y') AS CHAR) AS Purchase_Date, sum(ItemCount) AS TotalSales FROM table Works for my purposes this time, but it would still be nice to know why the group by clause caused MySQL to convert the Date column to Binary data if any one knows. -- Jay > -Original Message- > From: James Smith [mailto:[EMAIL PROTECTED] > Sent: 03 September 2004 12:58 > To: CF-Talk > Subject: RE: Awkward SQL > > Ok, extension of this problem > > SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS > Purchase_Date, ItemCount > FROM table > > Works just fine and returns the dates exactly as I want, > unfortunately I need to be using sum(ItemCount) giving me... > > SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS > Purchase_Date, >sum(ItemCount) AS TotalItems > FROM table > GROUP BY Purchase_Date > > And unfortunately as soon as I group on the date it gets > mutated into binary data instead of the date. > > Any ideas on why and how to get round it? > > -- > Jay > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. There is no firewall on this computer, the only thing is I installed the sp2 and after disabling the firewall still the website was not opening for the rest of the world so, I uninstalled the sp2, no effect, then I restore the system on old date(before sp2) then it start serving website and it can open from outside and localhost, but not with the domain on same machine. I can ping the ip no problem, i can ping the domain no problem. I still don't understand what can be the cause of this. it was fine before please advise. >> could someone tell me that whats wrong with this netstat report >> the website is not opening from the same machine, the rest of >> the world can open easily but not getting open from the same >> machine. > >Is your web server configured to accept requests to the localhost address? >My guess is that it isn't. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
Ok, extension of this problem SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date, ItemCount FROM table Works just fine and returns the dates exactly as I want, unfortunately I need to be using sum(ItemCount) giving me... SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date, sum(ItemCount) AS TotalItems FROM table GROUP BY Purchase_Date And unfortunately as soon as I group on the date it gets mutated into binary data instead of the date. Any ideas on why and how to get round it? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
Ok... only a guess anyway!!! Andrew. - Original Message - From: Claude Schneegans <[EMAIL PROTECTED]> Date: Fri, 03 Sep 2004 07:21:52 -0400 Subject: Re: Anyone looking for a java WYSIWYG online textarea replacement... To: CF-Talk <[EMAIL PROTECTED]> >>Vive La Monde!!! (not sure that is completely right!!!) Almost: "LE monde" ;-)) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
Finally... After much messing about I finally got a modified version of Jochem's solution working... Jochem's original: SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table Working: SELECT CAST((your_datetime_field + INTERVAL 9 HOUR) AS DATE) FROM table Note the extra parenthesis around the "MessageDate + INTERVAL 9 HOUR" and the removed quotes around the time interval. I have also dropped it to 9 hours as the cut off is 3pm not 13:00 but that was the least of my troubles! Thanks go to Jochem and all others. -- Jay > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: 03 September 2004 12:17 > To: CF-Talk > Subject: Re: Awkward SQL > > >>Now I can do this by looping over a query and stinking the > values into > >>an > array but is it possible to do this directly in the SQL? > > My feeling is that it would probabily be rather difficult with MySQL. > I would do it in a loop in CF. > > -- > ___ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: > [EMAIL PROTECTED]) Thanks. > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Access alternatives (WAS: Security gurus out there?)
> 7. What does zerofill do to a integer field? A database is > meant to store data, not to format it while storing. > Actually I find this to be a nice feature...if necessary. > For instance you are using Auto_Increment INT field and you > are using it as your order number. Maybe you want all of > your order numbers to be a specific length. I actually found it usefull with barcodes which in the US are only 12 digits but in Europe are exactly the same format but 13 digits long. Adding a zero to the beginning of a US code makes it a European compatible code. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
>>Vive La Monde!!! (not sure that is completely right!!!) Almost: "LE monde" ;-)) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Chaning debug output in CF5
Is there anyway to do this? I do a lot of fusebox and I wanted to change the colours so I can see what files are being called. I KNOW how do do this is CFMX but I need a solution for CF5 Any ideas? -- Mark Drew coldfusion and cfeclipse bloged: http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
>>Now I can do this by looping over a query and stinking the values into an array but is it possible to do this directly in the SQL? My feeling is that it would probabily be rather difficult with MySQL. I would do it in a loop in CF. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
Jochem van Dieten wrote: > > Does the following work: > SELECT MessageDate + INTERVAL 11 HOUR AS DATE > FROM table That should be: SELECT MessageDate + INTERVAL 11 HOUR FROM table Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
Same old same old... commercial differences always get in the way of progress. If everyone in the world worked together on everything and shared all knowledge the we would probably have made more advances then we have and be a much better place. Vive La Monde!!! (not sure that is completely right!!!) Andrew. - Original Message - From: Claude Schneegans <[EMAIL PROTECTED]> Date: Fri, 03 Sep 2004 07:05:20 -0400 Subject: Re: Anyone looking for a java WYSIWYG online textarea replacement... To: CF-Talk <[EMAIL PROTECTED]> >>I think the W3C >>need to take more external advice from developer how actually have to >>use their standards in day to work, not just from the people that make >>the browser products like MS and Mozilla. I'll second that. Now, as far as HTML and _javascript_ standards are concerned, and about the way they have been settled, I think one must not forget a long history of more or less fair competition between Netscape and Microsoft. Both these compagnies were members in the standard comitees, and both were defending their approach. And at the time it happened, it was really a war between them. But Netscape was still strong enough, and a couple of things they were not able to do have been specified as "should not do" in the standard. I remember in another life, I used to be a member in an ISO comitee for vocabulary in computer graphics. Microsoft was not even a project, and Bill Gates was probabily still sucking his Pablum in these days, but IBM, Xerox, etc. were omnipresent and fighting each others every minute. >>BTW, you English is excellent... Thanks, I do my best to stick to standards and I have a good documentation ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query Problem
>>My problem is with is piece of code in QueryB. It is creating an ODBC error. If your query contains quotes, you have to use #preserveSingleQuotes(SQLQUERY)# in your query "B" -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
James Smith wrote: > 2004-09-03 08:00 --> 2004-09-03 00:00 > 2004-09-03 14:00 --> 2004-09-03 00:00 > 2004-09-03 15:01 --> 2004-09-04 00:00 SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table >>> >>> At first glance this looks good and the MySQL docs seem to support >>> this theory but it just throws an error. >> >> Which version are you running? > > 4.1.3 Does the following work: SELECT MessageDate + INTERVAL 11 HOUR AS DATE FROM table Then you can use date_format to set the hours to zero. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
>>I think the W3C >>need to take more external advice from developer how actually have to >>use their standards in day to work, not just from the people that make >>the browser products like MS and Mozilla. I'll second that. Now, as far as HTML and _javascript_ standards are concerned, and about the way they have been settled, I think one must not forget a long history of more or less fair competition between Netscape and Microsoft. Both these compagnies were members in the standard comitees, and both were defending their approach. And at the time it happened, it was really a war between them. But Netscape was still strong enough, and a couple of things they were not able to do have been specified as "should not do" in the standard. I remember in another life, I used to be a member in an ISO comitee for vocabulary in computer graphics. Microsoft was not even a project, and Bill Gates was probabily still sucking his Pablum in these days, but IBM, Xerox, etc. were omnipresent and fighting each others every minute. >>BTW, you English is excellent... Thanks, I do my best to stick to standards and I have a good documentation ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
> >>> 2004-09-03 08:00 --> 2004-09-03 00:00 > >>> 2004-09-03 14:00 --> 2004-09-03 00:00 > >>> 2004-09-03 15:01 --> 2004-09-04 00:00 > >> > >> SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS > >> DATE) FROM table > > > > At first glance this looks good and the MySQL docs seem to support > > this theory but it just throws an error. > > Which version are you running? 4.1.3 -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
> > SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM > > table > or if you're not fortunate enough to have standards compliant > db like postgres, say sql server: > SELECT > CAST(CONVERT(char(12),DATEADD(minute,541,yourDateColumn),101) AS > smalldatetime) AS yourNewDateTime Unfortunately even after converting the DATEADD function to DATE_ADD (as used by MySQL) this solution produces the same error as Jochems solution. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
James Smith wrote: >>> 2004-09-03 08:00 --> 2004-09-03 00:00 >>> 2004-09-03 14:00 --> 2004-09-03 00:00 >>> 2004-09-03 15:01 --> 2004-09-04 00:00 >> >> SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS >> DATE) FROM table > > At first glance this looks good and the MySQL docs seem to support this > theory but it just throws an error. Which version are you running? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
> > 2004-09-03 08:00 --> 2004-09-03 00:00 > > 2004-09-03 14:00 --> 2004-09-03 00:00 > > 2004-09-03 15:01 --> 2004-09-04 00:00 > SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS > DATE) FROM table At first glance this looks good and the MySQL docs seem to support this theory but it just throws an error. When I run... SELECT SELECT CAST(MessageDate + INTERVAL '11 hours' AS DATE) FROM table I get the error... Syntax error or access violation: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT CAST(MessageDate + INTERVAL '11 hours' AS DATE) FROM table' at line 1 I have also tried using the DATE_ADD() syntax but with no better results. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
> SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) > FROM table or if you're not fortunate enough to have standards compliant db like postgres, say sql server: SELECT CAST(CONVERT(char(12),DATEADD(minute,541,yourDateColumn),101) AS smalldatetime) AS yourNewDateTime [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access alternatives (WAS: Security gurus out there?)
there's an idea (i don't want to say generally held but it sometimes seems so) among folks "serious" about their databases that mysql isn't quite right-in-the-head. a few years ago the developers of mysql had this "funny" publicly stated attitude about transactions as being a fancy, unnecessary function. they used to brag about it. i've always been suspicious of it since then--maybe a reformed harlot is more zealous but i can't help thinking deep down there's something still loose & zany lurking. and of course it currently doesn't do unicode which makes it kind of useless to me even for the most trivial applications. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
James Smith wrote: > I have a query I need which is nothing short of awkward. I have a field > which is a date/time type storing data as a full date/time i.e.: "2004-09-03 > 10:37" > > I need to select them so that the value returned is "2004-09-03 00:00" but > more than this I need 3pm to be the date change. > > For example. > > 2004-09-03 08:00 --> 2004-09-03 00:00 > 2004-09-03 14:00 --> 2004-09-03 00:00 > 2004-09-03 15:01 --> 2004-09-04 00:00 > > Now I can do this by looping over a query and stinking the values into an > array but is it possible to do this directly in the SQL? SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Awkward SQL
I have a query I need which is nothing short of awkward. I have a field which is a date/time type storing data as a full date/time i.e.: "2004-09-03 10:37" I need to select them so that the value returned is "2004-09-03 00:00" but more than this I need 3pm to be the date change. For example. 2004-09-03 08:00 --> 2004-09-03 00:00 2004-09-03 14:00 --> 2004-09-03 00:00 2004-09-03 15:01 --> 2004-09-04 00:00 Now I can do this by looping over a query and stinking the values into an array but is it possible to do this directly in the SQL? I am using CFMX 6.1 and MySQL 4.1.3. -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access alternatives (WAS: Security gurus out there?)
Matt Robertson wrote: > Jochem wrote: >> >> After doing a simple division by 2.20371, your balance doesn't quite >> balance anymore. > > You mean do the division in the sql? Thats something I would never > do, personally. Where else can you do it and have control over precision and rounding? In CF we have no control over the datatype, which means there is no way we can control precision if there is an int to float conversion in an unexpected place. In databases we have exact numeric types of arbitrary scale and precision that have a behaviour that is exactly specified by the SQL standard. Except in MySQL. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle "Unsupported Data Conversion"
On Thursday 02 Sep 2004 22:04 pm, Adrocknaphobia wrote: > This is def a driver/cfmx issue as you will not see this error in any > form in SQL*Plus. Do you still see the error with the updated drivers from the Updater ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Access alternatives (WAS: Security gurus out there?)
I quote, for foreign keys, transactions and triggers. Correct me If I am wrong but this comes from the MySQL site. "Note that, for the moment, only InnoDB tables support foreign keys. See section 16.7.4 FOREIGN KEY Constraints . Foreign key support in MyISAM tables is scheduled for implementation in MySQL 5.1. " " Using the InnoDB or Berkeley DB (BDB) storage engines, the MySQL database server supports transactions." "Upcoming Features" -> Support for stored procedures was added in version 5.0, and support for triggers will be added in version 5.1. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Auto-Login
You need to disable "Anonymous access" under the security tab of the website under IIS. This will populate the cgi variable cgi.auth_user This will only work on your intranet though. Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Tony Pimm [mailto:[EMAIL PROTECTED] Sent: Friday, 3 September 2004 5:48 PM To: CF-Talk Subject: Re: Auto-Login Great! Can anyone tell me how to configure IIS to do this? Thanks. >> If I'm logged onto my local machine in the local domain, is >> there a way that ColdFusion can identify my username? >> >> Is there a way of identifying if the user is logged onto the >> local domain already? And who the user is? >> >> Basically, I want to avoid making users log on to an internal >> system, and for the system to identify the person automatically. > >If you're using Windows and Internet Explorer on your client machines, and >IIS on your server, and the clients and server are within the same domain, >you can configure IE to automatically provide domain login credentials to >IIS, which can then be accessed via CGI or CFLOGIN within CFMX. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access alternatives (WAS: Security gurus out there?)
Wow! Which version did you use last? I really want to hear an explanation of this one Cutter Micha Schopman wrote: > MySQL is out of the question for sensitive information. MySQL is missing > to much functionality to maintain data integrity on db level. > Micha Schopman > Software Engineer > Modern Media, Databankweg 12 M, 3821 AL Amersfoort > Tel 033-4535377, Fax 033-4535388 > KvK Amersfoort 39081679, Rabo 39.48.05.380 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Auto-Login
Great! Can anyone tell me how to configure IIS to do this? Thanks. >> If I'm logged onto my local machine in the local domain, is >> there a way that ColdFusion can identify my username? >> >> Is there a way of identifying if the user is logged onto the >> local domain already? And who the user is? >> >> Basically, I want to avoid making users log on to an internal >> system, and for the system to identify the person automatically. > >If you're using Windows and Internet Explorer on your client machines, and >IIS on your server, and the clients and server are within the same domain, >you can configure IE to automatically provide domain login credentials to >IIS, which can then be accessed via CGI or CFLOGIN within CFMX. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML verity indexing problem
I'm not 100% sure about this, but I think the version of Verity shipped with CF is so old that it does understand that your page with the extension .xml is rendered like an HTML page in the browser and therefore doesn't know how to parse it. I had a similar problem with PDF file recently. The Verity with CFMX can only read PDF up one created with version 4 of Acrobat so when I asked Verity to index about 300 PDFs created with Acrobat 6 it simply ignored them. The solution I came up with was to use a third party Java API (pdfbox) to extract the text from the PDF file and then pass that text to verity. Worked like a treat. Maybe you will need to do something similar to extract the text from your XML pages and pass that to Verity with the filename of the page. Also, I'm not Verity can index CFM page either, as it would need to call the CFM and get the returned page. I'm pretty sure that Verity only reads files. So it will index you HTML pages as it simply reads the file, removes the HTML tags and indexes the remaining text. Verity can be very good, but it need some tweaking. Also, if you have a good budget, and I mean good, you could look at using Verity Ultraseek as that will spider a site and index pages, pdf, etc and all you do is give it the base URL. You can connect to it with CF as a web service, it is pretty easy. But like a say Ultraseek is not cheap. Hope that helps. Andrew. - Original Message - From: Charles Chen <[EMAIL PROTECTED]> Date: Thu, 02 Sep 2004 18:27:38 -0400 Subject: XML verity indexing problem To: CF-Talk <[EMAIL PROTECTED]> Hi All. I'm a fairly new CF developer. I'm having weirdness indexing a website that is mostly a collection of XML pages. I'm really stumped. Can someone help me? If I create the verity collection via the colfusion administrator and add .XML to the extension types, it will properly create and index the site and the XML files will show up in my search. However, I need to use the programmatic method rather than the administrator because content on the site changes frequently and I want to schedule a CFM page to index the collection automatically at intervals. So, I programmed CFM pages to create a collection and then index it. In the cfindex, I have specified .xml as an extension type in addition to the standard HTML, CFM, etc. However, when I do a search the indexed collection only returns HTML files. even though XML and CFM has been declared as extensions to index as well. I tried using action="" and action="" I even tried action="" followed by action="" but no dice. Any idea why this is the case? I've cut and paste my code for creating an collection and for indexing it. Thank you for any generous help! - Charles Create collection action page (takes values from form): collection="#Form.CollectionName#" path="c:\cfusionmx\verity\collections\"> The collection #Form.CollectionName# is created. collection="#Form.CollectionName#"> The collection #Form.CollectionName# is repaired. collection="#Form.CollectionName#"> The collection #Form.CollectionName# is optimized. collection="#Form.CollectionName#"> Collection deleted. Index collection page (takes collection name value from form): action=""> extensions=".htm, .html, .cfm, .cfml, .xml" key="c:\InetPub\wwwroot\www.vsarts.org\" type="path" urlpath="http://www.vsarts.org" recurse="Yes" language="English"> The collection #Form.IndexColl# has been indexed. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
Bonjour Claude I think we are both coming at this thing the same, but just from a slightly different direction. I agree with almost everything you say, but personally I would prefer to see the standard layed down agree by all before it is implemented. Implementing something without telling anyone else first is where the problems come from. I agree the standard should be expanded and improved upon, of course as technology so the standard in to expand to include new things, but simply sitting there and going, "oh this is a good idea i'll stick that in" simply isn't a good way forward for the developer community. I think the W3C need to take more external advice from developer how actually have to use their standards in day to work, not just from the people that make the browser products like MS and Mozilla. BTW, you English is excellent... Andrew. - Original Message - From: Claude Schneegans <[EMAIL PROTECTED]> Date: Thu, 02 Sep 2004 18:05:56 -0400 Subject: Re: Anyone looking for a java WYSIWYG online textarea replacement... To: CF-Talk <[EMAIL PROTECTED]> >>I agree that the Mozilla documentation is poor, maybe if you feel that strongly you could offer to help write some, If I were one of the author, I sure would do. But not being one of them, I would need docs to learn how it works first. ;-) The problem with Mozilla is that they refer you to the W3C docs, but these are even worse. >>I don't agree that sticking to the standard should mean expanding upon it. I stick to the French language standard as much as I can. But I'm also able to use English, ... well at least I do my best ;-) >>The standard is there so the people like us whole program DHTML in the browser know that if you use a command in one browser it will work in all browsers that comply with the standard in the same way. Exact, this is why those who write standard have a big responsability: make a standard that makes sense. W3C standard does not. Just to cite a few flaws: - no block elements are not resizable (ie: span) Why? Is it so difficult to implement? IE was able to resize non block elements even before the standard was written. - no integer values for element dimensions (ie: pixelLeft, etc.). in order to work on them, one must parse text properties that include units at the end. Now this is really ridiculous, DHTML is supposed to be done by programming or what? >>Expanding on the standard only causes problem as IE has shown. Adding extra stuff only causes programmers problem, Again, I agree with that, but not when adding extra stuff is need to palliate a lack of functionality in the standard. Take for instance WYSIWYG HTML editors, the unbeilivable number of available species proves there is a need for them, it is a shame there is nothing in the standard to make one. Microsoft has implemented HSTML editing with the execCommand method. Now Mozilla has implemented similar facilities (although not as functional), and this is not in the "standard". And last but not least (See my English, wow! ;-) the role of any standard is NOT to show the way, it is to set a common basic practice for everybody. If everybody was strictly complying to standard, there would be NO standard, and nothing to standardize. It is thanks to developers who make extras that new ideas can come and enrich standards. When Netscape -- a great company before it was swallowed by AOL -- brought us _javascript_, it was NOT standard, now _javascript_ is part of the standard, for the benefit of all of us. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
