Ask a Question related to Dreamweaver AppDev, Design and Development.
-
kartz #1
DataSet Filter "=" not working
Hello, I am using MX2004 on W2K. I have two pages pulling data from an Access
2000 database. One uses a filter with 'contains' to pull the data and the
other users '='. Both work fine when I test the datasets. When I switch to
Live Data View the page with 'contains' works fine but the one using '='
displays no data. The same thing happens when I view them on the testing
server. Just as a test, made them both 'contains' and they both worked great.
However I really need it to be '='. Any ideas will be greatly appreciated.
kartz Guest
-
ASP.NET: Can a MM:DataSet be "refilled" in a Repeater?
I'm trying to put a DataGrid inside a Repeater. The idea being that the DataSet that the DataGrid is based on will be re-filled each Repeater loop... -
vb.net: Problem using "IS" operator with ? parameter in Dataset
I'm sure someone's come across this, but I couldn't find it searching the boards. I get the error message "Invalid use of Is operator in query... -
A filter or effect to give "roughed up" look on apparel???
I am a designer for an apparel screenprinting company and recently many of the clients have wanted their logos or prints to have a "roughed up",... -
#24339 [Bgs->Opn]: "Add*Filter PHP .." directives not work
ID: 24339 User updated by: eng at anrdaemon dot mtu-net dot ru Reported By: eng at anrdaemon dot mtu-net dot ru -Status: ... -
"unable to load graphics conversion filter"
I recently purchased a new computer with Windows XP and it uses wordperfect. When I receive Emails with attachments sent with Microsoft Word 97 I... -
kartz #2 Re: DataSet Filter "=" not working
Here is the code for the department.aspx page that uses the '='' filter. <%@
Page Language='VB' ContentType='text/html' ResponseEncoding='iso-8859-1' %> <%@
Register TagPrefix='MM' Namespace='DreamweaverCtrls'
Assembly='DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,cultu
re=neutral' %> <MM:DataSet id='ds_dept' runat='Server'
IsStoredProcedure='false' ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSett ings('MM_CONNECTION_STRING_lic
ense') %>' DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSett ings('MM_CONNECTION_DATABASETY
PE_license') %>' CommandText='<%# 'SELECT Certificate, Invoice_cost, Purchaser,
Quan_ordered, Quan_used, Soft_name, Version FROM Master WHERE Purchaser = ?
ORDER BY Soft_name ASC' %>' Debug='true' > <Parameters> <Parameter
Name='@Purchaser' Value='<%# IIf((Request.QueryString('Purchaser') <>
Nothing), Request.QueryString('Purchaser'), '') %>' Type='WChar'
/></Parameters></MM:DataSet> <MM:PageBind runat='server' PostBackBind='true' />
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN'
'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'> <html
xmlns='http://www.w3.org/1999/xhtml'> <head> <meta http-equiv='Content-Type'
content='text/html; charset=iso-8859-1' /> <title>Untitled Document</title>
<link href='../css/main2.css' rel='stylesheet' type='text/css' /> </head>
<body> <h2>Washington County Information Technologies <br /> Software License
Database Search Results</h2> <hr /> <p><span class='txt_reg_bold'>Search by
Department sorted by Software Name:</span></p> <table width='90%' border='1'
cellspacing='0' cellpadding='5'> <tr bgcolor='#99CCFF'
class='txt_link_center'> <td>Software Name </td> <td>Version</td>
<td>Department</td> <td>Quan. Ordered </td> <td>Quan. Used </td>
<td>Cost</td> <td><a href='cert.htm'>Certificate</a></td> </tr>
<ASP:Repeater runat='server' DataSource='<%# ds_dept.DefaultView %>'>
<ItemTemplate> <tr> <td><%# ds_dept.FieldValue('Soft_name',
Container) %></td> <td><%# ds_dept.FieldValue('Version', Container)
%></td> <td><%# ds_dept.FieldValue('Purchaser', Container) %></td>
<td><%# ds_dept.FieldValue('Quan_ordered', Container) %></td>
<td><%# ds_dept.FieldValue('Quan_used', Container) %></td> <td><%#
Double.Parse(ds_dept.FieldValue('Invoice_cost', Container)).ToString('C')
%></td> <td><a href='<%# ds_dept.FieldValue('Certificate', Container)
%>'><%# ds_dept.FieldValue('Certificate', Container) %></a></td> </tr>
</ItemTemplate> </ASP:Repeater> </table> <p>&nbsp;</p> </body> </html>
kartz Guest
-
Julian Roberts #3 Re: DataSet Filter "=" not working
Try using WHERE Purchaser = @Purchaser
--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004
Julian Roberts Guest
-
kartz #4 Re: DataSet Filter "=" not working
YES!!! Jules, it works on the testing server. It doesn't work in Live Data View but I don't really care at this point. Thank you so much!
Kim
kartz Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
