Database

Re: What should I do to connect JavaScript to database

7-Oct-10 7:13

One can easily view the source of the HTML pages, and that would expose the connectionstring to the outside world. Hence, it'd be ~~better~~ safer to use a server-side language to access the database.

I are Troll Suspicious | :suss:

blitz2bleach7-Oct-10 10:37

blitz2bleach

7-Oct-10 10:37

I see so there is no other way to connect it is by ASP/ASP.NET/ADO/AJAX?am I right?so if I used some of this language my file extension should be .asp..instead of .html or .js?if I used ADO?

Re: What should I do to connect JavaScript to database

Eddy Vluggen7-Oct-10 11:38

Can drop temptable from different server?

7-Oct-10 11:38

ASP is the older serverside scriptlanguage
ASP.NET is the newer version
ADO is what's used to talk to the database
AJAX is used to have the client call some serverside function

Do you have a webserver that's capable of running ASP.NET pages? You can verify by executing a small test-aspx Smile | :)

I are Troll Suspicious | :suss:

Naunt6-Oct-10 22:25

6-Oct-10 22:25

Dear all,

I want to know that can I drop temp table from different server?
tables are existed in Server1
but, I will create storeprocedure to drop these table from Server2

if (exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME = 'TEMP1'))
    begin
    Drop TABLE .dbo.TEMP1
end

my problem is I can't pass the servername(Server1) to check if temp tabels are exist or not.

Pls,Is there anyway to drop table from different server?

Thank you.

Blue_Boy6-Oct-10 22:49

Blue_Boy

6-Oct-10 22:49

DROP TABLE FROM LinkedServer.YourDB.dbo.#TableName

Hope it helps you.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Naunt6-Oct-10 23:02

6-Oct-10 23:02

thank you for your help.

but, got error like this

The object name 'server1.dbname1.dbo.' contains more than the maximum number of prefixes. The maximum is 2.

and the other fact is I have to check if table is exist or not.
if I select from Information.schema I can't put server name before Information.Schema

SELECT 1 FROM INFORMATION_SCHEMA.TABLES

SELECT 1 FROM servername.dbname.INFORMATION_SCHEMA.TABLES  (this code not work)

Blue_Boy6-Oct-10 23:26

Blue_Boy

6-Oct-10 23:26

You have to create linked[^], then you can try to delete temp table

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Naunt6-Oct-10 23:51

6-Oct-10 23:51

Yah, already link

even I can select from it, but not delete.

Eddy Vluggen7-Oct-10 11:50

7-Oct-10 11:50

naunt wrote:
even I can select from it, but not delete.

The DELETE and the SELECT statement require the same prefixes when referring to a linked server. Did you get the same error when executing the delete, or a different one?

Can you post both the command and the error-message?

I are Troll Suspicious | :suss:

Naunt7-Oct-10 15:51

7-Oct-10 15:51

Hi! Eddy Vluggen,
sorry I mean I can't drop. Delete is work fine.
select & delete work fine.

select * from [linkserver].dbname1.dbo.test
delete [linkserver].dbname1.dbo.test where field1='yyyy'

but, not for drop

DROP TABLE [linkserver].dbname1.dbo.test
got err --> The object name 'linkserver.dbname1.dbo.test' contains more than the maximum number of prefixes. The maximum is 2.

Blue_Boy7-Oct-10 20:32

Blue_Boy

7-Oct-10 20:32

Worths to check this link.[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Eddy Vluggen8-Oct-10 7:59

Access database modified date and time

8-Oct-10 7:59

Seems that you can't directly drop a remote table then. How about creating a sproc in the remote database that takes a tablename and drops it? Could that be called with the three prefixes?

I are Troll Suspicious | :suss:

Sakhalean6-Oct-10 19:57

Sakhalean

6-Oct-10 19:57

Hi All,

I have a access database.

Whenever we open the database the date and time of the
database file will be changed.

If the user has modified the database ( any table updation )
then only the date and time of the file to be changed?

How to do this?

Pete O'Hanlon6-Oct-10 22:02

6-Oct-10 22:02

Why would you want to do this? As Access stores the data on disk, it has to abide by the operating system rules on file modifications. If you need to check the date for datas sake, then this information should be on the tables themselves. In other words, you should supply created/changed fields which store the details of the time the data item was created/updated.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

Sakhalean6-Oct-10 23:07

Sakhalean

6-Oct-10 23:07

OK .
How to get the date and time information
of the table through ADO programming.

I want to know when the date and time of the table is modified.

Pete O'Hanlon6-Oct-10 23:31

6-Oct-10 23:31

Did I not mention that they would be columns on the table? Just query that information.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

David Skelly6-Oct-10 22:21

David Skelly

6-Oct-10 22:21

If you open a table in an Access database, even if all you do is open it and never run a select query or anything, then Access modifies the mdb file, so the file timestamp will change. That is the way Access works, and there is nothing you can do about it.

As someone else has already pointed out, if you need to know when the data was last updated then you should build it in to your application in one way or another.

How can I add the data found from one table to another?

Mycroft Holmes7-Oct-10 0:44

Mycroft Holmes

7-Oct-10 0:44

I'm not sure how you would get table modifications, however getting RECORD modifications is a VERY simple excercise, you do have a number of options. ALL of them require additional columns/fields to be added to the tables you want to monitor.

We monitor all tables so we have a Modified and ModifiedBy on all tables.

Add a timestamp field to the table and trigger it every time a record is saved, I think you can trigger this in access, not sure anymore.

From your UI pass in the userid and datetime whenever you write back to the database.

In your update/insert query automatically gather the current user and the datetime and add then to the update/save

Never underestimate the power of human stupidity
RAH

djhankypark6-Oct-10 6:19

djhankypark

6-Oct-10 6:19

Hi
I am comparing data between 2 tables looking for what exists in one so i can then enter whatis found into the second table as follows...

<pre>
mysql_select_db($database_Chartmenu, $Chartmenu);
$query_find_all = "SELECT hankypark.ID FROM hankypark LEFT JOIN tbl_ply_hankypark ON hankypark.ID = tbl_ply_hankypark.Song_ID WHERE (((tbl_ply_hankypark.Song_ID) Is Null))";
$find_all = mysql_query($query_find_all, $Chartmenu) or die(mysql_error());
$row_find_all = mysql_fetch_assoc($find_all);
$totalRows_find_all = mysql_num_rows($find_all);
</pre>

in the hankypark table i know will be entries that do not exist in the tbl_ply_hankypark table hense the Is Null query which gives me an array of the ID field, I now want to add those ID's to the tbl_ply_hankypark table. Question is what do I use to roll through all the ID's found ?

My INSERT query looks like this...as said what do use tat the begining is it a...

while or do or what?? and how should it be properly laid out please? not having played with arrays I have tried several things from suggestions on the net but none seem to work apart from one that only inserted the first ID and then stopped?

<code>
// Insert a row of information into the table "example"
mysql_query("INSERT INTO tbl_ply_hankypark (Song_ID) VALUES ('???')")or die(mysql_error());
</code>

Thought it best to just bite the bullet and come ask you guys cos your always right lol Smile | :)

Cheers in advance of any help

Regards

Ray

Re: How can I add the data found from one table to another?

PIEBALDconsult6-Oct-10 14:59

PIEBALDconsult

6-Oct-10 14:59

Look into using an INSERT/SELECT statement.

Re: How can I add the data found from one table to another?

Pete O'Hanlon6-Oct-10 21:57

6-Oct-10 21:57

One thing that you can do is combine an insert and a select command together, so you actually get the values inserted that you select from the select query. Your command becomes something like this:

INSERT INTO tbl_ply_hankypark(song_id)
SELECT hankypark.ID FROM hankypark 
LEFT JOIN tbl_ply_hankypark ON 
hankypark.ID = tbl_ply_hankypark.Song_ID 
WHERE (((tbl_ply_hankypark.Song_ID) Is Null))

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

Re: How can I add the data found from one table to another?

djhankypark7-Oct-10 2:28

djhankypark

7-Oct-10 2:28

Thnak you for both replies I knew I would get the right directions here

Many Thanks for you help

Regards

Ray

Re: How can I add the data found from one table to another?

Pete O'Hanlon7-Oct-10 2:34

7-Oct-10 2:34

You're welcome.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads