[font=Arial ]
I am creating a checkbox list to display some information. When I test the page it gives me this error.
Sub or Function not defined
I'm not sure why so I'm hoping you can tell me. here is the code.
<%sdpmdh = ""%><%sdpmdh2 = ""%><%sdpmdh3 = ""%>
<% If orecord("DPMD_hardware") Like "%~cpu1~%" Then sdpmdh = "checked" End If %>
<% If orecord("DPMD_hardware") Like "%~cpu2~%" Then sdpmdh2 = "checked" End If%>
<% If orecord("DPMD_hardware") Like "%~cpu3~%" Then sdpmdh3 = "checked" End If%>
        <td align=right width="53%">
[size=2]<strong>DPMD Hardware</strong> [size=2]CPU

<input type="checkbox" name="DPMDh1" value="~CPU1" <%=sdpmdh%>>
<input type="checkbox" name="DPMDh12" value="~CPU2" <%=sdpmdh2%>>
<input name="DPMDh13" type="checkbox" value="~CPU3" <%=sdpmdh3%>>
[/font=Arial]

¤¤¤¤¤¤¤¤¤¤¤¤
Jackel23
¤¤¤¤¤¤¤¤¤¤¤¤

"Like" is not a VBScript keyword or function. You should be able to use InStr to look for the "cpuX" string.

If InStr(orecord("DPMD_hardware"), "~cpu1~") > 0 Then...

You don't need to have all those pairs of <% %>. Every one slows down the page a bit. If you have many lines of script, just wrap them all in one pair.

<%
sdpmdh = ""
sdpmdh2 = ""
sdpmdh3 = ""
If InStr(orecord("DPMD_hardware"), "~cpu1~") > 0 Then sdpmdh = "checked" End If
If InStr(orecord("DPMD_hardware"), "~cpu2~") > 0 Then sdpmdh2 = "checked" End If
If InStr(orecord("DPMD_hardware"), "~cpu3~") > 0 Then sdpmdh3 = "checked" End If
%>

Peter
------------------------------------------------------
Work smarter, not harder.

That's what I thought but I couldn't find any rule that showed proof of what VBscript could use. Thanks for the % advice too.

¤¤¤¤¤¤¤¤¤¤¤¤
Jackel23
¤¤¤¤¤¤¤¤¤¤¤¤

Is "%~cpu1~%" a string literal or is it a variable? Is the tilde (~) really part of the string? Maybe you could just post your code cause now I'm curious. :-)

Your right I couldn't post my code. It was the variable to look for in the string. the odd thing is the access DB accepted it directly so viewing the info worked ok but saving it did not. I took out the ~ and used no seperation character. It didn't want to save then either. I insured the fields in question are text based and they are but it will only accept numbers. I'm working around this problem by making the input numerical. The save page as far as I could see doesn't have anything requiring a number for that input. I'm starting to babble here so long story short I'm working around it but I would like to know what it mean when this pops up.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 4.


¤¤¤¤¤¤¤¤¤¤¤¤
Jackel23
¤¤¤¤¤¤¤¤¤¤¤¤

Try this

<%
sdpmdh = ""
sdpmdh2 = ""
sdpmdh3 = ""
If orecord("DPMD_hardware") Like '%" & cpu1 & "%' Then sdpmdh = "checked" End If
If orecord("DPMD_hardware") Like '%" & cpu2 & "%' Then sdpmdh2 = "checked" End If
If orecord("DPMD_hardware") Like '%" & cpu3 & "%' Then sdpmdh3 = "checked" End If
%>

Alternatively, this should work or be pretty close...

<%
sdpmdh = ""
sdpmdh2 = ""
sdpmdh3 = ""
If InStr(orecord("DPMD_hardware"),cpu1) > 0 Then sdpmdh = "checked" End If
If InStr(orecord("DPMD_hardware"),cpu2) > 0 Then sdpmdh2 = "checked" End If
If InStr(orecord("DPMD_hardware"),cpu3) > 0 Then sdpmdh3 = "checked" End If
%>

I am continuing with the InStr code just so I can expand my coding vocabulary. One thing I wanted to know is why is the >0 there?
If InStr(orecord("DPMD_hardware"),cpu1) > 0 Then sdpmdh = "checked" End If

¤¤¤¤¤¤¤¤¤¤¤¤
Jackel23
¤¤¤¤¤¤¤¤¤¤¤¤

InStr returns an integer indicating where the string starts, 0 means it was not found. It is used incorrectly as returning a Boolean but this is because VB(Script) will interpret 0 to be false and all positive integers to be true.

--

Joe

Personally I'd go with the LIKE statement. Something tells me that 'inStr' is not always supported in MsSql, but it is in VbScript or ASP. Not totally sure about that, but I've had problems with it and had to use 'CharIndex' for performing an inStr search. Could have been for a specific data type or something. However, the LIKE statement should be supported in both and that kinda comes in handy when troubleshooting.

I'd have to agree. I'm learning ASP under fire though so I haven't been able to realy learn the language. I'm actually taking someone elses site and reworking it to be more purposeful. If you don't mind a second dumb question I'm not able to get my javascript that I picked up from javascript.com to work in an ASP page. I'm just wondering if there is anything needed to show what script is being used other then <Script> tag.

¤¤¤¤¤¤¤¤¤¤¤¤
Jackel23
¤¤¤¤¤¤¤¤¤¤¤¤