Storing Dates As Int But Selecting Them As Date

while I store the dates as is in db, I can use a select statement like this:

mySQL="SELECT SUM(total) AS totalSum, month(orderdate) AS monthsql FROM orderDetails GROUP BY MONTH(orderdate)"

but when I use dates as integer, it simply gives me error. Are there any way of getting over that problem?

View Replies


ADVERTISEMENT

Selecting Records Where Date Between Two Dates

I'm trying to display all the jobs that occur during a selected month/s. Here is the code I use: Code:

View Replies View Related

Selecting Data For Latest 5 Dates

I am trying to come up with a select statement which would select info from the latest 5 dates. I know how to do the latest date using
SELECT * from table1 WHERE PDate = (Select Max(PDate)

Is there an easy way to write a select statement to give the latest 5 dates? My data is in a SQL Server database.

View Replies View Related

Selecting * After Date()

I have a database with date of gigs in it and am trying to select * from the database the next gig basically, and am compariung against todays date and saying select * more than todays date. Is this right, cause it's not doing it? Code:

dateN = Date()
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "************"
set recsetS= server.createobject("ADODB.Recordset")
sql = "select * from admin where dated > "& dateN &" order by relevance DESC "
recsetS.open sql,conn,3,3

View Replies View Related

Selecting The Next Five Upcoming Birthdays From The Current Date

I want to do is select the next five upcoming birthdays from the current date, using ASP + Access. The name of table is "juventude" and the birtday field is "db_dtnasc" ....

View Replies View Related

Storing Correct Date Format In Database

I am using the code below to add a date input into an access database.

Quote: rs.Addnew
rs("Date")= Request.Form("Date")

Instead of inserting a date with the format dd/mm/yy, a date format of yy/mm/dd will be inserted into the database.

I entered the following code before the insertion Quote: response.write request.form("Date") and it displayed the correct date format as dd/mm/yy.

Pls how do I insert the date into the database for it to store the date as dd/mm/yy instead of as yy/mm/dd. The date format in the date field of the database is dd/mm/yy.

View Replies View Related

Dates (julien Date)

i need to get a julien format of todays date. 0AAJJJ

0AAJJJ = 006087 = 2006 march 27

0AA = 006 = 2006

JJJ = 087 = 87days since jan1

anybody understand? the bank requires all date formats this way.

View Replies View Related

Storing RSS/XML

I am using a customized version of the XML RSS Content Feed VBScript Class (available at:
XML RSS Content Feed VBScript Class to show an XML-feed on my web site. Since the web site are based on a CMS that uses an MS SQL - database, I will try to store the XML-feed in the database instead of just displaying it using a XML/RSS-parser.

I know Microsoft have several tools for this, but they seems to sofisticated and complicated for my use. I just wants an simple ASP-script that reads thought the XML-feed, and store the differnt news-items straight into my MS-SQL DB.

View Replies View Related

How To Check The Date Difference Between The Current Date And The Booking Date?

I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.

I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:

View Replies View Related

Selecting Info

I've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing.
How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work.
For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:

<%
If request.form "template" = "template1" then
strTemplate = "template1.htm"
Else
strTemplate = "template.htm"

If request.form "template" = "template2" then
strTemplate = "template2.htm"
Else
strTemplate = "template.htm"

End If
End If
%>

View Replies View Related

Selecting A Value From The List Box

I have a list box which has the following values:

Car
bike and Boat

If I select "car" it is fine but when I select "bike and boat" it just takes bike
as the selection. It is taking the space as the end of the string. Is there a way I can
rectify this?

View Replies View Related

Selecting Dropdown In ASP

My boss wanted me to add a dropdown to this form. I was able to add in the dropdown and it inserts into my database (Access) just fine. However, I have an edit page also and this is where my trouble comes in.

On the edit page, the dropdown does not "know" which specific option was selected. I tried to write an If statement but I think there is something wrong in my syntax. Code:

View Replies View Related

Selecting Software

I have undertaken a website revision project after not programming for about 6 years. I am beginning to set up a work environment on my pc, and have questions about the software being used verses what could be the ideal software.

I am familiar with classic asp pages, not asp.net. I am also familiar MS Interdev (but am unable to locate my copy and cannot find a torrent file - is this an archaic program now?). The last thing that I'll mentioned is that I prefer to have a debugging capabilities.So the current website uses Dreamweaver 8.0, IIS 6.0, and MSSQL 2000. Question.Given my background, what software would you use to set up a work station?

View Replies View Related

Selecting Values

i need to display results that do not match those in the database.I have an excel file and i upload it,inserting the records in a temp table. han i compare the values in the original table and the temp table.All i want is the values that do not match

sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)

i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.

View Replies View Related

Selecting Last Record

i need to extract some data from a table called accountantsBids. I want to select the last entry for every accountant based on the date descending.

Table:
entryid = Autonumber
Accountantid = FK
DatePosted

I've tried TOP 1 but that doesn't do it - it only gives one recordset. What would be the best way to get this working.

View Replies View Related

Selecting All Checkboxes Using ASP

I created a form for Deleting multiple records (from Access db )using checkboxes. However, I would like to add a link or button that would check mark all the checkboxes since I could have hundreds of records.

What is the best way to go about it. Does anyone knows of any samples other than Javascript.

View Replies View Related

ASP & XML - Selecting Last Node??

I was wondering if anyone has a moment to look over some code I've written?

I'm involved in the maintenance of an old CMS system I wrote a number of years ago, when I was regularly coding in ASP. These days it takes a while to mobilise the grey matter when it comes to ASP.

Anyhow, basically I am trying to select a specific node and determine the id of the last child of the parent node.

At the moment, I am only returning the first childs id, despite my best efforts. Code:

View Replies View Related

Selecting Ranges

On the online crm system i've built (using ASP) our customers can create a list of contacts and download/delete/add to this list when they want to and then go and view the list. It will display 20 on a page with forward/back buttons etc.

I have written a routine which queries the MS SQL 2000 database and retrieves all the IDs of the contacts. It will then work out the page it is on and display the appropriate records by reading through the 20 IDs for that page and query the data from each ID it needs to display on the screen.

This works fine for lists of up to 1000-2000 but when it gets to 5000, 10000 records it becomes an issue of performance as it will hold in a variable all of those 5000 or 10000 IDs. There has to be another way of doing this.

View Replies View Related

Storing Cookies

Anyone know of any special issues with storing cookies with ASP? I'm
trying this with two browsers: One is IE 6.0 with cookies set to
'prompt'. This has been working properly as any new site I goto seems
to prompt me to store their cookie. The other is Pocket IE on Pocket
PC 2002, with the cookies set to 'enabled'.

My problem is that the cookies dont seem to be being written with my
ASP. I dont get the prompt to store the cookie when I should. My
storage code looks like this:

Response.Cookies("AcctNbr")= nAcctNbr
Response.Cookies("MsgStart")= nMsgStart
Response.Cookies("MsgEnd")= nMsgEnd
Response.Cookies("AcctNbr").Expires= DateAdd("h", 15, Now)
Response.Cookies("MsgStart").Expires= DateAdd("h", 15, Now)
Response.Cookies("MsgEnd").Expires= DateAdd("h", 15, Now)

And the read code looks like this:

View Replies View Related

Storing Arrays

I have run into a unique issue, what I want to be able to do is store a collection or array into a database or xml file. The main reason for doing this, is I don't want to use Sessions as they are volatile to server hiccups or resets. I don't want to use cookies as they are insecure, but I will use one cookie to store a UniqueID to relate to the data in the database or XML file.Can anyone think of a way to store an array in Access, MySQL, or XML file?

View Replies View Related

Storing And Retrieving UTF-8

I'm writing a vbscript application that reads UTF-8 XML containing Chinese
characters and stores the data in MySql 4.0.x.
Does anybody have any experience in this area with regarding codepage and
character sets? Ideally I want the scripts to be able to handle Standard
European characters and Chinese characters as well.
Are there any special considerations for using MySql/ODBC and ADO to get and
put the data.

View Replies View Related

Storing Objects

I've read that you shouldn't store objects in Session variables.
I've read these reasons:
- The object takes up memory that may not be freed until the session times
out. Better to create the object only when you actually use it.
- Causes poor performance because the thread that created the object has to
service all requests for it.
Assuming I can live with the memory and performance implications (a big if,
but let's assume it for a minute), what other reasons are there?

View Replies View Related

Storing A Choice To Use

I have a page which reads the contents from a certain table. The displayed text is followed by a link which is also stored in that table. They can just click the link belonging to a certain newsitem and the page with that news will display. But, for every new item I make a new page. What I want is that the link every time opens the same newspage but with only the selected newsitem. Something like "SELECT description FROM tblNews Where ID= [the ID belonging to the link I pressed on the previous page]"

View Replies View Related

Storing .doc And .pdf In Database

Is anyone know how I can store Word Docs and PDF's in database, and how I can make link for visitor to download these files.

View Replies View Related

Password Storing

When I'm creating database driven asp applications, I store my constants,including my connection string to the database within an asp file calledconstants.asp. All constants are stored inside asp coding <% ... %> so people can't save the data through the web.

I've been told this is an insecure way of storing the connect string becuase my connect string would also store the username and password to connect to the db.what is the current standard for storing an connect string to a database for asp applications?

View Replies View Related

Storing Time In

developing a small application, user logs into a page, as soon as user logs into the page, the time(incl seconds) of the page opens has to store in database(time-in), and also the page closing time has to store in db (time-out).

once the time-in and time-out time is stored and it has to calculate the how much time user spend and the total time has to store in db?. i am using sql.

View Replies View Related

Storing Variables

I'm trying to store a filename to in a variable from aspfreeupload file. Once the file is uploaded I can't seem to fine the variable it's stored in so that I can store it in the database without typing the filename in manually.

View Replies View Related

Storing Information From URL

how to store information after the ? in the url in form fields. i.e. http://url/test.asp?User=Rob in Form Field UserName .

View Replies View Related

Storing Data

Code:
<%
Dim rsDB
Dim strSQL
Dim name
Dim price
Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )
rsDB.Open strSQL, Application("strConn" )

' put fields into variables
name=rsDB("ProductName" )
price=rsDB("ProductPrice" )
%>
I am trying to store some data from my database (access) into some variables so that I don't have to keep on opening up the database everytime I want to display the data. Dont know what I am doing wrong but i keep getting an internal server error 500.

View Replies View Related

Storing Recordset

I am not too familiar with arrays or recordsets, but I am trying to store ids from database records into an array in an ASP file.

I opened the recordset object in the ASP file, and the stored procedure in the SQL Server pulls back ids from multiple records. I want to store these ids in an array. But I am not sure how to do it. The recordset now seems to be only giving me one id (the id of the last record only) when the stored procedure is made to give ids from multiple records.

View Replies View Related

Selecting Count(distinct Value)

I want to select just one field to display using sql and I want to have another variable that counts how many fields of the same value there are. My code looks something like this but i'm getting an error...

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal. Code:

View Replies View Related

Selecting Random Images

Is it possible to select random images from a directory without creating a "library"

As in I want to have a directory with 25 or so images and want to randomly select an image without having to change the txt document when I add new images.

View Replies View Related

Selecting Which Page To View .ASP.

This is my page that displays a certain players games played below. It sorts by games played and excludes all records that = 0. Now with 9 different grades to show i did not want 9 different pages, so i added in 'strSortGames' so that they can select which grade to view and only one page is needed.

I used a menu (list field) on a previous page to do this, do you no a better way to do this? e.g Text links or some other way? or is a list field a fairly good way? Code:

View Replies View Related







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