Dynamic IF Statement?!?!?HELP

The Mighty Dubs · 13-06-2011 10:54AM #1

Hi,

I have a dynamically driven site and am having an issue with an IF statement.

Basically I want the page to write a frameset depending if a record ("TotalQTY") equals "1" Else if it doesnt, it remains blank.

Im using ASP VBScript and SQL Server DB.

Any help would be much much appreciated.

Sorry i posted this on the wrong forum, i hope i got the right one now:eek:

amen · 13-06-2011 01:35PM

you really need to post some code that you have tried to get working.

This will help us to point you in the right direction.

E39MSport · 13-06-2011 02:05PM

Bit vague but perhaps a case would help?

CASE
WHEN TotalQTY=1 THEN 'something'
ELSE 'Dont'
END AS WHATEVER

The Mighty Dubs · 13-06-2011 02:05PM

OOPS! Will this do the trick
**************
<%
Dim recordset
Dim recordset_cmd
Dim recordset_numRows

Set recordset_cmd = Server.CreateObject ("ADODB.Command")
recordset_cmd.ActiveConnection = strConnection
recordset_cmd.CommandText = "SELECT * FROM dbo.qryViewListItems WHERE ProdID = ?"
recordset_cmd.Prepared = true
recordset_cmd.Parameters.Append recordset_cmd.CreateParameter("param1", 5, 1, -1, recordset__MMColParam) ' adDouble

Set recordset = recordset_cmd.Execute
recordset_numRows = 0
%>



<fieldset class="fieldset1" style="width:780px; height:inherit; border:2px solid #00addf; ">
<legend> Do you want to put this item On Hold? </legend>
<form ACTION="<%=MM_editAction%>" name="frmQuarantine" method="POST" >
<table width="100%" cellspacing="2" cellpadding="2">
<tr class="tbl-head">
<td width="7%" align="center">Brand</td>
<td width="12%" align="center">PfizerItemID</td>
<td width="55%" align="center">Description</td>
<td width="11%" align="center">Total Stock</td>
<td width="10%" align="center">Total Released</td>
<td width="10%" align="center">Total Qty On Hold</td>
<td width="5%" align="center">Qty To Put On Hold</td>
</tr>
<tr class="tbl-row">
<td align="center" bordercolor="#333333"><img src="siteimgs/brands/<%=(recordset.Fields.Item("brandlogo").Value)%>" /></td>
<td align="center" bordercolor="#333333"><%=(recordset.Fields.Item("PfizerItemID").Value)%></td>
<td align="left" bordercolor="#333333"><%=(recordset.Fields.Item("ProdDesc").Value)%></td>
<td align="center" bordercolor="#333333"><%=(recordset.Fields.Item("TotalQty").Value)%></td>
<td align="center" bordercolor="#333333"><% response.write(GetReleasedStock(rsReleaseOnHold))%></td>
<td align="center" bordercolor="#333333"><%=(recordset.Fields.Item("QTYONHOLD").Value)%></td>
<td align="center" bordercolor="#333333">
<input name="QtyOnHold" type="text" id="QtyOnHold" value="<%=(recordset.Fields.Item("QTYONHOLD").Value)%>" />
</td>
</tr>
<tr class="tbl-row">
<td colspan="6" align="center" class="tablerepeatrow"><table width="100%" border="0" cellspacing="3" cellpadding="3">

<tr class="tbl-row">
<td><label>Comments </label></td>
<td><textarea name="ItemComments" id="ItemComments" cols="45" rows="5"> <%=(recordset.Fields.Item("ItemComments").Value)%></textarea></td>
</tr>
</table></td>
</tr>
<tr class="tbl-row">
<td colspan="6" align="center"><input type="reset" name="button" id="button3" value="Reset" />
<input type="submit" name="button" id="button4" value="Submit" />
<input name="OnHold" type="hidden" id="OnHold" value="1" /></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="frmQuarantine" />
<input type="hidden" name="MM_recordId" value="<%= recordset.Fields.Item("ProdID").Value %>" />
</form>
</fieldset>

lynchie · 13-06-2011 02:13PM

Been a while since I done vb but will the following not work?

<%

if recordset.Fields.Item("TotalQty").Value <> 0

%>

<fieldset .......
.
.
.
</fieldset>

<%
end if
%>

Malice · 13-06-2011 06:27PM

Whatever about the rest of the solution I'd recommend that you change this

recordset_cmd.CommandText = "SELECT * FROM dbo.qryViewListItems WHERE ProdID = ?"

to only return the columns you need. Seeing "SELECT *" statements in production code annoys me.

kayos · 13-06-2011 08:39PM

Malice wrote: »

Whatever about the rest of the solution I'd recommend that you change this

to only return the columns you need. Seeing "SELECT *" statements in production code annoys me.

Or go one futher and move the query into a SP...

I had forgotten what a wall of text ASP was.

Malice · 14-06-2011 06:45PM

kayos wrote: »

Or go one futher and move the query into a SP...

Good point.

kayos wrote:

I had forgotten what a wall of text ASP was.

Things like avoiding a table-based layout and keeping styling in a CSS file will help to a certain extent but it is definitely a shock to the system if you wind up maintaining something like this if you've had any exposure to a project where data access, code and presentation are kept apart.

15-06-2011 12:26AM

My eyes!, that is all.