Standard Way To Store The Dates
when some data is being into my database, most of the data is recieved from a form.
2 of the fields are dates, but looking at the db (access) the dates are stored in the '38307' format. - is this the standard way access stores dates?
Now, how do I get it to enter /todays/ date into a column? I thought it would be something like
RecordSet.Fields("LogDate") = today()
but this is wrong, right?
The other date, is to be entered by the user in the form. Now, what is the best way of going about this? It will be in a different column, but in the same format. My default, it would be 'todays' date, but needs the option of being changed. Any ideas? Code:
View Replies
ADVERTISEMENT
Is there a third-party product or something that will allow me to call a
standard DLL (not a COM DLL) from ASP code?
View Replies
View Related
I'd like to display sections of my site using non standard fonts. What i'd like to know is if there is any way of me being able to force a font to install that is stored on my web server, or can i make the client browser look at my font file before the page is displayed?
View Replies
View Related
A friend has told me that links that worked fine in IE 6 on a PC are now not
working in IE 7. The only thing they can see is that these links have the
following common traits:
a) long file names, ie about 30 plus chars
b) underscores in the filenames.
c) They are derived from the old asp routine to force a pdf download rather
than open them up in the browser window.
I'm desperately trying to borrow a PC to install IE 7 (I don't want to
affect my own PC in anyway at the moment) to test this
View Replies
View Related
i have to write same sql statement twice.. is there anyway i can write statement once and call all the values in second combo box ? Code:
View Replies
View Related
Does anybody know where I can get some standard lists like
- a list of all countries in the world (with abbreviation, international prefix...
- a list of common christian names (aaron, abbey, adeline...
- a list of all currencie
- a list of all language
in txt/xls/mdb or whatever format
View Replies
View Related
Can someone please tell me what the 5 standard protocols of ASP are?
View Replies
View Related
coding standard in c# what is the best way of coding i mean some developers develop applications through direct query's INSERT,UPDATE,SELECT,DELETE or some developer develop applications through using classes create classes and call INSERT,UPDATE,SELECT,DELETE querys some developer develop application's through stored procedure create classes and call stored procedures i mean i am little confused what is the best way to written code .
View Replies
View Related
I've tried several users code, and everytime i try to do the redirect part it fails, this webpage at least gave me a confirm that it is the redirect part failing.
View Replies
View Related
anyone have experience customizing iCode's Everest Standard webstore pages?
View Replies
View Related
Is there an easy way to automatically detect and encode a URL within a string? How can I automatically make it so that the link is clickable?
View Replies
View Related
I am performing a post from one classic ASP page to another in order to get the value of a string passed between the two pages. I have a client script variable declared to take the value of the value being received in the page i.e. var x = '<%=varName%>'. Unfortunately, ASP seems to be adding a carriage return to the value of varName when it
is passed in i.e. it expands the stated line to var x = 'FieldContents';. I.e. somewhere a carriage return has been added. The string gets passed in OK if I use the Get mechanism. Don't know why this carriage return is being added when using Post mechanism. Anybody seen this before? Is it a bug in ASP ?
View Replies
View Related
how to write store procedure in asp?
View Replies
View Related
where I can find an asp script(free) to do a store locator.
I've only been able to find 2 on the web, and they are both at a cost.
View Replies
View Related
I am looking for some ASP - SQL server 2000 online store application that i can buy for my company. This store is completely internal for the company and will be on our intranet server and will be utilized by the company employees to buy company merchantdize.
Also at this time there will be no credit card processing as the amount of purchase will be deducted from the payrol. I will be needing the shopping cart and product view. Later if we provide the credit card processing, we have already installed PayFlowPro from verisign and do creadit card procesing on our main site.
Does any one know such application that i can integrate with our style sheets and general layout?
View Replies
View Related
I am using ASP and VBScript to access an Oracle database and display query results to my users.
However, my query is huge! and I want to keep the query separate from my ASP/VBScript code.
How do I store the query on one page and then call it from another page?
View Replies
View Related
I have this problems regarding "storing New values into session".
Take the "online movie tix booking" as an exmaple. When i click on one seat, beside storing the seatNo into a session, i also want to store the number of seats he has clicked throughout. How can store the incremental of seats clicked into a session by overriding new Values
View Replies
View Related
i am stuck with the following error message
"Application uses a value of the wrong type for the current operation."
did anyone know the reson this occur?
just because of my store procedure....
View Replies
View Related
I have an ASP page and a Store Procedure but I keep getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sp_searchresultsZIP' expects parameter '@xDateTo', which was not supplied. Code:
View Replies
View Related
what is the diference between these two cache control header.no-cache and no-store.I have read the w3.org explanation.So lets say I am using only no-cache ....my understanding is thatnothing is cached and nothing is writen to disk.but what happens when we use no-store....i think..nothing is written to disk but it could be cached.
Now my question where is this cache located...is it only in memory ?....if it is written to disk how log is it there and when does it gets cleaned.Is no-cache more secure than no-store ..why?
View Replies
View Related
i found that OLE won't work. any alternative?
View Replies
View Related
I'm having need of storing a recordset in a collection tempararily. Can I hold a record set in a Collection object ? Any other way of holding a record set is also works, except arrays.
View Replies
View Related
I've been trying to come up with a method to store the values of a forms variables into a basic text document, say a notepad txt file. Its a windows server that im experimenting with and I'm not experienced with PHP, so im trying to find a easy way via either javascript/html or asp.
View Replies
View Related
when i perform this:
Session(username) = Request.Form("username")
and print it out:
<%= Session("username")%>
it doesn't output anything.
View Replies
View Related
how do i store a value from a XML into a ASP variable
I need to store "maxpage" into a variable call "totalpages" in my asp file...how do i do it?
View Replies
View Related
Does anyone know where I can find on the internet a good web site that can explain to me how a Store Locator script works using ASP and a SQL database?
View Replies
View Related
I created a table with varchar field where i want to store
the path of an image.
I will then use this file to retrieve this image on my
browser. Everything goes fine when i use a simple html
command as :
<img src="C:InetpubwwwrootMyWebimagesone.jpg"
height="200" width="200">
this is a hard-coded path. Hence no problem.
But when I store in the database path value: Code:
View Replies
View Related
i m creating a site using asp in which i will collect user details, means their names, address, other information along with their pictures, so please can any one help me by telling how can i strore pictures in sql sever using asp. in very long detail. and how can i retrieve snaps from data base to display on the pages.
View Replies
View Related
I have made a registration form for adding my friends information in a
database. The problem is that I want to connect the persons with companies
in the same database. I wonder how i could connect a person to several other
id's in a table.
I wonder if I can make a string in the database that holds all the id's
separated with , for example....?
the string would then look like this:
1,4,6,22,56
for example...
But how can I then open this string and separate the numbers from the , ???
View Replies
View Related
I usually create a db.asp file, and include it on each page i need the db connection, but where do you think is the best place to store the db connection? anything a bit more secure?
View Replies
View Related
I would like to ask izzit correct that assign a variable in asp and store the value select from XSL list at below: (in my asp page) Code:
View Replies
View Related
I want to maintain the user's session variable while moving from HTTP to HTTPS. I learned that you can store the sesison in a database, but I am not sure about the logic behind this method.Can someone explain how this works?
View Replies
View Related
i'm looking for a script that would help me establish "find the nearst store to you, enter your zip code here" i have the DB with the stores and i want some help with this?
View Replies
View Related
