In MySQL, which I know you aren't using, this is addressed by
terminating fields with a comma and enclosing them with quotes. I do
the exact same thing with fields including commas and quotes and it
works every time.
FileMaker does present a different predicament. My experience with its
I would do almost anything to
avoid it including converting to MySQL : )
Please forgive me if I seem a little frustrated, but this really isn't
helping.
The site uses FileMaker.
The data files are CSV.
The issue is bringing CSVs (some of whose fields contain commas) into arrays
in Tango.
Do not mean to frustrate, just thought you might be interested in a
possible workaround which you would have seen if you had read a
little further. Depending on the source of the file, you might be able
to specify a different and less common delimiter (such as a pipe) to
avoid the problem
which you would have seen if you had read a
little further.
Oh I read the whole thing. I only quoted the salient part.
As I stated the files are CSVs. I have no control over that.
Wayne Irvine
Byte Services Pty Ltd
http://www.byteserve.com.au/
Good luck.
On Apr 15, 2004, at 1:54 AM, Wayne Irvine wrote:
which you would have seen if you had read a
little further.
Oh I read the whole thing. I only quoted the salient part.
As I stated the files are CSVs. I have no control over that.
Wayne Irvine
Byte Services Pty Ltd
Good luck.
Not so far. :(
Byte Services Pty Ltd
http://www.byteserve.com.au/
[EMAIL PROTECTED]
Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088
TO UNSUBSCRIBE: Go
Title: Message
Hey Ted !
You talk
of course about MS SQL ?
The dbo. Prefix comes from the owner or creator of the table. If you
have connect to the SQL server as the user sa and there creates a
table it will get the prefix dbo.
If you connect as Ted and have privileges to create tables
Title: Message
Yes,
we are using MS SQL.
I
understand the why there is the prefix dbo and we only connect as "sa".
But sometimes when I open up a search action that had columns with the
prefixes, the prefixes disappear and then I have to edit the column references
in the Result Action. It
A properly formatted csv file has double quotes around all fields,
not just text fields. In that case, I have done the following to
read in a csv file:
1. parse the file into text lines
2. for each line:
a. Replace @dq,@dq with |
b. tokenize using |
c. omit @dq from the first and last
A properly formatted csv file has double quotes around all fields,
Damn, these files don't have quotes around the numeric value fields.
Wayne
Byte Services Pty Ltd
http://www.byteserve.com.au/
[EMAIL PROTECTED]
Ph 02 9960 6099 Mob 0409
Title: Message
Strange, havent seen it.
I tried just now but I always get the dbo. Prefix in
the columns. Do you connect the same way to the database from the different
workstations, the same ODBC system configuration, username etc. ?
Med
vänlig hälsning/Best regards
Bengt
Maybe you can request that they are formatted correctly from
your source?
Stefan
At 10:30 AM 4/15/2004, you wrote:
A properly formatted csv file has double quotes around all fields,
Damn, these files don't have quotes around the numeric value fields.
Wayne
Byte Services Pty
You could also do the following (tedious) replacements before
the final tokenize step:
replace ,1 with ,1
replace ,2 with ,2
and so on...
replace 1, with 1,
replace 2, with 2,
and so on...
Yuck, but it would work.
Stefan
At 10:53 AM 4/15/2004, you wrote:
Maybe you can request that they are
Actually, this might not work in the following scenario
where you have an address field like this:
123 Laurel Lane Apt. 3, Chicago, IL
Bummer.
At 10:59 AM 4/15/2004, you wrote:
You could also do the following (tedious) replacements before
the final tokenize step:
replace ,1 with ,1
replace ,2
Not all CVS files have quotes delimiting the fields ... AFAIK always
delimiting your fields with quotes is optional...
(from the first link i could find on G that specified the CVS format)
Not sure how much of an authority this is, but It matches my experience
of what's out there.
* *Each
Anybody know what the deal with buying a J2EE runtime license is? I
found a way to request a trial key, but can't find any way to make the
purchase.
/John
TO UNSUBSCRIBE: Go to
I've requested information several times from
[EMAIL PROTECTED] but have not received any information.
Is this the right email to contact for information?
Bryan Hughes
TFG-PIU
954-493-6565 x122
On Apr 15, 2004, at 12:16 PM, John McGowan wrote:
Anybody know what the deal with buying a J2EE
I've gotten responses from that email in the past.
/John
Bryan Hughes wrote:
I've requested information several times from
[EMAIL PROTECTED] but have not received any information.
Is this the right email to contact for information?
Bryan Hughes
TFG-PIU
954-493-6565 x122
On Apr 15, 2004, at
try [EMAIL PROTECTED] :-))
rs
Daniel
- Original Message -
From: Bryan Hughes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 6:26 PM
Subject: Re: Witango-Talk: Purchasing J2EE Runtime License
I've requested information several times from
[EMAIL PROTECTED] but
I'd say the first thing to try is ask him if he can produce csv files
with all fields quoted. That may or may not be possible, depending on
the program he's using and his level of expertise, but you could ask.
If that's not possible, are they standard files? By which I mean, the
same columns
Hello
all,
I am trying to assign
the handlerreturned by@createobject to an array, but I do
not know how to do it.It seems that @ASSIGN
NAME=user$array[1,1] @createobject ...
metatag
casts the handler to a hex value.Is there a way to specify that the array is
expecting to store a values
I've been looking at EDI mappers specifically for HIPAA files. I dunno
about VAN sr - that's not something we're doing.
I don't know if my notes would be helpful to what you're doing, but if
you want 'em just let me know.
jamileh
-Original Message-
From: Dan Stein [mailto:[EMAIL
The use of @ASSIGN with the @CREATEOBJECT
makes an object instance in memory. This is a special type of variable, and can
not be combined with an array, which is another special type of variable. (at least I dont believe so)
-Original Message-
From: [EMAIL PROTECTED]
If anybody out there is allowing their end users to save credit card
info in their account (for future purchases), i'd be interested in
knowing what approach they use for encrypting the card number in the
DB. Are you using the @cipher tag? Which type of encryption are you
using? What level
for anyone interested, I found the solution to my
problem.
after i got the list of messages, it looks like
this:
1 1400
2 5670
3 1200
4 1880
i was telling it to retrieve "5670" instead of
"2".
wasnt sure which number it wanted but it seems to
be happy now (:
- Original Message
ROBERT,
I'VE SEEN YOUR POSTS A LOT ON WITANGO; I, TOO, USE WIN 2K ADV
SERVER AND WITANGO 5.0 SERVER. THERE ARE TIMEOUT ISSUES WHICH MY
CLIENT IS CONCERNED ABOUT. THERE IS THE WITANGO DATASOURCELIFE
TIMEOUT WHICH I CAN SET TO A LARGE NUMBER, BUT THERE MUST BE
OTHER TIMEOUT'S AFFECTING THE
We are going to start blocking incoming traffic on the serial interface on
our router to tighten up security. We are going to deny all traffic that
does not relate to the following ports: pop3, smtp, http, 443, exchange,
citrix, dns, and ftp.
I know Witango uses port 14100 for something. But is
I am having problems with shoppers selecting the Add To Cart button
repeatedly. It all happens within a few seconds. They are probably impatient
when the server is busy.
Is there a way to display something immediately when the shopper selects the
button to indicate we are processing?
Thanks for
Blocking that port is fine. As long as you do not have any of your
servers on the other side of the router which I doubt you would since
it would be pretty hard to hook em up out there without a router :-)
We are going to start blocking incoming traffic on the serial interface on
our router to
On Apr 15, 2004, at 1:39 PM, Fogelson, Steve wrote:
I am having problems with shoppers selecting the Add To Cart button
repeatedly. It all happens within a few seconds. They are probably
impatient
when the server is busy.
1. does it cause problems? Normally the subsequent button presses
My add to cart function checks to see if an item is already in
the cart before adding it. If it's there, then it just skips that step.
This way you don't have to worry if someone repeatedly submits
the form or tries to add the same item later.
Stefan
At 04:39 PM 4/15/2004, you wrote:
I am having
The only port that Witango uses, typically 18100, is used between the
CGI or DLL (Web server plugin) and the Witango Daemon (service) itself.
In most cases, the web server and the Witango server are the same
machine and you simply use the loopback 127.0.0.1, thus a packet never
actually leaves or
Steve,
On your form tag, add onSubmit=return(checkSubmit())
and add a javascript function that says:
var submitted=false;
function checkSubmit()
{
if (submitted==false)
{
sunmitted=true;
return true;
}
else
{
alert('Already submitted');
return false;
}
}
That should
Roland Dumas wrote:
I am having problems with shoppers selecting the Add To Cart button
repeatedly. It all happens within a few seconds. They are probably
impatient
when the server is busy.
1. does it cause problems? Normally the subsequent button presses
override the earlier ones.
It it
Thanks for the responses. Witango is on the same server as the web server.
Everything is behind the router. And I'm not using SQL. So it looks like I
am covered.
Thanks
Steve
-Original Message-
From: Robert Shubert [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 4:05 PM
To:
I believe you are speaking of the variabletimeout in the user scope.
That is, once a user logins in and you assign a user scoped variable
that allows Witango to maintain the fact that they are logged in, that
login closes after 30 minutes (the default).
For a server wide setting change, edit the
I think I am going to incorporate 2 or 3 of the ideas. Java script looks
good. I should double check for products already added. I have to add a
little bit to this as I allow product options as well and will have to check
them as well.
I believe I am using a single threaded ODBC for my db. Still
Dave Shelley wrote:
Steve,
On your form tag, add onSubmit=return(checkSubmit())
and add a javascript function that says:
var submitted=false;
function checkSubmit()
{
if (submitted==false)
{
sunmitted=true;
return true;
}
else
{
alert('Already submitted');
return false;
}
}
could you explain how they could both get caught in the false case?
it looks ok to me so just wondering what im missing
- Original Message -
From: John McGowan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 2:43 PM
Subject: Re: Witango-Talk: Select a submit
It's a basic race condition...
Like I said it depends on the event handlers being multithreaded...
Take a look at the code with line numbers...
1: var submitted=false;
2: function checkSubmit()
3: {
4: if (submitted==false)
5: {
6:sunmitted=true;
7:return true;
8: }
9: else
10: {
oh ok, that makes sense now, thanks (:
- Original Message -
From: John McGowan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 2:56 PM
Subject: Re: Witango-Talk: Select a submit button in a form (OT)
It's a basic race condition...
Like I said it depends on
Thanks for the lesson!
Original message
Date: Thu, 15 Apr 2004 17:12:12 -0400
From: Robert Shubert [EMAIL PROTECTED]
Subject: RE: Witango-Talk: data sources
To: [EMAIL PROTECTED]
I believe you are speaking of the variabletimeout in the user scope.
That is, once a user logins in and
Very late last night I started throwing together some code to parse the CSVs
and replace delimiter commas with [COL] and leave those within text fields
in place.
It also replaces CRLFs with [ROW].
Or at least that's what it's supposed to do. It fails at the first ELSEIF.
Anyone who's had some
I'd say the first thing to try is ask him if he can produce csv files
with all fields quoted. That may or may not be possible, depending on
the program he's using and his level of expertise, but you could ask.
Hey, I asked for tab delimited and look what I got. There's already about 2
weeks
Be sure to use Witango 065 as the REGEX code was just recently updated.
-Original Message-
From: Wayne Irvine [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 7:39 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Import CSV
I'd say the first thing to try is ask him if he
Sussed it!!
@ELSEIF '@VAR local$CurrChar=@CHAR CODE=44'
@IF '@VAR [EMAIL PROTECTED]=OFF'
@ASSIGN NAME=NewString VALUE=@VAR local$NewString[COL]
SCOPE=LOCAL
@ELSEIF @VAR [EMAIL PROTECTED]='ON'
@ASSIGN NAME=NewString VALUE=@VAR local$NewString@VAR
local$CurrChar SCOPE=LOCAL
Any help on this one? Someone must know how to do it.
_
I need to list any files in a particular folder and assign the list to an
array.
Is there a way of doing this in Tango 2000 on a Mac running OS 9?
Wayne Irvine
Byte
47 matches
Mail list logo