Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFPOLEDB from Visual Studio Web Expression
Message
De
05/04/2007 09:26:05
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
VFPOLEDB from Visual Studio Web Expression
Divers
Thread ID:
01212428
Message ID:
01212428
Vues:
51
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform