Re: Google Gadget

On 12 Mar, 18:46, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
bagega wrote:
On 12 Mar, 12:35, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
DBMS: SQLServer2005

Oops, I missed this the first time I read it

<snip>

what datatypes are needed for those two columns? INT
2. What programming language and platform are you using? I'm using
google gadget SDK

An SDK is not a programming language. It is a set of classes meant to be
used by a developer in some programming language (VB, VB.Net, vbscript,
Java, C++, etc). I am not familiar with this google sdk so will be
unable to help you with anything regarding it. I can, however, help with
ADO if you tell us what programming language you are using.

3. Where specifically do you need help? I need to know how store the
value of the value in the first row of a column of a table

A database table is by definition an unordered set of rows and columns,
so there is no such thing as the "first row" of a column. The database
designer needs to provide a column or a group of columns to act as the
key to the rows of a table. If that key allows the first row that was
entered into the table to be identified, then that will help perform
your task.

Given the information you've provided, inserting a row into your table
is simply (using vbscript):

dim cn, sql
sql = "insert into helpme(ONE,TWO) values (1,1)"
set cn=createobject("adodb.connection")
cn.open "provider=sqlncli;data source=MYSERVER;" & _
"initial catalog=YourDatabase;user id=xxxxx;password=xxxxx"
cn.execute sql,,129
cn.close:set cn=nothing

4. In Google desktop developer forum they told me to use ADOdb, and it
didn't sound a bad idea

The ADO documentation can be found here:http://msdn2.microsoft.com/en-us/library/ms675532.aspx
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

With first row of a table I wanted to mean that the table will have
just a record (row), it probably doesn't make sense, but that's what I
need.
I'm going to produce java script...


always thanks
.

Relevant Pages

  • Re: Google Gadget
    ... google gadget SDK ... An SDK is not a programming language. ... so there is no such thing as the "first row" of a column. ...
    (microsoft.public.data.ado)
  • Re: Google Gadget
    ... google gadget SDK ... An SDK is not a programming language. ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Getting an error 20498!
    ... it's actually a bad idea to use the puportedSearch attribute. ... As for the error you are encountered: Which programming language do you use? ... As i try to get the first row from the ... I changed the filter to all possible ways ...
    (microsoft.public.exchange.development)