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 biv343 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: *

  • Users: Qik3Coder
  • Content: Threads
  • Order by date
  1. Qik3Coder

    Get stsadm command for Central Admin button

    Sharepoint 2007, Standard "custom" web part feature. When I try to deploy the feature using the stsadm command, the command reports a success, but in Central Admin it is not deployed. "%SPAdminTool%" -o deploysolution -name "%PackageName%" -local -allowGacDeployment -url %TargetWebUrl% Trying...
  2. Qik3Coder

    Visual Studio Oddity - Case Statement extra indenting

    Why does VS add an extra indent on the parens for the CASE block? Is there a way to turn that off? No other logic block does that. switch (DisplayMethod) { case CONSTANTS.DisplayMethod.Mode1: ------>{ ... } case CONSTANTS.DisplayMethod.Mode2: {...
  3. Qik3Coder

    FormView Cascading DropDownList Binding problem

    Let me preface this with I didn't create this nightmare. Page Setup: There is a custom object data source which is used to "collect" all the bound field values, and place the values in SESSION, so that they can be put in an XML document on a downstream page. There are separate Edit/Insert item...
  4. Qik3Coder

    Web User Controls in separate project

    I'm trying to create a new web site, with some heavy data controls. I wanted the data controls in their own project in case I need to use them again. Solution Structure: BusinessLogic (WebApp) [tab]UserControl.ascx [tab]UserControl2.ascx WebSite (WebApp) [tab]WebPage1.aspx [tab]WebPage2.aspx...
  5. Qik3Coder

    How to destroy/discard/remove/GC a local variable?

    Haven't had to do this before, but I'm going to be pasting together a lot of snippets, in which I regularly use the same variable names. Is there a way to remove a variable once I'm done with it, so the system doesn't freak out when I re-declare it 3 lines later? TIA, Lodlaiden You've got...
  6. Qik3Coder

    To normalize or not to normalize?

    So, I'm defining a structure that is going to be my focus for quite some time, so I want it to be supportable. I have various entities with explicit relationships. I'm defining the relations separate from the objects so that I can re-use the base components. This would look like Person ---...
  7. Qik3Coder

    C# GridView iterate over non displayed rows

    I have a standard grid view with 100 items in it. I have the page size set to 25. I need to inspect all items to get a full total of all items in the grid, not just the items on page 1. I already have a foreach that iterates over the row collection, but this only iterates over the first 25...
  8. Qik3Coder

    CreateObject with network installed executable

    I had a code block in an Access module that was working. The sys admins upgraded the software and now it is not a local install, but a network install. If I open the application manually, then the code is able to "Get" the running instance and works fine. How can I tell the application to...
  9. Qik3Coder

    LEFT JOIN vs MAX(...)

    Back story: I have a NASTY query I'm working with. It's a "straight" select and it's over 800 lines long. Problem: There are approx 50 left joins to a kev/value table by GUID SELECT col47.Value MySpecialColumn ... left join dbo.myLookupTable col47 (NOLOCK) on col47.[ID] = myBaseTable.ID...
  10. Qik3Coder

    Able to optimize date comparision?

    I need to return all records created in a specific YYYY-MM I've optimized the query by filtering out the IDs prior to joining all my other tables, but I'm curious if there's a better date compare. Here's the pertinant code bit: FROM( SELECT LCi.ID FROM dbo.myTable LCi (NOLOCK) WHERE...
  11. Qik3Coder

    Invalid Object (Window) crashes Build and Import

    I have window X. When i try to compile, using PB 7.0.3, it crashes. If I export and re-import the window PB crashes on import. This is all I get in the Event log: Faulting application pb70.exe, version 7.0.2.8003, faulting module pbmss70.dll, version 7.0.3.10312, fault address 0x0000689f. I am...
  12. Qik3Coder

    PB 7 ddw uses old select at runtime

    Powerbuilder 7.0.3 SQL 2005 I have a datawindow with a super basic select: SELECT a.code , a.desc FROM a ORDER BY a.code ASC I needed to filter out some values, so the select now looks like: SELECT a.code , a.desc FROM a WHERE code <> '0' and desc is not null ORDER BY a.code...
  13. Qik3Coder

    Create &quot;table&quot; for mailto:

    Let me start with I couldn't find a better way to do this. I am prefilling a outlook email with some dynamically gen'ed tabular data. The preferred method would be to actually create a populate the table. Failing that i create a mailto: string and then send that to Process.Start(). I am padding...
  14. Qik3Coder

    Select Headers union Data with Group and Order not working

    Hey, Trying to work through this and am getting hung up on the fact that it says the columns don't exist: SELECT'ACCT' as Acct, 'PROJECT' as Project, 'TASK' as Task, 'SUBACCT' as SubAcct, 'TOTAL' as Total, 'DESC' as [Desc], 'SCR' as SCR UNION SELECTAcct, Project, Task, SubAcct...
  15. Qik3Coder

    Optimize case when to use IN?

    I have a status column that contains text. I have to return either everything, or where the status is in(X) based on whether or not a flag was sent and (i.status = case when @ActiveOnly = 1 then 'OPEN' else i.status END or i.status = case when @ActiveOnly = 1 then 'PEND' else i.status END)...
  16. Qik3Coder

    Optimize Date function (Only if you are bored)

    So i have to pre-load a date drop down with the monday before today. I got this working, but was curious if there was a better way to do it. By the way, I have tests for this and it works for each day of the week. Public Shared Function GetMondayPriorTo(Optional ByVal dteToUse As Date =...
  17. Qik3Coder

    Possible to Throw Visual Studio Error?

    I am working a slew of user controls for windows form control. Has any been able to throw a Visual Studio error if certain conditions aren't met? Problem: I have a control that works with a DataGridView. If the target datagridview isn't set, I want to have an error show in the Error List in...
  18. Qik3Coder

    API for drawing cool stuff with Javascript

    Came across this on my Google Toolbar. Thought you guys would like to see it: http://dev.jquery.com/~john/processing.js/ -Sometimes the answer to your question is the hack that works
  19. Qik3Coder

    Looking for better solution than CURSOR

    Workup: I have a (table) function getZips(@ZipCode, @RangeToCheckInMiles) that returns a list of zip codes within x miles of a zip code that you pass to the function. I have a temp table that has two zip codes in it. Problem: I need to update a flag column if Zip1 is close to zip2. I tried...
  20. Qik3Coder

    Setup project Conditional deploy of config files with the same name

    Ok. So, I have a setup project that writes out the "primary output" and some other files. I have EXCLUDED the app.config that is automagically renamed to MyApp.exe.config. In addition i have 3 config files, (Dev/Stg/Prd).exe.config I have their target names set to MyApp.exe.config I have added...

Part and Inventory Search

Back
Top