Reading CSV Into Recordset Using GetString
I'm experiencing a little difficulty and having to resort to a work around.
I already found one bug, although stated the bug was only in ODBC, which I'm
not using. It appears to be in the OLEDB driver also. Code:
View Replies
ADVERTISEMENT
I have two(2) issues.
I'm experiencing a little difficulty and having to resort to a work around.
I already found one bug, although stated the bug was only in ODBC, which I'm
not using. It appears to be in the OLEDB driver also.
My connection was:
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath & ";" &
"Extended Properties='Text;HDR=NO;FMT=Delimited'"
I got information from here:
http://msdn.microsoft.com/library/d...ing03092004.asp
I am using a schema.ini file and in it was:Code:
View Replies
View Related
I can successfully get one field of information at a time and randomize it, but I need the whole string. I've been searching the internet trying to find an answer to this question and I found these two commands Request.querystring and Recordset.GetString, but I
don't think I know how to use them properly. Code:
View Replies
View Related
i have a date eg. 9/1/04, 28/9/04 (format,d,m,y). how to i get the int for d, m & y? i try use
Response.write Right(String1,2) just only got the y.
Anybody could help me to get only the d & m because of the date or month not always in 2 number format(01 for 1)
View Replies
View Related
I learned from 4guysfromrolla.com to use the GetString method to speed up displaying database query in an HTML table. After converting a sample page to using GetString, the biggest improvement was the HTML source code. Before it was spread into 4 pages; now it is only on one page. I think it works beautifully.However, I think GetString can only be used for simple generic tables. I have a customized table, and I would really like to use GetString to produce a long string instead of creating 500 tables. You can see the page here: http://pjshimmer.homeunix.com/ Those who have experience using GetString, can you tell me if my table is feasible to use this function? The reason I ask is I use different font for diff cells, and I also produce various cell background based on some information.
View Replies
View Related
When using ActiveX Combo Boxes, can you use the GetString method to populate the control? I currently am using AddItem, however, it is taking a long time to process. I know that GetString works well to improve the performance. Here is my code while using AddItem:
while not rsClient.EOF
Response.Write chr(9) & "MenuForm.lstClient.additem " & chr(34) & replace(rsClient.Fields("Client Name").value,chr(34),"'") & " [" & trim(rsClient.Fields("Client Number").Value) & "]" & chr(34) & chr(13)
rsClient.MoveNext
View Replies
View Related
I know that getstring or getrows increase performance but my question when to use this method. This is because what I know is this method will output all fields in a table and not just certain few.
View Replies
View Related
I need to be able to use an asp administration page. However I am getting errors when I add apostrophes (') or parenthesis is also returning errors. I have been shown a long time ago a small few lines of code that can by pass this problem, anybody know the code?
View Replies
View Related
I'm connecting to an Access table with 100+ rows of data of approx 20 columns wide. I'm using getstring to "Quickly" display it in a table, but it's un-useably slow.
View Replies
View Related
i get data using getstring function. can i process this data using java script?
set rsShow = conn.Execute("SELECT league_E FROM Market M WHERE id=1113 ")
if not rsShow.eof then
aa=rsShow.getstring()
end if
rsShow.close
set rsShow=nothing
View Replies
View Related
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
View Replies
View Related
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
View Replies
View Related
Could somebody please help me out with this? I have been researching it all day and can't figure it out.
All I want to do is put some info from this XML file (staff.xml):
<staff>
<employee id="1">
<name>John</name>
<job>Janitor</job>
</employee>
<employee id="2">
<name>Mary</name>
<job>Accountant</job>
</employee>
</staff>
into an ASP page. I already started an ASP page:
<html>
<head></head>
<body>
<%
Set objXMLDoc = CreateObject("Microsoft.XMLDOM")
objXMLDoc.async = False
objXMLDoc.load("staff.xml")
response.write("<p>")
'I NEED TO INSERT THE FIRST PERSON'S NAME HERE
response.write("<br>")
'I NEED TO INSERT THE FIRST PERSON'S JOB HERE
response.write("</p>")
response.write("<p>")
'I NEED TO INSERT THE SECOND PERSON'S NAME HERE
response.write("<br>")
'I NEED TO INSERT THE SECOND PERSON'S JOB HERE
response.write("</p>")
%>
</body>
</html>
That's all I have in the ASP page because I am having trouble with it. Could somebody please help with it real quick? I'm sure it's very simple, but I am having trouble learning the XMLDOM thingy.
View Replies
View Related
anyone know a simple to use RSS/XML feed getter so i can add external news
to my site?
View Replies
View Related
I got a little piece of ASP code to read from a remote url, which is expected to be an xml, like a RSS feed, and echo the content out to be processed by downstream xml processor. The code is like this:
<%response.ContentType="text/xml"%><%
Response.Buffer = false
Dim objXMLHTTP, xml, url, text
Set xml = Server.CreateObject ("Microsoft.XMLHTTP")
url = Request.QueryString("url")
xml.Open "GET", url, false
xml.Send
text = xml.ResponseText
Response.write(text)
Set xml = Nothing
%>
Using firefox, I get the request.responseXML object back from the code above, works fine. But in IE, the request.responseXML is returned null, but request.responseText did show the entire xml file.
My question is how should I make change to the above code to let IE honor the request.responseXML object? I gues the xml is somewhat ill formatted and IE can not recognize it as an xml.
View Replies
View Related
I have an ASP classic site that needs to add the option of reading an XML file send back from another web site and parsing it into a multi-column HTML table. The server is Windows Server 2003. Can anyone direct me to where I might find more info on this?
View Replies
View Related
I have just created a cd based demo web with FP2000 under XP pro. The disc plays back fine on the XP machine, but when tried on a WIN 98 machine it doesnt play, and I get " G: is not accessible Device not ready" when I try to read it in Win Explorer. The disc is a 48x speed 700mb CD-R. Is it too fast for the older machine?
View Replies
View Related
am trying to create a login page for the first time, I have a login page, validate login page and if the password is correct it takes me to the first page.
I have customized this code someone else created,but what I have a problem with now is I need to log who submitted that data and that is why I am trying to read UserName cookie so I can later match that data.
This is the error I get which is telling me that it is reading the cookie since this is the UserName I am logging in with
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'boxhill'.
but I can't see what is wrong, and there is not much out there for this kind of error.
So I can login successfully but now i need to read and dispaly that cookie and then insert the value of the cookie but,but don't worry about that now, just trying to give you the full picture.
So this is the code for reading the cookie ...
View Replies
View Related
i was wondering if any one could give me some info on how to get mp3 ID3 tags in ASP?
I've seen it done, but don't really have any idea how,
just looking for info like song lenth, bitrate, and so on.
View Replies
View Related
I have a function in ASP and I want to read a DIV tag. Any ideas? I know
the syntax but when I apply it, doesn't work.
View Replies
View Related
What is a good method to read a file that is hosted on another server. I really want to echo the code found between a "<PRE>" and "</PRE>" tag found in the source of an externally hosted file. How should I go about this? I am somewhat new to ASP, but am confident there is a way.
View Replies
View Related
I have a routine I'm writing to read the contents of a file and modify it. However the file will not parse properly into an array, so I strongly suspect I'm using the wrong character to parse the file. The line of code that is supposed to parse the file is:
arrLines = Split(sFileContent, vbCRLF)
When I view the array, it appears as one continuous line, but when I open the file in a file editor it's very clear there are 15 lines.
View Replies
View Related
I've got a league standings file that gets uploaded as an xls file. To display the contents, I'm not sure what the most efficient way is:
1.) Import the xls file into a database every time the file is updated
2.) Read the contents of the xls file using OpenDataSource or OpenRow Set
3.) Something I haven't thought of yet!
View Replies
View Related
I've to got a login script, but in the middle of the verification script, I'd like once the vify has been ok'd to look for a sql file, that has insertion data in it, once the file has been found the asp code must read and carry out the sql command (insert the data in the access db), once done the sql file gets deleted. Code:
View Replies
View Related
I have to upload one excel file. In that excel file I need to check the availability of data in particular cells and also the worksheet name. If the data is not available at particular cell, say for eg: $F1, an error should be thrown to user saying that the data is manadatory. How to do that? How to read the particular cell in ASP? If anybody knows the code, please send the same.
View Replies
View Related
How do you read a variable that you've declared on one page
For example
I've declared
dim x
x=23
then i goto the next page. I can't seem to access it.
How do I get access to that variable that has been defined in the previous page.
View Replies
View Related
Im having a bit of trouble with taking a csv file and sperating each row with a "," because we all know that csv's are serpated by cammas, my problem is the rows are getting messy because say I have for the first Collum "Toy, Really fast", it will seperate the collum name because of the , Is there any way I can remove these or whats the best way.
Heres my code right now: Code:
View Replies
View Related
I am developing a web page, in that i have to get user's photo from user and insert it in to database. how to upload this photo from local drive to my server
View Replies
View Related
i dont know that is this right to put the question in this forum or in html forum.
anyways, the question is how can we read/find the value of title tag of html page using asp or any scripting langauge.if any one has idea, please do share
View Replies
View Related
I cannot figure this out for the life of me. All the tutorials I've gone though give code (and from what it looks like, wrong code) with absolutely no explanation?
My ultimate end is to read the xls file into a mysql database.. but I need some method, way or idea of actually doing this. Presently the data is an a .mdb database (so I can save it to different formats) but I cannot use the .mdb itself to upload the info (server disallows reading and writing from .mdb).
I've looked all over and there is no detailed method of doing this (all I really need is just the basic code for connecting to a .xls sheet (excel sheet) and then reading the data from a line and displaying it on the screen (there is no present tutorial that explains that, least that I can find)
View Replies
View Related
I need to read from a weekly email and extract the contents of that email then convert them into HTML. I do not have control over the email that is being sent but do have control over the email account the notice is sent to? So to explain everything I need to take this email and post it onto a site, I can do it manually everytime but am looking for a way to let the script do it?
View Replies
View Related
Is it possible to display a doc file within an ASP page and have it show the header and footer of the page?For example,in ColdFusion you can use cfcontent to display doc files, however any html on the containing page doesn't show.I was hoping that with ASP, it would show the HTML of the page that reads the doc file.
View Replies
View Related
Does anyone have any experience of using barcode reading software with ASP applications?
I have an ASP-based application where Serial No's are entered manually. The users want to move across to a barcoding system so Serial No's can be picked-up automatically.
I have no experience in this area... Are there appropriate tools out there?Can anyone give me a few pointers?
View Replies
View Related