Re: Google Gadget

On 12 Mar, 12:35, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
bagega wrote:
Hi,
I would to load a set of values stored in a table in MSSQL, and take
the into a google desktop gadget.

I asked for that in GD group and they kindly told me that you're going
to help me.

This is what I have to do:

let's suppose:

Goal: load the values in a table and store them in some variables

DBMS: SQLServer2005
name of the Server "MYSERVER"
name of the table HELPME
name of columns of inteerest ONE and TWO

name of the variables I want to fill var1 and var2

We're going to need some more information:
1. What version of sql server are you using?
2. What programming language and platform are you using
3. Where specifically do you need help?

- With the database tasks? Frankly, the names of your table and columns
don't inspire confidence in your database abilities. If so, what datatypes
are needed for those two columns? Why aren't there any other columns to help
us key the table rows and select which row of data to retrieve from the
table? And why do the table and columns need to have such nondescriptive
names? Are you having trouble creating the table? If so, you should
1. start reading SQL Books Online
2. ask for help with this part in a sqlserver group (although, given some
details, we can provide some help in this area)

- With writing the query to retrieve the data you want?
- With the ADO code to open a connection to the database and open a
recordset?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Hi,
first of all thanks for answering.
second, Yes, I'm not too confident with Databases, but the table names
were just an example.

I'm going to answer to what you asked:
what datatypes are needed for those two columns? INT
1. What version of sql server are you using? 2005
2. What programming language and platform are you using? I'm using google gadget SDK
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
4. In Google desktop developer forum they told me to use ADOdb, and it
didn't sound a bad idea



.

Relevant Pages

  • Re: Searching Sharepoint with Google Desktop
    ... You wouldn't be able to since, as you said, the content is stored in the database and Google Desktop doesn't search SQL Server databases (nor would it be able to recognize a Word/Pdf/etc. ... all the documents are stored in a database instead of file folders, I'm having a hard time figuring out a way to do this. ...
    (microsoft.public.sharepoint.portalserver)
  • Searching Sharepoint with Google Desktop
    ... Has anyone found a way to search Sharepoint with Google Desktop? ... all the documents are stored in a database instead of file folders, ...
    (microsoft.public.sharepoint.portalserver)