Converting XML Into MySQL Data
Is there a way to import XML data into mySQL on a daily basis using some sort of automatted process?
View RepliesIs there a way to import XML data into mySQL on a daily basis using some sort of automatted process?
View RepliesI need to know how can i insert the data that is saved in an excel file into my SQL Server database.. I've seen some websites.. but i dun quite understand them. I would be great of you can explain to me the steps in doing tat etc...
View Replies View RelatedI'm using ASP, VBScript, ADO for SQL server 2000. I have a stored procedure that I'm trying to use to insert a row using parameters. One of the field is date. Here is the parameter for that. Code:
Set param = cmd.CreateParameter("theDate", adDBTimeStamp, adParamInput, Date())
cmd.Parameters.Append param
But I'm getting this error. Error converting data type varchar to datetime.
This is the code for my Procedure:
Code: .....
When I execute this code, I receive this error on line 314:
[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to int.
Line 314 is the classComm.Execute line. All the datatypes in my stored procedure those specified in the parameter declararations, and they all match with the datatypes in the DB. Other than the strings that are integer (strClassID) or date (strOccurDate), everything is a varchar.
I have no idea why this error is occurring. I have a similar stored procedure that adds the records in the same way and it kicks out the same error at the same time.
there is an old asp application that is moved from one machine to the other.On the one machine its working fine, but on the new one, when trying to insert from the asp page(variables from the asp page), i get this error, Error converting data type varchar to datetime.
I have tried almost everything, from checking the order of variables, but still get the error. When the proc is executed on SQL it runs fine, am i maybe missing something?
I have migrated ASP pages and SQL SERVER database from a development server to the Live SERVER the regional settings are fine both set to use UK date dd/mm/yyyy. But I have that stupid error when I try to run a stored procedure EXEC sp_add_user 1,'28/08/2004 10:00:00'.... on the live server and not on the development one. I dont want to redevelop all my stored procedures.
View Replies View RelatedI have a 3 page set that searches a database for users, displays the user information in a form and updates the data in the database. The first 2 pages work fine, the third page doesn't. What is annoying is that these pages are a copy of another set of pages that edit news articles (basically the same thing) and they work perfectly.
This is ASP with SQL and VB Script.
Quote: Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '6, 6' to a column of data type int.
/d1intranet/useredited.asp, line 72
So this message is saying that it is unable to UPDATE the field 'UserName' (which has data type INT) with the variable in the SQL code which is default as VARCHAR. Here is line 72: Code:
How do I take all the data in a database in range from 01-01-01 00:00:00 to 01-02-01 00:00:00 i have a column with dates+time in it, and i only need to take some data from a specific timerange Is it something like this:
Select * FROM table where Date = "01-01-01 00:00:00 " to "01-02-01 00:00:00"
In has to be in ASP.
I use ASP to create reports by interacting with a mySQL database..
View Replies View RelatedI'm writing ASP/mysql apps, and I'm almost clueless about mysql. Can someone tell me how to insert data into fields using ASP? Code:
View Replies View RelatedCurrently i working on a project using ASP.net and mysql. these are the classes i imported:
<%import Namespace="System.Data" %>
<%import Namespace="MySql.Data.MySqlClient"%>
Sub Page_Load(sender As Object, e As EventArgs)
Dim myConnection As MySqlConnection
Dim myDataAdapter As MySqlDataAdapter
Dim myDataSet As DataSet
Dim strSQL As String
Dim iRecordCount As Integer
myConnection = New MySqlConnection("server=myserver; user id=XXX; password=XXXX; database=XXXX; pooling=false;")
when i try to test it out on my localhost, i got this error compiler page:
(warning BC40056: Namespace or type specified in the Imports 'MySql.Data.MySqlClient' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
or
Dim myConnection is not defined. ....
Has anyone else found a memory leak using ADO streams to access binary data held in a database. I have searched through this forum and have not come across anyone else, so maybe it is just me.
The scenario is as follows:
Windows 2000 SP3
MDAC 2.7 SP1
IIS5
MySQL 3.23
MyODBC 2.50
If I query the database and do a response.binarywrite everything works fine and no memory leak. eg. response.binarywrite myrecordset("blobfield")
If I read the very same BLOB field into a ADOstream I then get a memory leak in DLLHOST.EXE of how big that binary field was. ie If the picture is 140k in size DLLHOST.EXE increases its memory size by 140k.
This keeps on happening until DLLHOST.EXE is something like 250 MBytes in size at which point it stops working. Quick restart of the IIS Web service and I get all my memory back.
The command I am using to get the data into the ADOstream is picturestream.write myrecordset("blobfield")
I have also tried putting the binary data into a variable first before inserting it into the stream:
set x=myrecordset("blobfield")
picturestream.write x
The stream is closed and set to nothing at the end of processing. Everything is cleanly shut down. Through testing I know the memory leak occurs once the data has been written into the stream. The stream is correctly created as type binary.
The stream problem I am encountering does not seem to be limited to ASP, I tried it using Visual Basic to create a COM component to do the same job and still got a memory leak.
So the questions are:
1. Has anyone come across this before or fixed it?
2. Is there another way of getting binary data out of MySQL, something like the opposite of LoadFile?
I have wasted so much time on this problem but cannot find, having searched Microsoft's knowledge base and the rest of the web, any reference to the problem.
I am using two fields on a form to capture time someboby is working. The fields are hours and minutes. How can I when submitting to the db take both fields and convert them to a single field in the db as minutes?
View Replies View RelatedI'm looking for a control to us on our web site that will take our reports
that are generated in PDF and convert them to DOC format all on the server.
We are using win2k3 web servers if that helps.
I have developed an access database with VBA. Right now its on a network drive and is shared by 75 users. Works fine.
Now I would like to have this in the company intranet. Is it advisable to go with ASP? I recently installed IIS in my system. After that I have no idea how to convert my application to ? Is there a website or any walk through how to get my stuff's solved.
My application has 20 input screens, data add, save, update and also sends email based on certain rules. Is it possible to do all these stuffs?
I want to convert CSV file to XLS. Is there anyway this can be done in ASP without renaming the file to XLS.Also can there Macros to Sort data in it while generating XLS?
View Replies View RelatedWe are evaluating a clients request for converting their existing site using cgi and flat text files to ASP 3 and Access.
The site displays: their products that are broken down into sub categories, guest book, and a survey.
I am only "aware" that text files can be imported into Access but have never done it.
I have some PHP scripts that need to be converted to ASP3 so that they can run on a Micrsoft NT server using ADO. My knowledge of ASP is limitied so i was hoping you could answer a few questions..
1. Is ADO part of ASP.net or is this completely different?
2. Is ASP3 the same as ASP.net?
3. Is there any advice you can give me regarding converting from PHP to ASP3?
I've stored a set of months in an access database as numbers but when it display on the front end I need it to display as the name of the month.
How would you convert the numbers in the database to their word equivalent? Or is it possible to arrange the months in their correct order in the database?
I have an existing application in asp. I need to add new functionality can I do using ASP.net ?
View Replies View RelatedDo we have any function in ASP that will convert US time(which is captured in the database) to IST
View Replies View RelatedMy data input page uses a id generator which includes dashes, and the
corresponding column in the db is set up as varchar to handle that.
There is a problem, however, when the value in the varchar column is
compared to the string from the URL, and the following error message
occurs:
"Syntax error converting the varchar value '071-213' to a column of
data type int."
<%strSQL = "SELECT * FROM AMS where MinutesID = " & Request ("id")%>
Would it be possible to CAST the request string to varchar?
I am passing a string into a page and them looking up info to display from a database based on whats passed in. The link is www.domain.com/page.asp?variable='12345678'
Once inside the page the following code is executed Code:
i want to convert asp file to excel sheet through asp application. iam having report.asp file as a view form i need that form to convert in excel sheet can you help me.
View Replies View RelatedI have a project to do that requires that I use mysql as the database. I have only used MS Access. The sql will be simple searches.
Is there a drastic difference, or just different punctuation?
Can I find a copy of mysql on the web? If so, is there any advice on installing?
I am trying to get values from our database which are in a single field, into seperate variables.
I have a field called locations, with multiple values example... "East Sussex, London & Home Counties, Scotland"
I would like to get each of these into seperate variables e.g.
variable 1 = East Sussex
variable 2 = London & Home Counties
variable 3 = Scotland.
I guess it will need some sort of regex to detect number of commas, then a loop or something.
To make things slightly easier, none of the values in the locations field have commas inside them.
While I've used Access's export function in the past to generate ASP from
the tables, I wonder whether there's anything around to do a more
comprehensive automatic conversion. I've noted a few ads for such products,
and I wonder/hope there's some experience around here that might be shared -
with recommendations.
I am using XMLhttp and responsebody to receive info from a webpage
I dont use responsetext since i need the international chars едц
The information I recieve is binary is there any fast way to convert the
binary data to text ?
I used this function but its slow compared to response.binarywrite
and i need the information in a string so I can alter it with my script.
So is there any way to convert Binary to Text just as fast as
response.binarywrite ?
Function BinaryToString(Binary)
Dim I, S
For I = 1 To LenB(Binary)
S = S & Chr(AscB(MidB(Binary, I, 1
Next
BinaryToString =
rtf files cause so many troubles,i.e.,allow the users to download the files, slow loading,incompatible with other browser, and so on. Do you think I should convert them to JPEG files to embeb them into HTML?
Once converting JPEG,it is easier to programming in HTML(i.e.,just add the image tag),load faster,and prevent the user from download the files?
how to convert a date in (tuesday,may 17,2005) to a date in(17/05/2005) format. is it possibleto dowith the helpof formatdatetime() function. if possible how ?
View Replies View RelatedI have a form with multiple text fields, when i submit the form i want it to edit a table in my database using UPDATE. I know i have the syntax correct. The problem I have is 2 fields are Currency and 2 are Date. The request.form command always returns a string and i keep getting the 'Data type mismatch in criteria expression' error. How do i convert the strings to dates, and strings to Currencies.
View Replies View RelatedHow do I convert this into something that I could read into an HTML email? I can string regular text but have NO IDEA how to convert syntax for a checkbox into HTML.
Can anyone give me some direction? My code for my checkbox is below. The msgBody is the string I'm building to send in my email. Code:
Im having serious trouble converting CDONTS to CDO and was wondering if anyone would be able to give me a hand. Here is the CDONTS code:
View Replies View Related