Encrypted data via dbi into postgres

[K Old]

Hello,

I am trying to load encrypted data (a credit card number encrypted by the 
Crypt::Twofish perl library) and postgres won't accept the data.  I have 
tried escaping each character, and nothing works.


For example a credit card number like

7384998737264839

when encrypted by Crypt::Twofish would look like

qþՕ¨Ñ.'¿Ҍ½

I cannot get postgres to accept this input.  Any ideas of different 
datatypes, or ways I can get it to accept this highly encrypted string?

I have several modules that encrypt the string with letters and numbers 
rather than symbols, etc. like Twofish, but would love to have this solution 
work.

Any help is appreciated.

Kevin
[EMAIL PROTECTED]

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Connecting to DBI via VBScript

[K Old]

Hello all,

I'm currently running a FreeBSD system with Apache, and have the Apache::ASP 
module, etc. installed.  I am running PostgreSQL 7.0.2 and have setup a 
persistent connection vi Apache, and was wondering if anyone could point me 
to documentation that shows how to call a DBI connection from VBScript.

I have programmers that are familiar with VBScript and just need the code 
that will allow them to connect to the DBI connection via VBScript.

Any help is appreciated.

Thanks,
Kevin
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

Re: Transaction in PostgreSQL

[K Old]

Simon,

Thanks for your reply.  Just for clairfication in the eval{} do I need to do 
a sth-prepare($statement) then an sth-execute() for each statement in the 
eval?

Can you give me an example of two statements?

Thanks,
Kevin


From: Simon Oliver [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Transaction in PostgreSQL
Date: Wed, 25 Apr 2001 09:37:06 +0100

Set AutoCommit to 0 to enable transaction, something like:

From the DBI man pages:

$dbh-{AutoCommit} = 0;  # enable transactions, if possible
   $dbh-{RaiseError} = 1;
   eval {
   foo(...)# do lots of work here
   bar(...)# including inserts
   baz(...)# and updates
   $dbh-commit;   # commit the changes if we get this far
   };
   if ($@) {
   warn Transaction aborted because $@;
   $dbh-rollback; # undo the incomplete changes
   # add other application on-error-clean-up code here
   }


K Old wrote:

Hello,

I was wondering if someone could show me the syntax for doing a
transaction in Perl via the DBI.  When I try to just send the
appropriate SQL, the compiler says to use the DBI to process
transactions.  I can't find the appropriate functions to use.

Any help is appreciated.

Thanks
Kevin
[EMAIL PROTECTED]
_
Get your FREE download of MSN Explorer at http://explorer.msn.com


--
   Simon Oliver

---
   Department of Biomolecular Sciences
   UMIST, PO Box 88, Sackville St
   Manchester, M60 1QD
   United Kingdom

   Phone:  +44 161 200 8912
   Fax:+44 161 236 0409
   Mobile: +44 776 183 0327
   Email:  [EMAIL PROTECTED]
---


_
Get your FREE download of MSN Explorer at http://explorer.msn.com

PostgreSQL currval()

[K Old]

Hello all,

I'm trying to do the following insert statement and can't seem to get it to 
work:

INSERT INTO domains (dname, user, pass) VALUES('currval('cust_seq')', bob, 
something);

I am getting the error that says it that cust_seq.currval is not defined.  I 
do have cust_seq defined as a Sequence and am wondering how to reference a 
sequence variable in an insert statement.

Any ideas?

Thanks,
Kevin
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

Difference between do and execute?

[K Old]

Hello all,

Can someone explain what the difference is between using do and execute? 
  I understand their general purpose, but why would I want to use one over 
the other, and it what situations?

Thanks,
Kevin
_
Get your FREE download of MSN Explorer at http://explorer.msn.com