XML Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreXML Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old October 26th, 2003, 03:20 AM
seb835 seb835 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Location: UK, London
Posts: 95 seb835 User rank is Lance Corporal (50 - 100 Reputation Level)seb835 User rank is Lance Corporal (50 - 100 Reputation Level)seb835 User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 9 h 29 m 2 sec
Reputation Power: 5
WML page wont work with SQL??

Hi, im trying to code a ticket booking system for WAP devices using WML and ASP.

However ive come across a seriously wierd problem. When i try to use an SQL SELECT, WHERE statement and then try and read data from that result, it simply wont let me. Let me explain, heres the code:


<% @ language="vbscript" %>
<% Option Explicit %>
<% Response.ContentType = "text/vnd.wap.wml" %>
<!-- #include file="adovbs.inc" -->
<!-- #include file="dataConnect.asp"-->

<?xml version="1.0" encoding="iso-8859-1" ?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
"http://www.wapforum.org/DTD/wml_1.1.xml">

<wml>

<card title="Result">

<%
Dim objRst, objConnect, holdAns, SQL_data, showData

holdAns = "$(three)"

Set objConnect = Server.CreateObject("ADODB.Connection")
objConnect.Open objConn

SQL_data = "SELECT dataOne, dataTwo FROM tblTest WHERE dataTwo='" & holdAns & "'"

SET objRst = objConnect.execute(SQL_data)

showData = objRst("dataOne")
%>

<p align="left">

Hello!

</p>

</card>

</wml>


Notice the RED line of code where im trying to store the results of the SQL from that single table column called dataOne. The WAP browser simply wont accept this line of red code (above), because if i comment-it-out then the page will load fine.

Can anyone tell me if im doing something wrong here?

Many thanks!
Seb

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreXML Programming > WML page wont work with SQL??


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway