Search Results - VBForums

Search:

Type: Posts; User: sapator

Page 1 of 13 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    6
    Views
    126

    VS 2010 Re: Need Help : COM control in Aspx

    Totally agree but here is the problem i see in a lot of big companies (and my own), they have combined their DB business logic with Web logic and various reporting tools that use Active X (mostly to...
  2. Replies
    6
    Views
    126

    VS 2010 Re: Need Help : COM control in Aspx

    You have to create something that will interpret the control to html code in order to be show at the page.
    Can you do that?
  3. Re: Refresh data for gridview without reloading page

    Just stay away from devexpress web controls and you are good to go.
  4. Re: Refresh data for gridview without reloading page

    Yes, i am just saying because if u use asp.net and get accustomed to the controls, it's more difficult to let go but when you go to the Javascript way then you will never want to go back.So that was...
  5. Re: Netgear DG834N re booting constantly.

    Doesn't do it any more. 30 euros pocketed and ready to be spend on other pleasures!
  6. Re: Refresh data for gridview without reloading page

    There is also a couple of ways.
    1) Very hard and pointless: Use a asp.net gridview and manipulate it's data with javascript. Data will load from a web service
    2)Easy. Use a JS grid (slickgrid) and...
  7. Re: Netgear DG834N re booting constantly.

    If it does it again yes but if super admin sap has made it work with changing the settings then I've saved 30 euros.
  8. Re: Is this PHP page loading time fast enough??

    There exist some test tools to check the speed but i can't recall since it was about a year ago i did test in command prompt, if i remember correctly.
    Also (white), bear (since you're an Indian) in...
  9. Re: Netgear DG834N re booting constantly.

    2 days but i am not sure it's doing it now as i am looking at the rooter about 20 minutes. Again not sure cuz i was out all day. Maybe the settings i changed worked (in that case i'm a frikin' mega...
  10. [RESOLVED] Netgear DG834N re booting constantly.

    Hi.
    Yep, the rooter will reboot after 10-15 minutes. I have changed some setting on UpnP and SIP ALG with the hope that these effect things and i am watching what's going on , better yet, will...
  11. Replies
    2
    Views
    188

    Re: Excel 210 database connection.

    Actually i am putting a zero if the month and day have only one digit.
    Changing the querystring worked, i googled since i haven't used vba for 10 years and i got a "working" excel querystring for...
  12. Replies
    2
    Views
    188

    [RESOLVED] Excel 210 database connection.

    Hah! I am so happy that i use vba again...NOT.
    Anyhow here, when i connect to the DB and use execute i take the 3. I mean i get an error saying:
    "Run time error -2147217900 (office...
  13. Replies
    2
    Views
    221

    VS 2010 Re: Field Validation

    Maybe some Javascript will get you of the hook or simpler you can use CSS but you may need html objects not aspx server ones:
    http://css-tricks.com/users-leave-search-box-empty/
  14. Replies
    15
    Views
    338

    Re: pivot specific columns

    As i could not do it the way you suggested i did a double cursor loop da loop to fix this.
    Seems pity since your solution seemed promising and only 20-30 rows but with the cursors i had to go to...
  15. Replies
    6
    Views
    210

    Re: [RESOLVED] case with update 200sql

    Hi funky. I guess it should be easy but i was using 2 #temp tables and i was joining each other and, well, "IF", was more clear to me in the end so i went for that but thanks for the heads up.
  16. Replies
    6
    Views
    210

    Re: case with update 200sql

    Well, i think i got it the other way around, so i will close this and come back if there is an issue.
    thanks.
  17. Replies
    6
    Views
    210

    Re: case with update 200sql

    Hi.
    Yes 2005slq but i am struggling with case here.
    Can you give me an example as i can't seem to do it properly.
    Thanks.
  18. Replies
    6
    Views
    210

    Re: case with update 200sql

    I do this, but i prefer a simple case if possible:


    declare @isset int
    set @isset =0
    declare @issetrow int
    set @issetrow = 0
    declare @between1 nvarchar(100)
    declare @between2 nvarchar(100)
  19. Replies
    6
    Views
    210

    [RESOLVED] case with update 200sql

    Hi.
    table2 xx int,time1 varchar,time2 varchar, time3 varchar

    row: 1,19:30,NULL,NULL

    What i want to do is a case to check when the first available time row is NULL and then update it with a...
  20. Replies
    15
    Views
    338

    Re: pivot specific columns

    This will bring null,null,null etc in time rows. Also even if we can fix this there are extra rows as there is the date row.
    This is getting worst and worst :(



    declare @datefrom...
  21. Replies
    15
    Views
    338

    Re: pivot specific columns

    I Am guessing this?
    But i will do nothing, still show the extra rows:


    declare @datefrom datetime,@dateto datetime
    set @datefrom = '11/27/2014 00:00:00'
    set @dateto = '12/03/2014 00:00:00'...
  22. Replies
    15
    Views
    338

    Re: pivot specific columns

    Ok, i officially don't get this one bit.


    declare @datefrom datetime,@dateto datetime
    set @datefrom = '11/27/2014 00:00:00'
    set @dateto = '12/03/2014 00:00:00'
    Create Table #PL...
  23. Replies
    15
    Views
    338

    Re: pivot specific columns

    Hmm, if i can i will look for a PK there, i was so tired that i may missed a PK.
    Another question and i will try this tomorrow. So we create the temp table, find a PK, do the partition in the time...
  24. Replies
    15
    Views
    338

    Re: pivot specific columns

    Hey.
    I do not have a primary key at all.


    Cinema1 room 04 27.11.2014 - 03.12.2014 HORRIBLE BOSSES 2 HORRIBLE BOSSES 2 MYFILMS 27 Nov 2014 17:00
    Cinema1 room 04 27.11.2014 -...
  25. Replies
    15
    Views
    338

    Re: pivot specific columns

    Hey, can you give me one row of the expected result? What will it give out?
    "partition by partid order by contype" this is where i put the time value?


    ,PL1.ProvText
    ,PL2.ProvText...
  26. Replies
    15
    Views
    338

    Re: pivot specific columns

    I am not sure i get you.


    use vista
    declare @datefrom datetime,@dateto datetime
    set @datefrom = '11/27/2014 00:00:00'
    set @dateto = '12/03/2014 00:00:00'
    Declare @ReallyWideField...
  27. Replies
    15
    Views
    338

    Re: pivot specific columns

    or doing:


    declare @datefrom datetime,@dateto datetime
    set @datefrom = '11/27/2014 00:00:00'
    set @dateto = '12/03/2014 00:00:00'

    SELECT
    convert(varchar, @datefrom, 104) + ' - ' +...
  28. Replies
    15
    Views
    338

    Re: pivot specific columns

    I was thinking, if that is not possible, to create 2 steps.
    One to bring everything, till the tickets and the other to pivot the tickets.
    Then, somehow to merge the two sets but this seems...
  29. Re: JSON Not letting me post a URL?

    I don't think php passes different than asp.net, as i pass it in the same way (for a service "myservice.svc/getfunction"). I am not sure though how would you pass this on remote domains. I think...
  30. Replies
    15
    Views
    338

    pivot specific columns

    Hi. I haven't used pivot in a looong, so i am not sure if this is the way to go.
    I have a result such like
    27.11.2014 - 13.03.2014, CinemaX, TitleX ...etc , 17:00
    27.11.2014 - 13.03.2014, CinemaX,...
  31. Replies
    5
    Views
    269

    Re: adding a double transaction row to group.

    Excellent!


    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    declare @datefrom datetime,@dateto Datetime,@Cinema AS VARCHAR(2),@CinemaDescription VARCHAR(50),@CardStrType varchar(10)
    set...
  32. Replies
    5
    Views
    269

    Re: adding a double transaction row to group.

    Ok, so the closer i can get is the above.
    This is correct in the way that it will give me the E transactions in the first table (i reversed the payment and refund so it will appear in the refund...
  33. Replies
    5
    Views
    269

    Re: adding a double transaction row to group.

    Hi.
    The problem is that i want every L that exists and only the 'E''s that have the same transC_lgnnumber , and then i can do the sum.
    thanks.
  34. Replies
    5
    Views
    269

    adding a double transaction row to group.

    Hi. i have a transaction 29801 that will have 2 rows, L and E.
    L= type of transaction and E will only be the extra line if the transaction is canceled ,
    So if a transaction is NOT cancelled it will...
  35. Re: VS 2008 trying to add and expand a report.

    So the file width was a printer issue!!! If you have strange a default printer (i had an IRS print) turns out that it will cut the width!!!!!!!!!!!!!
    Haven't solved the second problem but i will...
  36. Re: VS 2008 trying to add and expand a report.

    Ok so i found a report file that has wider width and i am fixing this but the problem here is that if i put a field (that has 100 rows) in section 3 (Details) it will not show anything and if i put...
  37. Re: VS 2008 trying to add and expand a report.

    Edit , sorry the full screen is a Microsoft report viewer that only sees server urls.
  38. [RESOLVED] VS 2008 trying to add and expand a report.

    Hi.
    I am either trying to use a reportviewer on crystal report application or a reportviewer on a vb from in order to display a crystal report.
    The report is already made to a rpt file.
    I have...
  39. Replies
    10
    Views
    271

    Re: Replace '' with characters

    So the issue was "else '%0D%0ASummer'" ?
    Thanks.
  40. Replies
    10
    Views
    271

    Re: Replace '' with characters

    Ok,


    USE [lagetest]
    GO

    /****** Object: Table [dbo].[ZZ_vwpProgressBoard] Script Date: 11/16/2014 02:42:28 ******/
    SET ANSI_NULLS ON
    GO
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.