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 Mike Lewis 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. Qik3Coder

    All possible combinations with a twist

    Is this limited to 3 groups or can you have a dynamic number of groups? You've got questions and source code. We want both! Here at tek tips, we provide a hand up, not a hand out.
  2. Qik3Coder

    Default Constraint

    To clarify why Frederico's solution will work: A default constraint is used when no value is specified. You had explicitly indicated you wanted a NULL value. I've found default constraints seem to be designed for "extending" your database, without extending your code base. The code doesn't know...
  3. Qik3Coder

    Newbie Question HTML, Maybe Javascript -- opening pop up

    You can't put a lot of data in a popup. Are you trying to show a whole new page? Did you get it to show the "Notes" text? Are you against using a second datagrid to show the details for the particular row that is chosen? You've got questions and source code. We want both! Here at tek tips, we...
  4. Qik3Coder

    How to I execute a script without Management Studio?

    If you are working on a deploy process then the command line should get you there, otherwise you can just connect to your test machine and run the script from your main box. Just putting that out there... Lodlaiden You've got questions and source code. We want both! Here at tek tips, we...
  5. Qik3Coder

    Email alert notification doesn't work on our system any more

    Have you validated that your dll is being loaded? Check in the GAC, or the appropriate Template folder to make sure your dll is present. Check in the web.config and make sure your dll is still listed in the SAFECONTROLS section. Make sure the version number and the GUID are correct for your...
  6. Qik3Coder

    How to validate a checkbox?

    You need to make sure the validator is in a GROUP that is separate from the SEARCH validation GROUP. Otherwise it is always running that validation. Lodlaiden You've got questions and source code. We want both! Here at tek tips, we provide a hand up, not a hand out.
  7. Qik3Coder

    Different behaviour Agent Job and Query Window

    Fix your data conversion issue. You've got questions and source code. We want both! Here at tek tips, we provide a hand up, not a hand out.
  8. Qik3Coder

    Views with filter "Does not contain"

    If it is letting you use the CONTAINS (because I couldn't get a function to work with CONTAINS), then create a column that is a YES/NO with whether or not the field has closed in it, then just show the NO's. Lodlaiden You've got questions and source code. We want both! Here at tek tips, we...
  9. Qik3Coder

    Email alert notification doesn't work on our system any more

    Make sure the users accounts have access to send email as whatever account you're using to send the mails. Internal mail should just work. Have they renamed the SMTP server? Lodlaiden PS: If you've found a solution to this, then post it. You've got questions and source code. We want both! Here...
  10. Qik3Coder

    Deadlock occurs with INSERT VALUES

    I was actually talking about the "fillfactor". Tables with "Old"/static data are sometimes have a fillfactor of 100%, so that they take up the least amount of space, but this makes inserts take longer because they have to juggle the data. How often do you re-index and recompute the statistics...
  11. Qik3Coder

    Date between two or more records min and max dates

    Why does that not work? That's exacly how I would have responded. You've got questions and source code. We want both! Here at tek tips, we provide a hand up, not a hand out.
  12. Qik3Coder

    Deadlock occurs with INSERT VALUES

    What kind of traffic are you seeing on that table? Do you have foreign keys to other tables (that it has to go check) Are there triggers on this table, which may be slowing the insert down? I'm not sure of the correct terms for this next question, but you should be able to figure out what I...
  13. Qik3Coder

    ROW NUMBER Partition by

    Sequential Number is the same for all your entries, so it cannot break across and start a new number set. You need a something to group the sets. SQL does not like doing row over row comparisions. BTW, your trying to use ROW_Number the exact opposite of the way it's supposed to be used. Raad...
  14. Qik3Coder

    View / SQL / T-SQL

    The view will enable you to cache some of the query, but you must still use the view in some fashon to get data, which is why I "normally" bypass that step. If you only grant access to the view and not the underlying tables, then those users do not have access to the "extra" columns. I normally...
  15. Qik3Coder

    View / SQL / T-SQL

    The stored proc will let you cache an execution plan, so it is able to run faster than the random script. Procs and views have different purposes. A procedure is a fixed set of steps/actions that you need to contain into an atomic unit. A view is use to standardize some logic, but the final...
  16. Qik3Coder

    ODBC database Component not found

    You need to figure out which registry setting it's looking for. You can manually add these in, but you need to be VERY careful. I'd use a known working box for comparison of registry entries. You've got questions and source code. We want both! Here at tek tips, we provide a hand up, not a hand...
  17. Qik3Coder

    Sorting multiple columns in different orders ASC & DESC not working

    DougP, your row number function is done in SQL, and will generate based on what you have provided. When you sort in a grid view you are bypassing the sort specified in the query, and by default, you can only sort on one column at a time. Lodlaiden You've got questions and source code. We want...
  18. Qik3Coder

    ODBC database Component not found

    Whether your account is an admin or not, most items do not explicitly run "AS Admin" with Windows 7. I'd start with Re-installing the software as GMM suggested, explicitly running as Admin. You've got questions and source code. We want both! Here at tek tips, we provide a hand up, not a hand out.
  19. Qik3Coder

    running service from command line

    Gib, You need to build a console app to actually execute your code. You've got questions and source code. We want both! Here at tek tips, we provide a hand up, not a hand out.
  20. Qik3Coder

    image quality needs improvement

    Have you saved the image out on it's own to validate that it is fine before pdf compositing? You've got questions and source code. We want both! Here at tek tips, we provide a hand up, not a hand out.

Part and Inventory Search

Back
Top