Search results for query: *

This function works in IE but not Netscape or Mozilla. Doesn't seem to be evaluating getElementById in Netscape or Mozilla. The function getStyleObject(objectId) returns false for Net. and Moz. I have several div's that will show/hide according to the option box selection. Here's a snippet of...

I am trying to return a varchar converted to date. Then I want to sort by the date. Returned values vary, some are 02/01/2004, some 2/01/2004, etc. This is causing sql to not sort the way I want. I would like to sort chronologically by year, then month, then day. Here's my query Select...

I have a page with a select box. The select box is defaulted to index 2, and it's corresponding div. When the user makes a selection from the select box, the previous selection's div should disappear, and the new selection's div should display. However, the new div is appearing below the old...

I am trying to create a single select box based on a dynamic array. However, it appears that only the last value in the array is populating the dropdown. Any help would be appreciated. Here is a snippit of the function: if (questionsArray[i].questionType == "Drop Down") { //...

This query - DECLARE @Note varchar(255) SELECT @Note = NoteText FROM Notes WHERE RecordID=5173 Returns the following string: Please review and provide feedback.<br><br><a href=test>Candidate cjtest54r jtest54r</a><br><br><a href=test>Candidate cjtest08r jtest08r</a><br><br> I use the...

I need to get a count on the number of values in a string. For instance, my query returns something like this: '1000,2000,3000' I need a count of 3 returned (as a varchar). Or if the data returned is '1000', I need a count of 1 returned. Any help would be appreciated.

I have a record set that has three rows per person. All of the columns and rows are the same except for the last column. The first line will have field1 in the last column, the second line will have field2 in the last column and the third line will have field3 in the last column...

I am sporadically seeing truncated data using Crystal 8.5. The recordset returns the full data, but when I view the data in crystal, it is truncated. It doesn't happen everytime or on all fields. I searched the knowledge base and found an issue where using a font of less than 12pts. can cause...

I have a report that returns a number of rows based. The report gets the data from a returned sql recordset. I need a formula that will evaluate each row and suppress any duplicate rows. The evaluation will have to take into account that some of the rows begin with an asterisk, and some do...

I have a simple report, with no formulas, that is just intended to show data. The issue is some of the data from other fields is showing up where it shouldn't. For example, if the name John Smith should show, the report is displaying John SmiC31-IS. My recordset is not returned this way so...

Can a user insert a dropdown on to a report? I'm not talking about a parameter dropdown, just a dropdown on the report that can display multiple values.

I am developing a report which groups Applicant information. There is a new row for each Applicant. The problem I'm having is some of the columns have single values only, and some of the columns have multiple values. I have written sql that generates a record set with a row for each distinct...

I keep getting this error when running the report for a specific date range.&quot;Error in formula . 'WhilePrintingRecords; ' Division by zero.&quot;. Error Code: 515&quot; Here's the calculation formula, I need to deal with the circumstance where DistinctCount = 0. Any insight would be...

I am trying to add 1 to a fieldvalue. This works great except when a null value is returned. How do I set a null value to 0? I tried using the ISNULL function but kept getting a null value returned. Select top 1 num.fieldvalue + 1 as 'num.fieldvalue' FROM blah blah blah Thanks.

I would like to pull some data out of field that contains URL's. For instance my the URL may be http://www.myserver.com/wss/start.asp?application=test&group=abc&function=logon I need to pull out the name of the group, which is between group=(name)&function. I have tried using charindex and...

I am attempting to open a recordset using VB 6 and Access with AD0 2.6 using the following: Set mrsAppProd = New ADODB.Recordset mrsAppProd.ActiveConnection = gcnMain mrsAppProd.CursorType = adOpenKeyset mrsAppProd.Source = &quot;SELECT DISTINCT...

I am attempting to open a recordset using VB 6 and Access using the following: Set mrsAppProd = New ADODB.Recordset mrsAppProd.ActiveConnection = gcnMain mrsAppProd.CursorType = adOpenKeyset mrsAppProd.Source = &quot;SELECT DISTINCT Inventory.Inv_itemname FROM(...

I have a report that sums the instances of three conditions. On the last record in the report, CR shows the value as null, enen though there is an instance that it should count. As a result the sum of the instances is off by one. Any Ideas?

I have four formula fields that pass a number and I want to get a total count for these fields. What is the best way to do that? Let's say the fields are {@a} {@b} {@c} and {@d}. Thanks

I am looking for a simple duplicate check function. User should not be allowed to add record with same first name, last name and address. They are allowed to add record with same first name and last name and a different address. Thanks.