Re: [Csvjdbc-develop] JDBC driver for CSV

[Tomasz S. <Tom...@e-...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

John Walker wrote:
|
| a) On Windows, how do you secify the CSV directory on the server?   I
| did the following, which I am pretty sure is wrong and causing my grief:
|
| jdbc:relique:csv:*e:\cf\bocs\PFVMI\SAPData*

Try jdbc:relique:csv:e:/cf/bocs/PFVMI/SAPData (use Un*x slashes instead
of Windows' ones - you should always use them - no matter what platform,
omit asterisks)

|
| b) When using ODBC drivers for CSV files, I am accustomed to select *
| and have the rows returned as field_1, field_2, etc..  Appears this
| driver will use whatever field name I give it?  Or, is it expecting a
| header row of field names in the 1st row that correspond to what I select?

Sorry, ask someone else, or look into sources :)

|
| c) I am also accustomed to select * from csvfile.csv, but it appears I
| the .csv is taken for granted and should not be specified, correct?
|

Yep. Read the manual.

|
|
| John Walker
| Macromedia Solutions Manager
| Black Oak Technology Solutions
| 805 N. Salisbury Blvd. Suite 3100
| Salisbury MD,  21801
| http://www.black-oak.com
| Office: 410-546-8100 x:2258
| Cell:    410-430-6706
| jw...@bl...

Cheers.

- --

Tomasz Skutnik, R&D Director, www.e-point.pl
tel +48 (22) 853 48 30, mob +48 501 555 705, fax +48 (22) 853 48 30
e-point S.A., ul. Filona 16, 02-658 Warsaw, Poland
PGP/GPG public key: http://scooter.ext.e-point.pl/tomasz.skutnik.gpg
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+FVhzZe1f4n3990IRAnYSAKCHa36+nuQDVaimSkExo0SCzFUU4wCeOLOG
+Z16jDkD0lINhRZVyP89deo=
=i6WB
-----END PGP SIGNATURE-----