Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NewbiDoobie

    Cannot connect Via ASP?

    I have been trying to dify a sample asp page from CR to run the RDC with V: XI. Here is my code: <%@ LANGUAGE="VBSCRIPT" %> <% '=================================================================================== ' WORKING WITH THE REPORT DESIGNER COMPONENT AND ASP TO SET A REPORT'S QUERY...
  2. NewbiDoobie

    Microsoft VBScript runtime error '800a0005'

    I am getting this error: Microsoft VBScript runtime error '800a0005' Invalid procedure call or argument It has been traced back to set m_de = Server.CreateObject("DERuntime.DERuntime") m_de.Init(Application("DE")) This was working fine on the dev server. when we moved it to the new...
  3. NewbiDoobie

    Anchor not working

    I am trying to set the anchor of an internal HTML page on my asp page. I have a couple of the pages pulling from the url, but this page will not accept that. The only place it calls the html page is here: m_sFileLocation = Session("sTemplatePhysicalPath") & "C-ClientSummary.htm" m_sHtmlDoc =...
  4. NewbiDoobie

    Stored procedure in MySQL5

    I am writing this stored procedure and it keeps erroring out: create procedure RetensionRate () BEGIN CREATE TEMPORARY TABLE mytemptable (Week int, beginning_Count bigint, Ending_Count bigint, Retension_Rate decimal); insert into mytemptable select Week, Beginning_Count,Ending_Count...
  5. NewbiDoobie

    count of records based on criteria

    I am fairly new to CR XI and I am trying to develp a formula to determine the original record count then the final active record count. How can I put these conditions in formula? count({Transactions.UserId}) isnull({Transactions.InactiveDate}) or {Transactions.InactiveDate} <= DateTime...
  6. NewbiDoobie

    readtext?

    I have a text field that I am updating. Once the procedure finishes running i need to save it to a file. The problem is that I am getting about half of the document. Here is my code set nocount on declare @Abbr table ( IDN int identity , Abbreviation varchar(12) , Definition...
  7. NewbiDoobie

    Unterminated string constant Code 0

    I have this little bit of code that is throwing me for a loop. I looked up what the error said, but do not see where this has not been terminated. If I take this code out, the page works fine. If I leave it in I get: Line 100 Char 25 Error: unterminated string constant Code 0 If I take...
  8. NewbiDoobie

    Convert a convert

    I am trying to do an insert, however this is not working the way I expected. Case when liter is not null then '-' else convert(varchar(5),(convert(numeric (18,1), Liter) * 1.0567) End as Quarts I had expected to conver a varchar(4) to conver to a number if it was not null, multiply it out by...
  9. NewbiDoobie

    Did I type this wrong?

    I cannot seem to change the color of my link via the stylesheet. This is the statement I am trying to change the link to blue with is: <p class="main">Go ahead, click on <a class="SubSectLink" href="javascript:document.frmDemo.submit();">Try It Now!</a></p> The stylesheet looks like this...
  10. NewbiDoobie

    number of files in a web folder

    I have a site uploaded to a server. Within this site I have a folder which contains between 5 to 10 separate web pages which are loaded into an inline frame at random. What I am trying to do is: A: get the count of the number of files in the web folder B: generate a random number based on the...
  11. NewbiDoobie

    setfocus nightmare

    I have read and read and still have no clue why this does not work: <body...
  12. NewbiDoobie

    hyperlink issue

    I have an image that when clicked should go to another page. When I tried to add on the hyperlink, there seems to be a grey bar at the bottom of my image and it seems to have now widened. <td><a href="../free_demo.asp"><img src="img/try_it_now.gif" width="172" height="36"></a></td> the...
  13. NewbiDoobie

    Cannot replace this?

    I am trying to do something I am not sure can even be done. I have code which may contain several abbreviations and I need to update it with the correct description from an abbreviations table. This is the type: W/ oop W/o oop Abbreviations table contains these...
  14. NewbiDoobie

    Delete using an inner join???

    I am trying to covert the next section of code to be performed using an inner join opposed to using the covert process. (I think I am going to have to do this as 2 seperate commands, but this statements does not seem to be working delete a from @NotInXref a left outer join @CurrentXref cx...
  15. NewbiDoobie

    Cannot determine Distinct records?

    I have a field that i am trying to select/noselect based on if there is mosre than 1 distinct record in the field, I have 3 records ID FIELD1 1 W/ oop 2 W/o oop 3 W/o oop I am being told that there is only 1 distinct field1 Why will it not give me the correct count of 2 and is...
  16. NewbiDoobie

    Best place to Start CSS or Master Pages

    Hi I am writing my first web ap in VS 2005. I am not sure what the correct method would be to integrate a constant look and feel across my site. Should I be using CSS or should I not be using the master page option? Kinda new to Web design so i want to keep it the most efficient and easily...
  17. NewbiDoobie

    Reading excel problem

    I am trying to read 3 fields from an excel worksheet to import into a SQL server table which two of the fields are supposed to be text fields. Problem is a majority of the data comes back missing. I have narrowed it down tot he records which come back blank and they are all comma delimited...
  18. NewbiDoobie

    Reading excel issues

    I am trying to read information from an excel spreadsheet to place them into a database. Problemn I am having is that I cannot seem to read a comma delimted Cell. I only want to import it as a text field, but every time i walk through that cell it puts it in as a blank. Why is this such a...
  19. NewbiDoobie

    Copy from 1 cell to another

    I have a loop that goes through and copies information from a spreasheet into another. All of the cells are being copied cept for one which keeps displaying as a #Value. It is the same field each time. I can diplay it in a message box with no problems. I thought if I changed from a .Value to...
  20. NewbiDoobie

    value of a cell

    I am not sure if there is a way to do this in excel, but if a user double clicks on a cell in a specific column, can I have the value of that cell passed to a macro to autofill another group of cells based on that value?

Part and Inventory Search

Back
Top