It is called table alias in SQL I think But anyway I tried what you
suggested and I get the error indicating I have an invalid object.
I thought your code would and should work just as is but it is not happening
and that is where I am confused. Somehow it seems to want the "Correlation
name" befor
Title: Working now but!
Is there a shorter way to write this or a way to use alias. This is working.
Update [Verification].[dbo].[campaign]
Set [Verification].[dbo].[campaign].DBCompany=[Original_Outbound].[dbo].[campaign].DBCompany,
[Verification].[dbo].[campaign].NeverCallFlag=[Orig
Hi Dan,
I think you mean Correlation-Name
Which is usually accomplished in the From statement
Example:
Update Verification.campaign
Set vc.DBCompany=oc.DBCompany,
vc.NeverCallFlag=oc.NeverCallFlag,
vc.AgentID=oc.AgentID,
vc.VerificationAgentID=oc.VerificationAgentID,
vc.CallRe
Title: SQL help Again
Update Verification.campaign
Set Verification.campaign.DBCompany=Original_Outbound.campaign.DBCompany,
Verification.campaign.NeverCallFlag=Original_Outbound.campaign.NeverCallFlag,
Verification.campaign.AgentID=Original_Outbound.campaign.AgentID,
Verif
Title: SQL DBMS Help
Would be nice to know the Alias thing but found my mistake in this one. No column define in 1st set line.
Have two databases.
Verification
Original_Outbound
Need to update the Campaign table in Verification with data from Original Outbound.
Would love to use Table alias
Title: SQL DBMS Help
Have two databases.
Verification
Original_Outbound
Need to update the Campaign table in Verification with data from Original Outbound.
Would love to use Table alias if I can because there are a boatload of columns ( not my design just try to do the DBMS for someone else)
Two Lifetimes ago I did this with a mysql db for social security numbers,
drivers license numbers and credit card numbers
On post and update we developed a routine that parsed the string if the
character was alpha it was converted to it's hex value if numeric it was
converted to it's binary equaliv
Steve,
Well, without working out the details, I would take the number, place it
in a text file, PGP encrypt that file, copy the contents of that file
into my database and erase the file. Follow the steps in reverse to
retrieve the number. I'd have to work up some code to test this, but I'm
guessin
Hi Robert,
What database are you using?
I know DB2 has really good support for encrypted columns.
I believe SQL Server has an ENCRYPT function, but I understand that it
changed from version 7.0 to 2000 (meaning that any data you encrypted with
the 7.0 version couldn't be decrypted automaticall
Robert,
Thanks for the reply. I might not be understanding what you are saying, but
it's not the transmission over the internet that I am concerned about. I
used a digital certificate for that. I would like certain fields within the
table encrypted, so that if a potential hacker got my db, he woul
Why not just install PGP and use the command line to encrypt and decrpyt
the data? I've done this from within Witango for transmitting sensative
data through the internet.
Robert Shubert
www.witangostore.com
"Fogelson, Steve" wrote:
>
> Thanks for the responses.
>
> Eric,
>
> I looked a little
Thanks for the responses.
Eric,
I looked a little more at the Shopzone's code. They store the key as a file
within the web site. Probably not good. If the db's are available to the
hacker, so would the key. The contents of a sample key seem pretty simple:
BT_GK1=RHDDzwECQNpYPBbZhSKJ0OSvd
I raised a similar question a couple of months ago. Jess Parker, a former
Pervasive/EveryWare Tango guru stated that the encryption tag was pretty
much useless. If I remember correctly, he also told me that the OneTimePad
didn't work as the code needed was watered down in the Tango Server just
befo
Steve,
I don't believe OneTimePad works on numbers either (ie. credit card
numbers, social security numbers). I would probably find an
implementation of blowfish encryption in java and hook into it with
WiTango.
Mike
"Fogelson, Steve" wrote:
>
> Has anyone done this in the shipping cart softwa
>Does anyone know the best way to convert images on the fly using Mac OS? I
>need to either resize the images or convert them to .jpg format.
I have used PixelPipe in the past. Allows you to constrain height/width
of the images among other options. Very good AppleScript dictionary. I
use it to p
I was wondering the same thing :-b
Hi all, for a quick check on the level of exposure you have to the
internet go to
http://www.grc.com
and then click on SHIELDS UP.
Now, this is going to attempt to do some of the main hacks used out
there, if you are not the admin of your firewall you better wa
I have no experience of either when called directly from tango - but there are others
on this list who understand this well and can help
Robert Garcia <[EMAIL PROTECTED]> also has a Thumbnailer program that might be ideal
and he's a regular here
There is also a lot of knowledge here about File
Thanks. Do you recommend one over the other? Also, I've been using Tango for
a while, but am still new to using Tango with other apps. Is there a
specific Apple Event that I call or do I need to write an AppleScript?
Chris
>> Does anyone know the best way to convert images on the fly using Mac OS
>Does anyone know the best way to convert images on the fly using Mac OS? I
>need to either resize the images or convert them to .jpg format.
ImageMagick and Graphic Convertor
ImageMagick
http:/www.imagemagick.org
Graphic Convertor
http://www.lemkesoft.com
___
Does anyone know the best way to convert images on the fly using Mac OS? I
need to either resize the images or convert them to .jpg format.
Thanks,
Chris
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
The code is as
follows:
LABEL ONESET RULES OFFCLEAR VAR VSOCSET
VAR VSOC INTCLEAR VAR NOPERSET RULES OFFSET VAR VNAME1 TEXTSET
VAR VREPNAME TEXTSET VAR NOPER TEXTREMOVE VIEW TEMPRENAME TABLE
GINPUT TO TEMP1 NOCHECK
CREATE VIEW GINPUT AS SELECT
+ T1.NAMEX,SOC,SEM,COURSE,GRADENO,XYEAR,DAT
I recently ordered the Development Studio upgrade and
noticed that it does not install a “development”
Application Studio like the old Tango development studio used to. I tried installing the
version 5 Application Studio using the Development Studio serial number but
alas that does not work
Ow! Doesn't that assume you'd have to have the necessary port (NetBIOS,
perhaps?) open to the outside world to allow the spammer to connect to
initiate the NET SEND command?
-Original Message-
From: Anthony M. Humphreys [mailto:anthony@;humphreys.org]
Sent: 19 October 2002 3:24
To: Mult
Dave,
Is the Username/Password prompted in a dialog box? It sounds to me like IIS
has been configured to only allow 'authenticated' users, and this is
probably nothing to do with Witango.
In IIS, you need to check the properties of your site(s) | Directory
Security | Anonymous Access...
Jon
-
Hi,
I
would say that the 2nd line of the message pretty much sums it
up.
when
you write stored procedures the need to be self contained and ask nothing from
end users.
I
noticed that your procedure doesn't take any input
ie.
select (call proc5('param'))
does
it return a value ie an
Has anyone done this in the shipping cart software an databases?
I have used Shopzone for a shopping cart in the past. Last year they
released an new version that would encrypt the credit card info within the
database. There was a group of hackers in Russia that hacked into commerce
databases and
26 matches
Mail list logo