OT: Shall be order

2001-10-21 Thread Michael Lugassy

Please help me with that SQL script, I'm hopeless :(

I have a product table which has:
product_cat (identity, int, i.e=4) and product_list (which is a $$
delimited list of products, i.e - mouse_wheel$$screen$$keyboard) -
don't ask... about 400,000 rows.

I have a info table that looks like this:
product_item (mouse_wheel, for example) and product_description (text
explanation about mouse_wheel)
about 2,000,000 rows (!)

I want to combine the two tables, in a long process.

What I need is that for every row on the PRODUCT table, SQL would delimit
each item from product_list and update its INFO table occurence with the
appropriate product_cat.
come to think of it, I can simulatinsoluy update severl products with the
same product_cat
(because I have a list of different products, delimited).

Further more, I need a unique identifier for each row (i.e - on every
item, to add an increment identity integer, never mind the order).

so in the end I will have an organized row that will include all
information for SINGLE product.

can anyone help me with that?

Michael.
ICQ: 3056792



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Regular Expression

2001-10-21 Thread Michael Lugassy

This is not neccesarly have to be done with coldfusion's REReplace but 
anyhow,
I'm trying to come up with a regular expression that will help me turn 
this:

[Object]
ID=2031
URL=http://www.cnn.com/
OtherSrvLev=0w33a
Category=31

Into: http://www.cnn.com/

Overall, I'm trying to find a way to remove EVERYTHING 
(numeric/alpha/special/+New lines)
from [Object] over to URL=, keep everything from URL= to the New 
line and again, remove
everything from OtherSrvLev to the end.
So I will be left with a URL alone.

Anyone?

Michael.


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Can anyone Translate this?

2001-10-03 Thread Michael Lugassy

I have a mySQL CREATE script that I want to run on MS-SQL 2000.
Can anyone let me know how to translate this?

CREATE TABLE content (
  catid mediumint(10) unsigned NOT NULL default '0',
  link text,
  link1 text,
  link_count smallint(5) unsigned default NULL,
  link_total int(6) unsigned default NULL,
  symlinkfarm enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (catid),
  KEY link_total (link_total),
  KEY symlinkfarm (symlinkfarm),
  KEY link_count (link_count)
) TYPE=MyISAM;

Michael.



~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



xml to SQL?

2001-09-22 Thread Michael Lugassy

Sorry for my ignorance, but how do I export
a XML file into MSSQL 2000?

Michael.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: RDF/XML/SQL??

2001-09-21 Thread Michael Lugassy

I just downloaded a 300mb sample database in RDF file.
I recall once opening it in IE and got a huge XML formatted data.

Is there a way to export this thing into SQL somehow?

Michael.

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: I've lost a week's work!!!

2001-09-20 Thread Michael Lugassy

Thanks all,

I've stayed up late (VERY LATE) and completed the whole thing! :))
My lesson from this: BACKUP, BACKUP, BACKUP
and when you've gone through this kind of thing (no backup), don't go to 
sleep upset,
code it again when the CF_stuff is in your head! :)

Turned out even better... :))

Thanks,

Michael.
  - Original Message - 
  From: Tilbrook, Peter 
  To: CF-Talk 
  Sent: Thursday, September 20, 2001 7:02 AM
  Subject: RE: I've lost a week's work!!!


  Probably not, and CF Studio 5 (RC1) backup doesn't work at all. BACKUP
  BACKUP BACKUP or at least use something like MS Visual SourceSafe.

  -Original Message-
  From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
  Sent: Friday, 21 September 2001 9:36
  To: CF-Talk
  Subject: I've lost a week's work!!!


  I just had to hard reset my computer while editing a cfm template
  in coldfusion studio, and when I logged in again found out it was
  0 byte!!!

  All of my week's work is gone (the file was around 15Kb of code).
  I didn't save it in a diffrent location. is there still a place where 
I 
  can find it??

  I know the chances are ZERO! but... maybe?? :(((

  Michael.


  
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



I'm resending - help

2001-09-20 Thread Michael Lugassy

Resending this, please take a look (haven't got response).

I have a complexed CFM template that output a result page after a long
process.The process includes: connecting to 3-4 diffrent datasources, string
manipulation, math calculations, links, includes, everything...

I though about the following way to cache: Every cfoutput (and other html/js
code) is
store incremently in a cf variable. (upon succesful completion of every
phase).

In the end, I output the result to the user and store that variable in a SQL
table with a UID. Then, the second time a user calls the CFM, I first check
if the output
content is already in SQL, and output it. If the content is not there, or
expired, I simply parse the
CFM from the start.

Any comments on my way to do this?
What is better in this way, store the output content in SQL or a text file
(and then cfinclude it)?

Michael.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



I've lost a week's work!!!

2001-09-19 Thread Michael Lugassy

I just had to hard reset my computer while editing a cfm template
in coldfusion studio, and when I logged in again found out it was
0 byte!!!

All of my week's work is gone (the file was around 15Kb of code).
I didn't save it in a diffrent location. is there still a place where I 
can find it??

I know the chances are ZERO! but... maybe?? :(((

Michael.

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: ImageMagick - anyone use with CF?

2001-09-19 Thread Michael Lugassy

If your project needs to create thumbnails, copy/rename/move images 
alone, just use CFX_IMAGE.
http://www.intrafoundation.com

CFEXECUTE is easy to use, just read the docs,
call the cmd prompt with the right arguments to complete the task for 
you.

Again, I'm not sure how ImageMagik handles multiple calls, but if you 
need image maniupulations
such as remove red eye, change contrast/brightness - it's the easiest 
tool.

Michael.

  - Original Message - 
  From: Scott Weikert 
  To: CF-Talk 
  Sent: Tuesday, September 18, 2001 9:22 PM
  Subject: Re: ImageMagick - anyone use with CF?


  Thanks guys! Just what I needed to hear :)

  If any of you guys could toss me some examples of how you use 
CFEXECTUTE
  (i.e. the command you pass through it) to do various things, it'd 
probably
  help save me some time. Don't go out of your way, mind you... don't 
want to
  eat up anyone's time :)

  Thanks!
  --Scott
  
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



test

2001-09-19 Thread Michael Lugassy

test

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Hardware Consideration

2001-09-17 Thread Michael Lugassy

Mark,

I assume the OS would be windows advanced server?

Why advanced?

Michael.


Date: Sun, 16 Sep 2001 14:11:10 +0200
From: Michael Lugassy [EMAIL PROTECTED]
Subject: Hardware Consideration
Message-ID: 000e01c13ea8$adc3c240$[EMAIL PROTECTED]

This may seem a bit OT, but if any pro. can help me out here, I'll be 
glad
to hear all tips and pointers.

I'm intrested in buying a 1U server to host our full-text/SQL/coldfusion 
IIS
website.

The server mostly run SQL Full-text queries, (10-20 million text rows)
Also, there some Coldfusion scripts that consumes some resources for
calucluation, generating and querying.
Further more, the site send out hunderds of images and htmls very 
quickly,
in a high above average rate.

How can I check which server will be enough? Should I consider SCSI or
settle for IDE?
Should I consider more ram (1-2Gb over 512MB) and settle for a slower 
CPU?

Any help or links on the subject would be great!

Michael.

brbrbrMark Smeets/stranger0/ICQ #1062196

My new email: [EMAIL PROTECTED]

Mr. West, not every situation requires your patented approach of shoot 
first, shoot later, shoot some more and then when everybody's dead try 
to 
ask a question or two - Wild Wild West

A Stranger's Domain
http://24.113.34.178/stranger

Official Splitting Adam Homepage
http://www.splittingadam.com/


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Hardware Consideration

2001-09-16 Thread Michael Lugassy

This may seem a bit OT, but if any pro. can help me out here, I'll be glad
to hear all tips and pointers.

I'm intrested in buying a 1U server to host our full-text/SQL/coldfusion IIS
website.

The server mostly run SQL Full-text queries, (10-20 million text rows)
Also, there some Coldfusion scripts that consumes some resources for
calucluation, generating and querying.
Further more, the site send out hunderds of images and htmls very quickly,
in a high above average rate.

How can I check which server will be enough? Should I consider SCSI or
settle for IDE?
Should I consider more ram (1-2Gb over 512MB) and settle for a slower CPU?

Any help or links on the subject would be great!

Michael.


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Hardware Consideration

2001-09-16 Thread Michael Lugassy

Jeffry,

   Are you looking for a database Server ( SQL Server? Oracle?) or a
 ColdFusion server, or a machine that can handle both at once?
   It is usually recommended that you try to separate your database server
 from your Application Server.

Something that can handle both at once (SQL and IIS/Coldfusion).

Michael.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Long Term Caching

2001-09-16 Thread Michael Lugassy

I have a complexed CFM template that output a result page after a long
process.The process includes: connecting to 3-4 diffrent datasources, string
manipulation, math calculations, links, includes, everything...

I though about the following way to cache: Every cfoutput (and other html/js
code) is
store incremently in a cf variable. (upon succesful completion of every
phase).

In the end, I output the result to the user and store that variable in a SQL
table with a UID. Then, the second time a user calls the CFM, I first check
if the output
content is already in SQL, and output it. If the content is not there, or
expired, I simply parse the
CFM from the start.

Any comments on my way to do this?
What is better in this way, store the output content in SQL or a text file
(and then cfinclude it)?

Michael.

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Long-Term Caching

2001-09-14 Thread Michael Lugassy

I have a complexed CFM template that output a result page after a long
process.
The process includes: connecting to 3-4 diffrent datasources, string
manipulation, math
calculations, links, includes, everything...

I though about the following way to cache:
Every cfoutput (and other html/js code) is store incremently in a cf
variable.
(upon succesful completion of every phase).

In the end, I output the result to the user and store that variable in a SQL
table with a UID.
Then, the second time a user calls the CFM, I first check if the output
content is already in SQL,
and output it. If the content is not there, or expired, I simply parse the
CFM from the start.

Any comments on my way to do this?
What is better in this way, store the output content in SQL or a text file
(and then cfinclude it)?

Michael.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Highlighting search results

2001-09-14 Thread Michael Lugassy

I have a search query that uses verity to produce search results from a
Product_desc field.
Instead of Verity's summary field, I need to output portions of the
Product_desc column.

I want to output ONLY relevent sentences (the same as Google does), so a
search
for nokia or cellular or phone would output 2-4 diffrent sentences
from Product_desc:

... Cellular accessories that include Plantronics headsets and horizontal
leather cases for most...
.. accessories for Audiovox, Mitsubishi, Samsung, Nokia, Ericsson,
Motorola, Qualcomm...
... We match our quality cellular phone accessory products with ...

Michael.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: SQL Filtered SELECT

2001-09-03 Thread Michael Lugassy

I use a SQL Full Text query that finds search_query in Product_desc,
Something like this:

SELECT Product_id, Product_desc
FROM Products WHERE CONTAINS(Product_desc,'#search_query#')

What if I don't want to select the complete Product_Desc field, but only
portions of it?
By only portions I mean - Text that is most relevent to the search
query. Overall - I want to output 3-4 sentences that have as much
keywords (from the search_query) As possible, just like Google does to
its search results. I.e: a search for science fiction will yield:

..THE ULTIMATE |SCIENCE FICTION| WEB GUIDE..
...ALMOST SIX THOUSAND LINKS TO WEB |SCIENCE FICTION|...
...Here you can find definitions and RESOURCES of |Science Fiction|
...

Help, anyone?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SQL Filtered SELECT

2001-09-03 Thread Michael Lugassy

Don,

 If there is any interest I could write either a custom tag or 
 udf to do this.

The idea was the filter the SELECT, and not highlight the search
term(s).
Is there a way to minimze the amount of data sent by CFQUERY like I
need?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Plain text view in outlook?

2001-08-31 Thread Michael Lugassy

How can I use my outlook to simulate Plain text e-mail reader?

I just come up with a code that will send both html and plain text In
the same message = I see the html just fine (without text notes) But I
want to be able to see it in Plain text also.

Thanks,
 
Michael


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Plain text view in outlook?

2001-08-31 Thread Michael Lugassy

Mark,

 tools, options, mail format, and choose plain text from the 
 message form drop down list

This option is for sending mail messages, not receiving.

Maybe if someone has a plain text (support?) e-mail client
I can send him an example?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: bookmarking pages?

2001-08-31 Thread Michael Lugassy

Put a session (cookie or var) in the login screen 
And then for every page check if the user has this var/cookie.
If he does, proceed and show the page, if he doesn't = throw
Him to the login page.
(prefarbly embed this code on application.cfm)


Thanks,
 
Michael


 -Original Message-
 From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] 
 Sent: Friday, August 31, 2001 12:19 PM
 To: CF-Talk
 Subject: bookmarking pages?
 
 
 I have a site that I was wanting to know if I can keep users 
 from book 
 marking a page in the site allowing them to bypass the login page?
 
 
 Thanks,
 
 Dominic
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Me Vs. Search Results

2001-08-29 Thread Michael Lugassy

Brian,

 SELECT left(whateverColumn,20) AS shortDescription
 FROM whateverTable

This will only catch the 20 left most characters. I need the select (AS
shortDescription)
to include sentences that includes some/all of the query term(s).

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Me Vs. Search Results

2001-08-28 Thread Michael Lugassy

I'm trying to output a google like results from SQL (not verity):

1. Build a summarize result that contains only sentences that includes
most of the search word/pharases.

2. Highlight the summary - so that any search term(s) from the query
will be bold. (in example i've marked bold/highligheted as |word|):

This should apply to single/multiple search term(s):

for example, a search for hp printer buy would give:

|Printer|s are a wonderful thing ...|HP| announce the new laser |printer|
...
and a network |print| server come standard with the |HP| LaserJet 2200dn,
and it's a good
bargain for |buy|ers... has our vote, hands down, as the best |printer|
|buy| of the year. ...

Any help would be great!

Michael.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



TagFusion/$ervlet?

2001-08-25 Thread Michael Lugassy

Wasn't TagFusion/TagServlet was free (open-source) 2 months ago?

http://www.tagservlet.com/purchase.cfm

Are there any more alternatives for Macromedia expen$ive Coldfusion Server
that I should know about?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: Checking server

2001-08-21 Thread Michael Lugassy

We're about to co-locate a server in a new location.
The sales dept. of the farm and sysadmin agreed to let us
hook a computer to check their farm speed and connectivity.

prefearbly, without the need to purchase any software..

How can we do it efficiently?
How can we simulate users access and file downloads?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: a matter of milliseconds?

2001-08-19 Thread Michael Lugassy

In an OPTIMAL NETWORK conditions,
Will a server co-located in Israel perfrom as good
as a co-located server in the US?

Same hardware, same visitors from around the world
(with a slight edge for US people).

Any idea?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT: a matter of milliseconds?

2001-08-19 Thread Michael Lugassy

Len,

 probably not, ime.  typically a lot worse, since connectivity and peering
 for .il is much poorer than for USA.
 Try to telnet or develop over ftp with 500 ms delay is painful.

But will the visitors really see the diffrence?

 There was some @sshole in .il trying to anonymous ftp login into our
 machines in Paris last night from ras3-p104.hfa.netvision.net.il.  Here´s
 ping from Paris to netvision.net.il:

Send the @ssholes information to: [EMAIL PROTECTED]
They usually alert those kids!



 Len

 http://MenAndMice.com/DNS-training
 http://BIND8NT.MEIway.com : ISC BIND 8.2.4 for NT4  W2K
 http://IMGate.MEIway.com  : Build free, hi-perf, anti-abuse mail gateways



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT: a matter of milliseconds?

2001-08-19 Thread Michael Lugassy

That's a problem because I'm in Israel and would
like to see the affect on US surfers.

Would you mind trying

www.imvamp.com
www.jpost.com


Thanks,

Michael

- Original Message -
From: Len Conrad [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, August 19, 2001 4:22 PM
Subject: Re: OT: a matter of milliseconds?



 But will the visitors really see the diffrence?

 try it yourself. surf to the US hosting service, and then surf to
 www.netvision.net.il or whatever hosting svc you´re considering there.

 Len


 http://MenAndMice.com/DNS-training
 http://BIND8NT.MEIway.com : ISC BIND 8.2.4 for NT4  W2K
 http://IMGate.MEIway.com  : Build free, hi-perf, anti-abuse mail gateways



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Pushing VERITY limits

2001-08-14 Thread Michael Lugassy

I'm trying to push VERITY (version that is supplied with CF) to its limits.
Have anyone tried Verity with hunderds of thousdans of text records?

Is there a big diffrence with the version supplied on CF 4.5/5?

Thanks,

Michael


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Pushing VERITY limits

2001-08-14 Thread Michael Lugassy

Dave,

notenough
125-250,000 is not enough. any alternatives to Verity that I should
consider?
/notenough

Thanks,

Michael

- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 14, 2001 3:36 PM
Subject: RE: Pushing VERITY limits


  I'm trying to push VERITY (version that is supplied with CF)
  to its limits. Have anyone tried Verity with hundreds of thousands
  of text records?
 
  Is there a big diffrence with the version supplied on CF 4.5/5?

 CF 5 actually provides two versions of Verity: the VDK version similar to
 that in CF 4.x, and the standalone K2 server, which is newly provided in
CF
 5. From the documentation:

 The restricted version of K2 Server installed with ColdFusion has
document
 search limits as follows: 125,000 documents (ColdFusion Professional) and
 250,000 documents (ColdFusion Enterprise). Macromedia Spectra sites have a
 limit of 750,000 documents.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFMAIL and SMTP on IIS4.0 (NT4.0)

2001-08-14 Thread Michael Lugassy

Good one.
Again, are there any other HEAVY=DUTY solutions for full-text?
Other then Verity built-in (or Verity pro add_on)?

Thanks,

Michael
- Original Message -
From: David Berger [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 14, 2001 3:09 PM
Subject: CFMAIL and SMTP on IIS4.0 (NT4.0)


 I'm getting an intermittant error (in mail error log): Failed to send the
 spooled mail file.  SMTP server replied, connection limited reached.

 Our application server has ASP and Cold Fusion applications running.  We
are
 also loosing some emails from the ASP application, but not as frequently.

 So, I have a couple of questions.
 1) Does Cold Fusion use it's own SMTP service? (or are they handled
 similarly to the CDONTs with ASP on the web server?)

 2) Has anybody run into this problem, and if so how was it fixed?  (I
can't
 find any resources pertaining to SMTP settings for performance with Cold
 Fusion.)

 3) It doesn't appear that Cold Fusion attempts to resend failed emails.
 Does anybody know of an easy way to handle this? (I'm considering writing
a
 Visual Basic application to resend bad emails)

 Any information you can provide would be greatly appreciated.  Thank you!

 David Berger
 Cynergy Consulting

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Hebrew with SQL Full-Text

2001-08-14 Thread Michael Lugassy

I can't seem to run SQL Full-Text queries (FREETEXT/CONTAINS)
using hebrew. every word/phrase I try to search on, SQL is throwing:
All noise words error.

I know I have to change the SQL settings to Neutral Language.
Is that true? how can I do that?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: buying/leasing SQL

2001-08-08 Thread Michael Lugassy

I need to license SQL for DUAL cpu server and didn't find answer on MS site.

1. is it possible to still buy SQL server 7 somehow?
does the new (per-cpu) pricing apply to this?

2. is it possible to lease SQL 7/2000 somewhere?

3. is it possible to have the rather high price splitted into monthly
payments?

4. do I have to buy per-cpu license if I use SQL with Coldfusion (IIS)
to server dynamic webpages? can I buy per-seat license for this?

Michael.





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: rent a coder

2001-08-08 Thread Michael Lugassy

Someone know other sites like: rentacode.com where I can rent a coder
to do c/c++/delphi work for me? for mostly small projects.

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: multiple IE installations

2001-08-07 Thread Michael Lugassy

Is it possible to install several Internet Explorer browers (diffrent version)
on the same machine for testing? (IE4, 5, 5.5, 6)

and what about Netscape? anyone tried it?

how should I do it?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



PostgreSQL with CF

2001-08-03 Thread Michael Lugassy

Anyone tried PostgreSQL with Coldfusion?

I'm trying to develop a full-text mechanisem of 10gb table with it.
Possible? Recommended?

All comments welcome!

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



default.ida?

2001-08-03 Thread Michael Lugassy

I keep seeing on the log files some default.ida request.
are those hacking attempts? what is this file do?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



POSTgreSQL

2001-08-03 Thread Michael Lugassy

Anyone tried PostgreSQL with Coldfusion?

I'm trying to develop a full-text mechanisem of 10gb table with it.
Possible? Recommended?

All comments welcome!

Michael.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Resizing images

2001-07-31 Thread Michael Lugassy

Search the archives for thumbnails


Thanks,

Michael
- Original Message -
From: Hamid Hossain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 11:16 AM
Subject: Resizing images


 Hi,

 I want to be able to resize gif, jpg or bmp pictures
 with coldfusion.

 Any help.

 Regards,
 Hamid Hossain

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: Developing IE toolbar

2001-07-31 Thread Michael Lugassy

Prett OT, but anyone know how hard it is to program IE toolbar that will run
queries
on a cf server? something which is similar to Google's great toolbar?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Got the fellow, but....

2001-07-31 Thread Michael Lugassy

For servers?

Thanks,

Michael


 I heard BlackIce was useless. ZoneAlarm does a better job apparently.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Jon Hall
 Sent: Tuesday, 31 July 2001 5:41 AM
 To: CF-Talk
 Subject: Re: Got the fellow, but


 This is why we keep BlackIce on all of our servers, and set it to accept
 everything. It will still give you a heads up on potential bad guys and
 allow you to block the ip address very quickly.
 With all of the recent worm stuff going around, we decided to invest in
 Cisco's IDS, and have it logging live to a SQL server database...very cool
 stuff. IDS actually inspects every packet going across the wire and flags
 suspicious traffic, which you can set custom actions to happen if a
certain
 flag goes up, like blocking the ip at the router. It even detects
Sircam...

 jon

 At 03:14 PM 7/30/2001, you wrote:
 I'm doing a pretty intensive watch on my server stastics and log files
 in real-time. sometimes I see people who try stupid stuff like:
 
 /winnt/system32/cmd.exe and trying to url hack (with ;drop tables) .
 
 my question is: when I'm seeing the guy's IP address in the stas server
 or log files, and the guy is still causing problem (i,e - trying to hack)
 what can I do to him? can I throw him, and only him away?
 will adding him to the banned IP in IIS helps immediatly?
 
 any other alternatives?
 
 Michael.
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



mySQL

2001-07-31 Thread Michael Lugassy

I was wondering if someone is using mySQL with coldfusion?
and in general, can someone tell me how good mySQL is compared
to msSQL, does it support full-text? and reasonable (3-5 gb) amount of data?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: mySQL

2001-07-31 Thread Michael Lugassy

The big and most important question before I even begin installing:
a. will it support 4-5 and even 10 gig of data?
b. will it allow full-text indexing/searching?
c. does it allow replication between remote servers?
d. anyone know something about hebrew support?

Michael.

- Original Message -
From: Tracy Bost [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 11:58 PM
Subject: Re: mySQL


 We're using MySQL on a linux box with coldfusion for some things.
  As far as select statements go, its extremely fast even with a large
amount
 of data.
MS-SQL is going to give you alot more functionality though.

 - Original Message -
 From: Michael Lugassy [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, July 31, 2001 5:10 PM
 Subject: mySQL


  I was wondering if someone is using mySQL with coldfusion?
  and in general, can someone tell me how good mySQL is compared
  to msSQL, does it support full-text? and reasonable (3-5 gb) amount of
 data?
 
  Michael.
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Got the fellow, but....

2001-07-30 Thread Michael Lugassy

I'm doing a pretty intensive watch on my server stastics and log files
in real-time. sometimes I see people who try stupid stuff like:

/winnt/system32/cmd.exe and trying to url hack (with ;drop tables) .

my question is: when I'm seeing the guy's IP address in the stas server
or log files, and the guy is still causing problem (i,e - trying to hack)
what can I do to him? can I throw him, and only him away?
will adding him to the banned IP in IIS helps immediatly?

any other alternatives?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: DOSS Attacks (Was: Got the fellow, but....)

2001-07-30 Thread Michael Lugassy

Sorry for the way newbie q. here but what are those DOSS
attacks? I've heard that there is no solution for them. true?

Michael.

- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 30, 2001 8:52 PM
Subject: Re: Got the fellow, but


 You're going to see a lot of these.  If it's just someone doing this from
 his home computer and he's got a fixed IP, then yes, you'll cut him off.
 However, if he's got a dialup and gets different IP addresses, it won't
help
 for long.

 More likely what you'll see is someone who's hacked into other computers
and
 is using those computers to find other vulnerable systems.  Selectively
 cutting off those IP addresses is like trying to fill the holes in a block
 of swiss cheese.  If you're not vulnerable to this exploit, don't worry
 about it.  Worry more about DDOS attacks.

 Jim


 - Original Message -
 From: Michael Lugassy [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, July 30, 2001 1:14 PM
 Subject: Got the fellow, but


  I'm doing a pretty intensive watch on my server stastics and log files
  in real-time. sometimes I see people who try stupid stuff like:
 
  /winnt/system32/cmd.exe and trying to url hack (with ;drop tables) .
 
  my question is: when I'm seeing the guy's IP address in the stas server
  or log files, and the guy is still causing problem (i,e - trying to
hack)
  what can I do to him? can I throw him, and only him away?
  will adding him to the banned IP in IIS helps immediatly?
 
  any other alternatives?
 
  Michael.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Put into Reverse

2001-07-30 Thread Michael Lugassy

I'm having difficulties reversing a long string that was written in backward hebrew.
which means it was first written from right to left AND opposite (dont ask...)

something like:
skrab dna riah tuo evael yehT. sgod etah I.

I want to get this string back to it's straight form
(I hate dogs. They leave out hair and barks.).

Reversing all the string won't help, neither will reversing each word and
sticking it together (sentences won't be in order). I had limited success when
trying to first split the sentences (. as the delimter), but no 100% solution.
I know this is doable, because Internet Explorer uses the Visual Encoding, which
acts the same (on the same text).

! pleH

leahciM


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Put into Reverse (cf_hinojosa)

2001-07-30 Thread Michael Lugassy

Guess my example was wrong, hebrew is more likely to look like this:
.sgod etah I .skrab dna riah tuo evael yehT

which gives out (using cf_hinojosa)
They leave out hair and barks. I hate dogs.

And THATS the same problem I get with hebrew.

Michael.

 Original Message -
From: Hinojosa, Robert A [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 30, 2001 11:43 PM
Subject: RE: Put into Reverse


 This should work.

 cfset str = .skrab dna riah tuo evael yehT .sgod etah I
 cfset newStr = 
 cfloop to=1 from=#Len(str)# step=-1 index=i
 cfset newStr = newStr  mid(str, i, 1)
 /cfloop
 cfoutput#newStr#/cfoutput



 -Original Message-
 From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 30, 2001 5:25 PM
 To: CF-Talk
 Subject: Put into Reverse


 I'm having difficulties reversing a long string that was written in
backward
 hebrew.
 which means it was first written from right to left AND opposite (dont
 ask...)

 something like:
 skrab dna riah tuo evael yehT. sgod etah I.

 I want to get this string back to it's straight form
 (I hate dogs. They leave out hair and barks.).

 Reversing all the string won't help, neither will reversing each word and
 sticking it together (sentences won't be in order). I had limited success
 when
 trying to first split the sentences (. as the delimter), but no 100%
 solution.
 I know this is doable, because Internet Explorer uses the Visual Encoding,
 which
 acts the same (on the same text).

 ! pleH

 leahciM

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Put into Reverse (WWF)

2001-07-30 Thread Michael Lugassy

works great in english, but gives the same errors on my hebrew data.
Apperantly hebrew is somehow diffrent, I'll try to explain what I see.

I see sentence which need to be no. 1 sometimes starting alright, but
sentence
number 2 starts after sentence number 3.

Let's say if I would've tried something like this (in hebrew):
I hate dogs. They leave out hair and barks. And also Cats. You know I hate
cats.

I would've gotten: I hate dogs. And also Cats. They leave out hair and
barks. You ...
and sometimes:
And also Cats. I hate dogs. They leave out hair and barks. You know...

Any thoughts on why this is not consistent?

Michael.


- Original Message -
From: Hinojosa, Robert A [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 12:17 AM
Subject: RE: Put into Reverse


 last one... sorry.

 change the order of the output of the sentences array.  Like this.
 Robert.

 !--- Output the sentences ---
 cfloop to=1 from=#arrayLen(sentences)# step=-1 index=i
 cfoutput#sentences[i]#/cfoutput
 /cfloop

 then that should yield.

 I hate dogs. They leave out hair and barks.


 -Original Message-
 From: Hinojosa, Robert A [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 30, 2001 5:05 PM
 To: CF-Talk
 Subject: RE: Put into Reverse


 I might've misunderstood your first request because I thought that the
 periods at the end of the reverse request was a typo.  But I think I
 understand now, only the words are reversed and not sentence
 structure(periods)?   Anyway,  if they are, here is that code that will
keep
 that in tact.

 Robert

 cfset str = skrab dna riah tuo evael yehT. sgod etah I.

 cfset sentences = arrayNew(1)
 cfset counter = 1

 !--- Loop through Sentences ---
 cfloop list=#str# index=sentence delimiters=.
 cfset newStr = 
 !--- Reverse Sentence ---
 cfloop to=1 from=#Len(sentence)# step=-1 index=i
 cfset newStr = newStr  mid(sentence, i, 1)
 /cfloop
 !--- Add the delimiter back ---
 cfset newStr = trim(newStr)  .
 !--- Add sentence to array ---
 cfset sentences[counter] = newStr
 cfset counter = counter + 1 
 /cfloop

 !--- Output the sentences ---
 cfloop from=1 to=#arrayLen(sentences)# index=i
 cfoutput#sentences[i]#/cfoutput
 /cfloop


 -Original Message-
 From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 30, 2001 5:25 PM
 To: CF-Talk
 Subject: Put into Reverse


 I'm having difficulties reversing a long string that was written in
backward
 hebrew.
 which means it was first written from right to left AND opposite (dont
 ask...)

 something like:
 skrab dna riah tuo evael yehT. sgod etah I.

 I want to get this string back to it's straight form
 (I hate dogs. They leave out hair and barks.).

 Reversing all the string won't help, neither will reversing each word and
 sticking it together (sentences won't be in order). I had limited success
 when
 trying to first split the sentences (. as the delimter), but no 100%
 solution.
 I know this is doable, because Internet Explorer uses the Visual Encoding,
 which
 acts the same (on the same text).

 ! pleH

 leahciM

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: To hell with it all......

2001-07-30 Thread Michael Lugassy

You guys are starting in Monday and still complaining???

Michael, Israel


- Original Message -
From: Justin Hansen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 1:16 AM
Subject: RE: To hell with it all..


 Sounds like someone has a case of the Mondays.
 That'd be great

 Hope that helps  :)
 Justin


 -Original Message-
 From: BT [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 30, 2001 6:04 PM
 To: CF-Talk
 Subject: RE: To hell with it all..


 Another Monday.

 -Original Message-
 From: Fuon See Tu [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 30, 2001 7:09 PM
 To: CF-Talk
 Subject: Re: To hell with it all..


 huh???


 From: BT [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: To hell with it all..
 Date: Mon, 30 Jul 2001 18:56:42 -0400
 
 I say to hell with this whole Internet thing
 
 -Original Message-
 From: Lee Fuller [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 30, 2001 6:59 PM
 To: CF-Talk
 Subject: RE: Something wrong with my CFIF (to Lee Fuller)
 
 
 No.. It doesn't.
 
 Take a look at the ISNULL CF function.
 
  Lee
 
 
   -Original Message-
   From: Fuon See Tu [mailto:[EMAIL PROTECTED]]
   Sent: Monday, July 30, 2001 3:32 PM
   To: CF-Talk
   Subject: RE: Something wrong with my CFIF (to Lee Fuller)
  
  
   I think CF treats Null and  as the same.  Right?
  
   From: Lee Fuller [EMAIL PROTECTED]
   Reply-To: [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Subject: RE: Something wrong with my CFIF
   Date: Mon, 30 Jul 2001 15:29:26 -0700
   
   The DB field isn't .. It's most likely NULL.
   
   Try using ISNULL and/or wrap the var with TRIM.. i.e.,
   #trim(myvar)#.  That will remove any extraneous spaces.. Etc.
   
   
   Lee Fuller
   Chief Technical Officer
   PrimeDNA Corporation / AAA Web Hosting Corporation
   We ARE the net.
   http://www.aaawebhosting.com
   
   
   
 -Original Message-
 From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 30, 2001 3:14 PM
 To: CF-Talk
 Subject: Something wrong with my CFIF


 If I run any of these;
 cfif qGetLab.Critical_High NEQ 
tr
 TH
Critical High
   /TH
   td
#Critical_high#
   /td
/tr
/cfif

 cfif (qGetLab.Critical_High) NEQ 
tr
 TH
Critical High
   /TH
   td
#Critical_high#
   /td
/tr
/cfif

 cfif (#qGetLab.Critical_High#) NEQ 
tr
 TH
Critical High
   /TH
   td
#Critical_high#
   /td
/tr
/cfif

 and the DB field is empty, I should not see those rows.
   Problem is,
 I do see those rows, and the DB field is empty. What
   gives? I have
 done this a thousand times before with no problems.



   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Big, Very BIG

2001-07-25 Thread Michael Lugassy


I'm looking for a big search engine solution.
Not a simple verity collection, something very big (10-20 million rows of text).
I've looked into SQL full text search but it has it disadvantages.

can someone help in reffering me to some solution? maybe outsource or a 3rd party
which is recommended?


-Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Hebrew in SQL

2001-07-25 Thread Michael Lugassy

Do you know if I can put hebrew characters inside a SQL 7.0 database?

I want to enable full-text searching via MS-SQL capability, 
Will one of MSSQL versions will support it?

Do I need a hebrew supported operating system for that?

(I don't want to use unicode)

Thanks,

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Big, Very BIG

2001-07-25 Thread Michael Lugassy

10,000,000 rows of text? can Verity handle that?
is this what the big portals and search indexes are doing?

Thanks,

Michael
- Original Message -
From: Paul Ihrig [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 6:33 PM
Subject: RE: Big, Very BIG


 i would use verity.
 it can handle this.

 you can even buy a supped up version of verity if you want

 -paul


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Making A Local Copy of a CF site...

2001-07-24 Thread Michael Lugassy

Try offline explorer Pro
at http://www.metaproducts.com


this will create an offline version of any given site
no matter how complex it is (coldfusion, javascript, flash, java...)

Check it out,.

Michael.

- Original Message -
From: Dasher [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 8:31 PM
Subject: Making A Local Copy of a CF site...


 I need to find some way to step through
 a Cold Fusion site I have, process the CFM pages,
 and then save the result into a seperate folder
 so I don't need CF to navigate it anymore.

 Any ideas?


 -- Dasher
 [EMAIL PROTECTED]
 http://www.bentmedia.com/
 Bent Media, Inc.
 128 South Clark Street
 New Orleans, LA 70119-6103
 Phone - 504.488.2848 x19
 Fax - 504.488.2979



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: date field

2001-07-24 Thread Michael Lugassy

IsDate
Returns TRUE if string can be converted to a date/time value; otherwise,
FALSE. Note that ColdFusion converts the Boolean return value to its string
equivalent, Yes and No.

cfif isDate(weirdcolum)

#DateFormat(weirdcolum)#

cfelse

#weirdcolum#

/cfif



Helps?

Michael.

Interactive Music Ltd.

http://www.imvamp.com

- Original Message -
From: Joshua Tipton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 8:37 PM
Subject: date field


 I have a query that returns a field that is either a date or N/A or No or
 Now.  I want it to output the words if there is words and if there isnt
then
 do a dateformat on the date.  How can I do this?

 Joshua Tipton



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Fusebox and Search Engines/Statistics

2001-07-24 Thread Michael Lugassy

I'm curious on why do you need to track each and every page on your site.

If statistics is what bothering you, just implement a cfquery that will
raise
counter for specific tasks/pages you want to track seriously (that's what we
do).
just don't forget to use cftrycfcatch to skip the counting if something
goes wrong (better not track a single view then to give a stupid error).

Anyhow, I'm intrested too if a cfinclude template=/comp/welcome.html
would count as a hit on welcome.html with IIS stastics?

anyone?

Michael Lugassy,
Interactive Music Ltd.
http://www.imvamp.com

- Original Message -
From: Frank Mamone [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 8:29 PM
Subject: Fusebox and Search Engines/Statistics


 I am just reading up onFusebox and find it pretty interesting. However,
 before developing with that methodology, I am trying to determine the pros
 and cons of it.

 I have a question:

 How does always calling index.cfm impact statistics and indexing of the
 website?


 I welcome anyone's comments on this issue on determing pro/cons. I'm sure
 there are other users with the same dilemma.

 Thanks,

 Frank Mamone.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Me Vs. Complexed Table Design

2001-07-23 Thread Michael Lugassy

We have a big index of sites, each site belongs to a certain main category
and a sub_category. 

Certain sites are nested inside 2,3 and even 5 sub-sub categories.

How can I create a category(ies) table(s) that will store the catID and catNAME?
(each category/subcategory ID takes 2 places xx)

Here is an Example:

The Yahoo! site, for example is in:

Computers and Internet  Internet  Internet and Search Engines  Directories  World

Where Computers and Internet = 24 00 00 00 00
(I've added space just to explain what I need)
Internet = 24 11 00 00 00
Internet and Search Engines = 24 11 92 00 00 00
Directories = 24 11 92 83 00 00
World = 24 11 92 83 00 

Ofcourse there could be more then one sub-sub category named world
and the sub-sub count varies.

Any help, tips, something?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Me Vs. Complexed Table Design

2001-07-23 Thread Michael Lugassy

I didn't find secretagents' tutorial,
the site looks alot like hotmail, I can't get in without becoming
a member, or what? :)

I would like to take a look at it before implement the alternative.

Michael.

- Original Message -
From: Norman Elton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 8:07 PM
Subject: Re: Me Vs. Complexed Table Design


 Sounds like you're trying to implement a tree (it's formal
 name). For a good lesson, check out Steve Nelson's free
 tutorial at www.secretagents.com. The concepts somewhat
 complicated, so you might have to read it a few times, but
 works well.

 As an alternative, you could just keep track of the
 following for each record:

 1. ID
 2. Name
 3. Parent ID

 Where Parent ID is the parent of the current record. This
 makes it hard to build a link from a record (known as a
 node) back to the root of the tree. You'd probably have to
 loop over a CFQUERY, which gets nasty.

 Hope this helps

 Norman

 Quoting Michael Lugassy [EMAIL PROTECTED]:

  We have a big index of sites, each site belongs to a
  certain main category
  and a sub_category.
 
  Certain sites are nested inside 2,3 and even 5
  sub-sub categories.
 
  How can I create a category(ies) table(s) that will
  store the catID and catNAME?
  (each category/subcategory ID takes 2 places xx)
 
  Here is an Example:
 
  The Yahoo! site, for example is in:
 
  Computers and Internet  Internet  Internet and
  Search Engines  Directories  World
 
  Where Computers and Internet = 24 00 00 00 00
  (I've added space just to explain what I need)
  Internet = 24 11 00 00 00
  Internet and Search Engines = 24 11 92 00 00 00
  Directories = 24 11 92 83 00 00
  World = 24 11 92 83 00
 
  Ofcourse there could be more then one sub-sub
  category named world
  and the sub-sub count varies.
 
  Any help, tips, something?
 
  Michael.
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Me Vs. Complexed Table Design

2001-07-23 Thread Michael Lugassy

Let's say I'm using the second (following) alternative:

CATEGORIES:
catID
parentCat
catName

SITES:
siteID
siteName
catID (FK)

and I want to display a tree of categories, based on a catID from sites
how can I SQL-SELECT recursivley, all the relevent catNAMES?

Sounds pretty messy...

Michael.

- Original Message -
From: Philip Arnold - ASP [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 9:13 PM
Subject: RE: Me Vs. Complexed Table Design


  I didn't find secretagents' tutorial,

 That's because it's Secret g

 Actually, it's here
 http://www.secretagents.com/tools/freeviewlets/
 (You Still Have Time To Learn, Free Online Training)

 or here
 http://www.secretagents.com/tools/viewlets/
 (You Still Have Time To Learn, Professional Online Tutorials)

 Philip Arnold
 Director
 Certified ColdFusion Developer
 ASP Multimedia Limited
 T: +44 (0)20 8680 1133

 Websites for the real world

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 **




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Me Vs. Complexed Table Design

2001-07-23 Thread Michael Lugassy

I think I'll look into the secret agent thingy.
I didn't understand one thing - why did he created a sql view?
can I do without it?

Michael.

- Original Message -
From: Norman Elton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 9:48 PM
Subject: Re: Me Vs. Complexed Table Design


 You're right, it gets messy very quickly. The big drawback
 is lots of queries. If you're five or six levels deep,
 your page will take five or six queries to figure out the
 path back to the root. This might not be what you want if
 you're aiming for performance. Of course, if you cache the
 queries, you could be in luck.

 I implemented it once using CFLOOP. Inside the loop is a
 CFQUERY that fetches the next level up, and stores its data
 into an array. Keep looping until the next level up has
 the ID of zero, which means you've reached the top. The top
 level record has a parent of zero.

 I've wanted to go back and convert it to the nested tree
 model, but haven't gotten around to it :)

 If you need more detailed info, i can dig up the code.

 Norman

 Quoting Michael Lugassy [EMAIL PROTECTED]:

  Let's say I'm using the second (following)
  alternative:
 
  CATEGORIES:
  catID
  parentCat
  catName
 
  SITES:
  siteID
  siteName
  catID (FK)
 
  and I want to display a tree of categories, based on
  a catID from sites
  how can I SQL-SELECT recursivley, all the relevent
  catNAMES?
 
  Sounds pretty messy...
 
  Michael.
 
  - Original Message -
  From: Philip Arnold - ASP [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, July 23, 2001 9:13 PM
  Subject: RE: Me Vs. Complexed Table Design
 
 
I didn't find secretagents' tutorial,
  
   That's because it's Secret g
  
   Actually, it's here
   http://www.secretagents.com/tools/freeviewlets/
   (You Still Have Time To Learn, Free Online
  Training)
  
   or here
   http://www.secretagents.com/tools/viewlets/
   (You Still Have Time To Learn, Professional Online
  Tutorials)
  
   Philip Arnold
   Director
   Certified ColdFusion Developer
   ASP Multimedia Limited
   T: +44 (0)20 8680 1133
  
   Websites for the real world
  
  
 
 
 **
   This email and any files transmitted with it are
  confidential and
   intended solely for the use of the individual or
  entity to whom they
   are addressed. If you have received this email in
  error please notify
   the system manager.
  
 
 
 **
  
  
  
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: Complex Select

2001-07-22 Thread Michael Lugassy


Is it possible to SQL-SELECT a specific number of rows from between the result set.
NOT by using the BETWEEN keyword in the WHERE clause, but by choosing
to select only rows x through y.

let's say I have this results set

personID  personNAME
1 Michael
2 Roman
3 David
4 Ilia
5 Uri

I want to get Roman till Ilia, WITHOUT specifiying - WHERE personID BETWEEN 2 AND 4
but Specifying something liek:

SELECT ROWS 2 TILL 4 FROM personalls (without personID, which I want to get!)

Is this possible?

Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: [OT: Complex Select]

2001-07-22 Thread Michael Lugassy

Alex,

The Database is Access, how can I loop, exactly?

Michael.

 what dastabase? you could do it it in a stored proc with a loop

 Michael Lugassy [EMAIL PROTECTED] wrote:

 Is it possible to SQL-SELECT a specific number of rows from between the
result
 set.
 NOT by using the BETWEEN keyword in the WHERE clause, but by choosing
 to select only rows x through y.

 let's say I have this results set

 personID  personNAME
 1 Michael
 2 Roman
 3 David
 4 Ilia
 5 Uri

 I want to get Roman till Ilia, WITHOUT specifiying - WHERE personID
BETWEEN 2
 AND 4
 but Specifying something liek:

 SELECT ROWS 2 TILL 4 FROM personalls (without personID, which I want to
get!)

 Is this possible?

 Michael.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: General windows question

2001-07-22 Thread Michael Lugassy

CF_formatkindaWay OFF TOPIC and Not intresting!/CF_format

Thanks,

Michael
- Original Message -
From: jonathan hamner [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, July 22, 2001 6:21 PM
Subject: General windows question


 When you click on start, then click on run. Then when
 you type a letter, it will bring up the list of
 programmes you have opened or the websites etc. Is
 there a way to clear this also as the list has gone
 enormously loong. I have tried clearing
 history, cookies and the whole temp internet files
 folder. it did not help. please advise. thanks.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: HTML image

2001-07-21 Thread Michael Lugassy

Adrian -

Check out http://www.html2jpg.com
I recently checked ver 2.1 and had great success!

Michael

- Original Message -
From: Adrian Cesana [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 9:38 PM
Subject: HTML  image


 Anyone know of any tools available to convert HTML to a gif or jpg?

 I am currently creating a UPS shipping label with barcodes and maxi code
 etcall html based.  I need to convert this to a gif or jpg so I can
 print it in portrait mode but having the label rotated 90deg.

 I guess an alternative would be to generate the HTML but rotated 90deg? is
 that possible?

 Thanks! Adrian




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: HTML image

2001-07-21 Thread Michael Lugassy

I've succesfuly used CFHTTP in the past to GRAB the data
from a publisher website, then parsed the information using left,mid,find,
and
other functions and then created an image (on_the_fly) using CFX_image's
action: PASTE_TEXT

you can create any image you'd like, in any format and define x,y, font
size,
color and even paste images.

Contact me offlist if you're having problems.

Michael.

- Original Message -
From: Adrian Cesana [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 9:55 PM
Subject: RE: HTML  image


 thanks but I need to integrate the process into an application so its
 somewhat seamless.  I cant ask the end user to take a print screen, crop
the
 image, then print.  It needs to just come up on a page ready to
 print.thats my challenge.

 thanks,Adrian

 -Original Message-
 From: Robert Grody [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, July 21, 2001 12:52 PM
 To: CF-Talk
 Subject: RE: HTML  image


 It's easy.  Load the HTML in a browser and take a screen capture using a
 tool like Snagit.

 Thanks,

 Bob Grody


  -Original Message-
  From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, July 21, 2001 3:39 PM
  To: CF-Talk
  Subject: HTML  image
 
 
  Anyone know of any tools available to convert HTML to a gif or jpg?
 
  I am currently creating a UPS shipping label with barcodes and maxi code
  etcall html based.  I need to convert this to a gif or jpg so I can
  print it in portrait mode but having the label rotated 90deg.
 
  I guess an alternative would be to generate the HTML but rotated 90deg?
is
  that possible?
 
  Thanks! Adrian
 
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



sending a file directly

2001-07-19 Thread Michael Lugassy

I have a page with direct links to ZIP files (i.e http://mydomain/1.zip, 2.zip and so 
on..)
I'm trying to find a way to count hits on that link WITHOUT opening a pop up window.

I.e - users will click on the ZIP file, a cf page will answer, count the hit to the 
database and
then release the file, without refreshing.

Is that possible?


Thanks,

Michael


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: sending a file directly

2001-07-19 Thread Michael Lugassy

Thomas, It's not that simple.
I don't want a pop up window to relase the file with cfcontent,
yet I don't want the file to be displayed on the main page on every 
view.
just on click.

Thanks,

Michael

- Original Message -
From: Thomas Chiverton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 2:25 PM
Subject: RE: sending a file directly


  Is that possible?

 You want CFCONTENT...


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RequestTimeOut

2001-07-18 Thread Michael Lugassy

Can I set a special RequestTimeout value for certain files
that are located in the same directory using application.cfm?

if so, what should I add there?

Thanks,

Michael 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Scoping Variable

2001-07-18 Thread Michael Lugassy

how do I enforce CF to use only url.q and not simply q
i.e -  how to ask cf to search for scoping on every variable?
where is it in the administrator?

Thanks,

Michael 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Scoping Variable

2001-07-18 Thread Michael Lugassy

wasn't there a switch in cf admin that would only use SCOPE variables
and WON'T allow, let say: a URL.p to be considered a FORM.p?

I think I read it boost performance also? but I might be confused with
something
else.

Thanks,

Michael
- Original Message -
From: Andy Ewings [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 2:45 PM
Subject: RE: Scoping Variable


 by doing exactly what you said!.  Prefix your variables with the
 scope e.g.
 url.q, form.q, client.q, etc

 The order with which CF looks for them is:

 QUERY RESULT VARS
 LOCAL
 CGI
 FILE
 URL
 FORM
 COOKIE
 CLIENT


 --
 Andrew Ewings
 Project Manager
 Thoughtbubble Ltd
 http://www.thoughtbubble.net
 --
 United Kingdom
 http://www.thoughtbubble.co.uk/
 Tel: +44 (0) 20 7387 8890
 --
 New Zealand
 http://www.thoughtbubble.co.nz/
 Tel: +64 (0) 9 488 9131
 --
 The information in this email and in any attachments is confidential
 and
 intended solely for the attention and use of the named addressee(s).
 Any
 views or opinions presented are solely those of the author and do 
not
 necessarily represent those of Thoughtbubble. This information may 
be
 subject to legal, professional or other privilege and further
 distribution
 of it is strictly prohibited without our authority. If you are not 
the
 intended recipient, you are not authorised to disclose, copy,
 distribute, or
 retain this message. Please notify us on +44 (0)207 387 8890.



 -Original Message-
 From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
 Sent: 18 July 2001 14:35
 To: CF-Talk
 Subject: Scoping Variable


 how do I enforce CF to use only url.q and not simply q
 i.e -  how to ask cf to search for scoping on every variable?
 where is it in the administrator?

 Thanks,

 Michael

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: COUNT(*)

2001-07-18 Thread Michael Lugassy

Which is faster?
COUNT(*) or COUNT(fileID)

assuming fileID is a regular INT, that is also my primary key

Thanks,

Michael 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: COUNT(*) I think I think ;-)

2001-07-18 Thread Michael Lugassy

No straight answer, ha?

Thanks,

Michael


- Original Message - 
From: Pete Freitag [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 5:58 PM
Subject: RE: COUNT(*)


 I think this depends on the DBMS that you are using.  In SQL Server 
I 
 think
 COUNT(field) is faster, and in Access COUNT(*) is faster.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Reversing Text Order BUT...

2001-07-17 Thread Michael Lugassy

Paul,

I will first need to make use of all the offline content that the company
have
on backward hebrew...

Thanks,

Michael
- Original Message -
From: Paul Hastings [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 17, 2001 7:48 AM
Subject: Re: Reversing Text Order BUT...


  I need to do a complexed revers of a long text file that includes hebew,
 english and numbers.

 use Unicode instead of monkeying around w/bidirectionality.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



IE crashes when copying shortcut?

2001-07-17 Thread Michael Lugassy

I've seen this in a couple of sites, now it's happening to me!

Did someone tried to right click an image or link in IE 5.5
and chose copy shortcut and got a IE crash?

I'm trying to do so on every one of our thumbnails here:

http://www.imvamp.com/photoshare/?action=browsegrid=Pokimon

and CRASH!
 
this is the URL that need to be copied (I've copy pasted from the address bar after 
clicking)
http://www.imvamp.com/photoshare/?action=browsegrid=Pokimonphid=1787colid=1cols=3

Can someone try and tell me what happens? and better yet - how can I solve this? :(((

Michael.
http://share.imvamp.com


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Me Vs. Counters

2001-07-17 Thread Michael Lugassy

I'm trying to find the best way to count hits on multiple files on a photoshare site.
Each photo (jpeg) is called using a .cfm page (to include the next/prev
interface and photo details) like this:

http://www.imvamp.com/photoshare/?action=browsegrid=Pokimonphid=1787colid=1cols=3

Questions:

1. Is there a better solution then to include a CFQUERYUPDATE/CFQUERY
in the bottom of each page to count hits?

2. Is it possible to somehow use IIS log files to intereprt hits better?
(we have LOG visit turned on on those resources)

3. If that's the only solution, can someone explain how can I make use of the 
cftry/cfcatch thing on the CFQUERYUPDATE section so that if an erro
occur in the update process to the db will be down, users will still see the image 
without a cf error.

Thanks!

Michael.
http://share.imvamp.com




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Licensing Search Engine Results

2001-07-16 Thread Michael Lugassy

Search Results that include all/most of the WEB's pages, yes.

Thanks,

Michael
- Original Message -
From: Lee Fuller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, July 15, 2001 8:36 PM
Subject: RE: Licensing Search Engine Results


 I think the more important question is would you WANT other search
 results?

 Lee


  -Original Message-
  From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
  Sent: Sunday, July 15, 2001 12:05 PM
  To: CF-Talk
  Subject: WOT: Licensing Search Engine Results
 
 
  Can anyone recommend a good search engine company that will
  license the search results and allow me to put them on my
  site, after full customization? (Other the the OBVIOUS
  google/altavista
  which seem a bit expensive.)
 
  This is kinda WOT but I'm gonna use CF to customize the
  results on the back end.
 
  Thanks,
 
  Michael
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Love CF, what about CFFLUSH?

2001-07-16 Thread Michael Lugassy

I just finish one heck of a Photo Share mechanisem with CF 4.5 in JUST 2 weeks! :)))
Databases, Images, thumbnails, subscriptions, http calls, everything! but one thing
IS DEFINITLY MISSING - the new CFFLUSH tag.

I wanted to ask how well does it perfom?
My site need sometime to make extensive calculations and manipulation before
showing the final page. this may take some time a bit.
will the CFFLUSH help to show the page, part by part? so users won't click STOP and 
vanish??

Thanks,

Michael Lugassy

VAMP Photo Share!
http://www.imvamp.com/photoshare/index.htm
Serving all of your media needs.






~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Love CF, what about CFFLUSH?

2001-07-16 Thread Michael Lugassy

WOW Guys,
I'm seeing on my logs that LOTS of you are visiting the site.
would it be alright if I ask what do you think about it???

It was built completly with Coldfusion and was a great experience for me.

Stop downloading the Harry Potter gifs!! :)

Thanks,

Michael
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 9:44 PM
Subject: Re: Love CF, what about CFFLUSH?


 Works well for me in some initial use... Certainly gives the
 perception of a more responsive system.

 One thing to keep in mind, of course, is that CFFLUSH won't help if
 your output is contained within a single HTML table for formatting
 purposes. In one case where I had been using such a table to
 define a nav menu at the left and the main content area to the right,
 I've added some conditional code to my CFINCLUDEd header and
 footer code so the user has the option of switching to a horizontal
 layout. This puts the menu at the top of the page and CFFLUSH
 can freely do its thing on the page output without the use of a
 single large container HTML table and its associated output
 issues. Guess I could have used frames to accomplish the same
 thing...

 Gene Kraybill

 On 16 Jul 2001, at 19:12, Michael Lugassy wrote:

  I just finish one heck of a Photo Share mechanisem with CF 4.5 in JUST 2
weeks! :)))
  Databases, Images, thumbnails, subscriptions, http calls, everything!
but one thing
  IS DEFINITLY MISSING - the new CFFLUSH tag.
 
  I wanted to ask how well does it perfom?
  My site need sometime to make extensive calculations and manipulation
before
  showing the final page. this may take some time a bit.
  will the CFFLUSH help to show the page, part by part? so users won't
click STOP and vanish??
 
  Thanks,
 
  Michael Lugassy
 
  VAMP Photo Share!
  http://www.imvamp.com/photoshare/index.htm
  Serving all of your media needs.
 
 
 
 
 
 
 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: execute programs

2001-07-16 Thread Michael Lugassy

use cfexecute! almost every program can run very well with params
or in command line mode to create great stuff.

make sure the coldfusion user/system has enough privilieges, though.

Michael.

- Original Message -
From: Jones, Becky [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 9:30 PM
Subject: execute programs


 is there a cutsom tag or a cf tag that would allow me to execute a program
 from a web browser?  like could i run notepad or word thru the web
browser?


 *
 This e-mail, including any attachments, is intended for the
 receipt and use by the intended addressee(s), and may contain
 confidential and privileged information.  If you are not an intended
 recipient of this e-mail, you are hereby notified that any unauthorized
 use or distribution of this e-mail is strictly prohibited.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



javascript vars to cf vars?

2001-07-16 Thread Michael Lugassy

this might sound stupid but - is it possible to put js vars (like, screen width) into
coldfusion vars?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Reversing Text Order BUT...

2001-07-16 Thread Michael Lugassy

I need to do a complexed revers of a long text file that includes hebew, english and 
numbers.

because hebrew is written backwards on htmls, I will need to reverse all
hebrew chars, recognized by specific chr numbers (150-179, for example)
BUT keep the english and numbers in the same order.

I can't use regular reverse(), I will need somehow to go over each char and look
for space as seperator.

Checked the gallery for something similiar.. nothing.

Any help?

Michael.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



WOT: Licensing Search Engine Results

2001-07-15 Thread Michael Lugassy

Can anyone recommend a good search engine company that will license the search results
and allow me to put them on my site, after full customization? (Other the the OBVIOUS 
google/altavista 
which seem a bit expensive.)

This is kinda WOT but I'm gonna use CF to customize the results on the back end.

Thanks,

Michael 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFTry/CFCatch

2001-07-12 Thread Michael Lugassy

Yes

- Original Message -
From: Duane Boudreau [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 8:38 PM
Subject: CFTry/CFCatch


 If an error is caught by cftry/cfcatch is it logged in the server or
 application log?

 TIA,
 Duane



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Important ColdFusion Security Patch Released Today

2001-07-11 Thread Michael Lugassy

Maybe they don't want no hackers to take advantage of that melicous bug?
Let's install it, god d$$m

Michael.

- Original Message -
From: Larry W. Virden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 11:47 PM
Subject: Re: Important ColdFusion Security Patch Released Today



 From: Howie Hamlin [EMAIL PROTECTED]

  2) the nature of the security problem - obviously MM is going for
  security-thru-obscurity and is not going to describe the exact problem,
but
  some clue as to the possible effects, how to tell if the weakness has
been
  taken advantage of, etc would be helpful
 
 
 No idea...in a way it's better that they don't point out the
vulnerability.

 And in a way it is far worse - since while we are 'closing the door' on
 a bug, without more details, how can we tell if someone has taken
advantage
 of that open door on our system?
 --
 Never apply a Star Trek solution to a Babylon 5 problem.
 Larry W. Virden mailto:[EMAIL PROTECTED] URL:
http://www.purl.org/NET/lvirden/
 Even if explicitly stated to the contrary, nothing in this posting should
 be construed as representing my employer's opinions.
 --


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cffile error

2001-07-10 Thread Michael Lugassy

Weird, I'm getting the same error when I ran out of ram or restart the
cf-server
(while trying to view a .cfm file), maybe the file you are uploading is very
big?
try uploading a simple 10Kb TXT file, see what happens.

also - try changing upload2.cfm to include only 1 task (file upload OR db
insert)
this way you can figure out what is maxing the server (or generating this
unique error).

make sure you have enough space on h:\ and that you have write/modify rights
on this directory - as the best practice, I suggest again to upload a 10kb
txt
file to c:\cfusion or somewhere easier.

Let me know,

Michael.


- Original Message -
From: Parra, Fernando [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, July 07, 2001 1:58 AM
Subject: cffile error


 Can anyone help me?

 I am trying to set an upload form and I am getting the following error:

 Error Occurred While Processing Request
 Error Diagnostic Information Request canceled or ignored by serverServer
 busy or unable to fulfill request. The server is unable to fulfill your
 request due to extremely high traffic or an unexpected internal error.
 Please attempt your request again (if you are repeatedly unsuccessful you
 should notify the site administrator). (Location Code: 26)
 Please inform the site administrator mailto:[EMAIL PROTECTED] that this
error
 has occurred (be sure to include the contents of this page in your message
 to the administrator).

 Here is the code:



 FORM:

 form action=upload2.cfm method=post enctype=multipart/form-data

 input type=hidden name=doc_cat value=
 table border=0 align=center style=font-size: xx-small; font-family:
 Arial; font-weight: bold
 tr
 tdPlease Choose a File to Uploadbrinput type=File
 name=NewFile size=20/td
 tdName of Documentbrinput type=text name=doc_title/td
 /tr
 tr
 td
 !--- Nested table ---
 table border=0 style=font-size: xx-small; font-family: Arial;
 font-weight: bold cellpadding=0 cellspacing=0
 tr
 tdUpload Date/td
 td width=40nbsp;/td
 !--- tdNumber of Pages/td ---
 /tr
 tr
 tdinput type=text name=doc_date value=mm/dd/
 size=10/td
 tdnbsp;/td
 !--- tdinput type=text name=doc_pags size=5/td ---
 /tr
 /table
 /td
 tdAuthorbrinput type=text name=doc_author/td
 /tr

 tr
 td colspan=2Document's Descriptionbrtextarea
 name=doc_description cols=45 rows=5 wrap=virtual/textarea/td
 /tr
 tr
 tdnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;input
 type=Submit value=Upload File/td
 /tr
 /table
 /form


ACTION::
 ::

 cffile action=UPLOAD filefield=form.NewFile
 destination=h:\web\content nameconflict=ERROR accept=text/html
 !--- cffile action=UPLOAD filefield=doc_title
 destination=\\P2\P2Web\web\NewIM3\Content nameconflict=SKIP
 accept=text/html ---
 cfinsert datasource=im3 tablename=documents
 formfields=doc_title, doc_date, doc_author, doc_description,  doc_cat
 !--- /cfif  ---


 **


 Thanks,


 Fernando




 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Column names containing a # sign

2001-07-10 Thread Michael Lugassy

Try calling the # with its respectebly chr(num)
I don't know which asacii code is # but try this (although it may sounds
silly):

(let's say the 19 ASCII code is #)...

UPDATE Registration#chr(19)#
SET . bla bla bla

It might help because I've seen cases where the char itself and the
chr(ASCII_char_num) performed diffrently.

Michael.

- Original Message -
From: Daniel Lancelot [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 9:31 PM
Subject: RE: Column names containing a # sign


 have you tried doubling your #

 ie product# = product## etc - cf should convert  that to a single # before
 passing to db...

 -Original Message-
 From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
 Sent: 10 July 2001 17:18
 To: CF-Talk
 Subject: Column names containing a # sign


 Hi

 I've been given a database containing column names such as
 Product# and Registration#

 I've tried using aliases and backticks on these columns in my query to
 no effect - the # sign throws CF each time. Changing the column names
 isn't an option unfortunately.

 Any suggestions greatfully received.

 Tristram Charnley

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



HTML to JPEG?

2001-07-09 Thread Michael Lugassy

I need to create a thumbnail view of the front/home page of a given site.
that should be done automaticlly, ofcourse.

does anyone know such a program that will allow batch convert of html files
to jpegs (as if I would hire a peon to capture/grab the pages manually)?


Thanks,

Michael Lugassy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Is it really POST? [SOLVED]

2001-07-09 Thread Michael Lugassy

Andddy,
That is definitly the best solution up to date.
I mark this thread as SOLVED!


Thanks,

Michael
- Original Message -
From: Andrew Tyrone [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 5:55 PM
Subject: RE: Is it really POST?


 -Original Message-
 From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, July 08, 2001 2:40 PM
 To: CF-Talk
 Subject: Is it really POST?


 How can I check if the .cfm file was submitted using POST and not GET?
 (I'm trying to prevent, as possible, people to submit the params using URL
and not form fields).

 Thanks,

 Michael Lugassy


 

 Well this was interesting when I tested it.  I made two pages:

 !--- testform.cfm ---

 form name=newform action=testform_action.cfm method=get

 Test Form:br
 input type=text name=test1 value=

 input type=hidden name=hidden1 value=yep, I'm hidden!

 input type=submit name=submitbutton value=click to go

 /form



 !--- testform_action.cfm ---

 cfif IsStruct(form)

 FORM is defined.

 brbr
 cfloop collection=#form# item=thisvar
 cfoutput#thisvar#br/cfoutput
 /cfloop

 cfelse

 FORM is not defined.

 /cfif


 Now, if you run the first page and submit it, whether you keep the FORM
method as GET or change it to POST, the IsStruct() function will tell you
that FORM is indeed a structure.  This first led me to believe that even
though the form was submitted by GET, CF still knew a form had been
submitted.  Now, even though I didn't check (bad), I surmise that the called
page doesn't know a form has been submitted when method=GET because if you
run the second page on it's own, FORM is STILL a structure.  I might be
wrong about that, but I still have a solution that I think will work for
you.  Since the FORM structure exists on every page, and is empty on some,
if you change the IsStruct() function to the StructIsEmpty() one, you will
be able to tell if a form was submitted by GET and not post.

 I figured this was a good alternative method since HTTP headers can be
faked.


 -Andy



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CGI.variables list

2001-07-08 Thread Michael Lugassy

Does someone has a full/partial list of CGI variables?



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: KILL THE COOK!

2001-07-08 Thread Michael Lugassy

But I didn't understand what they put inside the cf_inputfilter that deleted
the cookie
whenever I closed the browser (although it was set to never).
did you happen to take a look at it?

btw: I thought the data in the cookie is encrypted, how does people suppose
to change it?

Thanks,

Michael
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, July 08, 2001 9:04 AM
Subject: RE: KILL THE COOK!


  Are you familier with Allair's CF_INPUTFILTER TAG?
  that suppose to remove all special chars from being set and sent???
 
  cf_inputFilter scopes=FORM,COOKIE,URL chars=,,|,\,?,
  tags=ALL
 
  This thing has caused the cookie to be deleted.
  I've removed the COOKIE scope and it worked.
 
  god knows why did they put a cookie scope.

 They put a cookie scope in because cookies, like any other data sent from
 the client, can be manipulated by a malicious end-user.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Is it really POST?

2001-07-08 Thread Michael Lugassy

How can I check if the .cfm file was submitted using POST and not GET?
(I'm trying to prevent, as possible, people to submit the params using URL and not 
form fields).

Thanks,

Michael Lugassy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: URL Hacks (even more)

2001-07-06 Thread Michael Lugassy

What about people who write something like this:

http://www.vawter.com/slideshow.cfm?seldir=90;'%20DROP%20TABLE%20IMAGES
or
http://www.vawter.com/slideshow.cfm?seldir=90;''%20DROP%20TABLE%20IMAGES

' or '' between/after/in middle the URL, thus closing the first condition and opening 
a new statment??


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



single IP mode?

2001-07-06 Thread Michael Lugassy

I've just installed the cf 5.0 evaluation.
what is that Single IP mode restriction after 30 days?

Thanks,

Michael Lugassy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: URL Hacks

2001-07-06 Thread Michael Lugassy

Would it be a good solution to add something like this into my
application.cfm file?

cfloop index=IDelement list=numID1,numID2,numID3,numID4,numID5
cfif isDefined(url.#IDelement#)
cftry
 cfparam name=url.#IDelement# type=numeric
   cfcatch
!--- Replace the parameter with a good one ---
cfset url.#IDelement#=val(Evaluate(url.#IDelement#))---
cfoutput
 !--- Now lets retaliate ---
 script
  alert(#cgi.remote_addr# + had been submitted your isp's abuse
reporting sytem);
  document.location=http://www.abuse.com;;
 /script
/cfoutput
cfabort
   /cfcatch
  /cftry
/cfif
/cfloop

Where numID1-numID5 would be all of my SQL's numeric colums.

BTW: have someone used Allaire CF_INPUTFILTER succesfuly to prevent things
like that?


Thanks,

Michael
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 1:53 AM
Subject: RE: URL Hacks


   If anyone has any interest it is at:
   http://www.vawter.com/urlhack.cfm
 
  Quick question, the dropping of tables seems very destructive, and of
  little point other than trashing a site.
 
  Is it possible to construct more useful queries to run piggy back,
  i.e. the SQL to display all the tables in a database, the fields in a
  table, or the data in a field(s)? I'm not asking for examples, just if
  it's theoretically possible.
 
  Having the data deleted is easy to recover from (if not careless),
  having someone view your data, or database construction would seem to
  be a lot worse.

 Sure, it's possible to construct more useful strings, although usefulness
 here is going to be in the eye of the beholder. For example, if you knew a
 site was running against SQL Server, you might be able to execute the
 xp_cmdshell stored procedure, which would get you a command prompt on the
 database server, essentially. If you could do this, you could conceivably
 have that command shell retrieve a file from an FTP server and run that
 file. That might be useful, if your goal is to compromise a remote
database
 server.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



html and plain text on the same cfmail?

2001-07-03 Thread Michael Lugassy

I remember looking at an archived message that gave a good solution
on implementing both html and plain text code on the same page
so people with no html support will see the text version and vice versa.

unforunatlly, the list archived have changed? and I can seem to find it.
does anyone know something about it?

Thanks,

Michael Lugassy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Multiple file upload / activeX?

2001-07-03 Thread Michael Lugassy

Anyone know a good activex com' that will be installed on the user computer (as with
the Install and Always Trust software from... window) and will allow multiple files
upload to server w/ the client's directories tree, selection etc.?

Thanks,

Michael Lugassy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



ot: SQL select all BUT

2001-06-28 Thread Michael Lugassy

Is there a way to run a select statment that fetch ALL (*) colums BUT colum5,coulm6

something which is similiar to:
SELECT colum1,colum2,colum3,colum4


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cfx_imageinfose

2001-06-28 Thread Michael Lugassy

has someone had the problem with cfx_imageinfose that suddently it stoped working?
just giving 0,0,0 for all images?

Thanks,
\
michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Generating a .txt document with CF

2001-06-27 Thread Michael Lugassy

Yea, it's very easy!
if you can create a variable or a regular cfoutput with the formatting you
want, you just need
to use CFFILE action=write/append to write this information into a file.

cffile action=WRITE file=fullpath\filename.txt output=put output
string here


Thanks,

Michael


- Original Message -
From: W Luke [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 7:56 PM
Subject: Re: Generating a .txt document with CF



  For transaction purposes, I need to generate
  a text document with certain variables.
 
  I have no idea how to do this.

 Have a look at cffile

 hth

 --
 Will
 new media discussion for Berkshire -=- http://cf.lukrative.com
 local classifieds -=- http://www.localbounty.com
 e: [EMAIL PROTECTED]  icq: 31099745



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Problem with cfhttp

2001-06-27 Thread Michael Lugassy

Here is my help on the subject for someone else, but maybe can help you:

JM,

you must seperate between the two tasks:
1- first fetch for the page using cfhttp, then output
cfoutput#cfhttp.filecontent#/cfoutput
2- write to another file using CFFILE.

As I see it, you do have a problem of permissions, timeout or inaccessive
file.

what is the output when you're copy-paste the scheduled cf page into IE?
try to get http://iberc.fasturn.com/iberc/autoproc/wl-em.cfm
to output the desired result on a regular browser, then try from the local
server (again,
using a browser, because scheduled tasks doesn't show results or problems as
they occur).

if you get connection Failure I would suggest to check:
1. if the file u'r calling using cfhttp actually exists on the remote
server.
2. if the fil

start by calling a simple URL like: http://www.yahoo.com
and disply the results cfoutput#cfhttp.filecontent#/cfoutput
if this doesn't work, I guess you have some kind of firewall restrictions
and/or cfhttp limitation?
also, while trying, be sure to have CF 4.5.1 SP 2 as the cfhttp tag has a
known problem of eating
lots of ram without the need to.

Tell me what u come up with, I'll try to help.


Thanks,

Michael
- Original Message -
From: JM Ivler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 10:21 PM
Subject: Re: Scheduled Tasks and CFAS service


 I was following a set of posts from April on CF and the task scheduler
with
 connection Refused errors and you indicated that you had some
familiarity
 with the application and what may generate that error.

 I have a page that does one thing... it writes out: Hellowbrwrold
 when the scheduler runs I have it outputting to a file called temp and it
 contains one line Connection Failure. I have loaded the task into the CF
 administer using operation: httprequest Port: 80 URL:
 http://iberc.fasturn.com/iberc/autoproc/wl-em.cfm
 No username, no password, no timeout, no proxyserver.

 any ideas on why it's failing?






Thanks,

Michael
- Original Message -
From: Tom Espen Pedersen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 1:24 PM
Subject: Problem with cfhttp


 We've encountered a problem on one of our customers servers.
 We use cfhttp to grab a wddx packet from an outside the house server.
 This has worked perfectly up until tuesday 19th.
 The error we get is : Connection Failure

 we suspected this to be a bug in CF 4.5 so we upgraded the server to 4.5.1
 sp2.

 Has anyone encountered errors like this ? and how did you solve them ?
 A reinstall of CF server is the last thing we wanna do since they've got
 alot of services running on that machine.

 Sincirely
 Tom Espen Pedersen
 [EMAIL PROTECTED]




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



replication software for sql

2001-06-27 Thread Michael Lugassy

I'm trying to replicate 2 remote databases that holds about 2-3gb of information.
most of the changed information daily is about 400-500 mb and weekly, 1gb.

Is there a good replication software for sql that support resuming and might
help me handel this scenarion better then the built-in mechanisem in sql 7?

Thanks,

Michael Lugassy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



  1   2   3   4   >