Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scot
Starting Member
7 Posts |
 Posted - 2011-03-16 : 08:28:17
|
| I am building a website with SQL Server (2005). On the pages where I am pulling the data from the database record fields the data just stops pulling in. For example, I have a coupon manager where a business owner can login and veiw and edit their coupon. Everything pulls in on the coupon except for 3 fields (phone2,phone3,phone4). When it first started It wouldn't display any of the addresses then I kept moving things around (I would put 1 of the address fields where the company name is and just to see if it would pullin there) then it started showing the address and not the phone fields. The data is there in the database but doesn't showup on the page. The DB fields are setup identical to the others. This same code is used on the coupon print page and everything shows up there. I am also having the same issue with another page pulling data from a different DB table. I also had this same issue on another site (that never got resolved). Is there anything that would cause SQL Server data to just stop pulling some of the fields in a record?It displays the the 4 location_desc fields after the phone #s. The code to the page that stops showing the phone numbers is here http://membersonlybenefits.com/code.txtAny help or advice is greatly appreciated.Thanks!scot |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-03-16 : 08:46:28
|
(phone2,phone3,phone4) are not in your DIM-command!
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
scot
Starting Member
7 Posts |
Posted - 2011-03-16 : 22:20:36
|
| webfred, I appreciate the reply. I added those to the Dim command and still nothing.scot |
|
|
|
|
|
|
Data from SQL Server not showing on the webpage