www.webdeveloper.com

Search:

Type: Posts; User: gk53

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds; generated 29 minute(s) ago.

  1. Replies
    5
    Views
    4,554

    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 &...
  2. 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,
  3. Replies
    4
    Views
    5,867

    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...
  4. Thread: Publish

    by gk53
    Replies
    7
    Views
    5,522

    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...
  5. Replies
    3
    Views
    11,813

    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
  6. Replies
    2
    Views
    6,589

    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 ...
  7. Replies
    6
    Views
    4,993

    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...
  8. Thread: Publish

    by gk53
    Replies
    7
    Views
    5,522

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

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

    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...
  10. Replies
    5
    Views
    2,051

    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 ("...
  11. Thread: Show More Posts

    by gk53
    Replies
    1
    Views
    1,622

    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...
  12. Replies
    5
    Views
    2,051

    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,...
  13. Replies
    2
    Views
    2,046

    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
  14. Replies
    2
    Views
    1,332

    this is template for SQL server ...

    this is template for SQL server



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

    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...
  16. Replies
    2
    Views
    1,699

    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;
  17. Thread: PHP vs asp.net

    by gk53
    Replies
    6
    Views
    32,092

    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...
  18. Replies
    1
    Views
    2,747

    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...
  19. 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...
  20. Replies
    1
    Views
    1,587

    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...
  21. when you naming columns try to avoid reserve...

    when you naming columns try to avoid reserve words like index, primary, user....it will help
  22. 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...
  23. Thread: Unique constraint

    by gk53
    Replies
    3
    Views
    694

    so, add table BuildingRooms with biuldingId,...

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

    by gk53
    Replies
    1
    Views
    616

    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]
  25. Thread: filtering problem

    by gk53
    Replies
    5
    Views
    678

    I think it should be ...

    I think it should be

    <PHP>
    $resource=$connection->query(sprintf(
    "SELECT *,
    IFNULL(column1,column2) AS finalcolumn
    FROM mytable
    WHERE IFNULL(column1,column2) like '%s'",...
Results 1 to 25 of 59
Page 1 of 3 1 2 3
HTML5 Development Center



Recent Articles