ASP Dreamweaver Access db

  • Wurn
  • Graduate
  • Graduate
  • User avatar
  • Posts: 122
  • Loc: Cape Town

Post 3+ Months Ago

Hey all

I have gone through below link and successfully done all parts. The only problem is that nothing displays on my results page. In Dreamweaver 8 in the "Bindings" field I connect to the MS Access DB and can run a query no problem, but it does not want to show up on my result page. Im at witts end. No real coder myself so...

ps. please dont ask why im using Dreamweaver and asp and not this or that... if you can help, please do so otherwise no biggie. :D

Web link tuturial:
pixeldigest com / aspsearch

My code: Result page
Code: [ Select ]
<MM:DataSet
id="DataSet1"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_phone") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_phone") %>'
CommandText='<%# "SELECT ext, mobile, name, surname FROM contact WHERE name LIKE ?" %>'
CurrentPage='<%# IIf((Request.QueryString("DataSet1_CurrentPage") <> Nothing), Request.QueryString("DataSet1_CurrentPage"), 0)  %>'
PageSize="10"
Debug="true"
>
<Parameters>
<Parameter Name="@name" Value='<%# IIf((Request.QueryString("name") <> Nothing), Request.QueryString("name"), "") %>' Type="WChar"  /></Parameters></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
  1. <MM:DataSet
  2. id="DataSet1"
  3. runat="Server"
  4. IsStoredProcedure="false"
  5. ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_phone") %>'
  6. DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_phone") %>'
  7. CommandText='<%# "SELECT ext, mobile, name, surname FROM contact WHERE name LIKE ?" %>'
  8. CurrentPage='<%# IIf((Request.QueryString("DataSet1_CurrentPage") <> Nothing), Request.QueryString("DataSet1_CurrentPage"), 0)  %>'
  9. PageSize="10"
  10. Debug="true"
  11. >
  12. <Parameters>
  13. <Parameter Name="@name" Value='<%# IIf((Request.QueryString("name") <> Nothing), Request.QueryString("name"), "") %>' Type="WChar"  /></Parameters></MM:DataSet>
  14. <MM:PageBind runat="server" PostBackBind="true" />
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Wurn
  • Graduate
  • Graduate
  • User avatar
  • Posts: 122
  • Loc: Cape Town

Post 3+ Months Ago

no ideas yet
  • Wurn
  • Graduate
  • Graduate
  • User avatar
  • Posts: 122
  • Loc: Cape Town

Post 3+ Months Ago

So i take it Dreamweaver is not everyones cupper?

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 143 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.