dcsimg
www.webdeveloper.com

Search:

Type: Posts; User: gk53

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    825

    why not just simple as... get every thing from...

    why not just simple as...
    get every thing from SQL in once


    declare @question as table
    (
    questionId int,
    question varchar(20)
    )
  2. Replies
    5
    Views
    6,065

    the problem is new line after sql="INSERT INTO...

    the problem is new line after
    sql="INSERT INTO Users (Email,Password,Role)
    it is creates unterminated string...
    change sql="INSERT INTO Users (Email,Password,Role)
    VALUES ('" & email &...
  3. it is something like that SELECT plat.title...

    it is something like that

    SELECT
    plat.title AS p_title,
    plat.initial AS p_init,
    builder.title AS p_builder,
    address.city AS p_city,
    lt.min_price,
    lt.max_price,
    lt.min_sqft,
  4. Replies
    4
    Views
    6,761

    it is problem there when you open file as...

    it is problem there
    when you open file as http://site.com/somefolder/file.xls
    you open file from your website and you will not be able to save file, becouse excel in local computer does not have...
  5. Thread: Publish

    by gk53
    Replies
    7
    Views
    6,305

    do you have any specific error? what does in meen...

    do you have any specific error? what does in meen its not working...
    in dot.net all your configuration in web.config file which must be in your virtual application folder...
    set debug="true" inside...
  6. Replies
    3
    Views
    13,113

    Guys, do you know dot.net? :) I gess yes, so is...

    Guys, do you know dot.net? :) I gess yes, so is that version in 3 and higher ajax is build in
  7. Replies
    2
    Views
    7,838

    after fix your query as $requests_q =...

    after fix your query
    as
    $requests_q = mysql_query("

    SELECT cnt, id, ord FROM (
    SELECT count(*) AS cnt, ava_users.*, 0 AS ord
    FROM ava_friend_requests
    LEFT JOIN ava_users ...
  8. Replies
    6
    Views
    5,778

    I think your problem there $sql = "insert into...

    I think your problem there
    $sql = "insert into $table_name values(",'$page_name', '$Page_desc', '$date_added')";
    you building sql statement like
    insert into myTable values(",'login.php', 'secure...
  9. Thread: Publish

    by gk53
    Replies
    7
    Views
    6,305

    Just copy your files into virtual folder or root...

    Just copy your files into virtual folder or root and it is all
  10. Replies
    5
    Views
    2,310

    I found a problem with your page You need to...

    I found a problem with your page
    You need to remove ; on
    str_ini = "SELECT Numero, Nazione, Nome, Wp_date AS [Work Proposal], Ris AS Ris_C, Rev FROM t_mrg WHERE Numero Like '2013044' ORDER BY...
  11. Replies
    5
    Views
    2,310

    did you tried to print full query and see what...

    did you tried to print full query and see what you have?
    after
    str_last = 'SELECT str_ini.Numero, str_ini.Nazione, str_ini.Nome, str_ini.[Work Proposal], str_ris.Ris_C AS Ris, str_ini.Rev FROM ("...
  12. Thread: Show More Posts

    by gk53
    Replies
    1
    Views
    1,695

    that is really depence from how youdesign your...

    that is really depence from how youdesign your page. you can reload all posts with number of posts increased or just add more posts on existing page (preferred). :)
    you need to keep track of number...
  13. Replies
    5
    Views
    2,310

    You should understand your str_ini, str_ris, ...

    You should understand your str_ini, str_ris, str_last is asp variables and access does not know that variables... so where you send to access query
    SELECT str_ini.Numero, str_ini.Nazione,...
  14. Replies
    2
    Views
    2,197

    2013-12-03 should be in single quotes or in #...

    2013-12-03 should be in single quotes or in # depense from what database you have
  15. Replies
    2
    Views
    1,507

    this is template for SQL server ...

    this is template for SQL server



    --======================================
    -- Create T-SQL Trigger Template
    --======================================
    USE <database_name, sysname,...
  16. Replies
    2
    Views
    1,199

    select count(*) in SQL 2008 did not count actual...

    select count(*) in SQL 2008 did not count actual record it is read header record it is read data from system table, you can use script below to get your statistics from database


    DECLARE @Temp...
  17. Replies
    2
    Views
    1,815

    something like that DECLARE count INT...

    something like that


    DECLARE count INT DEFAULT 1;
    WHILE count < 2000 DO
    insert into youtTable (dateValue) values(DATE_ADD('12/1/2013',count 45 MONTH))
    SET count = count + 1;
    END WHILE;
  18. Thread: PHP vs asp.net

    by gk53
    Replies
    6
    Views
    33,959

    both options has pros and cons, I have experience...

    both options has pros and cons, I have experience in both and huge number of website already written on both. I would say you should look on your internet provider the big reason which drive to...
  19. Replies
    1
    Views
    3,058

    and where is the question? Yes you can have files...

    and where is the question? Yes you can have files written on different languages in the same website...
  20. the line Set objExec = Conn.Execute(strSQL)...

    the line Set objExec = Conn.Execute(strSQL) <------ Line 20
    if wrong you executing insert statement, it will not return recordset, so it should be
    Conn.Execute strSQL
    you should use set only if...
  21. Replies
    1
    Views
    1,798

    it is giving me Include file not found...

    it is giving me
    Include file not found
    /shop$db.asp, line 5
    check if you have shop$db.asp in right location...
  22. when you naming columns try to avoid reserve...

    when you naming columns try to avoid reserve words like index, primary, user....it will help
  23. how you relate your tables? users (ID, name)...

    how you relate your tables?
    users (ID, name)
    fields (ID, title)
    entries (nameid,titleid,value)
    you tables not related... it is does not make sense....
    Of cause if you creating thousands records...
  24. Thread: Unique constraint

    by gk53
    Replies
    3
    Views
    781

    so, add table BuildingRooms with biuldingId,...

    so, add table BuildingRooms with biuldingId, RoomId and it is unique compbination
  25. Thread: SQL Help

    by gk53
    Replies
    1
    Views
    731

    This is it select [user_name],...

    This is it

    select [user_name], max(l.date_time_last_login)
    from users_tbl u
    inner join users_access_log_tbl l
    on u.[user_id]=l.[user_id]
    group by [user_name]
Results 1 to 25 of 60
Page 1 of 3 1 2 3
HTML5 Development Center



Recent Articles