Web host sites - To test the query, you must enter a
To test the query, you must enter a realistic value into the Value box in the query editor. For example, I know for a fact that I have a user named Bob in my current membership system. So I could type that name into the Value box, (refer to Figure 12-14). After you enter a test value and click OK, the query executes. In this example, only rows that have Bob in the UserName field are retrieved from the view, as shown in Figure 12-15. The query results show every transaction made by user Bob. When you bind this to a data control on your page, however, the query won t show Bob s record on the page. It will show records for whatever user requested the page. Given those options you just discovered, you can retrieve anything you want from your database, no matter how large or small. When you ve accurately defined the columns and rows that your data-bound control needs, click Next. You re taken to the Test Query page again. There you can click the Test Query button once to make sure your query is retrieving the data you need. Then click Finish when you re certain the query provides the data your control needs. Figure 12-15: Only rows for user Bob are returned by the SELECT statement. Figure 12-14: The Parameter Values Editor dialog box. 272 Part III: Personalization and Databases
From our experience, we are can tell you that you can find a reliable and cheap webhost service at Java Web Hosting services.