Production News Clicks automatically add "1" [recommended]
Provide a nickname:
Pengcheng .NET
Author: levitian
Today, I saw a netizen who did not make news clicks. I had automatically add "1", I wrote this small tutorial, I hope to help my starting friends. ● Step 1: Use MX or UD to make a news headline browsing page, bind the field of the number of access times to the cell where the number of clicks is located; ● Step 2: Make a news content display page (ie the result page) ● Step 3: Open the news content display page Using the Data Bind Panel → Select the command (pre-stored process) → Set the following settings in the Command Settings: Name: Just a name, such as the Updatemmm Connection: Of course, you have selected the corresponding defined The database is connected, such as connflexmm type: Because we make record access times, you want to update the digital fields in the database, so select "Update". SQL: After selecting the update, a few rows of SQL statements will appear automatically in the SQL column, and we modify these statements, for example: Update MMT (MMT is to update database tables containing the corresponding field) SET VISITS = Visits 1 where mmtid = MMColParam Visits is a field that records the number of access times in the MMT data sheet. Visits 1 indicates every visit, and the field value is automatically added 1. MMTID is the ID number in the data table, MMColParam is a variable name, and you can take them. Here, it should be described: If the MMTID field type is an automatic number, the variable name does not add single quotes, but the mmtid field type is text, then the variable mmcolparam needs to add single quotes, which is mmtid = 'mmcolparam' ● Step 4: Top 4: After that, in the following variable column, click the " " button, enter MMColParam in the Name text box appear, enter the REQEST.QUERYSTRING ("MMTID") request.QueryString as ASP in the Run Value text box, indicating Get mode When prompted, the data is transmitted from the browser to the server. After setting up, it is very good. ● Note: "Command (Pre-Deprecation Procedure) To place in the result page (ie, you want to enter the page after clicking on the directory page), this can work