Viewing A Field With A "time" Type

im trying to view one of my fields in MySQL DB with a "time" type:

rsShowTime ("stime")

output is:

7/5/2004 hh:mm:ss AM

in my DB the record only shows hh:mm:ss, how come it outputs "7/5/2004 hh:mm:ss AM"?

i only want to have hh:mm:ss as my result.

View Replies


ADVERTISEMENT

Get Field Type

I am in the process of redeveloping a number of applications on our corporate intranet. One of them currently accesses an Oracle database, which I am transferring to MS SQL, as well as tidying up the ASP. I am unable to access the db to see the data types in any conventional way, but I can run a SQL query in an ASP page to get the types. Unfortunately, this is returning a numerical value for the data type, rather than a meaninful name, e.g.

Field Name Type Size
ID 139 20
INITIALS 200 10
SURNAME 200 40

I am assuming that 139 equates to ID and 200 to nvarchar, but does anyone have or know where I can get a definitive guide to what these numbers really are?

View Replies View Related

Date/Time Data Type

Im having trouble in storing blank or space value on a variable wich data type is Date/Time, if i make a statement like this

Field Data Type
CPARCAVEDate Date/Time

strCPARCAVEDate = rstFEVV.fields("CPARCAVEDate").value

if strCPARCAVEDate = "" then
counter = counter + 1
end if

The value doesnt increment. Do you guys have an idea how to recognize a no value.

View Replies View Related

Detect Field's Type

How to detect field's type in asp with accessing sql server.

View Replies View Related

Contents Of Field Type

I am writing vbscript code in an .asp page.I need to display field values from a sql table consisting of several fields, one of them is of type "Long Text".This field contains XML data. I like to be able to assign vale of this field to a variable display it and write out a text file using file streaming object.

When I set a variable to this field, the data is truncated.I am using "Recordset" object, is that not an appropriate type to retrieve <long Text> fields.

View Replies View Related

Field Type Nvarchar

i have a simple table with a field called "authors". this filed have a nvarchar(max) type (in MSSql 2005). i have a simple query "Select authors FROM table". in query analizer this return the value of authors, but when i run this in asp page, the field is empty.

in the code i have:

Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, Conn, 1, 1

but rs("Authors") is empty.

If i change the type (and i use nvarchar(4000) for authors) there is no problem. for the connection i have Driver={SQL Native Client}.

View Replies View Related

MySQL Column-Type Time With Win2k3

I've changed my Webserver from Win2k to Win2k3. The MySQL-Server 4.0.20 is on a separate machine and i've made no changes there.

When i read a time from a colum which column-type time with Win2k, i get the correct time.
But when i try the same with Win2k3 i get only a date. Why? I connect to the MySQL-Server with ADODB.Connection.

View Replies View Related

Time Field

I have a time field that starts at 00:00 through to 23:59 problem is the
list is too long. I would like to have 2 dropdown fields HOURS & MINUTES
that join together when the form is submitted and enters the time into the
SQL db.

View Replies View Related

Doesnt Display Char Type Data Field Length 1

I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.

I'm running query:

"select * from table" and fetching all the records and displaying...

It display all the data except data from this field..Doesnt display anything..

I had put Response.write rs("fieldname")

What could be the problem?

View Replies View Related

Time/Date Field

I have a few date fields on my form. The backend is SQL and the fields are set to smalldatetime. Adding records into these fields is not a problem. This is my code:

if Request.form("ScheduledTrainingDates") = "" then
else
objRS("ScheduledTrainingDates")=Request.form("ScheduledTrainingDates")
end if

The problem is updating the records when I got to edit them. Let's say I have a value in for ScheduledTrainingDates textbox, and I want to clear the value and leave it blank and save it to the database. How do I do this?

View Replies View Related

Format Time Field

I have this field time field in my database which has records in the military format

example:

203454
83452
113434
211413

Can anyone tell me how to come up with a slick function to show results in the normal time format

View Replies View Related

Updating Time Field

I'm trying to update time field which MSACCESS using query

Sql2 = "Update tblExtraNetUsers SET Lo_date = " & Date()
& ",Lo_time =#" & FormatDateTime(Time(),4) &"# ,Lo_count
= " & rs("Lo_count") + 1 & " WHERE UserLogOn = 'david'"

But its always gives a error message . Operation must use an updateable query.

View Replies View Related

Getting Time From Datetime Field?

i have db in MS SQL Server 2000.

i have a field in a table as datetime.
but i want to display only time from that datetime field.

i tried using time(rs.fields("time_in"))
i get this error

Error Type:

Microsoft VBScript runtime (0x800A01C2)
Wrong number of arguments or invalid property assignment: 'time'

how can i achieve this??

View Replies View Related

Date/Time Database Field

I'm trying to post a value from a form field into a database field of type Date/Time formated to short date.

Even though the value from the form comes in short date style ie 19/06/2004 I'm getting a type mismatch error

View Replies View Related

Date Time Field In ASP/SQL Server

suggest the correct way to store the date & time in SQL Server? I want to store the date and time a record was created. What should the field type be in SQL Server? How can I insert the current date/time into the table using SQL? I used to have date/time field type in access and use the following code

currTime = Now()

SQL="Insert into <table> (id, recDate) Values (" & sId & ", #" & currTime &
"#)"

conn.execute(SQL)

what the field type I should be using in SQL Server to store this date and also what should I replace the line currTime=Now() to?

View Replies View Related

Returning Records Based On Time Field

How does one return records in a recordset based on a time/date field. If todays date is 8/25/04, how could i return all those records from 8/25/04. Mind you, i have long date format ex. "8/25/2004 4:46:45 pm"

I dont want to user a form for this i simply just want these time- sensative records to be returned in the recordset .

View Replies View Related

Viewing Asp

I havent got any hosting and I was wanting to test out my pages, I noticed you can set up microsoft personal server using microsoft front page on your pc but i havent managed to get it to work.

Im currently running a test page with the following code but it just doesnt want to work. Code:

View Replies View Related

Error Type:Microsoft VBScript Runtime (0x800A000D) Type Mismatch: 'UBound'

I got a problem while running an application. The code for this is as follows:

aList = Split(strMsg,";")
For nX = 0 to UBound(aList)
strarry=split(aList(nX),"_")
var_year=left(strarry(2),4)
var_month=mid(strarry(2),5,2)
var_day=mid(strarry(2),7,2)
var_date=var_day&"-"&var_month&"-"&var_year
var_time1=mid(strarry(2),9,2)
var_time2=mid(strarry(2),11,2)
var_time=var_time1&":"&var_time2
set rs1=conn.execute("insert into tbl_BackupfileInfo(Filename,Createddate,Createdtim e)values('" &aList(nX)&"','"&var_date&"','"&var_time&"')")
Next

while runnig this application some times it works fine .But some times it giving an error

Error Type:Microsoft VBScript runtime (0x800A000D) Type mismatch: 'UBound'.

View Replies View Related

Viewing ASP Guestbook

Right i am making an ASP guestbook. I have got the code and everything sorted for INSERTING into the database. But i dont no how to view the guestbook, in a guestbook kind of way I have searched everywhere, but theres no look.

View Replies View Related

Viewing A Database

On a shared hosting account, I've got access to an SQL 2000 database on a remote server.
Stats are data size: 12MB, Log Size: 25MB. I set it up five years ago, and, uh, forgot
how I set it up...

Anyway, I need to be able to view and browse the structure of my SQL 2000 database - and
it would be nice to do it with an interface like a Microsoft Access style GUI? I need to
be able to see what tables, columns, etc. my db contains.

Is there a web-based, or client-based, interface I can use that will allow me to view
and browse my SQL 2000 database? (Would it be easier if I had my web host provider
convert it to SQL 2005?)

View Replies View Related

Viewing The Threads

how can I view the threads posted before by me.

View Replies View Related

About Viewing Content..

I want my Default.asp page to view different content in a <TD> according the request.
I've been understand that the best method to do it is by using the method GET, Example:

..MyHost../default.asp?page=news

And I have no idea how to write the code:

View Replies View Related

Viewing Of PDF Files

I have placed PDF files in a protected folder.I have a secure ASP page that I want to open a PDF file How can I have the ASP page handle the login authentication to the protected folder.

View Replies View Related

Viewing IIS Sites

I have three PCs connected in a workgroup, all have Windows XP.On one PC, called MF1, I have IIS installed.In IIS I have a virtual directory called dbsite, pointing to a folder c:dbsite.In a web browser I can view the site via http://localhost/dbsite, or http://MF1/dbsite.

how would I allow the other two pcs on the network to access this site.

View Replies View Related

Viewing Firefox

i have work on this 4 days already but still cannot find a way to solve.is the way i code cannot be support by firefox?it work well in IE,but firefox cannot work.i have upload the file, can someone pls help me on that?

the asp.txt is my asp page, while the menubar.txt is the js file that i include in the asp page.it should work like ie.jpg but when i use firefox to browse,it show like firefox.jpg. is my code got problem?

View Replies View Related

Viewing File

I inherited a site - www.highparkclub.com/curling.asp . If you look at any of the schedules - and you don't have excel installed it gives you the option to view or save the file.

For Mac users - this causes even more problems, as the link does not work at all. Is there a simple way to correct this, or do I need to associate the file type with the link.

View Replies View Related

Viewing Variables

I have a variable that passes through, called teamid which is requested by a page that has values called album type. I want to know if I can hide a snipt of code, and once a value is pass through, hide the first page, then display results of the second on the same page.

View Replies View Related

Viewing In Firefox

i have work on this 4 days already but still cannot find a way to solve. is the way i code cannot be support by firefox??it work well in IE, but firefox cannot work. i have upload the file,. the asp.txt is my asp page, while the menubar.txt is the js file that i include in the asp page. it should work like ie.jpg but when i use firefox to browse, it show like firefox.jpg. is my code got problem?

View Replies View Related

Viewing Date Like(12-dec-09)

Im having a problem in viewing date, does ASP have a function to format a date like this one (ex.12-Dec-05) aside from VBgeneralDate, VBlongDate and VBshortDate. In MS Access its called (Medium Date) but when I use VBmediumDate there is no effect at all. btw im using MS Frontpage and MS Access as my database.

View Replies View Related

Viewing An .xls File

how can i open an xls ( excel ) file and print its contents formatted with asp? is this possible without any ActiveX or Dll's?

View Replies View Related

Viewing On Server

I have localhost on my pc and its working. I use it to test all my asp pages, before uploading to the server. I have a web connection with a dsn connection. When tested on my pc it works fine. but as soon as i upload it to the server, it looks as if it doesn't get the data from the access database. I created exactly the same dsn on the server as on my pc, so why is it not working?

dsn name: pscs-db.mdb

is there something wrong that i'm not seeing or is the problem more complicated.

View Replies View Related

Viewing RTF File

We have the following problem: There is a RTF file that must be viewed on browser and we
have been developed a solution in Java to do it.

but the Java's VM is so bigger for download. So, we need a way to view this file in client side without bigger downloads. Any help will be welcome, because we work more than a month in this problem.

View Replies View Related

Viewing Files In A Directory

is there an easy way of viewing the files in a directory without using "server.MapPath"!!!
i need to view Doc files in a folder and then open them in IExplorer to print the matter in them...

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved