: I can not deal with databases that give me back a different value
: from what I inserted.
:
: If I insert the string 'This is a string ' into a varchar field,
: I want it back with the trailing space, not without it. If I
: insert a 50 character string in a 25 character field, I want an
: er
rom: "Dana Tierney" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2003 5:14 PM
Subject: Re: import
> wait you use CF? using a read command?
>
> Deanna Schneider writes:
>
> > Sure. You can import it into ac
I looked this back up to see what the exact issues where that Jochem had
with mysql again. I can live with the trailing space issue. I dont care
about null becoming zero. I am a little concerned about truncation... this
could matter a lot. What exactly is the limit of simultaneous transactions
==
If you are not satisfied with my service, my job isn't done!
- Original Message -
From: "Dana Tierney" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Sunday, June 08, 2003 11:13 AM
Subject: Re: import
|
very low-traffic = maybe 2-3 records added a day max. The number of records
will probably never exceed 1000. Relatively high traffic = I don't know, 5-
6 simultaneous users, up to 1000 records updated a day. The number of
records could conceivably get very high in this second case. I am trying t
so... in your opinion mySQL would not be an improvement over Access say?
I have two db projects. let me ask your opinion.
1. A patient registry which while be almost entirely character data and
booleans. Some counters. Will be very low-traffic. I am using mySQL for
this.
2. A patient system whic
f Garza
>
> -Original Message-
> From: Dana Tierney [mailto:[EMAIL PROTECTED]
> Sent: Saturday, June 07, 2003 9:14 AM
> To: CF-Community
> Subject: Re: import
>
>
> I am not sure if you are asking me or Jochem (talk about a range of
> technical expertise
--Original Message-
From: Dana Tierney [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 07, 2003 9:14 AM
To: CF-Community
Subject: Re: import
I am not sure if you are asking me or Jochem (talk about a range of
technical expertise! :) ) but my uninformed opinion is that the
documentation for both
- Ben Doom
> Programmer & General Lackey
> Moonbow Software, Inc
>
> : -Original Message-
> : From: Dana Tierney [mailto:[EMAIL PROTECTED]
> : Sent: Saturday, June 07, 2003 12:25 PM
> : To: CF-Community
> : Subject: Re: import
> :
> :
> : frust
ilto:[EMAIL PROTECTED]
> Sent: Saturday, June 07, 2003 11:19 AM
> To: CF-Community
> Subject: RE: import
>
>
> Actually, I was asking Jochem.
>
> From your frustration with this, I could guess how you feel
> about MySQL.
> :-)
>
> AFA MS SQL goes, I've learned
ilto:[EMAIL PROTECTED]
: Sent: Saturday, June 07, 2003 12:25 PM
: To: CF-Community
: Subject: Re: import
:
:
: frustration is more with my lack of knowledge, to some extent with the
: documentation. I hate feeling stupid, or even ignorant.
:
: But I do have SQL Server available as an alternative and
like to see different, but
> what's perfect? Of course, the downside to it is the price tag. :-)
>
>
> -- Ben Doom
> Programmer & General Lackey
> Moonbow Software, Inc
>
> : -Original Message-
> : From: Dana Tierney [mailto:[EMAIL PROTECTED]
&g
x27;s perfect? Of course, the downside to it is the price tag. :-)
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Dana Tierney [mailto:[EMAIL PROTECTED]
: Sent: Saturday, June 07, 2003 12:14 PM
: To: CF-Community
: Subject: Re: import
I am not sure if you are asking me or Jochem (talk about a range of
technical expertise! :) ) but my uninformed opinion is that the
documentation for both is pretty murky. The new host has a nice front end
for mysql which is why I went with that rather than SQL. Also, I dislike
relying on m$ and if
ecessary. Just extract and its ready to go. Update:
> Version 1.1 contains bug fixes and allows delimiter to be changed.
>
> http://www.hotscripts.com/Detailed/16571.html
>
> > -Original Message-
> > From: Dana Tierney [mailto:[EMAIL PROTECTED]
> > Sent:
> Sent: 07 June 2003 15:43
> To: CF-Community
> Subject: Re: import
>
>
> thanks :)
>
> Wayne Putterill writes:
>
> > I quoted on something like this about a year ago, nothing
> came of the
> > job but I do remember that there were php scripts that
&
What do you prefer?
We use MS SQL 2K here, but are looking into using MySQL for intranet
rollouts, so I'm curious as to your opinion.
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
: Sent: F
thanks :)
Wayne Putterill writes:
> I quoted on something like this about a year ago, nothing came of the
> job but I do remember that there were php scripts that would take text
> files and import them into mysql. Check some of the script sites out.
>
> > -Original Message-
> > From: D
I quoted on something like this about a year ago, nothing came of the
job but I do remember that there were php scripts that would take text
files and import them into mysql. Check some of the script sites out.
> -Original Message-
> From: Dana Tierney [mailto:[EMAIL PROTECTED]
> Sent: 06
text file defined as a datasource.
-Kevin
> -Original Message-
> From: Dana Tierney [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 5:14 PM
> To: CF-Community
> Subject: Re: import
>
>
> wait you use CF? using a read command?
>
> Deanna Schneider
OK. Looks like I have enough to get started. One question about Isaac's
answer, the board was previously on a server that was NT4 and migrated to
2000, so which would it be? And does it matter what OS the new server is
Dana
And PS, Jochem, thank you for the mysql manual reference, I never would
h
if I did I missed it :) looking at your link now
Jochem van Dieten writes:
> Dana Tierney
> >I didn't get an answer to this on talk
>
> You didn't?
> http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=24596&forumid=4&refresh=0#123639
>
> Jochem
>
~
OTECTED]
> > Sent: Friday, June 06, 2003 4:14 PM
> > To: CF-Community
> > Subject: Re: import
> >
> >
> > wait you use CF? using a read command?
> >
> > Deanna Schneider writes:
> >
> > > Sure. You can import it into access and then upsize fr
welp. I am also a mysql newbie but the primary interface *I* am aware of is
a line editor, meaning that I need to know the syntax.
Dana
Ben Doom writes:
> Is there no MySQL import for tab or comma delimited files? It'd be easy to
> convert...
>
>
> -- Ben Doom
> Programmer & General Lack
ll
>
>
> - Original Message -
> From: "Dana Tierney" <[EMAIL PROTECTED]>
> To: "CF-Community" <[EMAIL PROTECTED]>
> Sent: Friday, June 06, 2003 2:57 PM
> Subject: Re: import
>
>
> > mm no it's | delimited but that's eas
data and insert into your db.
make sense?
DRE
> -Original Message-
> From: Dana Tierney [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 4:14 PM
> To: CF-Community
> Subject: Re: import
>
>
> wait you use CF? using a read command?
>
> Deanna
I hate that manual. There are several discussions of the best way to import
so apparently its possible, but it doesnt turn up any page references to
import - syntax. Guess I am in for some digging.
Dana Tierney writes:
> mm no it's | delimited but that's easy enough to fix. I dunno if there i
t;[EMAIL PROTECTED]>
Sent: Friday, June 06, 2003 2:57 PM
Subject: Re: import
> mm no it's | delimited but that's easy enough to fix. I dunno if there is
> an import data function in mysql...I suppose I could always go look at the
> manualsee if import comes up in the ind
Is there no MySQL import for tab or comma delimited files? It'd be easy to
convert...
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Dana Tierney [mailto:[EMAIL PROTECTED]
: Sent: Friday, June 06, 2003 3:18 PM
: To: CF-Community
: Sub
wait you use CF? using a read command?
Deanna Schneider writes:
> Sure. You can import it into access and then upsize from there. Access lets
> you use any delimiter you want in the text file. (File - import - external
> data, follow the prompts from there.)
>
> I do this all the time. and then
hmm. I have access. I wonder if mysql will import from access. Seems like
it should.
Dana
Deanna Schneider writes:
> Sure. You can import it into access and then upsize from there. Access lets
> you use any delimiter you want in the text file. (File - import - external
> data, follow the prompts
thankee. I'm on it.
Matthew Small writes:
> You could easily import it into an access database and then I'm sure
> there's got to be an import function for access->mySQL.
>
> Matthew Small
> IT Director
> Showstopper American Dance Championships
> [EMAIL PROTECTED]
> 843-357-1847
>
>
> -O
it's a one-time transfer, moving the site to an actual data host. The files
are tiny, user name, password, email address, location, number of posts,
last post, etc. Maybe 500 of them.
I am yeah wondering about CF but I havent done any real file manipulation
yet. what's the syntax for read?
Dana
mm no it's | delimited but that's easy enough to fix. I dunno if there is
an import data function in mysql...I suppose I could always go look at the
manualsee if import comes up in the index
duh
Dana
William Bowen writes:
> is it comma delimited?
>
> is there an import data function s
Dana,
Why not use CF to do this? Read the file, pump it into an array
[listtoarray()] using Chr(10) as your separator, then loop over each array
index and stuff into the DB... I do this all the time with some of my log
files that don't fit into a good bulk import format for SQL Server...
HTH,
J
Are they regular in size and shape?
How big are the files?
I would write a simple cf page that reads and inserts, if the totals are reasonable
and you didn't needs to do it everyday.
If you get stuck, send me a couple lines of the text file and the db structure to pour
it in, and I'll jumble i
Sure. You can import it into access and then upsize from there. Access lets
you use any delimiter you want in the text file. (File - import - external
data, follow the prompts from there.)
I do this all the time. and then dump into oracle using CF. It's way easier
than getting our DBA to read it i
is it comma delimited?
is there an import data function similar to SQL Server 7.0/2000?
will
- Original Message -
From: "Dana Tierney" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2003 12:17 PM
Subject: import
> I didn't get an answer to this on ta
You could easily import it into an access database and then I'm sure
there's got to be an import function for access->mySQL.
Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
-Original Message-
From: Dana Tierney [mailto:[EMAIL PROTECTED]
39 matches
Mail list logo
