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 wrote:
>
>> On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote:
>>> On 16.12.2014 15:16, xiangdongzou wrote:
>>>
>Email: john.dais...@butterflysystems.co.uk
>
>
>
>
>
> --
> Best Regards,
>
> Prabhat Kumar
> MySQL DBA
> Datavail-India Mumbai
> Mobile : 91-9987681929
> www.datavail.com
>
> My Blog: http://adminlin
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"
To:
Sent: Saturday, January 10, 2009 10:22 AM
Subject: VC++ 2008 / MySQL debug / U
;s First ISP
there are just two issues that I would look at if his solution
- Original Message -
From: "Ian Sales" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Patrick Sherrill" <[EMAIL PROTECTED]>
Sent: Thursday, December 09, 200
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, Decem
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 Florida
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 rea
pe problem. 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 Sher
your parameters and data types 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: "Pa
quot;Arunachalam" <[EMAIL PROTECTED]>
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(MY
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 -
From:
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 no
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 fo
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
(23
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 multi-task
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 Corpo
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
distribu
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, J
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
--
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
> erro
In the command line mode of Windows(DOS sic), F3 will repeat the last
command line. In current versions of mysql CLI arrow up will replay the
command series. What version are you using and with what version of
Windows?
Pat...
- Original Message -
From: "Paul Flint" <[EMAIL PROTECTED]>
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, th
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 t
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'
/var/src/mysql-3.23.
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 al
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 WI
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 ne
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:
: mysql++ linker errors with VC++ ver6
> Patrick Sherrill writes:
> > Any clues on :
> >
> > "LINK : warning LNK4098: defaultlib "MSVCRT" conflicts with use of other
> > libs; use /NODEFAULTLIB:library"
> >
> > when attempting to link a
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]
--
Being an *NIX developer for longer than I care to recall and using Linux
since .99r, I would disagree about a buggy io subsystem. There may be some
issues with marshalling and /or threads (usually a coding/synchronization
issue not a thread issue), but I would suspect it is relating to db cachin
34 matches
Mail list logo
