Re: GetDate() in Access - Database Discussion Boards

Re: Strange problem with Access and SQLServer

Mazdak29-Dec-02 19:59

29-Dec-02 19:59

Thanks Rob,But problem in connection string caused unhandled error,but I don't recieve any error,and also about name of table.Those are problems when I copy paste codes here. Smile | :)

Mazy

"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits

Re: newbie needs database help

Michael P Butler28-Dec-02 10:25

Michael P Butler

28-Dec-02 10:25

This may be of some use

http://www.learnasp.com/learn/dbupdate.asp[^]

Michael

Fat bottomed girls
You make the rockin' world go round -- Queen

A difficult challenge

skallestad27-Dec-02 15:06

skallestad

27-Dec-02 15:06

I have an application which stores data in a text field (sql server 2000) like the following:

1040970851Demotest me five1040970856Demothis is another thing1040970955Demothis is the n. no quotes now. that was scary.

I need to parse the data for crystal reports 8.0 so that it displays as it does in the application...

I don't have a problem parsing the data, but I do have a problem in figuring out how to implement a solution. It turns out that using Crystal 8.0 UFL dlls are limited to 255 characters or less.

Can I get the data to crystal properly using external stored procedures, or am I going to be relegated to writing an odbc driver?

GetDate() in Access

Mazdak27-Dec-02 8:40

Mazdak

27-Dec-02 8:40

Do we have something like GetDate() in Access?

Mazy

"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits

Re: GetDate() in Access

Nick Parker27-Dec-02 9:05

Nick Parker

27-Dec-02 9:05

Mazdak wrote:
Do we have something like GetDate() in Access?

Oh, in VB you need to use Now(). You can also format it such as:

d = Format(Now, "mm/dd/yyyy")

Nick Parker

You see the Standards change. - Fellow co-worker

Re: GetDate() in Access

Mazdak29-Dec-02 1:16

Mazdak

29-Dec-02 1:16

Hi Nick:

I need to used GetDate() in a query that Access does not support it.I don't use VB.I use C#.

Anyway thanks. Smile | :)

Re: GetDate() in Access

Rob Graham30-Dec-02 8:59

Rob Graham

30-Dec-02 8:59

The previous CPian gave you the correct answer. The equivalent function for getDate() in MsAccess is Now(). It will work in both an isert query and as the default value for a date/time field: "INSERT INTO MyTable( Mydate) SELECT Now() AS Expr1"
or
"INSERT INTO MyTable( Mydate) Values( Now())"

Some ideas are so stupid that only an intellectual could have thought of them - George Orwell

Re: GetDate() in Access

Mazdak31-Dec-02 7:30

Mazdak

31-Dec-02 7:30

Oh,I got it. Smile | :)

Thanks.

Mazy

"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits

Determining if a datarow contains a particular column

MS le Roux26-Dec-02 21:35

MS le Roux

26-Dec-02 21:35

When binding a datagrid, one of the columns calls a function to process the "Status" field. However, sometimes that field is not there - sometimes I get the exception "Status is neither a DataColumn nor a DataRelation for table ABC".

So I used an IF statement to check if that field is Nothing, but that too caused the exception to be thrown.

How do I determine if a datarow contains a particular column?

Re: Determining if a datarow contains a particular column

MS le Roux26-Dec-02 21:54

MS le Roux

26-Dec-02 21:54

Never mind. I discovered the Contains function on DataRow.Table.Columns.

Re: Determining if a datarow contains a particular column

leppie27-Dec-02 12:14

leppie

27-Dec-02 12:14

Dont you hate that. Doing sh&tloads of coding only to realize the solution is already provided Smile | :)

Especially those damned static methods in the Object Browser. Smile | :)

WebBoxes - Yet another collapsable control, but it relies on a "graphics server" for dynamic pretty rounded corners, cool arrows and unlimited font support.

How do I execute a query through an ASP page to update my fields

E Slipchenko26-Dec-02 18:29

E Slipchenko

26-Dec-02 18:29

I'm creating a contract database that has over 80 different calculations and formulas. I'm using one table with fields and one query for formulas. I need to run/update query through the browser. Does anyone have any idea how this should be done? I'm using this SQL statement in the query, maybe there is a better SQL statement I can use to automatically update my fields in the table? Please help!
I appreciate any help from you guys.

Re: How do I execute a query through an ASP page to update my fields

leppie27-Dec-02 12:20

leppie

27-Dec-02 12:20

I dont know about ASP as such, but SQL aloows you to make Stored Procedures that in turn aloows you to pass parameters (variables) into the statement. The .Net frameworks allows you to use this functionality.

Smile | :)

WebBoxes - Yet another collapsable control, but it relies on a "graphics server" for dynamic pretty rounded corners, cool arrows and unlimited font support.

How to send data from one application to another

Exceter25-Dec-02 17:37

Exceter

25-Dec-02 17:37

1. I have an application (SDI) which works with database
that is, retrieves data and the data are displayed in Edit Boxes and Statics
I want to send these data to another program, MS Word in my case
how to do this ?

2. Is it possible with ADO?

thank you.

Re: How to send data from one application to another

Alexander Kojevnikov26-Dec-02 6:00

Alexander Kojevnikov

26-Dec-02 6:00

You ought to use WinWord's COM API, e.g. create a new Word document, insert a table, and fill it in with the data from your database.

Alexandre Kojevnikov
MCP (SQL2K)
Leuven, Belgium

Count records / ASP

Sarvesvara (BVKS) Dasa24-Dec-02 21:02

Sarvesvara (BVKS) Dasa

24-Dec-02 21:02

I want to count the number of records.... and display it in my web-page using my ASp page. I know that the "Select count(*) from table" will give the count in the database.

How can I retrive the 'result' from that query and pass it on to my ASP page??

Any help?

I was born intelligent
Education ruined me!.

Re: Count records / ASP

Rein Hillmann24-Dec-02 23:04

Rein Hillmann

24-Dec-02 23:04

Off the top of my head it goes something like this (there might be some mistakes since I haven't tested it):

<script language=vbscript runat=server>
Dim ADOConn
Dim ADORs
Dim RecordCount

set ADOConn = CreateObject("ADODB.Connection")
ADOConn.Open(myConnectionString)
set ADORs = ADOConn.Execute("select count(*) as NumRecords from MyTable")

if not ADORs.BOF and not ADORs.EOF then
    RecordCount = ADORs.Fields("NumRecords").Value
end if

ADORs.Close
ADOConn.Close

Response.Write "# Records: " & RecordCount
</script>

Re: Count records / ASP

Tatham26-Dec-02 7:04

Tatham

26-Dec-02 7:04

The fact that you're using a <script runat="server"> tag says that you're using .NET.

Therefore:
1. Use .NET the proper way with code behinds and a literal control
2. Use .NET the proper way with ADO.NET rather than ADO and late binding

Those are where your problems lie - your using legacy code in a new environment.

If you use ADO.NET, to get your record count just go get the value of myDataset.Tables(0).Rows.Count.

Tatham Oddie (VB.NET/C#/ASP.NET/VB6/ASP/JavaScript)
tatham@e-oddie.com
+61 414 275 989

Re: Count records / ASP

Rein Hillmann26-Dec-02 17:43

Rein Hillmann

26-Dec-02 17:43

Actually, you're wrong there.

The <script runat="server"> tag was there long before .NET was developed. It's how script is run server-side in ASP.

Tatham wrote:
Those are where your problems lie - your using legacy code in a new environment.

Since the grandparent post asked for "ASP" and not "ASP.NET", I answered using VBScript which is the de-facto standard for using server side scripting in ASP.

Not everyone is using .NET yet.

Why my SQL Server is so slow?

Wenrich24-Dec-02 18:12

Wenrich

24-Dec-02 18:12

I just installed SQL Server on my machine, and found that it was
really slow! I even had to wait for quite a while when
create a table or open an empty table in the Enterrpise
Manager. Accessing it from a program is also painfully
slow. I got SQL Server SP2 installed as well, but didn't
solve the problem. Any ideas?

Thanks a lot!

Wenrich

Re: Why my SQL Server is so slow?

Nick Seng26-Dec-02 23:10

Nick Seng

26-Dec-02 23:10

What machine/spec are you running it on? Memory, OS, Clock-Speed, Harddisk ( fragmentation) all plays a part on the overall speed.

Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain

Get your facts first, and then you can distort them as much as you please
Mark Twain

Re: Why my SQL Server is so slow?

leppie27-Dec-02 12:25

leppie

27-Dec-02 12:25

Thats quite true what you are saying. I did a small test the other day. First test I set SQl to use all memoty available (384mb in my case). The avg time for an INSERT plus several updates x 100 were 30ms. The 2nd test I dropped SQL's memory to 128mb. The same test yeilded results of 65ms per "operation". It seems SQL likes memory (like most MS products). In a production enviroment I would bother if the SQL server didnt have at least 512mb RAM.

Smile | :)

WebBoxes - Yet another collapsable control, but it relies on a "graphics server" for dynamic pretty rounded corners, cool arrows and unlimited font support.

Re: Why my SQL Server is so slow?

Thomas Lau30-Dec-02 18:28

Thomas Lau

30-Dec-02 18:28

You can try to reinstall. Smile | :)

Count total records

Jassim Rahma23-Dec-02 21:18

Jassim Rahma

23-Dec-02 21:18

what is the easiest way to count the total records in C#? can I have an example please?

Jassim Rahma

Re: Count total records

Mazdak24-Dec-02 1:34

Mazdak

24-Dec-02 1:34

Select count(*) from tablename

This will return one record and its number of records.

Mazy

"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.