I’m new to MSSQL and I’m having a problem with an ASP3 JS website that I’m upgrading from Access. I’m trying to format the date from mm/dd/yyyy as held in the db by GETDATE to display as dd/mm/yyyy on a web page. Previously with the Access db I used:
"SELECT format(addate, 'dd/mm/yyyy') as addate1 FROM...”
I'm trying to insert a date value into MSSQL, the type of the sql filed is: "smalldatetime" and i'm trying to insert a text Variable that looks like this: "19/02/2006".
.... SET update_date='" & Update_Date & "' ...
i get the message:
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value
my application i'm busy with allows the user to create forms/tasks then allows them to set it to recurr weekly and the date it must start... question how do i write the sql query to check if that date is today and to show the task every seven days? Code:
can anyone tell me the correct way to encapsulate Date so that it can be used in an SQL query. specifically todays date i only want to display records that have the date > today.
I have to put Date Range Query using start and end date form. I have tried but when i run the query puting start and end date value in form, no result shows the records and when i only put start or end value the result shows the records. Code:
The trick is to be able to show all of the stamps that WERE NOT accounted for between two dates.
I am thinking I need to start with a page that has two text boxes on it, one for start date and one for end date, and then pass those values to a second page that will list each stamp NOT accounted for between those two dates. Any ideas?
"Select * from table1 where dDate = #" & CStr(Date()) & "#"
this query executes well on one computer where the date format is - "MM/DD/YYYY" but fails on the other computer - which has a date format of "MM.DD.YYYY".
if i write the query like this on my second computer -
"Select * from table1 where dDate = #" & Replace(CStr(Date()),".","/") & "#"
I've never worked with ASP, and was thrown into this major problem... I'm trying to perform an INSERT query into an SQL Server database. The query returns an error dealing with the date. The query is being inserted as: Code:
I've got an access database with a field containing dates (each saturday of the year), set up as a date field. In my code i need to write the SQL to select all records that have a date after todays date.
I've got the rest of the code but it's the where clause i'm stuck on. Something like, WHERE mydatefield is after (could i use >?) currentdate. Not really sure how ot go about doing this... I'm using ASP, is there a way the SQL can get the current date, or would i need to generate it and store as a variable first? Also, don't know what type of quotes i would need to use " or ' or + etc.
I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one. I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it. I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page). The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.
If I creat a ASP page, what do I need or how do I connect to a MSSQL database? Is it possible to connect to MySQL with an ASP page, or is it better to stick with MSSQL when creating an ASP page?
Looking for suggestions on any stable asp/MS SQL server content management systems in the market place. Any suggestions, or even places where I can look? I have quickly seen Rainbow and would like any comments from users of this CMS.
I am currently learning ASP but have a small PHP background, With PHP I used PHPMYADMIN to work with MYSQL Is there a web based Alternative for ASP and MSSQL that provides similair functionality?
I have a query to one table but one of the values in the table is referencing a record from another table... here is the sql Code:
strSql = "SELECT streetdate, barcode, itemname, descrip, vendor, sku, catlog, config, retail_cost, cost FROM blah WHERE (STREETDATE >='"& GSTARTDATE &"') AND (STREETDATE <='"& GENDDATE &"') ORDER BY STREETDATE, CATLOG DESC"
now I have 2 things going on here... 1. vendor is just a number... there is a tblvendor that matches the number with a name (that i need.. i coudl nest another db query but figured that would be more resource intensive as this returns 1000s of records) 2. itemname is also a number that references another tblItem the sam way, I woul dlike to sort alphabetical off this somehow (is it even possable)
Can't seem to find anything relating so forgive me if i've missed it. I'm after a way to open either a csv or xml file, then cycle through each line to see if it's in mssql, if it is update it... otherwise add it and then if it's in mssql and not the csv, remove it.Is it possable? Still learning and haven't dug into opening files, let alone this so any help would be grateful... oh and the fields are exactly the same in both
In our office we use RMS (Residential Management System) and they use an MSSQL database to store all the data. we can access this database using access and have made several...several queries to pull out info, save it to another access database, then upload it to the web and pull data from it.
the server that houses the MSSQL database is online and i was wondering if it is possible to connect to it and pull out information. we wouldnt want to change anything, just view.
I'm just deciding whether to use Access or MS-SQL for a web-application
I'm predicting that my application will grow large enough to warrant use of MS-SQL, but I'm wondering how extensive the changes to my code that would make
...Specificially in ASP.Net, if I use ADO.Net, would I just need to modify my connection string or would it involve more extensive modifications?
I am new to programming and I managed to store images in MSSQL. The problem I have is that when I retrieve the image from the database and display it in my browser it opens a new window. I would like to use the image control, but it requires a url. Is there anyway of viewing that image in the image control or keeping it in the same page where my information is but displaying it where and when I want it
I want an answer by tomorrow with examples and reference URLS if we can do this.There is a program written in ASP and the databse is MSSQL (Microsoft) hosted in Windows platform. But they want this databse and ASP Program host on a UNLIX/LINUX server and use the same ASP program. Can thy do it/ and how?
I am using a Windows 2000 Server and when i tried creating a simple asp application this error always appear everytime I access the database. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'MYSERVERIUSR_MYSERVER'. /o/faculty_evaluation/add_dean_db.asp, line 22
what kind of error is this?
is there something wrong with my connection string -> conn.Open "Provider=sqloledb;Data Source=MYSERVER;Initial Catalog=dog_evaluation;Integrated Security=SSPI;"
If I create an ASP page, what do I need or how do I connect to a MSSQL database. And, is it possible to connect to a MySQL with ASP, or is it better to use MSSQL when developing a ASP page?
I am planning to convert an ASP/MS SQL based site into ASP/MySQL to save on monthly recurring fees. MSSQL costs additional $40 a month while MySQL is free. Are there any major technical issues?
If you have a large traffic site, say over 30 current users accessing the database at once, can Access handle this. I know MSSQL can. Is there any other databases that can be used with asp other than Access and MSSQL and what would there benifits be?
I'm writing a script to show a bithday list. I select the data from a MSSQL db. I want to only show the next seven days's birthdays in the result. Something's wrong with my script below and would appreciate it if somebody could just have a quick look and let me know. Everything works well, but at the end of the month the order by doesn't work 100%
Below is the code:
<% Function formStr(s) if not isNull(s) then formStr = UCase(Left(s,1)) & lCase(right(s, len(s)-1)) else formStr = "" end if End Function