Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOLEDB from Visual Studio Web Expression
Message
From
05/04/2007 09:26:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
VFPOLEDB from Visual Studio Web Expression
Miscellaneous
Thread ID:
01212428
Message ID:
01212428
Views:
52
I am connecting to a FoxPro database using VFPOLEDB from Web Expressions (.NET 2.0). Using the tools built into Expression I get the following code, which works A-OK:
      <asp:SqlDataSource runat="server" ID="SqlDataSource1"
ConnectionString="< %$ ConnectionStrings:ConnectionString % >"
ProviderName="< %$ ConnectionStrings:ConnectionString.ProviderName % >"
SelectCommand="SELECT * FROM [publicdata] ORDER BY [lotno]">
      </asp:SqlDataSource>
Now, using the same toolset, I add a WHERE clause, which results in the following code:
      <asp:SqlDataSource runat="server" ID="SqlDataSource1"
      ConnectionString="< %$ ConnectionStrings:ConnectionString % >"
      ProviderName="< %$ ConnectionStrings:ConnectionString.ProviderName % >"
      SelectCommand="SELECT * FROM [publicdata] WHERE ([aucttype] = ?) ORDER BY [lotno]">
      <SelectParameters>
            <asp:querystringparameter Type="String" DefaultValue="MAIL" Name="aucttype" QueryStringField="aucttype" />
      </SelectParameters>
      </asp:SqlDataSource>
I never get any data returned. The structure of the table that I am querying includes a field called aucttype of type Character, length 6.

Am I doing something wrong here?

Thanks in advance for any assistance!
Thanks in advance.:
On a CLEAR day you can see forever.
Next
Reply
Map
View

Click here to load this message in the networking platform