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. jrball

    Two Tables into one result

    That was exactly what I was looking for. I was trying JOINS, but I don't think I was setting them up right.
  2. jrball

    Two Tables into one result

    I have two tables I am trying to get into one query, but I can't figure out how to do it. What I need is a final result with all 4 of the answer fields on the same line as the each one of the question fields. Table 1 - Answers Answer_ID Question_ID Answer_Text Correct 1 1...
  3. jrball

    Labels on charts

    There's a few ways to manipulate the format of the graph. I would recommend doing it in the design tab rather than the preview tab. You can right click on the graph and either choose chart expert, or there's also a chart options that has Template, General, Titles, Grid and Selected Item options...
  4. jrball

    Adding two NumberVars Crystal 10

    I have a CR 10 report where I have created two NumberVars and need to add them together and can't figure out the code to do it. Here's what I have so far: First NumberVar Formula Q1 - WhilePrintingRecords; If {GetSurveyReportValues;1.QuestionId} = 970 then Shared NumberVar SE1 := Sum...
  5. jrball

    SQL Query Help (Two Tables)

    That's exactly what I was looking for. thank you very much!
  6. jrball

    SQL Query Help (Two Tables)

    I have two tables that I need to get data from Objects: PubID ModuleID Name CreatedDate 123456 620 Briefs 2/21/2007 2/21/2007 123455 620 Briefs 2/20/2007 2/20/2007 123454 620 Briefs 2/19/2007...
  7. jrball

    LIKE query - using a formatted string in ASP.net web application

    found it in another forum (not here) I had to replace the "*" with "%" for it to work in the web app.
  8. jrball

    LIKE query - using a formatted string in ASP.net web application

    I have been struggling with this for a while trying to format the strselect string properly to execute the select command on an access database using a asp.net web application. I can't get it formatted the right way to bind the datagrid. Here is what I started with: condb = New...
  9. jrball

    DotNetNuke - to do or not to do?

    I have implemented a DotNetNuke portal on an Intranet site. My user base is around 1000 users, with about half of them being concurrent. Setup time was very minimal, if you read the documentation and understand it. Depending on your understanding of .Net, IIS, and read through the documentation...
  10. jrball

    Insert Muliple Rows from ASP.NET VB aspx form

    I can answer his question, but I didn't want to post a ton of vars to the page.. there are 175 vars for each userid userid = (Request.Form("userid")) k12SessionArray0interaction_id = (Request.Form("k12SessionArray0interaction_id")) k12SessionArray0correct_response =...
  11. jrball

    Insert Muliple Rows from ASP.NET VB aspx form

    Thanks, bboffin that was what I was needing!
  12. jrball

    Need help creating a heart monitor animation

    http://www.flashkit.com/movies/Animations/Heart_Mo-Tim_Quir-1107/index.php try looking at this example...
  13. jrball

    Insert Muliple Rows from ASP.NET VB aspx form

    I am stuck. I have some vars being passed to an aspx page though a post method, and I am reading them through the request.form("varname") for each. I need to dump into a db table in multiple rows, how do I do it? I am going into a SQL database using VS.Net 2003. I was hoping to do a bulk insert...
  14. jrball

    Convert String 1:45 to seconds

    half way there.. I need to take an average of all the results and display that also. I have the variables averaged to seconds, but now I need to convert the seconds back to the MM:SS format to display.. For example one average is 76 seconds..how do I get it to display 1:16 ?
  15. jrball

    Convert String 1:45 to seconds

    I figured it out... (ToNumber(split({ComputerBasicsAssessment.OverallTime},":")[1])*60)+ToNumber(split({ComputerBasicsAssessment.OverallTime},":")[2])
  16. jrball

    Convert String 1:45 to seconds

    I have a colum in an SQL db that is the total time that it takes someone to complete an online assessment, but it's stored as a string. An example would be 1:45. So it took them one minute forty five seconds to complete the test. How do I convert that to a number first then to total seconds...
  17. jrball

    Passing parameters to sub report

    I tried the first one without the Sub
  18. jrball

    Passing parameters to sub report

    That got me close, but now I need to group all the answers together instead of having them listed seperately on each a new page. I tried to group by QuestionText also, but it's not working. Once they are grouped together I need to graph the results. Do you know what I mean?
  19. jrball

    Passing parameters to sub report

    Thats's was I thought also. I didn't figure it out right away. Thanks so much!

Part and Inventory Search

Back
Top