Thanks, Joshua - just the sort of info I needed.
Off to find a more recent distro
Cheers
Terry
- Original Message -
> On Friday 11 February 2005 09:15, Terry Riley said something like:
> > Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk,
> > that had an apparently
Hello,
I made little board, where all postings are in one table:
Field Type
---
topic_id int(6) unsigned
topic_pid int(6) unsigned
authorvarchar(50)
mail varchar(255)
posting_time timestamp(14)
ipvarchar(15)
body te
Hi again mysql-listers
regarding the problem i mentionned this morning:
for a description check out my message of this morning.
in the meantime i have found out
1. how to reproduce the problem
2. how to work around the problem
1. how to reproduce:
DROP TABLE afir_accounts ;
DROP TABLE afir_contact
On Fri, Feb 11, 2005 at 10:45:46AM -0500, [EMAIL PROTECTED] wrote:
> Normally I do not reply to myself but I just realized that in my previous
> response I confused COUNT(*) (which is slow for InnoDB because it always
> does a table scan to resolve the version lock of each and every row) with
I already have a series of tables defining the world's
continents, oceans, nations, states, etc. Actually,
it's just two tables. Type defines the kinds of
divisions, like this:
TABLE: TYPE
(ID) (Type)
pla | planet
kon | continent
oce | ocean
nat | nation
sta | state
pro | province
Table famarea l
I want to import some data into my database, but it's
in an ArcView Shapefile, which I've never worked with.
Does anyone know what kind of software I can use to
access this data? Actually, I'd probably import it
into a spreadsheeet first, then save it as a csv file
and import it into my database.
David -
Here is a link to search results on http://www.esri.com.
http://search.esri.com/results.cfm?
h=10&ho=0&q=arcview+shapefile&sa.x=26&sa.y=11
ESRI is the leader in GIS software and the maker of the application,
"ArcView". Check out the link for the first search result on the link
I gave
Hi David,
I want to import some data into my database, but it's
in an ArcView Shapefile, which I've never worked with.
Does anyone know what kind of software I can use to
access this data? Actually, I'd probably import it
into a spreadsheeet first, then save it as a csv file
and import it into my d
Aha - that's why I like to ask questions on newsgroups
rather than get secondhand news from Google! :)
This sounds really cool. One question, though...when
you talk about downloading the "source code," are you
saying your program is for Linux only? As much as I
hate Microsoft, I'm still stuck with
Hi David,
This sounds really cool. One question, though...when
you talk about downloading the "source code," are you
saying your program is for Linux only? As much as I
hate Microsoft, I'm still stuck with Windows XP.
I developed it on Linux, and haven't ever tried to compile it on
Windows, as I d
Chris Elsworth wrote:
On Fri, Feb 11, 2005 at 10:45:46AM -0500, [EMAIL PROTECTED] wrote:
Normally I do not reply to myself but I just realized that in my previous
response I confused COUNT(*) (which is slow for InnoDB because it always
does a table scan to resolve the version lock of each and eve
I'm ripping hair out, here's the problem...I'm trying to insert content
cited below into a field and it's causing this error, ie. there's
content i just cannot insert into the DB an it's causing the following
error message:
"You have an error in your SQL syntax; check the manual that corresponds
t
Sweet! Thank you Jeremy!
-James
On Feb 12, 2005, at 3:52 PM, Jeremy Cole wrote:
Hi David,
I want to import some data into my database, but it's
in an ArcView Shapefile, which I've never worked with.
Does anyone know what kind of software I can use to
access this data? Actually, I'd probably import
I fixed it. But I'm not clear on why. The following code ie. taking the
content and blatently putting the content through addslashes():
$descrip_field=addslashes($descrip_field);
Fixed it. But the code:
if (!get_magic_quotes_gpc()) {
$descrip_field = mysql_real_escape_string($descrip_field);
Hi,
Sweet! Thank you Jeremy!
FYI, make sure you grab the libmygis-0.3.tar.gz or later instead of any
other version. I had some silly mistakes that made the DBF file
required instead of optional. I've also ported to Mac OS X in 0.3.
Regards,
Jeremy
--
Jeremy Cole
Technical Yahoo - MySQL (Datab
[EMAIL PROTECTED] wrote:
Hello,
I made little board, where all postings are in one table:
Field Type
---
topic_id int(6) unsigned
topic_pid int(6) unsigned
authorvarchar(50)
mail varchar(255)
posting_time timestamp(14)
ipvarch
leegold wrote:
I'm ripping hair out, here's the problem...I'm trying to insert content
cited below into a field and it's causing this error, ie. there's
content i just cannot insert into the DB an it's causing the following
error message:
"You have an error in your SQL syntax; check the manual that
I have a request for a list of database entries "Select x,y,z, etc" that is now
working OK. I have several questions, however. Here they are:
1.. Can I add a "total" line at the bottom of the report (ex: "Total
Selected: 23") for the total number of entries that are listed in the report?
18 matches
Mail list logo
