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


ADVERTISEMENT

ASP Script Inserting To SQL Table With Image Column Type

Would someone be able to explain the sql image field to me. I was reading about it a little but dont really understand.

I would like to have word documents that can be indexed and searched and i heard the image field with an accompanying char field with the file extension would be the trick. how would i actually get binary files into the image field?

I wanted to write an asp script so users could enter .doc that they could query. I understand basic asp sql inserts.

View Replies View Related

Syntax Error Converting The Varchar Value To A Column Of Data Type Int

I have a 3 page set that searches a database for users, displays the user information in a form and updates the data in the database. The first 2 pages work fine, the third page doesn't. What is annoying is that these pages are a copy of another set of pages that edit news articles (basically the same thing) and they work perfectly.

This is ASP with SQL and VB Script.

Quote: Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '6, 6' to a column of data type int.
/d1intranet/useredited.asp, line 72

So this message is saying that it is unable to UPDATE the field 'UserName' (which has data type INT) with the variable in the SQL code which is default as VARCHAR. Here is line 72: Code:

View Replies View Related

Displaying A Database One Column At A Time

I know how to write a script that will show all the tables fieldnames and then all the tables fields, but how can I do it so that it shows the database table one column at a time? for instance:

fieldname 1
<br>
1st fieldvalue for this column
2nd fieldvalue for this column
3rd fieldvalue for this column
<P>
fieldname 2
1st fieldvalue for this column
2nd fieldvalue for this column
3rd fieldvalue for this column
etc..

View Replies View Related

First Time Using ASP + MySQL

Now, since this is the first time I will be using ASP and MySQL can anyone help me and show me a SIMPLE example of displaying a row in the SQL db?

View Replies View Related

Sending Mail On Win2k3 Box

Shouldn't this code do it on a Win2k3 box.

Set oMsg = Server.CreateObject("CDO.Message")
oMsg.From = "address@domain.com"
oMsg.To = "address@domain.com"
oMsg.Subject = "Subject"
oMsg.Body = "Body"

oMsg.BodyFormat = 1 '1=Text, 0=HTML
oMsg.MailFormat = 1 '1=Text, 0=MIME

oMsg.Send

View Replies View Related

Warning BC40056: Namespace Or Type Specified In The Imports 'MySql.Data.MySqlClient'

Currently i working on a project using ASP.net and mysql. these are the classes i imported:

<%import Namespace="System.Data" %>
<%import Namespace="MySql.Data.MySqlClient"%>
Sub Page_Load(sender As Object, e As EventArgs)

Dim myConnection As MySqlConnection
Dim myDataAdapter As MySqlDataAdapter
Dim myDataSet As DataSet

Dim strSQL As String
Dim iRecordCount As Integer

myConnection = New MySqlConnection("server=myserver; user id=XXX; password=XXXX; database=XXXX; pooling=false;")

when i try to test it out on my localhost, i got this error compiler page:

(warning BC40056: Namespace or type specified in the Imports 'MySql.Data.MySqlClient' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.

or

Dim myConnection is not defined. ....

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

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 View Related

MySQL "TIME"

I have a field of datatype "time", named "time", in a MySQL database. Using ASP, I set RS("time") = time.

When I retrieve the time, Response.Write RS("time"), a date/time value is displayed using the current date, and the stored time: "6/25/2003 8:24:55 AM", instead of just "8:24:55 AM".

The time values seem to be correct and show no date in the MySQL database, which I administer using PHPMyAdmin. Does anyone know what I can do to fix this?

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

How To Make Column Of Table 1 = To Column Of Table 2?

I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:

View Replies View Related

Time Calculation :: Difference Between Login And Current Time

I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.

View Replies View Related

ASP To Re-load Page From Time To Time To Reset Varaibles

I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.

I need to need to reload that sign in url every few hours Code:

View Replies View Related

Comapring Database Time And Computer Date/time

there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something

View Replies View Related

Time/Date Format And Changing Time To GMT

Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:

"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"

Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:

View Replies View Related

Time Convert String To OdbcType.Time

I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.

View Replies View Related

Local Machine Time To Eastern Time

How will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?

View Replies View Related

Time Function Returns Wrong Time

When the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.

I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?

View Replies View Related

How To Get Asp Execution Time And Database Connection Time ?

Any some tools or sample codes drop down asp script execute time and
database connection time ?

View Replies View Related

Server Time Local Time Convert

I'm trying to do a very simple code that converts the server time into a time zone of your choice.

<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>

but obvisouly i'm having trouble with the time zone convert.

View Replies View Related

Add A Column

I have a csv file that I'd like to be able to add a column to. Specifically, I want to take the first 6 chars of the filename and add it to each row as a new column. e.g.

Code:


whatever.csv 'before
1,2,3,4

whatever.csv 'after
1,2,3,4,whatev

View Replies View Related

Compare The NOW Time With A Deadline Time

I am trying to compare the NOW time with a "deadline" time. Please help. Just not sure why this is not working. I need to be able to say IF IT'S BEFORE 9:30 TODAY, IT'S OKAY TO ADD SOMETHING. IF IT'S AFTER 9:30 TODAY, YOU MUST ADD IT TOMORROW.

CODE:

nowtime=now()
deadlinetime=formatdatetime(now(),2) + " 8:30:00 AM"
response.write "NOW: " & nowtime & "<BR>"
response.write "Deadline: " & deadlinetime & "<BR>"
if nowtime<deadlinetime then response.write "can send out today" end if
if nowtime>deadlinetime then response.write "must send out tomorrow" end
if

RESULTS:
NOW: 1/18/2007 8:51:43 AM
Deadline: 1/18/2007 8:30:00 AM
can send out today

As you can see, NOW is GREATER THAN Deadline, so it should must send out tomorrow.

View Replies View Related

Time Calculation :: Between Two Dates And Time

i want to calculate the total time between to dates and time.

Example: Total time elapsed from date 1 time 1 to date 2 time 2.

27/09/2004 11:00 - 28/09/2004 10:30

The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.

View Replies View Related

Get Column Name And Value Of Specific Row

Ok let me explain what I am trying to do as easily as I can. I have a table in my access database that I am connecting to. I select a specific id number using my SQL statement. Now what I am trying to do is scroll through that records row and get the column name of that column along with the value of that cell. I hope that isn't to confusing. Now I'm not sure whether this would be done using ASP or done in my SQL statement. Code:

View Replies View Related

Column Descriptions

How do you get the description of fields in an Access database? I really need this and can't find it anywhere....
It would also help if someone showed me how to get the datatype and other info (like if it's a Yes/no or True/False field).
What is the resource/doc for this so I know where to look before asking from now on?

View Replies View Related

How Do I Call The Last ID In A Column

Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question..

On the last line here i'm trying to some how get it to call the last ID entry...

ImageID = Request("ID")
If (Len(ImageID) = 0) then ImageID = "1"
If Not IsNumeric(ImageID) Then ImageID = "1"
If ImageID = "0" then ImageID = "1"
If ImageID>3 then ImageID = max(Len(ImageID))

This is basically for some max min links for a online comic here's what it links to

<a href="default.asp?id=<%=ImageID-1%>">< Backwards</a> -
<a href="default.asp?id=<%=ImageID+1%>">Forward ></a> -

Code:

View Replies View Related

Column Sorting

Can someone please explain to me why the hyperlinked column headings will sort in Firefox and IE 7 but not in IE6. Code:

View Replies View Related

Changing Column

I need to set up an HTML table or the like, with 4 columns.
Each column needs to have a header with a FRIDAY (dd/mm/yy) date.
i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb
etc.
So, I need column 1 to be headed 16th Feb, col 2 to show 23rd Feb etc.
As this week passes, the dates need to move up 1 week, so that next
week, col 1 will display 23rd Feb and so on.
These headers need to change according to the date.
Please can you advise how I best achieve this ?

View Replies View Related

Freeze Column

we have a requirement to freeze the column and row column heading... so that when the user scrolls to the right the first two columns ( I refer them as "row headings") will stay and the remaining columns scroll left and when the user scrolls to the bottom the first row stays ("column headings")and the remaining rows will scroll up.. This can be easily accomplished in EXCEL by freezing the itersecting cell... How can the same be accomplished using HTML tables /ASP code.... Is there any Active X control available that can be used to accomplish the same?Our technical env is ASP and Oracle DB

View Replies View Related

Splitting 1 Column Into 2

Pretty basic but I cannot figure it out.

Column:
FULLNAME (lname, fname)

Needs to be

FNAME
LNAME

Should split at the comman.I already have all the columns created; just
need to SQL command to make it happen.

View Replies View Related

Invalid Column Name

I am trying to access a table in a SQL server using ADO in ASP. It works fine in the rest of the site. Here is the code:

View Replies View Related

ORDER BY A Column?

If I have several fields:
a | b | c | d | e

and the original SQL = SQL & " ORDER BY a ASC ".

I want to place links to b, c, d, e to make the table of results to show by ascending order of b (or , c, d, e).

do I need to place an "if/ end if" in the sql or do I put some statement in the paging?

example
a (ORDER BY a ASC)| b | c | d | e
1 | 3 | z
2 | 2 | y
3 | 1 | x
4 | 5 | w
5 | 4 | v

to

a | b (ORDER BY b ASC)| c | d | e
3 | 1 | x
2 | 2 | y
1 | 3 | z
5 | 4 | v
4 | 5 | w

View Replies View Related







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