ASP和SQL帮助 - 我不知道我在做什么 [英] ASP and SQL help - I don't know what I'm doing
问题描述
我不太了解ASP，我对SQL的了解甚少。我一直试图在网上搜索能够完成我需要的信息。我已经尝试从许多不同的网站拼凑东西，在需要的地方添加我自己的信息，但它只是不起作用。
我想做的是，使用日历应用程序的现有数据库设置，从数据库中提取信息并显示与当前日期对应的条目的标题。
http://www.godfreyfritzs.com
如果你去上面的地址，你会看到有一个标志图形，上面有文字，上面写着冰淇淋的味道。现在我正在使用AJAX脚本为每月的每一天显示不同的HTML文件，因为每天的风味每天都在变化。我想从日历中汲取一天的风味，因为经理会将日历中的一天的风味作为活动。
这里是我的意思得到一个测试文件。
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 with the current date.
http://www.godfreyfritzs.com
if you go to the address above, you will see that there is a sign graphic which has text over it that says an ice cream flavor. Right now I am using AJAX scripting to display a different HTML file for each day of the month, because the Flavor of the day changes every day. I want to pull the flavor of the day from the calendar, since the manager will have the flavors of the day in the calendar as events.
here''s what i''ve got in a test file.
推荐答案
确定，修复了问题.. ..我的密码在这些东西''''......
但现在我在浏览器中收到此消息：
ADODB.Recordset错误''800a0bb9''
参数类型错误，不在交流中可以接受的范围，或者彼此冲突。
/testing.asp，第10行
这里又是我的代码：
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:
感谢您的帮助。
除了现在我收到此错误
< br> 用于ODBC驱动程序的Microsoft OLE DB提供程序错误''80040e14''
[Microsoft] [ODBC SQL Server驱动程序] [SQL Server]附近语法不正确关键字''SELECT''。
/testing.asp，第11行
此代码
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
这篇关于ASP和SQL帮助 - 我不知道我在做什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
