Jump to content

shamilton

Members
  • Posts

    43
  • Joined

  • Last visited

    Never

About shamilton

  • Birthday 10/24/1986

Profile Information

  • Gender
    Male
  • Location
    Reno, NV USA

shamilton's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Nevermind...figured it out. SourceID was 0 so the join wasn't going to do anything...fixed and now it works.
  2. SELECT DISTINCT Title, Date FROM TableName
  3. The code below works...but Status and Scheduled With return null values if the Type is 2...why? SELECT tblHistory.Dte AS 'Date', 'Scheduled With' = CASE WHEN tblHistory.Typ = 1 THEN tblActivity.SchedWith WHEN tblHistory.Typ = 2 THEN tblOpportunity.Name END, 'Type' = CASE tblHistory.Typ WHEN 1 THEN 'Activity' WHEN 2 THEN 'Opportunity' END, tblHistory.Details, 'Status' = CASE WHEN tblHistory.Typ = 1 THEN tblResults.Description WHEN tblHistory.Typ = 2 THEN tblStatus.Description END, tblUser.FirstN + ' ' + tblUser.LastN AS 'User' FROM CRMHistory tblHistory LEFT OUTER JOIN CRMActivity tblActivity ON tblHistory.SourceID = tblActivity.ID LEFT OUTER JOIN CRMOpportunity tblOpportunity ON tblHistory.SourceID = tblOpportunity.ID LEFT OUTER JOIN engCRM_Results tblResults ON tblHistory.Result = tblResults.ID LEFT OUTER JOIN UserInfo tblUser ON tblHistory.Login = tblUser.Login LEFT OUTER JOIN engCRM_Status tblStatus ON tblOpportunity.Status = tblStatus.ID ORDER BY tblHistory.Dte DESC
  4. Well... If you mean "How do I take the results from a SQL query and output them to a screen in columns" then you would probably use a table or CSS.
  5. Would you mind showing us the code where you include the files? The order might be relevant.
  6. OR: <?php if ($_GET['prevID'] != NULL) { echo "AHHHH";?> <input type="hidden" name="newID" value="<?=$_GET['prevID']?>" />
  7. So here is some HTML: <select name="status" id="status" tabindex="6" disabled="disabled"></select> Here is some CSS: *:first-child+html select { width:156px;; /* IE7 */ background-color:#ffffff; border:1px solid #7f9db9 !important; } select { display: block; width: 154px; float: left; margin-bottom: 10px; border:1px solid #7f9db9; background-color:#ebebe4; } I was able to get the background color of the disabled element to change to white. But I can't change the border color... Does anyone know how to alter the border color? I am basically trying to get all the elements to look the same when disabled...and the select element is being retarded.
  8. Well you can do this: SELECT crimeC.destinationid, allC.shortname FROM crime_countries crimeC JOIN countries_all allC ON crimeC.destinationid = allC.ID WHERE crimeC.sourceid = $personid I think that is right although I haven't tested it...
  9. If your script produces an error please post that. If it is not posting an error and you are having trouble with the logic - please post a detailed description of what you are trying to do. We are freaks here...not psychics...
  10. I solved it another way - but do you have a an example of your method? I solved it by adding another function called setLinkHeader which is just like setLink but it only focuses on the headers.
  11. I am currently messing around with the baaGrid class by Barry Andrew. I have the following sql statement: SELECT '<a href=\"?sortby=Name&sort=$nameSort\">Name</a>' = CASE Name WHEN '' THEN '[Empty]' ELSE Name END, '<a href=\"#\">Address</a>' = CASE Address1 WHEN '' THEN '[Empty]' ELSE Address1 END, '<a href=\"#\">City</a>' = CASE City WHEN '' THEN '[Empty]' ELSE City END, '<a href=\"#\">State</a>' = CASE State WHEN '' THEN '[Empty]' ELSE State END, '<a href=\"#\">Zip</a>' = CASE Zip WHEN '' THEN '[Empty]' ELSE Zip END, ' ' = CASE ID WHEN 0 THEN '<strong style=\"color:red;\">ERROR</strong>' ELSE '<div align=\"center\"> <button type=\"reset\" id=\"viewButton\" onclick=\"location.href=''index.php?click=manager&section=1&CustNum='+ numb +'''\">View</button> </div>' END FROM (SELECT TOP $max_results * FROM (SELECT TOP $depth * FROM Customer ORDER BY $sortby $sort) AS tempTable1 ORDER BY $sortby $altsort) AS tempTable2 ORDER BY $sortby $sort You'll notice on line #2: this still works...but no matter what it is set to...only the first 30 characters show...this sucks because it cuts off my URL. Anyone got any ideas?
  12. Why don't you have a cache table setup for the shopping cart? Store each users session ID into a table, and track their items by Session ID, Item Number, [Any other things like Boy/Girl]. This is good if you would like the users to be able to come back and not lose everything in their shopping cart.
  13. On line #4 you have: $view = isset($_GET['view']) ? $_GET['view'] : $view="main"; You're missing a parenthesis set and you don't need to do $view = anthing: $view = (isset($_GET['view'])) ? $_GET['view'] : "main"; That should work.
  14. Could you please tell me your sql,php and URL?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.