User Profile

Collapse

Profile Sidebar

Collapse
nkoriginal
nkoriginal
Last Activity: Jun 2 '09, 04:26 PM
Joined: Nov 14 '06
Location: Madrid, Spain
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nkoriginal
    started a topic Ado Recordset in PHP
    in PHP

    Ado Recordset in PHP

    Hello I would like to know if exist any way to create something like this in PHP

    I need to insert in mysql an entire form, but I've to many field and I want a code to insert in the DB without to write in code each variable.

    Thanks for you help

    Code:
     <% if request.Form("submit") = "submit" then 
Dim rs, data_source
Set rs = Server.CreateObject("ADODB.Recordset")
    ...
    See more | Go to post
    Last edited by Markus; Mar 9 '09, 10:44 AM. Reason: Added [code] tags.
    • nkoriginal
      started a topic Retrieve Binary Data from SQL 2005!! Help PLS
      in ASP Classic

      Retrieve Binary Data from SQL 2005!! Help PLS

      hello everybody:

      I've a page where upload .doc and .pdf to my DB (sql 2005), I tried many times to retrieve that information but I can't do it.
      My idea is:
      an ASP page with links, when somebody click that link, retrieve the .doc or .pdf from the DB. I've an unique ID per line. so I can know what row I want to retrieve.

      when the user click the link, my idea is to show a new windows where the user can select...
      See more | Go to post
      • nkoriginal
        started a topic Store Procedure - Dynamic Insert
        in SQL Server

        Store Procedure - Dynamic Insert

        Hello:

        I've a form with 100 fields and I created 4 tables in my sql server for that form.
        Now, I want to create an store procedure to insert in all fields in differents tables. But I dont want to define the statments for each field. I want something like ADO recordset.

        Somebody have an complete example for that. Or any tutorial?

        I really appreciate it

        thank you
        NIKO
        See more | Go to post
        • nkoriginal
          replied to ASP automatic Insert
          in ASP Classic
          Jared:

          I found the solution to my problem.
          Thank you for your help.

          Here is the complete code for insert X fields from HTML form in SQL table.


          Dim rs, data_source
          Set rs = Server.CreateOb ject("ADODB.Rec ordset")

          rs.ActiveConnec tion = MM_mm_STRING
          rs.CursorType = 2
          rs.CursorLocati on = 2
          rs.LockType = 3
          rs.source = "select * from...
          See more | Go to post

            Leave a comment:

          • nkoriginal
            replied to ASP automatic Insert
            in ASP Classic
            Yes I tried with Cursotype = 2 But nothing.
            I will try another way if I found something I will post a new message.

            thank you Jared
            NIKO...
            See more | Go to post

              Leave a comment:

            • nkoriginal
              replied to ASP automatic Insert
              in ASP Classic
              Jared:

              Yes I tried with the 2 alternatives.
              When I put the response.write "updating& x.name &" .....

              I received this message in the browser

              updating id

              Microsoft OLE DB Provider for SQL Server error '80004005'

              Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

              /mackoul/beta/forms/borrar.asp,...
              See more | Go to post

                Leave a comment:

              • nkoriginal
                replied to ASP automatic Insert
                in ASP Classic
                Jared, thank you for your help, I tried all you said but it didn't work.
                I've the same error in the same line.


                objRS(x) = request.form(x) or
                objRS(x.name) = request.form(x. name)

                I checked my database permission and everything is fine. It's not read-only.
                I've many form in differents way, update, delete, insert and never has a similiar problem like this one.
                I dont know what I can...
                See more | Go to post

                  Leave a comment:

                • nkoriginal
                  replied to ASP automatic Insert
                  in ASP Classic
                  Thank Jared for answer again my question.

                  The error is this line

                  objRS(x) = request.form(x)

                  Do you know why?
                  Thank you...
                  See more | Go to post

                    Leave a comment:

                  • nkoriginal
                    replied to ASP automatic Insert
                    in ASP Classic
                    Hi again:

                    I tried to use this sentence but it's not working, I would like to know if you can help me with this code.

                    I created an asp page
                    then I created inside it a html form

                    and I put this code
                    [code=asp]
                    <%
                    'set objRS = server.createOb ject("adodb.rec ordset")
                    'Set loConn = CreateObject("A DODB.Connection ")

                    dim query, x
                    ...
                    See more | Go to post
                    Last edited by jhardman; Aug 10 '07, 09:17 PM. Reason: put code in code tags

                      Leave a comment:

                    • nkoriginal
                      replied to ASP automatic Insert
                      in ASP Classic
                      Hi again:

                      I tried to use this sentence but it's not working, I would like to know if you can help me with this code.

                      I created an asp page
                      then I created inside it a html form

                      and I put this code

                      <%
                      'set objRS = server.createOb ject("adodb.rec ordset")
                      'Set loConn = CreateObject("A DODB.Connection ")

                      dim query, x
                      ...
                      See more | Go to post

                        Leave a comment:

                      • nkoriginal
                        replied to How to get Request.Form name
                        in ASP Classic
                        Another solution is:
                        You can save the variables in sessions or in url path.
                        Session is a good solution if you want

                        NIKO...
                        See more | Go to post

                          Leave a comment:

                        • nkoriginal
                          replied to AutoComplete using values from Database Table
                          in Javascript
                          You can use this example if you want it http://www.codeproject .com/jscript/jsactb.asp

                          Is easy to implement and really good.

                          If you need help with the connection to the database or show inputs in your page, just let me know.

                          You can insert 2, 3 , 4, etc, inputs with autocomplete, working with the database

                          If you need help, let me know
                          NIKO
                          See more | Go to post

                            Leave a comment:

                          • nkoriginal
                            replied to ASP automatic Insert
                            in ASP Classic
                            THANK YOU SO MUCH!! I really appreciate your help guys!

                            NIKO
                            See more | Go to post

                              Leave a comment:

                            • nkoriginal
                              started a topic ASP automatic Insert
                              in ASP Classic

                              ASP automatic Insert

                              I want an automatic insert.
                              I've an ASP page with more than 50 fields (form) and I want to an insert all that information in a table in SQL server 2005.

                              Now, I've statments for insert BUT I need to create en automatic insert, because sometimes I need to add new fields or remove some fields (from HTML form page), and I dont want to modify the insert statment every time I add a new field

                              I dont know if I explained...
                              See more | Go to post
                              • nkoriginal
                                replied to Store Procedure Insert in "X" rows
                                in SQL Server
                                Thanks guys for your response.

                                I want an automatic insert.
                                I've an ASP page with more than 50 fields (form) and I want to an insert all that information in a table in SQL server 2005.

                                Now, I've statments for insert BUT I need to create en automatic insert, because sometimes I need to add new fields o remove some fields, and I dont want to modify the insert statment every time I add a new file.

                                I...
                                See more | Go to post

                                  Leave a comment:

                                • nkoriginal
                                  started a topic Store Procedure Insert in "X" rows
                                  in SQL Server

                                  Store Procedure Insert in "X" rows

                                  Hi:

                                  I want to create an store procedure for an ASP page.
                                  I've a form with 100 fields and I want to insert the information in:

                                  1) one table with 100 rows
                                  or
                                  2) in 5 tables

                                  Now, my idea is create an store procedure for insert BUT if tomorrow I need to add more fields and rows in sql, I would like not touch nothing in my code.

                                  So I want an automatically insert.
                                  ...
                                  See more | Go to post
                                  • nkoriginal
                                    replied to Combining Two onClick JavaScript Actions
                                    in Javascript
                                    thank you so much for your help!
                                    The code is working perfect!

                                    :D:D:

                                    nico...
                                    See more | Go to post

                                      Leave a comment:

                                    • nkoriginal
                                      replied to Combining Two onClick JavaScript Actions
                                      in Javascript
                                      Hi,

                                      Thanks to everybody to help me.

                                      when somebody select YES (radio button) my textarea and my dropdown menu come active, if they select NO, my textarea and dropdown is inactive.

                                      so, I need one radio button to active or desactive a: dropdown menu and textarea.

                                      in this case, two onlick in one radio button.

                                      thank you to everybody
                                      nico...
                                      See more | Go to post

                                        Leave a comment:

                                      • nkoriginal
                                        replied to Combining Two onClick JavaScript Actions
                                        in Javascript
                                        Thanks for your help, but I tried the two ways and nothing happend
                                        I paste again my code:


                                        <input name="chkxrt" type="radio" value="1" onClick="javasc ript:document.f orm.xrthistory. disabled=FALSE; document.this.p revrt.disabled= FALSE;">

                                        <input name="chkxrt" type="radio" value="0" onClick="javasc ript:document.f orm.xrthistory. disabled=TRUE;...
                                        See more | Go to post

                                          Leave a comment:

                                        • nkoriginal
                                          started a topic Combining Two onClick JavaScript Actions
                                          in Javascript

                                          Combining Two onClick JavaScript Actions

                                          Hi:
                                          (this is a dummy question, I know, but I tried many times and I cant)
                                          I need to insert this javascript option inside the input, I can't insert any funtion in <head>

                                          I've this two javascript:

                                          Code:
                                           javascript:document.form.xrthistory.disabled=false 
javascript:document.form.prevert.disabled=false
                                          and I need to put in one line inside a input type=radio, like this:
                                          ...
                                          See more | Go to post
                                          Last edited by Niheel; Dec 16 '06, 08:06 PM.
                                          No activity results to display
                                          Show More
                                          Working...