|
Hi. I am an excellent VB programmer but a poor web programmer. I am trying to get some data off a grid on a web page into a vb app and I am having a terrible time doing it. The site also requires an id and password. The site is http://ctmls.mlxchange.com/ and I'm using VB 6 on Vista.
I don't care what form I get the data in but its not in the source when I view it or save the page. It looks like it is coming from javascript.
I think it changes pages in frames because the address never changes, but the display does. That's why I don't think I can use winsock. Inet doesn't work. I can browse to the page fine with the webBrowser control and see the data.
Here's how I get the data on the screen:
1. Type in URL; go to site
2. Login to site, frame changes
3. Click "Search" from menu, frame changes
4. Type in some criteria, click results
5. Frame loads with a grid with data on I need to get into VB
Here is what the screen looks like after the data is retrieved (with sensitive data blocked out). http://www.marvelousware.com/images/Form.jpg
The Userid is not mine, I am using it to write this program for the owner.
What property(s) or method(s) will return data? I searched innerHTML, outerHTML, innerText and outerText of efvery element in IE.Document.getElementsByTagName("HTML") where IE is reference to internet explorer and didn't find anything.
What is a proxy? Can a proxy pass the data through? Can it be done in VB? Can I get the data this way?
How do I get the HTML for a page when it isn't available in view source, doesn't appear when the page is saved and is served up in an inline frame that doesn't work in its own window?
Otherwise I will have to write OCR code to pull the data off the screen. That doesn't seem like the smartest way, or easiest way.
Any help is appreciated, I'll buy a book if anyone knows one that WILL solve this problem.
Or read an entire lengthy tutorial if directed to. Whatever works. This is the second category in the second forum I've asked and no one seems to know how to do it. Can it be impossible?
Thank you.
|
|
|
|
|
Dear Experts,
I made crystal report which is displaying one main report and then more than ten sub reports.When i login particular user report displaying as proper.
When i login another user, report showing following error. Sp and tables and databases are all same. Sp also returns some data.when i manually run the crystal report in outside of the .net solution problem doesnt occured.
I had verified database also.
Failed to open a rowset.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: CrystalDecisions.CrystalReports.Engine.InternalException: Failed to open a rowset.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
How to resolve this issue. Any body known please help me.
Thanx & Regards
Mani
|
|
|
|
|
1. Is your application running on an intranet with active directory?
2. Is the username passed as a part of the query for the crystal report?
The error you are getting usually appears when the SQL command is not executed and generates an error.
So I suggest to get the parameters values from you .net application and executes your query in the query analyzer window then fix the SQL error.
If this does not solve your problem provide me with more information and I will do my best to help you.
Mohammad Al Hoss
Development To Me Is A Pleasure more than a Job
|
|
|
|
|
I want to develop a company visitors software. the software will have the following columns:
Visitors name
Purpose of visiting
Who you are visiting
time in
time out
I am having a problem in how the interface should be. I am new in programming please can you descibe for me how the interface should be. especially the time out column. the managment should be able to see those who visited.
Thank you
|
|
|
|
|
hi..please be specific what you want..
your web application have only one page??
And you want help regarding GUI for this..Am i right?
|
|
|
|
|
Hi.My web application will have one page.
and i want help regarding GUI. can you help me with how many controls i can have.
Thank you
|
|
|
|
|
You keep asking the same questions, but you seem to be making no effort to actually write your application.
sturabumukiza wrote: can you help me with how many controls i can have.
You can have as many controls as you need - it's up to you to design the interface, and the code behind it which does the work. This is a very simple application, and doesn't need much of an interface, or program to run it.
Since this seems to be a course-related project, I have to wonder how you've managed to do any of the course work up to now...
Why not make a start, try to write it, and if you run into problems then come and ask for specific help with those problems - not "how can I design an interface?".
There are three kinds of people in the world - those who can count and those who can't...
|
|
|
|
|
stop posting the same question. read the previous responses (especially the one from the forum admin) and adhere to them. or give SPECIFIC questions. unless you want to pay us to do your work for you?
I suggest you go to w3schools.com if you want to learn web design.
|
|
|
|
|
Looks to me like you require 3 TextBox controls and 2 Labels. Unless I misunderstood your question.
|
|
|
|
|
|
|
I'm looking at trying to write something similar to the Google Calendar, but can't quite figure out what language(s) to use. I've dome mostly desktop applications in C#, VB, and Python. What would I use for an online webapp? I'd like to give the user a nice GUI, click-to-edit, drag-and-drop, etc. I've looked at ASP.NET, but haven't seen anything that indicates I can make a nice GUI in in. any other suggestions?
The Code Demon Rises.
|
|
|
|
|
web apps are generally styled using html and css - it looks as good as you can imagine it. use asp & c#/vb or python for the dynamic bits. you will also probably want to use a database such as mssql or mysql (free).
Alternatively you could use html,css,php,mysql,javascript(esp. jQuery for animation and drag n drop).
|
|
|
|
|
Okay, first, thanks for the pointers. After more research, here's what I'm thinking. First, can javascript and/or jQuery establish a secure connection to a server side MySQL database? Let me know if this will work:
Server running:
Apache
MySQL
possibly a java backend to handle DB interactions, making client load easier
Client Side/viewable site written using:
HTML
CSS
javascript and/or jQuery, connected to either MySQL directly, or backend java
I just want to know if this path will work, before I dive in and get myself lost.
The Code Demon Rises.
|
|
|
|
|
thecodedemon wrote:
First, can javascript and/or jQuery establish a secure connection to a server side MySQL database?
no. use php or asp (server side code).
thecodedemon wrote:
Client Side/viewable site written using:
HTML
CSS
javascript and/or jQuery, connected to either MySQL directly, or backend java
sounds good to me
|
|
|
|
|
|
I would love to be able to use Python, but I cannot find any explanations or examples of how to get a python script to run in a web browser. The actual data manipulation should be easy, but writing the interface is where I'm stuck. Everything I find on either ASP.NET or Python is on how to communicate with the server, or create a static page based on dynamic information. I want a dynamic page. Any tutorials or books on this subject using ASP or Python would be appreciated.
The Code Demon Rises.
|
|
|
|
|
I would suggest looking at a UI toolkit such as http://www.extjs.com[^] or http://developer.yahoo.com/yui/[^]
They use a combination of HTML/CSS/Javascript inside the browser.
Then their controls talk to the web server via a communication object written in javascript which can use Http GET, Http POST, or SOAP web services (behind the scenes its using jQuery Ajax[^] to talk to the server).
Google uses python on the backend. It's still using HTML/CSS/Javascript within the client.
As for the server side code that talks to mysql you can use pretty much whatever. I would suggest PHP or Rails for the server side goop unless you already have experience in asp.net.
Todd Smith
|
|
|
|
|
Latest post to top
Hi, I'm working on a forum script which does what it's supposed to do, except for one thing. That is, listing the latest reply or new thread at the top of the topic list correctly.
I had help on the code below from a forum which is now closed. The code works, but - this happens:
If this month is say May, then the latest post goes to the top of the list (only because May is at the top).
If someone posts a reply to a thread made in say April or March, then the reply only goes to the top of the section in the list where that particular month is displayed. Which is not what I want it to do.
Does that make sense?
What is needed to make any posting go to the top of the whole list, regardless of the month the original thread began?
I do not know how to do that (I'm not all that good a programmer).
sub printMonthLines {
my($filename) = @_;
$filename =~ s/[\^<>'\$!#;\*\?\&\|\`\/\~\\\(\)\{\}\"\n\r]//go;
$filename =~ s/\.\.//go;
# open file
$thefilenm = "$cgidir/$forumdata/$filename.txt";
if (open(DATA,"$thefilenm")) {
my %records;
while (<DATA>) {
chomp;
my @data = split(/_/);
my $date = join '', (split(/[\/:-]/, $data[5]))[2,1,0,3,4,5];
push @{$records{$date}},$_;
}
close(DATA);
foreach my $key (sort {$b cmp $a} keys %records) {
@sorted = "@{$records{$key}}";
# split new array
foreach $line (@sorted ) {
if ($line ne '') {
@info = split (/_/, $line);
$num = $info[0];
$subject = $info[1];
$name = $info[2];
$date = $info[3];
$responses = $info[4];
$replytime = $info[5];
$replyname = $info[6];
# print it all out
print qq ~
<TR valign="top"><td>
<A HREF="$ENV{'SCRIPT_NAME'}?msg=$num" onFocus="if(this.blur)this.blur()">$subject</A>
<div class="small">Posted on: $date</div></td>
<td>$name</td>
<td>$responses</td>
<td align="right">$replytime<br>by $replyname <A HREF="$ENV{'SCRIPT_NAME'}?msg=$num#$responses" onFocus="if(this.blur)this.blur()">$viewpost</a></td></TR>
~;
}}}}}
I hope someone can help please,
Thanks
|
|
|
|
|
look up "reverse sorting vb" - i presume you are using vb.
|
|
|
|
|
|
well then "reverse array perl"
i'd try inserting the following after "@sorted = "@{$records{$key}}";":
reverse(@sorted);
|
|
|
|
|
I tried that but it didn't change anything. Also tried adding an epoch date field at the end and sorting it by that (think I did it right) and that didn't work either. This is so far beyond me it's scary :-/
It's a pity as everything else works a treat on the forum scripts (so far - I'm redoing them). I had thought this would be an easy thing to do (famous last words).
|
|
|
|
|
or:
@sorted = reverse(@sorted);
????
if that doesn't work i suggest passing it to a web designer.
|
|
|
|
|
Okay. We'll just consider the thread closed now.
|
|
|
|