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 gkittelson 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 realize it is, however it is the starting for a long SP I an transfering from SQL server. There will be updates and modifications to the table, etc... I did check the verion and I can creat a simple SP, however when I add a begin/end it goes haywire
  5. 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...
  6. NewbiDoobie

    count of records based on criteria

    Synapse, Can you have multiple command objects in 1 report? I need to do this first for the opt-in, then the opt-outs column for this week and the previous 9 weeks. Also, we are creating this in access and then moving it to MYSQL. Will the command objects still be effective?
  7. 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...
  8. 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...
  9. NewbiDoobie

    Unterminated string constant Code 0

    what comment code? I am sorry, but I copied this from the previous version of the page and am still unsure what it does other than displays the message as it starts the page and then disapears. The change text function is this: function ChangeText(ElementID, newtext) { var...
  10. 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...
  11. NewbiDoobie

    Convert a convert

    I changed it, but now I am getting another error: Server: Msg 8115, Level 16, State 5, Line 1 Arithmetic overflow error converting numeric to data type varchar. Here is the new staement:\ select Case when Ltrs is null then '-' else convert(varchar(4),(convert(numeric (18,1), Ltrs) * 1.0567))...
  12. 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...
  13. NewbiDoobie

    Did I type this wrong?

    No, it does not seem to work in either case, which is why I think I typed it wrong, but I do not see where
  14. NewbiDoobie

    Did I type this wrong?

    it is the class in the css for blue links, by default for this site they are not supposed to change, but on this page they are supposed to be blue and underlined.
  15. NewbiDoobie

    Did I type this wrong?

    I need the link to turn blue. It does not do it. How do I get it to work using the stylesheet?
  16. NewbiDoobie

    Did I type this wrong?

    Still Black with no underline
  17. 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...
  18. NewbiDoobie

    number of files in a web folder

    alright I get the count of the files, but it will not generate the random number. Can I pass a vbscript variable to a javascript funtion? Dim oFSO Dim oFolder Dim FileCount dim count1 Set oFSO = server.CreateObject("scripting.FileSystemObject") Set oFolder =...
  19. NewbiDoobie

    number of files in a web folder

    That came back with an error: Microsoft VBScript compilation , (0x800A0408), Invalid character, /Default.asp, line 109, column 13, GET , /Default.asp, Here is what I have for the code now: Dim oFSO Dim oFolder Dim FileCount Set oFSO = server.CreateObject"scripting.FileSystemObject") set...

Part and Inventory Search

Back
Top