RE: Unicode drives me crazy - need help

2002-07-24 Thread Rudy Rustam

>From Form post, take input of Chinese character (GB2312 or Big5)

And then convert them to UTF-16



-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, July 24, 2002 5:34 PM
To: CF-Talk
Subject: Re: Unicode drives me crazy - need help

> I'm trying to convert some Chinese character to Hex code.
> Example: $B;0(J (Three) = 4E09

what was the original encoding? what do you mean by HEX, some unicode
transform?


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.375 / Virus Database: 210 - Release Date: 10/7/2545


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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



Unicode drives me crazy - need help

2002-07-24 Thread Rudy Rustam

Hi,

I'm trying to convert some Chinese character to Hex code.
Example: $B;0(J (Three) = 4E09

I am using ColdFusion MX, How am I supposed to do that?

Thanks in advance

- Rudy

__
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



Socket - Realtime data

2002-06-21 Thread Rudy Rustam

Scenario: getting the realtime data.
Is it possible to use cf to connect to a socket server?

Thanks in advance
- Rudy

__
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



CFGraph

2002-03-03 Thread Rudy Rustam

Hi guys,

When using CFGraph to create a flash file. Any idea where is the flash
file located?

Thanks in advance

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Milliseconds

2002-01-15 Thread Rudy Rustam

Very effective indeed for getting miliseconds from now().
In MSSQL, there is a datepart(ms,date). But coldfusion only support
until seconds.
Any idea?

Rudy

-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 16, 2002 12:52 PM
To: CF-Talk
Subject: RE: Milliseconds


GetTickCount()

+
Pete Freitag ([EMAIL PROTECTED])
CTO, CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/


-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 11:13 PM
To: CF-Talk
Subject: Milliseconds


Is there a way to get a miliseconds?



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



Milliseconds

2002-01-15 Thread Rudy Rustam

Is there a way to get a miliseconds?

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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



CFQUERY connect to MSSQL

2002-01-09 Thread Rudy Rustam

Is there a way to use cfquery connect to MSSQL without ODBC?

Thanks.

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Java - Socket()

2001-12-12 Thread Rudy Rustam

Yeah...! just what I want, Thanks guys, Thanks Craig!


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 7:36 PM
To: CF-Talk
Subject: RE: Java - Socket()

CFHTTP will not give you the control you need over the http headers.

You will need either a com object or a java custom tag. I'm doing
something
very similar with a com object called tcpclient, the writer of which
(Lewis
Sellers) is on this list.

It's fast, easy to use and gives you almost total control, you can get
it
here http://www.intrafoundation.com/tcpclient.html

I'll glady let you have the code I'm using if you need help.

HTH, Craig.


-Original Message-----
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks




~~
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: Java - Socket()

2001-12-12 Thread Rudy Rustam

Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks


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



Java - Socket()

2001-12-12 Thread Rudy Rustam

Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks
~~
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



RE: Need your help - http header

2001-12-06 Thread Rudy Rustam

I'm sorry, but I didn't get you,
Example code: 

Post /customer/file.sms
Host: www.yahoo.com
Authorization: Password 123456jkl
CONTENT-LENGTH: 95

Subject=Example
[MSISDN]
List=7756245,5563315
[MESSAGE]
Text = This is a test account.

The first 4 lines are header. How should I write it in cfhttp post?

Thanks

Rudy


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 07, 2001 5:20 AM
To: CF-Talk
Subject: RE: Need your help - http header

> However, how to put cfheader inside cfhttp method=post?

You can often use CFHTTPPARAM TYPE="CGI" to do this.

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

~~
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: Need your help - http header

2001-12-06 Thread Rudy Rustam

However, how to put cfheader inside cfhttp method=post?

Rudy



-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 07, 2001 2:49 AM
To: CF-Talk
Subject: Re: Need your help - http header



jamie

On Fri, 7 Dec 2001 02:07:41 +0800, in cf-talk you wrote:

>Does anyone got any idea how to generate a custom http header?
>
>Scenario:
>Send http post to a url ie. http://localhost/receiver.cfm
>
>Receiver.cfm must read exactly the following:
>
>
>

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



Need your help - http header

2001-12-06 Thread Rudy Rustam

Does anyone got any idea how to generate a custom http header?

Scenario:
Send http post to a url ie. http://localhost/receiver.cfm

Receiver.cfm must read exactly the following:


~~
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 account

2001-12-04 Thread Rudy Rustam

This is test account
~~
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: Help - Date in English (UK)

2001-08-29 Thread Rudy Rustam

Thanks Craig, it works.

Is it safe to put the following code in Application.cfm?


SetLocale("English (UK)");



-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, 29 August 2001 5:26 PM
To: CF-Talk
Subject: RE: Help - Date in English (UK)

Setlocale and lsparsedatetime try this...



SetLocale("English (UK)");
date1 = lsparsedatetime("15/09/2001");
date2 = lsparsedatetime("06/09/2001");




Month1: #Month(date1)#  = 9
Month2: #Month(date2)#  = 9




-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 29 August 2001 09:47
To: CF-Talk
Subject: Help - Date in English (UK)


Hi,

Please look at the following code:



Month1: #Month(date1)# = 09
Month2: #Month(date2)#  = 06


How to make ColdFusion consistently use English (UK) to grab a date?

Thank you.

Rudy
~~
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



Help - Date in English (UK)

2001-08-29 Thread Rudy Rustam

Hi,

Please look at the following code:



Month1: #Month(date1)# = 09
Month2: #Month(date2)#  = 06


How to make ColdFusion consistently use English (UK) to grab a date?

Thank you.

Rudy


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



Login page for WAP

2001-07-05 Thread Rudy Rustam

Greeting all, 

I'm new in developing WAP with CF.
Trying to create a login page here but it seems like I am completely lost...

Does anyone got any tips on this?
and what am I suppose to do with the cfapplication and all the session
tracking?

Thanks in advance.

regards,
- Rudy

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



Login page for WAP

2001-07-05 Thread Rudy Rustam

Greeting all, 

I'm new in developing WAP with CF.
Trying to create a login page here but it seems like I am completely lost...

Does anyone got any tips on this?
and what am I suppose to do with the cfapplication and all the session
tracking?

Thanks in advance.

regards,
- Rudy

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



test again - please ignore

2001-07-04 Thread Rudy Rustam

new user

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



Test - pls ignore

2001-07-04 Thread Rudy Rustam

testing new acc

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



CFPOP - attachments handling (critical)

2001-06-04 Thread Rudy Rustam

1. CFPOP will download the attachment to CFServer.
In this case, how do we control people from spamming a huge file?

2. queryname.attachments works fine with 1 attachment.
Put a link to the attachment path and user can download them. No problem.
BUT how about multiple attachments? 
All filenames are return in one long sentence which I have no clue what the
delimiter is.

Thanks in advance

- Rudy

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



cfpop - how to display html content properly?

2001-05-08 Thread Rudy Rustam

Here is my scenario:
Go to any website with a complex html like www.cnn.com or www.cnet.com
Sent the page (not the link) to your popmail account.
Use cfpop to retrive it.

- The Problem (my problem)
The mail doesn't show the html format properly, it's a mess html page.

Is it possible that cfpop do some conversion to the mail content?

All ideas are welcome.

Thank in advance

Regards,
- Rudy


~~
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: CF 5.0 RC : Problem with CFFTP - 0 size

2001-05-08 Thread Rudy Rustam

Finally got a good solution in beta forum
http://beta.allaire.com/betaconf/Thread.cfm?&Thread_ID=229574&mc=27

Thanks for the tips!

- Rudy

-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 8 May 2001 6:38 AM
To: CF-Talk
Subject: RE: CF 5.0 RC : Problem with CFFTP - 0 size


That question really should go to the ColdFusion 5 Beta forums. Aside from
the fact that you've agreed to an NDA by downloading and using Allaire Beta
software, the folks who will best be able to answer your question (and quite
possibly fix the problem) monitor those forums. :)

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057

-Original Message-----
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 07, 2001 2:33 PM
To: CF-Talk
Subject: CF 5.0 RC : Problem with CFFTP - 0 size


I got a problem with cfftp, 'some files' are uploaded with 0 byte in size.
I said 'some files', because it really happens randomly.
It's not the file type, attributes, I've checked on this.
And the good thing or the bad thing is, if a file can be completely
uploaded, then it forever no problem.
But if a file uploaded with size 0, then no matter how many times I try, it
will still be 0 in size.

I'm really frustrated with this, someone please help.
I'm using CF 5.0 RC with Win2K Server SP1.

Thank you so much.

- Rudy
~~
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



CF 5.0 RC : Problem with CFFTP - 0 size

2001-05-07 Thread Rudy Rustam

I got a problem with cfftp, 'some files' are uploaded with 0 byte in size.
I said 'some files', because it really happens randomly.
It's not the file type, attributes, I've checked on this.
And the good thing or the bad thing is, if a file can be completely
uploaded, then it forever no problem.
But if a file uploaded with size 0, then no matter how many times I try, it
will still be 0 in size.

I'm really frustrated with this, someone please help.
I'm using CF 5.0 RC with Win2K Server SP1.

Thank you so much.

- Rudy

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



CFFTP - file size 0

2001-04-30 Thread Rudy Rustam

Everytime I uploaded the files, it always save in 0 size.
While uploading with other ftp application, it works fine.

Have anyone got this problem before? How do you solve it?

- Rudy



~~
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: Do a CFLOCATION and all my session vars disappear?

2001-04-10 Thread Rudy Rustam

Kevin, I got the same problem with cflocation too.
Soon I realise it is in the Application.cfm

>

Frankly, I'm not really clear what's the logic behind.
It works for me, hope it helps

- Rudy

-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 11 April 2001 10:27 PM
To: CF-Talk
Subject: Fw: Do a CFLOCATION and all my session vars disappear?


Hi all,

Hope some people are still up and at it!

I have a code section where I do a CFLOCATION to a page in caller's parent
directory and it starts a brand new session.  I traced through the process
with the Studio debugger and as soon as I get to the Application.cfm it's as
if I started a new session.
The code is


I tried appending the token and it didn't make a difference.
What's strange is that I can cflocate to a test.cfm page without problem.

So then I tried switching from CFLOCATION to

   self.location="../survey_form.cfm"
  

Which didn't work either.

There's only one Application.cfm file so that can't be it either.  Really
stumped on this one.

Thanks,
Kevin
~~
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: Detect session timeout and prompt messages.

2001-03-29 Thread Rudy Rustam

but jon, no clue to differentiate whether session timeout or session never
set before.


-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 29 March 2001 5:51 PM
To: CF-Talk
Subject: Re: Detect session timeout and prompt messages.

Just put this in your application.com.





jon
- Original Message -
From: "Rudy Rustam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 3:58 AM
Subject: Detect session timeout and prompt messages.


> Hi folks,
> How is it possible to prompt the user a message after session timeout?
> Or how do we detect whether the session has time out?
>
> thanx in adv
>
> - Rudy
>
>
~~
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: Detect session timeout and prompt messages.

2001-03-29 Thread Rudy Rustam

Err... Jaav, I think you misunderstand me.
My situation apply after user has logged in to the system.
I have to detect if the session has timeout and prompt a nice message.

Regards,
- Rudy

-Original Message-
From: JAAV [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 29 March 2001 5:22 PM
To: CF-Talk
Subject: RE: Detect session timeout and prompt messages.


HI Rudy,

I never have tested it but I saw a website where they use a refresh
meta-tag. and  they did program to show a desconnection page.



hope this helps,

~Jaav
- Original Message -
From: Rudy Rustam <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 10:58 AM
Subject: Detect session timeout and prompt messages.


> Hi folks,
> How is it possible to prompt the user a message after session timeout?
> Or how do we detect whether the session has time out?
>
> thanx in adv
>
> - Rudy
>
>
~~
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



Detect session timeout and prompt messages.

2001-03-29 Thread Rudy Rustam

Hi folks,
How is it possible to prompt the user a message after session timeout?
Or how do we detect whether the session has time out?

thanx in adv

- Rudy

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



Help - cftoken is killing me

2001-03-26 Thread Rudy Rustam

My system works fine in localserver, the nightmare begin when I moved it to
my main server.
All cflocation without addtoken="yes" will kick the user out. (session
check)
And the most weird case is that the system works fine using IE5.0 but NOT IE
5.5
It's driving me mad, somebody please help!

Thanks in advance
- Rudy

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



Weird cfid and cftoken

2001-03-21 Thread Rudy Rustam

Hi,

Scenario:
I'm doing a simple security checking in each pages by detecting the
session.started in application.cfm (from Ben Forta's book).
All my cflocation is set without addtoken attributes. (ex. 
Everything works fine in my pc.
Btw, I'm using CF 4.5 Ent, Win2000 Pro

Question: 
- When copy my application to another similiar server, all url link with
cflocation failed me unless I manually add in the cfid and cftoken in the
url.
- Do I have to change all my cflocation setting?

Please help!

Thanks in advance
- Rudy


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



Repost: Grab images file with cfhttp

2001-03-05 Thread Rudy Rustam

Hi,

I'm trying to get some image files with cfhttp.
Have been trying for hours and no luck at all.
All I got from cfhttp.filecontent is just the filename.

Help...please!


Thanks in advance.

- Rudy

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



Grab images file with cfhttp

2001-03-04 Thread Rudy Rustam

Hi,

I'm trying to get some image files with cfhttp.
Have been trying for hours and no luck at all.
All I got from cfhttp.filecontent is just the filename.

All ideas are welcome, thanks in advance.

- Rudy

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



Get all book's price with cfhttp?

2001-02-23 Thread Rudy Rustam

Hi,

I'm trying to get the book's price and put it properly in my own database.

http://isbn.nu/9780789718105/price"
resolveurl = 1
throwonerror = Yes 
method="GET"
>




#cfhttp.filecontent#


What next? How to get the books' price from each website?


Regards,
- Rudy

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



Send SMS

2001-02-15 Thread Rudy Rustam

Hi,

Any information on sending SMS or SMS Gateway or Anything relevant.
Please contribute to this forum.

Thanks

- Rudy

~~
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 : Single quote in Informix

2001-02-06 Thread Rudy Rustam

Slightly OT, How do you guys stored single quote in Informix database?

All ideas are welcome!

- Rudy

~~
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: Replace function(very urgent)

2001-01-18 Thread Rudy Rustam

have u try this:




-Original Message-
From: ramesh deva [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 January 2001 3:07 PM
To: CF-Talk
Subject: Replace function(very urgent)



Hi 
Here i have wddx_packet variable, it contains text
file

So my question is can i replace whole file by using
following code.

Becos when i use this code 



 

Getting this error:-

An error occurred while evaluating the expression: 


 EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","&","ALL")



Error near line 310, column 11.



Parameter 1 of function Replace must be a basic value,
i.e., a string, number, logical, or date/time value i
am here 

Thanx in advance
Ramesh
~~
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: brain dead easy ?

2000-12-27 Thread Rudy Rustam

try:
mid(string, start, count)

-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 28 December 2000 2:31 PM
To: CF-Talk
Subject: brain dead easy ?


I need to remember how to find out what the third character of a given
string is.  Thanks, then I can goto bed.

Eric J. Hoffman
Director of Internet Development
Small Dog Design
www.smalldogdesign.com
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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



RE: Making changes to a live Database

2000-12-14 Thread Rudy Rustam

i would write a simple page to alter the table and run it once.

- rudy

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 14 December 2000 6:31 PM
To: CF-Talk
Subject: Making changes to a live Database


Hi,

I have a small change to make to a live database (create a new column in a
table) which is in Access.  I don't really want to download it and upload it
again, as I will undoutedly lose data (or visitors will get an error).  So I
was wondering what people's experiences are of this kind of situation and
how best to handle it.

Rgds

Will
www.localbounty.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



Not Working in Netscape

2000-12-14 Thread Rudy Rustam

Greeting, 
Run the code below in IE, it will fire javascript before submit the form.
However, javascript is not running in Netscape. Unless the type="image"
change to type="submit".

Anyone mind to tell me why?

Thanks
- Rudy




















#name1#



~~
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: Quick Question - Size Limit?

2000-10-30 Thread Rudy Rustam

I'm referring to the size and I have to agree that it depends on the
resources.
beside the length supports more than 255 chars and i don't bother about
that.

simple test, i stored the client var in database









okay


I tried 1M, but the result never come out and my cpu usage never goes down
from 100% (at the end, i have to restart).

come on guys, give it a try!



-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, 30 October 2000 4:40 PM
To: CF-Talk
Subject: RE: Quick Question - Size Limit?


Actually no whoops!

I read it again...

If you want the length of the variable then its 255 chars max, I think!

If its storage as the size of all the variables then its as I described,
your open to what ever resource you have available.



-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, 30 October 2000 7:34 PM
To: CF-Talk
Subject: RE: Quick Question - Size Limit?


Whoops! :-)

-Original Message-
From: Deva Ramesh [mailto:[EMAIL PROTECTED]]
Sent: Monday, 30 October 2000 6:37 PM
To: CF-Talk
Subject: RE: Quick Question - Size Limit?



HAHAHAH


HAI RUDY

SIZE LIMIT IS 255 CHARS FOR CLIENT V

THANX
RAMESH

-Original Message-----
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 2:34 PM
To: CF-Talk
Subject: Quick Question - Size Limit?


is there a size limit for client, application and session?

if yes, what's the limit line?

i'm dying for the answer


rgds,
- rudy


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Quick Question - Size Limit?

2000-10-29 Thread Rudy Rustam

is there a size limit for client, application and session?

if yes, what's the limit line?

i'm dying for the answer


rgds,
- rudy

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: CFHTTP - continue on broken url

2000-10-23 Thread Rudy Rustam

It's working, thanks Matt :)

-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 24 October 2000 9:23 AM
To: CF-Talk
Subject: RE: CFHTTP - continue on broken url


Try wrapping the code in a cftry with a cfcatch to report any errors that
happen. As long as the code is in the cftry block, the processing will
continue.
HTH, Matt








[*not sure what type you're dealing with]


ATTN: ERROR WHILE UPDATING DATA
MSG:#CFCATCH.Message#
TYPE:#CFCATCH.Type#
DETAIL:#CFCATCH.DETAIL#




-Original Message-----
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 23, 2000 6:51 PM
To: CF-Talk
Subject: OT: CFHTTP - continue on broken url


Scenario:
I have a few servers in different location.
When the new record is added to Master (Central) Database. My code should
automatically update the rest of the server in different locations.

Code:






Problem:
When there is an invalid Server's URL, the cfhttp will return error message
and stop executing.

Expected:
I need CFHTTP to continue executing until end of records, and returns the
list of invalid Server's URL.


Your idea are most welcome.


Thanks in advance.

- Rudy


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



OT: CFHTTP - continue on broken url

2000-10-23 Thread Rudy Rustam

Scenario: 
I have a few servers in different location. 
When the new record is added to Master (Central) Database. My code should
automatically update the rest of the server in different locations.

Code:






Problem:
When there is an invalid Server's URL, the cfhttp will return error message
and stop executing.

Expected:
I need CFHTTP to continue executing until end of records, and returns the
list of invalid Server's URL.


Your idea are most welcome.


Thanks in advance.

- Rudy

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



CFHTTP - how to continue when there is a broken url

2000-10-23 Thread Rudy Rustam

Hi guys,

Scenario: 
I have a few servers in different location. 
When the new record is added to Master (Central) Database. My code should
automatically update the rest of the server in different locations.

Code:






Problem:
When there is an invalid Server's URL, the cfhttp will return error message
and stop executing.

Expected:
I need CFHTTP to continue executing until end of records, and returns the
list of invalid Server's URL.


Your idea are most welcome.


Thanks in advance.

- Rudy


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Help - Client Variable Storage on MSSQL

2000-10-11 Thread Rudy Rustam

I stored my Client Variables on MSSQL.
The thing is when client is set, I have no records at all in both CDATA and
CGLOBAL.
While GetClientVariablesList() returns all the clients I set.

Any idea?
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Client variables

2000-10-07 Thread Rudy Rustam

Client variables are good in supporting Load Balancing, 
but are there any drawbacks in using Client variables compare to Session?


-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 7 October 2000 9:43 AM
To: CF-Talk
Subject: RE: Client variables


Yes, that's probably the best idea.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jack Tumlin [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 06, 2000 3:22 PM
> To: CF-Talk
> Subject: RE: Client variables
> 
> 
> Would the CFID and CFTOKEN values have to be stored in a DSN in order to 
> use the URL route?
> That is if cookies were not being used.
> 
> 
> At 06:10 PM 10/6/2000 -0400, Dave Watts wrote:
> > > Okay. Will Coldfusion know if a client returns by the CFID if
> > > cookies are not used?
> >
> >For CF to recognize a prior user and match that user to a set of Client
> >variables, the user's browser must send the CFID and CFTOKEN name-value
> >pairs to the server. They can be sent using cookies, or via the URL.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >voice: (202) 797-5496
> >fax: (202) 797-5444
> 
> Jack Tumlin
> Vice President Business Development
> Millennium Software, Inc.
> The Software Solutions Company
> [EMAIL PROTECTED]
> www.millsoftinc.com
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Test-Pls ignore

2000-10-05 Thread Rudy Rustam

test
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: I have a problem..

2000-09-12 Thread Rudy Rustam

select *
from tablename
where fieldname is NOT NULL

I dunno about you, but sometimes I forgot a simple thing.

- Rudy

- Original Message -
From: Roger Lim <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 12, 2000 2:16 PM
Subject: I have a problem..


> Hi there,
>
> I've a problem which I'm trying hard to solve, hope you guys can help me
out
> on this..
>
> I have two huge tables with alot of fields. One of the table is driven by
a
> form which will be filled by user and not all the fields are compulsory.
>
> I am required to compare these two tables and to match the correct data
out.
>
> However I can't perform a  with lots 'AND' criteria because some
of
> the fields are NULL. I only need to match those fields that the user
enter.
>
> How do I go about doing it?
>
> Hope that my message is clear.
>
> Thanks,
> Roger
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: SQL - Relational issue

2000-09-11 Thread Rudy Rustam

Hey, this TRIGGER thing is cool. Just what i need.

Thanks a lot Nick!

- Original Message -
From: DeVoil, Nick <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 11, 2000 6:16 PM
Subject: RE: SQL - Relational issue


> You need one DELETE statement for each table that you want
> to delete from. One way to make this simpler is to
> put the DELETE statements for "child" tables in a TRIGGER
> which fires automatically when you DELETE from the "parent"
> table.
>
> SQL Server can prevent you from creating orphan records
> but it won't do cascading deletes for you unless you
> have triggers set up to do it.
>
> Nick
>
> -Original Message-
> From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 11, 2000 11:03 AM
> To: [EMAIL PROTECTED]
> Subject: Re: SQL - Relational issue
>
>
> Back to the scenario, does it mean I have to write 10 queries to delete
all
> related records on the rest of the tables?
> Is that what you guys doing? Some comments plz...
>
>
> hey, thanks Ant
>
> - Original Message -
> From: Anthony Geoghegan <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, September 11, 2000 4:02 PM
> Subject: RE: SQL - Relational issue
>
>
> > Hi Rudy
> >
> > [You wrote:]
> >
> > System : NT4, MSSQL 7 and CF 4.5
> >
> > Scenario:
> > I have 2 tables, USERS and CARS with One-to-Many relationship.
> > If I delete a user, then all cars that he has should be deleted too.
> >
> > I use 2 queries to delete a user in the USERS and all his cars in the =
> > CARS table.
> >
> > Is there a more efficient way to just delete a user in USERS table and =
> > all connection to this will also be deleted too?
> > Imagine if there are more than 10 relational tables.
> > And Can setting up a Relation Diagram in SQL help me? (I did some tests
=
> > and it doesn't turn out to be what I expected)
> >
> > Suggestions and Advices are very much welcome.
> >
> > [Ant says:]
> > If you enforce referential integrity in MS SQL the manual says:
> >
> > "When you enforce referential integrity, SQL Server prevents users from:
> >
> > Adding records to a related table if there is no associated record in
the
> > primary table.
> > Changing values in a primary table that result in orphaned records in a
> > related table.
> > Deleting records from a primary table if there are matching related
> > records."
> >
> > This means that SQL will manage the references for you!
> >
> > Regards,
> > Anthony Geoghegan.
> > Lead Developer,
> > IFTN
> > http://www.wow.ie
> > mailto:[EMAIL PROTECTED]
> >
>
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> **
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: SQL - Relational issue

2000-09-11 Thread Rudy Rustam

Back to the scenario, does it mean I have to write 10 queries to delete all
related records on the rest of the tables?
Is that what you guys doing? Some comments plz...


hey, thanks Ant

- Original Message -
From: Anthony Geoghegan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 11, 2000 4:02 PM
Subject: RE: SQL - Relational issue


> Hi Rudy
>
> [You wrote:]
>
> System : NT4, MSSQL 7 and CF 4.5
>
> Scenario:
> I have 2 tables, USERS and CARS with One-to-Many relationship.
> If I delete a user, then all cars that he has should be deleted too.
>
> I use 2 queries to delete a user in the USERS and all his cars in the =
> CARS table.
>
> Is there a more efficient way to just delete a user in USERS table and =
> all connection to this will also be deleted too?
> Imagine if there are more than 10 relational tables.
> And Can setting up a Relation Diagram in SQL help me? (I did some tests =
> and it doesn't turn out to be what I expected)
>
> Suggestions and Advices are very much welcome.
>
> [Ant says:]
> If you enforce referential integrity in MS SQL the manual says:
>
> "When you enforce referential integrity, SQL Server prevents users from:
>
> Adding records to a related table if there is no associated record in the
> primary table.
> Changing values in a primary table that result in orphaned records in a
> related table.
> Deleting records from a primary table if there are matching related
> records."
>
> This means that SQL will manage the references for you!
>
> Regards,
> Anthony Geoghegan.
> Lead Developer,
> IFTN
> http://www.wow.ie
> mailto:[EMAIL PROTECTED]
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



SQL - Relational issue

2000-09-11 Thread Rudy Rustam

This is a multi-part message in MIME format.

--=_NextPart_000_0086_01C01C09.22A55D80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

System : NT4, MSSQL 7 and CF 4.5

Scenario:
I have 2 tables, USERS and CARS with One-to-Many relationship.
If I delete a user, then all cars that he has should be deleted too.

I use 2 queries to delete a user in the USERS and all his cars in the =
CARS table.

Is there a more efficient way to just delete a user in USERS table and =
all connection to this will also be deleted too?
Imagine if there are more than 10 relational tables.
And Can setting up a Relation Diagram in SQL help me? (I did some tests =
and it doesn't turn out to be what I expected)

Suggestions and Advices are very much welcome.

Thanks in advance.

- Rudy

--=_NextPart_000_0086_01C01C09.22A55D80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








System : NT4, MSSQL 7=20
and CF 4.5
 
Scenario:
I have 2 tables, USERS and CARS with =
One-to-Many=20
relationship.
If I delete a user, then all cars that =
he has=20
should be deleted too.
 
I use 2 queries to delete a user in the =
USERS and=20
all his cars in the CARS table.
 
Is there a more efficient way to just =
delete a user=20
in USERS table and all connection to this will also be deleted =
too?
Imagine if there are more than 10 =
relational=20
tables.
And Can setting up a Relation Diagram =
in SQL help=20
me? (I did some tests and it doesn't turn out to be what I=20
expected)
 
Suggestions and Advices are very much=20
welcome.
 
Thanks in advance.
 
- Rudy

--=_NextPart_000_0086_01C01C09.22A55D80--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Help - Crystal Report

2000-08-17 Thread Rudy Rustam

This is a multi-part message in MIME format.

--=_NextPart_000_0028_01C0091F.105E1010
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi guys,

My System: NT4, CF4.5, Crystal Report 7.0 and MSSQL 7.0.

I used to pass url parameter to CR files:
%3d+da=
te(#form.yy#,#form.mm#,#form.dd#)+and+{visit.visitdate}+<%3d+date(#form.y=
y1#,#form.mm1#,#form.dd1#)">

It's ugly I know, so I try to use CFFORM with hidden fields to pass all =
the parameters.
%3d+date(" &
#form.yy# &
"," &
#form.mm# &
"," &
#form.dd# &
")+and+{visit.visitdate}+<%3d+date(" &
#form.yy1# &
"," &
#form.mm1# &
"," &
#form.dd1# &
")"
>=20




BUT, CR returns error "An invalid selection formula has been specified". =
Any idea?

Thanks in advance.

- Rudy


--=_NextPart_000_0028_01C0091F.105E1010
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi guys,
 
My System: NT4, CF4.5, Crystal Report =
7.0 and MSSQL=20
7.0.
 
I used to pass url parameter to CR=20
files:
=
;%3d+date(#form.yy#,#form.mm#,#form.dd#)+and+{visit.visitdate}+<%3d+da=
te(#form.yy1#,#form.mm1#,#form.dd1#)">
 
It's ugly I know, so I try to use =
CFFORM with=20
hidden fields to pass all the parameters.
%3d+date("=20
&#form.yy# &"," &#form.mm# &","=20
&#form.dd# &")+and+{visit.visitdate}+<%3d+date("=20
&#form.yy1# &"," &#form.mm1# &","=20
&#form.dd1# &")"> 


 
BUT, CR returns error "An invalid =
selection formula=20
has been specified". Any =
idea?
 
Thanks in advance.
 
- Rudy
 

--=_NextPart_000_0028_01C0091F.105E1010--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Test - Pls ignore this mail

2000-03-31 Thread Rudy Rustam

This is a multi-part message in MIME format.

--=_NextPart_000_000B_01BF9B2B.2EF88080
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



--=_NextPart_000_000B_01BF9B2B.2EF88080
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








 

--=_NextPart_000_000B_01BF9B2B.2EF88080--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.