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 John Tel 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?

    ...application. ' 'We have chosen to leverage the server side include functionality of ASP 'for simplicity sake. So you can use the SmartViewer*.asp files to instantiate 'the smart viewer that you wish to send to the browser. Simply replace the line 'below with the Smart Viewer asp file you...
  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

    ...bigint, Ending_Count bigint, Retension_Rate decimal); insert into mytemptable select Week, Beginning_Count,Ending_Count, Retension_Rate * 100 from RetensionSummary order by week; select * from mytemptable; END the error I keep getting is: Failed to execute SQL : SQL create procedure...
  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?

    ...varchar (80) ) insert into @abbr (Abbreviation, Definition) select ABREVIATIO,DEFINITION from dbo.ABBR order by ABREVIATIO --select * from @Abbr create table #storagetable (HTML text) Declare @HTMLStart varchar(8000) ,@HTMLBody varchar(8000) ,@HTMLEnd varchar(8000) ,@abr1...
  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

    ...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)) End as Quarts from tbl1 where ltrs is...
  12. NewbiDoobie

    Convert a convert

    ...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 the conversion , then...
  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

    ...count1 = cint(oFolder.Files.Count) Response.Write count1 Randomize  filecount = cint(cint(oFolder.Files.Count) * Rnd ) + 1 Response.Write filecount if I comment out the random number section I get the count diplayed, however the last section is throwing errors. Randomize filecount =...
  19. NewbiDoobie

    number of files in a web folder

    ...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 oFolder =  oFSO.GetFolder(Server.MapPath("/rotation")) Randomize   filecount = cint(oFolder.Files.Count) * Rnd...

Part and Inventory Search

Back
Top