We always store as strings to avoid rounding issues and then convert for calcs
to whatever precision we need.
Pat...
Sent from my iPhone
On Dec 17, 2014, at 6:24 AM, Lucio Chiappetti lu...@lambrate.inaf.it wrote:
On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote:
On 16.12.2014 15:16,
Telephone: +44 (0)7918 621621
Email: john.dais...@butterflysystems.co.uk
--
Patrick Sherrill
patr...@michael-clarke.com
Michael-Clarke Company, Inc.
Since 1982
825 SE 47th Terrace
Cape Coral, FL 33904
(239) 945-0821 Office
(239) 770-6661 Cell
Confidentiality Notice. This email message
I seem to recall the issue with the debug library, but don't recall the fix.
Do you get the same permissions (access) error with the release library?
Pat...
- Original Message -
From: Miguel Cardenas renit...@gmail.com
To: mysql@lists.mysql.com
Sent: Saturday, January 10, 2009 10:22
- Original Message -
From: Ian Sales [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Patrick Sherrill [EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 9:53 AM
Subject: Re: Excel 2 mysql
David Ziggy Lubowa wrote:
On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote
David,
Please provide the complete LOAD DATA INFILE command you used.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
- Original Message -
From: David Ziggy Lubowa [EMAIL PROTECTED]
To: Eric Bergen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 08,
Given the many 'standards' for formatting phone numbers, I would recommend
using a char or varchar. Regex is intended for string types.
Do yourself a favor run an alter table and change the column to a char or
varchar.
I hope this helps...
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW
Ensure you have a timestamp(14) field. This will provide the required
uniqueness for Access (Jet).
I hope this helps.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: Adam [EMAIL PROTECTED]
To:
Arun,
You are back to the same issue. This has nothing to do with MyODBC. The
parameters you are passing are not the correct data types. If no username
is passed, the user 'ODBC' is supplied. If no host is passed 'localhost' is
supplied. The parameter you are passing for the password is being
for mysql_real_connect and ensure the
server you are attempting to connect to is in fact running and accepting
connections.
Also don't forget to reply to the list.
Pat...
- Original Message -
From: Arunachalam [EMAIL PROTECTED]
To: Patrick Sherrill [EMAIL PROTECTED]
Sent: Wednesday, December 31, 2003
. The parameters being
passed from your COBOL program, are not getting to the 'C' routine as the
correct data types or parameters (remember NULL is not zero).
Pat...
- Original Message -
From: Arunachalam [EMAIL PROTECTED]
To: Patrick Sherrill [EMAIL PROTECTED]
Sent: Wednesday, December
What is the syntax of your call to connect to the MySQL server?
It seems as though no server parameters are being passed, thereby defaulting
to the local machine which apparently has no mysql server running.
Pat...
CocoNet Corporation
SW Florida's First ISP
- Original Message -
]
To: Patrick Sherrill [EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 8:44 AM
Subject: COBOL Syntax of calling MySQL's C API
Hello Patrick,
The actual calling routines in C is;
MYSQL *mysql_real_connect(MYSQL *mysql,
const char *host,
const char *user,
const char *passwd,
const char
Statically linking using C API only you will need mysqlclient.lib
For odbc interface you'll need to make odbc calls in your code and use
myodbc.dll (Install myodbc on the client).
You can mix calls, but why would you. I have found the C API to be the best
solution for us. We statically link
Brian,
I think you are going to need to rename your fields/columns. If you are
unable to rename them in mysql then you will probably need to rename them in
your jet database with Access and re-import them.
Your column names should be literals not wrapped in graves or quotes and
should contain
We add an auto_increment BIGINT to every table we create. This gives us the
essence and utility of ROWID (BTW we always name the first column in a new
table 'row_id').
Just my 2 cents
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
825 SE 47th Terrace
Cape Coral, FL 33904
I'm reticent to consume any more of this lists bandwidth and trust this will
end the thread, but here is my point. There are many 'gotchas' to consider
when developing an application that uses any dynamic file structure from
simple flat ascii
files to engorged dbms's. Add multi-user and
Alternatively you can create a priority column defaulting to one number (99)
this will allow you to easily change the country sequence as needed.
SELECT countries_id, countries_name FROM TABLE_COUNTRIES ORDER BY
priority,countries_name;
I hope this helps...
Pat...
[EMAIL PROTECTED]
CocoNet
You just need to snag the website once you have published it or at least
have it running on a server somewhere. The result should be standard html
no need for MySQL or PHP on the CD.
Hope this helps
Pat...
- Original Message -
From: databarn [EMAIL PROTECTED]
To: MySQL [EMAIL
It sounds like it may be time to look at threads. Set up a thread and open
your recordset there or look at the C or C++ API for MySQL.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's 1st ISP
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday,
- Original Message -
From: Patrick Sherrill [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 14, 2002 9:22 AM
Subject: MySQL Source Dist.
I know I must be having brain gas, but where are the MySQL source
distributions currently?
Pat
Are partial word searches available with a FULLTEXT index.
I.E. could the following select statement return any results given that the
word Pippins or Pippin's is indexed ?
SELECT * from list WHERE MATCH (cols) AGAINST ('pipp')
TIA,
Pat...
[EMAIL PROTECTED]
MySql
Thanks for the input, unfortunately are production server is still v 3.26.xx
Pat...
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Patrick Sherrill [EMAIL PROTECTED]; mySQL List
[EMAIL PROTECTED]
Sent: Monday, July 22, 2002 2:40 PM
Subject: Re: mysql FULLTEXT Searches
What error? What schema?
Try TIMESTAMP(14)
Pat...
- Original Message -
From: Todd Cary [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 14, 2002 11:31 PM
Subject: ODBC and TimeStamp
I have a MySQL TimeStamp in my table. If I try to do a query via ODBC, I
get an
error on
If you are not using auto_increment for referential integrity, you could
dump your table structure,export all cols but your auto increment, drop your
table and re-import your table structure and data. Your idea should also
work if you run an ALTER TABLE and DROP INDEX first, then your UPDATE,
You need to link in the mysqlclient library. Select Project- Settings from
the VC menu bar, then select the Link Tab and add mysqlclient.lib to the
Object/Library Field. You will need to do this for the Release and Debug
version. You will also need to add the path under the Input Category of
I receive the following parse errors when attempting to compile a client
program on a Linux box using gcc 2.96:
gcc -c -DMYSQL -I/var/src/mysql-3.23.49/include checkhttpd.c
In file included from checkhttpd.c:9:
/var/src/mysql-3.23.49/include/mysql.h:175: parse error before `1'
If you are using PHP, just use the ucwords function.
From the PHP manual
ucwords(PHP 3= 3.0.3, PHP 4 = 4.0.0)
Uppercase the first character of each word in a string
string ucwords (string str)
Returns a string with the first character of each word in str capitalized,
if that character is
Please forgive the OT, but I am trying to integrate mysql db's with WIN32
clients on Linux servers. I need to use some programs (ONC RPC daemons) on
the Linux box from applications written in VC++ on a WIN32 box so RPC seems
the correct solution. Can anyone point me in the right direction for
Downgrade to 2.95.3
- Original Message -
From: luhar-123 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 25, 2001 2:09 AM
Subject: How to make use of mysql++ with gcc 2.96
Hi guys,
i have installed red hat linux 7.2 and mysql server version 3.23.42.
but i need
Have your ISP check permission on the file and parent directories.
Something has changed.
Pat...
[EMAIL PROTECTED]
SW Florida's 1st ISP
www.coconet.com
- Original Message -
From: Bruce Hodo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 12:15 AM
Subject: ISP
Patrick Sherrill writes:
Any clues on :
LINK : warning LNK4098: defaultlib MSVCRT conflicts with use of other
libs; use /NODEFAULTLIB:library
when attempting to link an MFC program using Mysql++ tweaked for MSVC?
Thanks,
Pat...
[EMAIL PROTECTED]
Hi!
The latest VC
Any clues on :
LINK : warning LNK4098: defaultlib MSVCRT conflicts with use of other
libs; use /NODEFAULTLIB:library
when attempting to link an MFC program using Mysql++ tweaked for MSVC?
Thanks,
Pat...
[EMAIL PROTECTED]
-
32 matches
Mail list logo