please CC me, I am on digest
---------------------------------
I have the following code from an application that is 'mysql_centric'. I
want to make it generic across all databases, if it's possible,
especially postgres :-)
mysql version:
INSERT INTO calendar_setting SET setting='colorEvent',value='#C2DCD5';
There is no data in this table at this time.
Isn't this the same as:
INSERT INTO calendar_setting( 'colorEvent' ) VALUES ( '#C2DCD5');
would this work on all db's?
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org) 6 1807
On 7-6-2004 23:29, Dennis Gearon wrote: please CC me, I am on digest --------------------------------- I have the following code from an application that is 'mysql_centric'. I want to make it generic across all databases, if it's possible, especially postgres :-)
mysql version: INSERT INTO calendar_setting SET setting='colorEvent',value='#C2DCD5';
There is no data in this table at this time. Isn't this the same as: INSERT INTO calendar_setting( 'colorEvent' ) VALUES ( '#C2DCD5');
would this work on all db's?
Afaik your first example is equal to:
INSERT INTO calendar_setting( setting, value) VALUES ('colorEvent',
'#C2DCD5');
Your first example isn't really SQL-standard and you'd perhaps better
try using SQL-standard stuff as much as possible on MySQL aswell. The
INSERT ... SET-version of INSERT wouldn't be my version to use.
Best regards,
Arjen
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
On 7-6-2004 23:29, Dennis Gearon wrote: please CC me, I am on digest --------------------------------- I have the following code from an application that is 'mysql_centric'. I want to make it generic across all databases, if it's possible, especially postgres :-)
mysql version: INSERT INTO calendar_setting SET setting='colorEvent',value='#C2DCD5';
There is no data in this table at this time. Isn't this the same as: INSERT INTO calendar_setting( 'colorEvent' ) VALUES ( '#C2DCD5');
would this work on all db's?
Afaik your first example is equal to:
INSERT INTO calendar_setting( setting, value) VALUES ('colorEvent',
'#C2DCD5');
Your first example isn't really SQL-standard and you'd perhaps better
try using SQL-standard stuff as much as possible on MySQL aswell. The
INSERT ... SET-version of INSERT wouldn't be my version to use.
Best regards,
Arjen
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
On Mon, Jun 07, 2004 at 02:29:33PM -0700, Dennis Gearon wrote: I have the following code from an application that is 'mysql_centric'. I want to make it generic across all databases, if it's possible, especially postgres :-)
mysql version: INSERT INTO calendar_setting SET setting='colorEvent',value='#C2DCD5';
That would be
INSERT into calendar_setting (setting, value)
VALUES ('colorEvent', '#C2DCD5');
This is the standard syntax, which is not quite the same thing as
saying it will work on all DBs - it will certainly work on both
Postgres and MySQL.
Richard
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
On Mon, Jun 07, 2004 at 02:29:33PM -0700, Dennis Gearon wrote: I have the following code from an application that is 'mysql_centric'. I want to make it generic across all databases, if it's possible, especially postgres :-)
mysql version: INSERT INTO calendar_setting SET setting='colorEvent',value='#C2DCD5';
That would be
INSERT into calendar_setting (setting, value)
VALUES ('colorEvent', '#C2DCD5');
This is the standard syntax, which is not quite the same thing as
saying it will work on all DBs - it will certainly work on both
Postgres and MySQL.
Richard
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
On Mon, 2004-06-07 at 15:29, Dennis Gearon wrote: please CC me, I am on digest --------------------------------- I have the following code from an application that is 'mysql_centric'. I want to make it generic across all databases, if it's possible, especially postgres :-)
mysql version: INSERT INTO calendar_setting SET setting='colorEvent',value='#C2DCD5';
For SQL 92, that's not supported syntax. I don't recall if something
like it got tossed into the latest SQL 03 standard or not.
There is no data in this table at this time. Isn't this the same as: INSERT INTO calendar_setting( 'colorEvent' ) VALUES ( '#C2DCD5');
That's the syntax the SQL 92 spec says to use.
would this work on all db's?
Probably not. It's non-standard in the old spec, I don't know about the
new one. If it got in the newest spec then it could probably get
committed pretty easily.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
On Mon, 2004-06-07 at 15:29, Dennis Gearon wrote: please CC me, I am on digest --------------------------------- I have the following code from an application that is 'mysql_centric'. I want to make it generic across all databases, if it's possible, especially postgres :-)
mysql version: INSERT INTO calendar_setting SET setting='colorEvent',value='#C2DCD5';
For SQL 92, that's not supported syntax. I don't recall if something
like it got tossed into the latest SQL 03 standard or not.
There is no data in this table at this time. Isn't this the same as: INSERT INTO calendar_setting( 'colorEvent' ) VALUES ( '#C2DCD5');
That's the syntax the SQL 92 spec says to use.
would this work on all db's?
Probably not. It's non-standard in the old spec, I don't know about the
new one. If it got in the newest spec then it could probably get
committed pretty easily.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: serge |
last post by:
I have a scenario where two tables are in a One-to-Many relationship
and I need to move the data from the Many table to the One table so
that it becomes a One-to-One relationship.
I need to...
|
by: Dotnet Gruven |
last post by:
I've posted this in the adonet group, however it was suggested I might have
better luck here....
=============================================================
I'm trying to use a typed dataset and...
|
by: Dennis Gearon |
last post by:
please CC me, I am on digest
---------------------------------
I have the following code from an application that is 'mysql_centric'. I
want to make it generic across all databases, if it's...
|
by: tparks69 |
last post by:
I get the error:
ObjectDataSource 'ObjectDataSource1' could not find a non-generic method
'Insert' that has parameters: last_name, first_name, email, role_id, user_id,
modified_by, modified_date...
|
by: Dennis |
last post by:
I created a table adapter on an xsd that uses 4 basic stored procedures
for select, update, insert, delete. Then I created an aspx page with
an object data source that uses the table adapter and a...
|
by: markww |
last post by:
Hi,
I have a wrapper around some 3rd party database library function. The
pseudo code looks like the following - it is meant to open a table in a
database, extract values from a table, then copy...
|
by: Srini |
last post by:
Hello,
I have a Generic List of values which is bound to a GridView
List<AppointmentattendeesList = new List<Appointment>();
List<AppointmentOldattendeesList = new List<Appointment>();...
|
by: fig000 |
last post by:
HI,
I'm new to generics. I've written a simple class to which I'm
passing a generic list. I'm able to pass the list and even pass the
type of the list so I can use it to traverse it. It's a...
|
by: Cirene |
last post by:
Using Visual Studio I created a DataSet using the GUI (XSD file).
Trying to use a tiered methodology I called the functions from my BLL.
Namespace Zzz.BusinessLogicLayer
#Region "DAL Access"...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |