oh and that code was in createSSN function.
I tried all sorts of ways to try to return "Nothing".. .
I either got invalid use of object or when I tried to check for Nothing in the calling routine, or invalid procedure call or argument in the function being called.
thelouvre
Last Activity: Feb 14 '11, 03:42 PM
Joined: Feb 25 '10
Location:
-
my code was like this
Code:strsql = "Select * From cvrSSN Where REPNO = " + "'" + gsRepno + "'" rsSSN.Open strsql, cn, adOpenForwardOnly, adLockReadOnly '!!check for no records and exit without child elements If rsSSN.EOF ThenLeave a comment:
-
I tried to do
when my query returned eof but my calling function died with that as I recall.Code:Set CreateSSN = Nothing Exit Function
I think I tried this too and it failed:
Code:Set SSNnode = Nothing CreateSSN = SSNnode Exit Function
Leave a comment:
-
How to detect a null child element?
I want to do an sql query and if it returns EOF then I want to skip the append child step.
...Code:Set xmldom = New DOMDocument60 xmldom.async = False xmldom.validateOnParse = False xmldom.resolveExternals = False xmldom.preserveWhiteSpace = True ' Create a processing instruction targeted for xml. Set Node = xmldom.createProcessingInstruction("xml", -
how to use something like left in select statement
I have two tables which have a field, let's call it FORM_TYPE, in which table 1's FORM_TYPE is LA-- and table 2's FORM_TYPE is LA---. Now I want to use a Where clause of Table1.FORM_TYP E = Table2.FROM_TYP E which always fails because of the extra -. I can't go change the database to make them the same. I was trying to use Where Left(Table1.FOR M_TYPE,4) = Left(Table2.FOR M_TYPE,4) so that I was basically stripping off some of the -. But it appears... -
use innertext
var elementFirst = document.getEle mentById("First ");
elementFirst.in nerText = "Whatever the new text is!";
I think this works for IE only.Leave a comment:
-
losing a row when rewritting table with hidden vs. visible
Depending on which transaction and search is selected in my select box, the page gets reformatted with only the elements needed (some text boxes disappear...). For some reason, when toggling between two of my searches, I lose the filer city row. Once it goes to hidden, I cannot make it become visible again. It is obvious on the screen because it becomes an empty row, just white space between the filer name and filer type rows. I've looked at... -
changing the lable on a text box
Given the following code:
<FORM NAME="MyCircleF orm">
<TABLE BORDER CELLPADDING=3>
<tr>
<td >
<input name="SimpleSea rches" type="radio" value="Circle" onclick="Enable TableElements(' Circle')"/> Circle</td>
<td >
<input type="radio" name="SimpleSea rches" value="Square"... -
i was able to send along the variable. i think this problem was that there was code to cast the url to all lower case. my new php had some capital letters and thus it was never found.Leave a comment:
-
how to preloading a text field when a certain button is pressed?
I have a little program here that I think would simulate something close to what I'm trying to do. I'm assuming if I can make it work, I can get the big stuff to work. I have a form, that basically allows you to select a radio button. When the button is pressed, I want to preload my date field text boxes. But their values are staying blanked out when I go and populate the page. So I tried to write a very small program included here that would... -
dynamically changing action variable of my form
I have a form defined and it has several radio button to allow form changes. When I click 3 of the buttons, i can go to the html defined form action="my.php" . But if i click the 4th button, i want to bypass this action and go to another php script that is called with the variable definition in the url. Normally the new script is called via
"html://www.mywebsite.c om/php/filer.php?acct= 0004". So in my html page, I want... -
want a clear subroutine that only clears text fields, not my buttons
i want to define a clear button that instead of resetting the entire form, only the text values are set to "". I tried with
document.getEle mentById("LastN ameRow").value = "";
but when my program runs, i enter data into the last name field and then press clear and the data remains. what am i missing? I know that i am entering my clear routine on click because my alerts are printing.
No activity results to display
Leave a comment: