johnnyboy7
Last Activity: Mar 8 '11, 08:52 PM
Joined: Mar 17 '07
Location:
-
I'm sorry I never came back and thanked you all for your help. I did get that site working, but soon handed it off to someone else...Last edited by Niheel; Mar 8 '11, 08:18 PM. Reason: Please post your question in another thread, this is an old thread that you're resurrecting. -
problem...
I got it pretty much working how I want it to, except for one thing. I had some entries in the database (which is my calendar's database). I put in an entry for 2/20, 2/21, 2/22, 2/23, 2/25, 2/26, and 2/29. The code (below) has successfully pulled the first six entries out of the database. However, when I put in an entry for 2/24 (which I had skipped earlier) it did not act as I thought it should. I figured the last entry,...Leave a comment:
-
You'll all be proud of me (I hope). I got something working out. check it out here. I know there is some stuff I should probably move or delete but I'll do that later: http://www.shiversfrozencustard.com/testing2.asp
so here's my code:
...Code:<% Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={SQL Server};Server=*****;Database=*****;Uid=*****;Pwd=*****;"Leave a comment:
-
I made some headway!
here's my code now, notice what I have done with the "response.write " stuff and my selection (SELECT).
...Code:<% Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={SQL Server};Server=************;Database=************;Uid=************;Pwd=************;" SQL = "SELECT event_title, event_date, event_descLeave a comment:
-
Ok, obviously I am doing something wrong...
oh ya, and it has been a while hasn't it...
here's the script
...Code:Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={SQL Server};Server=************;Database=************;Uid=************;Pwd=************;" SQL = "SELECT event_title FROM events WHERE category_id = '4'" SQLLeave a comment:
-
If anyone is still out there and sees this thread, I need some more help.
I can't figure out how to change the script so I can display items from the database that match the current date as well as the next 5 or six days.
Can anyone tell me how to do this. My code is still the same as the last one posted here, above this post.
Thanks in advance.Leave a comment:
-
Thankyou all very much! It finally works... at least right now. I'll watch it to make sure that it works tomorrow and the next day etc. This is so great.
And the password thing... I totally forgot...just started copying my code and didn't even think about it. Thanks for tellin me and changing it.
Thanks again! :) :) :)Leave a comment:
-
OK, I found another article I think on this site about using dates and that person told the other guy to use the actual date of that day (or a date he wanted) and plug that into the WHERE to see if it even worked that way. I did this and it worked:
So I know that I am on the right...Code:SQL = "SELECT event_title FROM events WHERE category_id = '4'" SQL = SQL & " AND event_date = '3/26/2007'"
Leave a comment:
-
here's the code
...Code:Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={SQL Server};Server=p3swhsql-v03.shr.phx3.secureserver.net;Database=DB_1003645;Uid=***;Pwd=***;" SQL = "SELECT event_title FROM events WHERE category_id = '4'" SQL = SQL & " AND event_date = " & date() Dim objRec Set objRec = Server.CreateObject("ADODB.Recordset")Leave a comment:
-
YAY something worked!
Ok, after studying a couple of other ASP pages that accessed data from a SQL database as well as reading this sites forums on default datasets or something like that, I edited my code to the below:
...Code:Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={SQL Server};Server=p3swhsql-v03.shr.phx3.secureserver.net;Database=DB_1003645;Uid=****;Pwd=****;"Leave a comment:
-
sorry, i changed back to this:
Code:Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={SQL Server};Server=p3swhsql-v03.shr.phx3.secureserver.net;Database=DB_1003645;Uid=****l;Pwd=****;" SQL = "SELECT event_title FROM events" Dim objRec Set objRec = conn.Execute(SQL) Response.Write objRec
and then I get...Leave a comment:
-
Thanks for helping out.
except now i get this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'SELECT'.
/testing.asp, line 11
on this code
...Code:Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={SQL Server};Server=p3swhsql-v03.shr.phx3.secureserver.net;Database=DB_1003645;Uid=****;Pwd=****;"Leave a comment:
-
OK, fixed a problem....had my password in these things ' ' ......
but now i get this message in the browser:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/testing.asp, line 10
here's my code again:
...Code:<% Set conn = Server.CreateObject("ADODB.Connection")Leave a comment:
-
ASP and SQL help - I don't know what I'm doing
I don't know a lot about ASP and I know even less about SQL. I have been trying to search the web for information to be able to get done what I need. I've tried piecing things together from many different sites, adding my own info in where needed, but it just isn't working.
What I want to do is, using an existing database setup for a calendar application, pull information out of the database and display a title of an entry that corresponds...
No activity results to display
Leave a comment: