(ChiliSoft) Insert
Current setup: Sun server running Solaris 9, Apache, Chilisoft ASP, MySQL
I'm having problems inserting data into MySQL from an ASP vbscript insert page
I am using Dreamweaver to create the forms for ease of use. When I try to insert a record via the table only the first field in the form is inserted into the database and any subsequent fields are ignored
I tried creating a test table with just three fields (id (auto_increment), helptitle, helpinfo)
The helptitle field is inserted fine and the record is assigned an ID but the subsequent helpinfo field is not inserted at all
I then tried creating an insert page using ASP JavaScript and all the fields were correctly inserted
View Replies
ADVERTISEMENT
My company recently changed its server and replaced chilisoft with sun one for the asp.
The problem is that all the INSERT pages I created in chilisoft no longer function correctly.
I am running MySql database. All INSERT forms now only submit the first field in the form, ignoring the rest of the entries. No error messages are displayed.
Anyone have any ideas? All the pages where created in UltraDev 4 so the ASP should be ok.
View Replies
View Related
I get next error if i want to add a component.
O------------------------------------------------------------------O
| Microsoft VBScript runtime error '800a01b6' |
|
| Object doesn't support this property or method: 'Server.Execute' |
O-------------------------------------------------------------------
Does Chilisoft ASP 3.6.2 support the Server.Execute() method? or
Do i need to Upgrade the Chilisoft ASP 4?
View Replies
View Related
anyone know a good source of info on sun's ASP proggie?
View Replies
View Related
I've been doing a lot of ASP programming for a website (hosted by Namesco) which uses Sun One ASP on a *nix machine and MySQL.
However when posting form data to the server I frequently get Bad gateway errors returned to the client browser.
After talking to the Hosting company support team they fed me some story about it being a source code problem with Sun One ASP interfacing with MySQL.
I was wondering if anyone else had ever heard about or come across this in the course of their work and if they had found a solution/work around for it?
I've not used Sun One extensively so I'm not sure of the limitations of it. (I really don't fancy recoding to PHP!)
View Replies
View Related
I am an ASP guy who is developing using chilisoft at this moment. All is going very well except for using the fileAttach method (CDONTS), I am having great difficulty finding assistance.
The chilisoft documentation seems to lack an explanation of the file attach method, would you have any suggestions where I may see an example of the CDONTS file attach method.
using chilisoft 3.6.2 / Linux / apache
View Replies
View Related
i get code samples for servers running windows/IIS. the problem is that the server with my site is an aapche with chiliasp-3.5.2L-C3. i cannot figure out the syntax to take the input from the html form and mail it to a specified address.
View Replies
View Related
How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies
View Related
Our graphic designer has just finished redeveloping our website. On the
site, we use SSL to secure the area where a user enters their personal
information to order items from us. (we do not do many transactions - maybe
1 per day...) We are a log home mfg company so they would only order plan
books, maybe a video etc...
When the user clicks "Submit Order", we want to encrypt each data item
(because of new legislation governing customer personal info etc...) and
write a record to an access db. From here it will be imported into our
Customer DB leads database...
I do not use ASP but program in VB 6 and Access 2000. ASP looks similiar in
many ways...
Does someone have a good ASP script for encrypting data? And, if so, is it
fairly strong encryption?
Also, is there any trick to writing an "insert" SQL script in ASP or is it
exactly the same as I would do in VB or Access? Maybe someone has an
"insert" script handy they could pass along including the command to
actually execute it?
View Replies
View Related
i have got a data base which contain more than one tables
one for student one for teacher and one for books
i make a fourm to read the input from the user Code:
View Replies
View Related
Code:
mySQL="INSERT INTO products (sku, youtube, description, details) VALUES ('" &pSku& "','" &pYoutube& "','" &pDescription& "','" & pDetails& "')"
call updateDatabase(mySQL, rstemp, "insert1")
that's shortly the way i'm inserting new records.
using mysql and asp functions.
The prob is that inserting only one record every time.
if i got data for 3 records how can i make it at once
to add 3 new records in some given order into the db
View Replies
View Related
What is the best way to see if a record has inserted correctly into the datase in ASP?
Also, how to tell the user what the error is.
I am inserting like this with the ADO command object:
Dim sInsert, objCmd
set objCmd = Server.CreateObject("ADODB.Command")
sInsert = "sp_ADS_Insert_Driver_General_Data "
on error resume next
With objCmd
.ActiveConnection = oConnEnergy
.CommandText = sInsert
.CommandType = adCmdStoredProc
.Execute , , adExecuteNoRecords
View Replies
View Related
Application X has three screens. The user captures information on screen one and then clicks a navigation button to go onto screen two.He does the same on screen three. At the bottom of screen three is a submit button. When this button is clicked the system does some calculations with the information that is supplied and then uploads all the info that was captured on the screens to the database.
Should the data be uploaded to the database all on one go when the user clicks the submit button or should it be uploaded after each screen - ie when the user clicks the button on Screen 1 the data is uploaded to the database and then screen two is displayed.
View Replies
View Related
When the following code runs it produces no errors but doesn't give proper results:
sql = "INSERT INTO TableName (Line1, Line2, Line3, Line4) VALUES ('" & lines(0) & "', '" & lines(1) & "', '" & lines(2) & "', '" & lines(3) & "')"
Response.Write(sql)
SET RS = Conn.Execute(sql)
lines() contains nothing but strings and is never empty.
The Response.Write(sql) shows the proper values going into the proper locations.
However, only Lines(0) actually populates the table. Line2, Line3, and Line4 never receive any values despite the SQL showing the proper syntax.
View Replies
View Related
i have this insert statement that is giving me trouble, the problem is with expiration_date field the error i'm getting is:
Syntax error in date in query expression '##'.Code:
SQL_Insert = "Insert INTO TableName(ColumnX, ColumnY, ColumnZ, ColumnZZ, ColumnXX, ColunmYY, Expiration_Date) values ('" & _
ColumnX& "', '" & ColumnY & "', '" & ColumnZ & "', '" & ColumnZZ & "', '" & ColumnXX& "', '" & ColunmYY & "', #" & Expiration_Date & "#)"
View Replies
View Related
I have a column call UserDate and it's properties are this : varchar(50) . I have a function which updates the column with todays date. for some reason, if I manualy give the value to be inserted a value of '10/10/2006' or use date() it inserts a value of 0 if I give a value of 4 to be inserted it works?
I have been working on a project for 2 days and this is the last piece to get it to work, can anyone point out where I'm going wrong. P.S I have tried giving the colum a date format but unfotunately the format is american and I need it in english to compare with something else I'm working on.
View Replies
View Related
How can i get the last inserted record in an ASP ACCESS combination? Code:
View Replies
View Related
I'm looking for tutorials on how to upload a file (.doc or .pdf),insert in database and retreive from database. i'm using pure asp and sql 2000.
View Replies
View Related
I'm getting a syntax error when I try to run this SQL Insert statement, can anyone tell me what might be wrong? Before I was getting a data type mismatch error then I removed the ' quotes around the intPhone variable. The error occurs on the line after the SQL statement.
strSQL = "INSERT INTO candidates (Name, Grade, CivilService, Branch, Department, Sector, Town, EmailAddress, PhoneNumber, LunchReq, SpecialReq) VALUES ('" & strName & "','" & strGrade & "', '" & strCivilService & "', '" & strBranch & "', '" & strDepartment & "', '" & strSector & "', '" & strTown & "', '" & strEmail & "', " & intPhone & ", '" & strLunchReq & "', '" & strSpecialReq & "')"
Set rs = cn.Execute(strSQL)
View Replies
View Related
I have a 2 asp pages for a registration form. The first one is where the user types the data, and the second one has a form that requests the data from the 1st one and then sends it to the database. Both are sending the data correctly (I've seen it on the error page) but it's not feeding the DB.
View Replies
View Related
I have a website I am working on that I did not create. It is ASP and SQL based. There is a content management system created using ASP and saving in the SQL server database. A user can enter a news article into a big text box/area, and choose to add an image. The text and image are stored in the database via ASP and pulled out to the website via ASP.
The image shows up in the website to the top left of the article. I need to make it so the user can enter an image where their cursor is in the paragraph (like a word document) and have it also show up there on the website. Any ideas?
View Replies
View Related
I have a problem. I have ASP code and Javascript code. Now, I want to access ASP code inside javascript code. Here is the ASP code:
View Replies
View Related
I have a form which the user fills and submits.i have insert statement there.
When i submit the form to itself ,the values get submitted and inserted in DB easily.
<form method="post" action="Infoviewagentver212.asp" name="form">
Now when i want the user to hit submit and go to other page i change the above to:
<form method="post" action="newpage.asp" name="form">
but here what happens is my values are not getting inserted in the DB??
How do i do this?
View Replies
View Related
This is on my HTML page
<td align=center>
<textarea cols="85" rows="7" name=""Problem"></textarea>
</td>
User" enters information into this box.
If they use either a quote or double quote, but SQL statement bombs. Is
there a way quick way to fix this beforehand?
Conn.execute ("INSERT INTO PROBLEMS (Problem) VALUES ('" & Problem & "')")
View Replies
View Related
How to insert fields in a table by using SQL?
View Replies
View Related
Just like to know if I am correct and no problems in this scenario:
I have page where the user clicks a button to save some information >>
gets directed to page 2 where a value gets returned from a recordset and the form is inserted automatically upon loading with the value (sequential for the database table) >>
the user then gets redirected to page 3 upon insertion into the database, if I use 'Select Top 1 ......' as a query to retrieve some information on this page am I sure that this is the correct record just inserted even if 2 or more people are saving at the same time?
View Replies
View Related
This is my code, for some reason, when I use this exact code it doesn't update my database, but if I use the next section of code it does. Anybody knows why that when I use two different "Insert" in If Then End If, it doesn't work? Oh and I did try the "If PID = 105 OR 151 Then" alone and it works well. Code:
View Replies
View Related
I've been choosing to insert data ni my db using a recordset with methods AddNew and Update. I would like some advices to make my coding opractice better. For example: am I doing it right? Is there a better to do what I'm doing and so on...:
Code:
set rsExample = Server.CreateObject("ADODB.RecordSet")
rsExample.Open "example", MyConn, adOpenStatic, adLockOptimistic, adCmdTable
rsExample.AddNew
rsExample("id")=id
rsExample("firstName") = firstName
rsExample("lastName") = firstName
rsExample("subject") = subject
rsExample("message") = message
rsExample("new") = 1
rsExample("date") = now
View Replies
View Related
is there a way to write a insert statment with out typing out all of my field names? i want to do an insert in every field but i don't want to have to write them all out.
View Replies
View Related
I'm using ASP + MS SQL. I wrote a simple insert into command but nothing is happening... it gave no error and no information is stored in the db. When I response.write my SQL, I got the following:
INSERT INTO [blog_entries](title,user,entry,date) VALUES('test','admin','test','Tuesday, December 25, 2007')
View Replies
View Related
How can i insert a data using a join statement
insert into partmaster.p, execmaster.e(e.execno, e.model, e.battqty, p.partno, p.parttype, p.itemtype, p.stacklength, p.line, p.execno)
values('1234567890', 'GBM', '2', '9876543210', 'AR', 'M', '29V', '2', '1234567890')
i have a few input box for the user to enter. but as u can see that both tables has execno. it's for both tables to connect. that's why i want to check on how i can key in one input box insert into execno in two different tables
View Replies
View Related
SQL_query = "insert into Activity_Status(UserID, TotalTime, Score, Activity_Name, Status) Values('" + Request.Form("username") +"'," + Request.Form("time") + "," + Request.Form("QuizScore") + ",'"+ Request.Form("QuizType") + "'," + "'" + Request.Form("status") + "')"
How shld I insert a date to this statement?
View Replies
View Related
Iam trying to insert values into my database, but i keep on getting this error, Code:
Subscript out of range: '[number: 1]'
I have tried to check my insert values but i can't pickup anything, can anyone assist me in this regard. Here is the portion of the code:
View Replies
View Related
