Search results for query: *

Hi, i am trying to position an iframe shim behind a <ul> when it appears using mouseover. Just wanted some help on how to do it, possibly using getElementsByTagName(). The following is my markup example. <div id="headerNav"> <ul> <li id="header_nav1" class="nav1"><a href="#">N</a></li>...

I am trying to do the below in part of my function.. keep getting error '800a0402 Argument type must be an integer. I heard you can't use variables as an argument for creating arrays in vbscript, anyone know any different? or a way around? Function displayRandomKeyProducts(rsJ...

Hi, is there a way to have checkboxes in excel that when ticked as an option.. they add a paragraph of text from a separate word document or from inside the same excel sheet... into another word document.. Eg. tick 3 of 5 options, once ticked the 3 options descriptions are put together in 1...

The below shows a couple of functions to create the options for a select box. They don't cover much but still working on them. The arguments beginning with ex don't seem like the best way to do it. Anyone have any ideas on how to refine these? * this method gets data from 1 lookup table for...

Hi, I was wondering how to get text inside a div to scroll up and down when hovering over an image of an arrow. Often people use flash to do it but i dont want to. The html tag <marquee> is an option to make it scroll vertically so maybe i can wrap all the text inside the <div> with that and...

form label { font-size: 8px; font-weight: bold; color: #376EB1; font-family: Verdana, Arial, Helvetica, sans-serif; width: 100px; } This works fine in IE but doesn't do anything in Firefox, could anyone shed some light on a reason or work around? Thanks

Hi, I was wondering how to get text inside a div to scroll up and down when hovering over an image of an arrow. Often people use flash to do it but i dont want to. The html tag <marquee> is an option to make it scroll vertically so maybe i can wrap all the text inside the <div> with that and...

Hi, What do you do if you want to search for someones surname if it is something like O'brian etc. For instance the sql where clause is: WHERE surname = 'o'brian' would be incorrect. It returns an error of Incorrect syntax near 'brian' because of the '. I use surname =...

Hi having a problem getting a menu's links to line up next to each other with no gap. Here is my html: <div id="menu"> <ul> <li><a href="#">Link One</a></li> <li><a href="#">Link Two</a></li> <li><a href="#">Link Three</a></li> <li><a class="apply_online" href="#">Apply...

I have got a SELECT statement that returns a recordset, with one of its values being 'acId'. acId is either null or an id number. Eg. In the Microsoft sql server database table the value in the acId field for each record is either <NULL> or an id number acting as a foreign key. The below if...

Hi, I have an old database layout that is still being used and i need to change the design. I have 2 tables. COM, USERS. COM has a 'managedBy' field which contains a foreign key from USERS. USERS has the following fields, 'id','username','access','active'. At the moment USERS.id is a...

Below is the test code i have done so far. I want to clean it up a bit and there are a few problems i want to ask about. I have used a record counter to limit the records instead of using .PageSize correctly, the main reason for this is i was having problems with the last page because the...

Currently i have this as part of my statement: CASE c.closeDate WHEN '01/01/1900' THEN '' ELSE c.closeDate END AS [closeDate], Microsoft SQL Server database. c.closeDate is a 'smalldatetime' data type. I want to show the 01/01/1900 values as "" so they dont show in an Excel report. The...

Currently i have this as part of my statement: c.closeDate is a 'smalldatetime' data type The database sets a default null value in this field as 01/01/1900, i want to remove that value in a report. CASE c.closeDate WHEN '01/01/1900' THEN '' ELSE c.closeDate END AS [closeDate], The result...

Hi, Is there a way to display the column names of a recordset in asp javascript? I have a recordset that is being used for reporting purposes and what is returned in sql is exactly what i want to have displayed. An example of what is returned: complaintType Branch1 Branch2 Branch3...

var sqlComplaint = "SELECT lc.complaintType, COUNT(*) AS complaintsReceived "; sqlComplaint += "FROM complaints c LEFT OUTER JOIN "; sqlComplaint += "lookup_complaint lc ON c.complaintType = lc.id "; sqlComplaint += "WHERE (c.dateReceived BETWEEN CONVERT(DATETIME, '" + dateReceivedFrom + "...

I have got this select statement so far.. SELECT * FROM pContacts INNER JOIN pContactsExtra ON pContacts.Con_SysID = pContactsExtra.ConExt_SysID WHERE (pContacts.Con_DateOfBirth > CONVERT(DATETIME, '2006-03-01 00:00:00', 102)) AND (pContacts.Con_DateOfBirth <...

Hi, What i want to try and do is have a list of customers but display them in rows of 10, with a next button for more records and also break them up by the start of their surname depending on what letter has been clicked. I have a basic search page for a list of customers in .asp using...