SQL isset且未显示空白“单元格”

25-03-12 5

此处将为大家介绍关于SQLisset且未显示空白“单元格”的详细内容，此外，我们还将为您介绍关于android–保存后未显示的配置文件图像(它只显示空白屏幕)、angularjsselect选择默认显

此处将为大家介绍关于SQL isset且未显示空白“单元格”的详细内容，此外，我们还将为您介绍关于android – 保存后未显示的配置文件图像(它只显示空白屏幕)、angularjs select 选择默认显示空白以及第一行空白的解决方法、arcgis server开发中，地图控件显示空白，不显示地图怎么解决呢？？？、asp.net – 报表查看器控件(Web)显示空白报告的有用信息。

本文目录一览：

SQL isset且未显示空白“单元格”
android – 保存后未显示的配置文件图像(它只显示空白屏幕)
angularjs select 选择默认显示空白以及第一行空白的解决方法
arcgis server开发中，地图控件显示空白，不显示地图怎么解决呢？？？
asp.net – 报表查看器控件(Web)显示空白报告

SQL isset且未显示空白“单元格”

我正在使用我的一个MySQL数据库表作为实际表，其中一天的时间作为每一列，而一列称为day。您猜对了，在一天中表示星期几，而在其他单元格中则说当时发生了什么。

我想做的只是显示其中具有价值的单元格。就我而言，我总是要把所有的行和2列都填满。2列是“天”和“ 19:00”，但是将来我可能会添加“ 18:00”等值。

那么，如何仅选择其中包含数据的列和行呢？某种类型的“哪里：有数据”？

谢谢！

编辑： 图片数据库

android – 保存后未显示的配置文件图像(它只显示空白屏幕)

我正在尝试上传用户个人资料图像并存储在firebase中.我的图像成功存储在firebase存储和用户数据库中.

当我上传它在屏幕上显示的图像时,但是一旦我保存并重新打开设置以查看配置文件图像,它就不显示,它只显示空白的白色屏幕(但重新打开时的名称和手机显示,只有图像不显示节目)

我附加了从db获取值并在ui中显示的代码,并添加了saveUserinformation(),当用户单击保存图像按钮时,该函数将被调用,此函数在db中保存名称,电话和配置文件.我在下面添加了数据库的屏幕截图,还添加了我得到的错误代码段.

我究竟做错了什么？

这是我控制台登录时滑行输出：
profile img here：target for：android.support.v7.widget.AppCompatImageView {528bbb2 V.ED..C .. …… ID 0,0-300,300#7f0a00b9 app：id / profileImage} [CDS] rx超时：0

 mCustomerDatabase.addValueEventListener(object :ValueEventListener{
            override fun onDataChange(dataSnapshot: DataSnapshot) {
                if(dataSnapshot.exists() && dataSnapshot.childrenCount>0){
                    val map:Map<*,*> = dataSnapshot.value as Map<*,*>
                    if(map["name"] !=null){
                        mName=map["name"].toString()
                        mNameField.setText(mName)
                    }
                    if(map["phone"]!=null){
                        mPhone=map["phone"].toString()
                        mPhoneField.setText(mPhone)
                    }
                    if(map["profileImageUrl"]!=null){
                        mProfileImageUrl=map["profileImageUrl"].toString()

                        Glide.with(applicationContext).load(mProfileImageUrl).into(mProfileImage)
                        val a=Glide.with(applicationContext).load(mProfileImageUrl).into(mProfileImage)

                        print("profile img here:$a")

                    }

                }

            }

            override fun onCancelled(p0: DatabaseError) {
                Todo("not implemented") //To change body of created functions use File | Settings | File Templates.
            }
        })

    private fun saveUserinformation(){
        mName=mNameField.text.toString()
        mPhone=mPhoneField.text.toString()
        val userInfo=HashMap<String,Any>()
        userInfo.put("name",mName)
        userInfo.put("phone",mPhone)
        mCustomerDatabase.updateChildren(userInfo)
        if(resultUri!=null){
            val imagePath:StorageReference=mStorage.child("customer_profile_image").child(userId).child(resultUri.lastPathSegment )
            val uploadTask:UploadTask=imagePath.putFile(resultUri)
            uploadTask.addOnSuccessListener(OnSuccessListener <UploadTask.TaskSnapshot>(){taskSnapshot->
                    val downloadUrl: Task<Uri> =taskSnapshot.storage.downloadUrl
                    val newImage= HashMap<String,Any>()
                    newImage["profileImageUrl"] = downloadUrl.toString()
                    mCustomerDatabase.updateChildren(newImage)

            }).addOnFailureListener(OnFailureListener() {
                Toast.makeText(this,"Profile image not uploaded",Toast.LENGTH_SHORT).show()
            })
        }
        finish()
    }

Load Failed for com.google.android.gms.tasks.zzu@c0645c1 with size [300x300]
    class com.bumptech.glide.load.engine.GlideException: Failed to load resource
    There were 3 causes:
    java.io.FileNotFoundException(/com.google.android.gms.tasks.zzu@c0645c1: open Failed: ENOENT (No such file or directory))
    java.io.FileNotFoundException(No such file or directory)
    java.io.FileNotFoundException(No such file or directory)
     call GlideException#logRootCauses(String) for more detail
      Cause (1 of 3): class com.bumptech.glide.load.engine.GlideException: Fetching data Failed, class java.io.InputStream, LOCAL
    There was 1 cause:
    java.io.FileNotFoundException(/com.google.android.gms.tasks.zzu@c0645c1: open Failed: ENOENT (No such file or directory))
     call GlideException#logRootCauses(String) for more detail
        Cause (1 of 1): class com.bumptech.glide.load.engine.GlideException: Fetch Failed
    There was 1 cause:
    java.io.FileNotFoundException(/com.google.android.gms.tasks.zzu@c0645c1: open Failed: ENOENT (No such file or directory))
     call GlideException#logRootCauses(String) for more detail
          Cause (1 of 1): class java.io.FileNotFoundException: /com.google.android.gms.tasks.zzu@c0645c1: open Failed: ENOENT (No such file or directory)
      Cause (2 of 3): class com.bumptech.glide.load.engine.GlideException: Fetching data Failed, class android.os.ParcelFileDescriptor, LOCAL
    There was 1 cause:
    java.io.FileNotFoundException(No such file or directory)
     call GlideException#logRootCauses(String) for more detail
        Cause (1 of 1): class com.bumptech.glide.load.engine.GlideException: Fetch Failed
    There was 1 cause:
    java.io.FileNotFoundException(No such file or directory)
     call GlideException#logRootCauses(String) for more detail
          Cause (1 of 1): class java.io.FileNotFoundException: No such file or directory
      Cause (3 of 3): class com.bumptech.glide.load.engine.GlideException: Fetching data Failed, class android.content.res.AssetFileDescriptor, LOCAL
    There was 1 cause:
    java.io.FileNotFoundException(No such file or directory)
     call GlideException#logRootCauses(String) for more detail
        Cause (1 of 1): class java.io.FileNotFoundException: No such file or directory
02-04 15:21:14.109 25281-25281/com.Sarah.taxi I/Glide: Root cause (1 of 3)
    java.io.FileNotFoundException: /com.google.android.gms.tasks.zzu@c0645c1: open Failed: ENOENT (No such file or directory)
        at libcore.io.IoBridge.open(IoBridge.java:487)
        at java.io.FileInputStream.<init>(FileInputStream.java:76)
        at java.io.FileInputStream.<init>(FileInputStream.java:103)
        at android.content.ContentResolver.openInputStream(ContentResolver.java:689)
        at com.bumptech.glide.load.data.StreamLocalUriFetcher.loadResourceFromUri(StreamLocalUriFetcher.java:85)
        at com.bumptech.glide.load.data.StreamLocalUriFetcher.loadResource(StreamLocalUriFetcher.java:60)
        at com.bumptech.glide.load.data.StreamLocalUriFetcher.loadResource(StreamLocalUriFetcher.java:15)
        at com.bumptech.glide.load.data.LocalUriFetcher.loadData(LocalUriFetcher.java:44)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.loadData(MultiModelLoader.java:99)
        at com.bumptech.glide.load.engine.sourceGenerator.startNext(SourceGenerator.java:62)
        at com.bumptech.glide.load.engine.DecodeJob.runGenerators(DecodeJob.java:302)
        at com.bumptech.glide.load.engine.DecodeJob.runWrapped(DecodeJob.java:272)
        at com.bumptech.glide.load.engine.DecodeJob.run(DecodeJob.java:233)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
        at java.lang.Thread.run(Thread.java:818)
        at com.bumptech.glide.load.engine.executor.GlideExecutor$DefaultThreadFactory$1.run(GlideExecutor.java:446)
     Caused by: android.system.ErrnoException: open Failed: ENOENT (No such file or directory)
        at libcore.io.Posix.open(Native Method)
        at libcore.io.BlockGuardOs.open(BlockGuardOs.java:186)
        at libcore.io.IoBridge.open(IoBridge.java:473)
        at java.io.FileInputStream.<init>(FileInputStream.java:76) 
        at java.io.FileInputStream.<init>(FileInputStream.java:103) 
        at android.content.ContentResolver.openInputStream(ContentResolver.java:689) 
        at com.bumptech.glide.load.data.StreamLocalUriFetcher.loadResourceFromUri(StreamLocalUriFetcher.java:85) 
        at com.bumptech.glide.load.data.StreamLocalUriFetcher.loadResource(StreamLocalUriFetcher.java:60) 
        at com.bumptech.glide.load.data.StreamLocalUriFetcher.loadResource(StreamLocalUriFetcher.java:15) 
        at com.bumptech.glide.load.data.LocalUriFetcher.loadData(LocalUriFetcher.java:44) 
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.loadData(MultiModelLoader.java:99) 
        at com.bumptech.glide.load.engine.sourceGenerator.startNext(SourceGenerator.java:62) 
        at com.bumptech.glide.load.engine.DecodeJob.runGenerators(DecodeJob.java:302) 
        at com.bumptech.glide.load.engine.DecodeJob.runWrapped(DecodeJob.java:272) 
        at com.bumptech.glide.load.engine.DecodeJob.run(DecodeJob.java:233) 
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113) 
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588) 
        at java.lang.Thread.run(Thread.java:818) 
        at com.bumptech.glide.load.engine.executor.GlideExecutor$DefaultThreadFactory$1.run(GlideExecutor.java:446) 
02-04 15:21:14.110 25281-25281/com.Sarah.taxi I/Glide: Root cause (2 of 3)
    java.io.FileNotFoundException: No such file or directory
        at android.os.Parcel.openFileDescriptor(Native Method)
        at android.os.ParcelFileDescriptor.openInternal(ParcelFileDescriptor.java:270)
        at android.os.ParcelFileDescriptor.open(ParcelFileDescriptor.java:200)
        at android.content.ContentResolver.openAssetFileDescriptor(ContentResolver.java:966)
        at android.content.ContentResolver.openAssetFileDescriptor(ContentResolver.java:894)
        at com.bumptech.glide.load.data.FileDescriptorLocalUriFetcher.loadResource(FileDescriptorLocalUriFetcher.java:22)
        at com.bumptech.glide.load.data.FileDescriptorLocalUriFetcher.loadResource(FileDescriptorLocalUriFetcher.java:14)
        at com.bumptech.glide.load.data.LocalUriFetcher.loadData(LocalUriFetcher.java:44)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.loadData(MultiModelLoader.java:99)
        at com.bumptech.glide.load.engine.sourceGenerator.startNext(SourceGenerator.java:62)
        at com.bumptech.glide.load.engine.DecodeJob.runGenerators(DecodeJob.java:302)
        at com.bumptech.glide.load.engine.DecodeJob.onDataFetcherFailed(DecodeJob.java:397)
        at com.bumptech.glide.load.engine.sourceGenerator.onLoadFailed(SourceGenerator.java:119)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.startNextOrFail(MultiModelLoader.java:153)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.onLoadFailed(MultiModelLoader.java:144)
        at com.bumptech.glide.load.data.LocalUriFetcher.loadData(LocalUriFetcher.java:49)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.loadData(MultiModelLoader.java:99)
        at com.bumptech.glide.load.engine.sourceGenerator.startNext(SourceGenerator.java:62)
        at com.bumptech.glide.load.engine.DecodeJob.runGenerators(DecodeJob.java:302)
        at com.bumptech.glide.load.engine.DecodeJob.runWrapped(DecodeJob.java:272)
        at com.bumptech.glide.load.engine.DecodeJob.run(DecodeJob.java:233)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
        at java.lang.Thread.run(Thread.java:818)
        at com.bumptech.glide.load.engine.executor.GlideExecutor$DefaultThreadFactory$1.run(GlideExecutor.java:446)
    Root cause (3 of 3)
    java.io.FileNotFoundException: No such file or directory
        at android.os.Parcel.openFileDescriptor(Native Method)
        at android.os.ParcelFileDescriptor.openInternal(ParcelFileDescriptor.java:270)
        at android.os.ParcelFileDescriptor.open(ParcelFileDescriptor.java:200)
        at android.content.ContentResolver.openAssetFileDescriptor(ContentResolver.java:966)
        at android.content.ContentResolver.openAssetFileDescriptor(ContentResolver.java:894)
        at com.bumptech.glide.load.data.AssetFileDescriptorLocalUriFetcher.loadResource(AssetFileDescriptorLocalUriFetcher.java:22)
        at com.bumptech.glide.load.data.AssetFileDescriptorLocalUriFetcher.loadResource(AssetFileDescriptorLocalUriFetcher.java:13)
        at com.bumptech.glide.load.data.LocalUriFetcher.loadData(LocalUriFetcher.java:44)
        at com.bumptech.glide.load.engine.sourceGenerator.startNext(SourceGenerator.java:62)
        at com.bumptech.glide.load.engine.DecodeJob.runGenerators(DecodeJob.java:302)
        at com.bumptech.glide.load.engine.DecodeJob.onDataFetcherFailed(DecodeJob.java:397)
        at com.bumptech.glide.load.engine.sourceGenerator.onLoadFailed(SourceGenerator.java:119)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.startNextOrFail(MultiModelLoader.java:153)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.onLoadFailed(MultiModelLoader.java:144)
        at com.bumptech.glide.load.data.LocalUriFetcher.loadData(LocalUriFetcher.java:49)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.loadData(MultiModelLoader.java:99)
        at com.bumptech.glide.load.engine.sourceGenerator.startNext(SourceGenerator.java:62)
        at com.bumptech.glide.load.engine.DecodeJob.runGenerators(DecodeJob.java:302)
        at com.bumptech.glide.load.engine.DecodeJob.onDataFetcherFailed(DecodeJob.java:397)
        at com.bumptech.glide.load.engine.sourceGenerator.onLoadFailed(SourceGenerator.java:119)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.startNextOrFail(MultiModelLoader.java:153)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.onLoadFailed(MultiModelLoader.java:144)
        at com.bumptech.glide.load.data.LocalUriFetcher.loadData(LocalUriFetcher.java:49)
        at com.bumptech.glide.load.model.MultiModelLoader$MultiFetcher.loadData(MultiModelLoader.java:99)
        at com.bumptech.glide.load.engine.sourceGenerator.startNext(SourceGenerator.java:62)
        at com.bumptech.glide.load.engine.DecodeJob.runGenerators(DecodeJob.java:302)
        at com.bumptech.glide.load.engine.DecodeJob.runWrapped(DecodeJob.java:272)
        at com.bumptech.glide.load.engine.DecodeJob.run(DecodeJob.java:233)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
        at java.lang.Thread.run(Thread.java:818)
        at com.bumptech.glide.load.engine.executor.GlideExecutor$DefaultThreadFactory$1.run(GlideExecutor.java:446)

enter image description here

解决方法:

您收到以下错误：

Load Failed for com.google.android.gms.tasks.zzu@c0645c1

因为您正在尝试显示不存在的图像.正如我在您的数据库中看到的那样,profileImageUrl属性包含一个无效的图像URL.

enter image description here

看到红线？它实际上持有的是来自内存的对象的地址而不是图像URL.这是因为您在downloadUrl对象上调用toString()方法.所以你获取donwload url的方式是不正确的. This是获取网址的正确方法.一旦获得图像的URL并将其添加到数据库中,一切都将按预期工作.

angularjs select 选择默认显示空白以及第一行空白的解决方法

最近需要加个select功能，以前是直接暴力写个<option value="" disabled>--请选择--</option> 这样就可以默认显示这个选项了，但是这样做的效果还是不够好。就像我现在需求，默认显示就是要指定其中一个选项而不是这个多余的选项，下面是解决的代码。

<select ng-model="countrys" ng-init="countrys=countries[0]" ng-options="country.name for country in countries"></select>

主要的问题就是ng-init这个的内容。默认初始化选中的那个为遍历的数组下标为0的那个。而默认显示的内容则是country.name这个值。我在ng-model的值跟ng-init里的值都是countrys，这样就不会说搞错对象了。

解决这个问题的来源于：http://codepen.io/cggaurav/pen/uikLg

arcgis server开发中，地图控件显示空白，不显示地图怎么解决呢？？？

arcgis server 10.1和visual studio 2010中，新建了个Web Mapping Application，地图控件显示空白，怎么解决呢？？？

asp.net – 报表查看器控件(Web)显示空白报告

我有一个包含ReportViewer控件的Web表单，一个DIV元素，所以我可以看到该页面实际呈现。我看到我的页面正确加载，我看到在fiddler中访问的报表服务，但是从来没有任何显示。

目前，我正在使用一个静态文本的报告，没有查询，以确保我隔离问题。

我的页面如下：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ReportViewer.aspx.cs" Inherits="PeopleNet.Web.Views.Reports.ReportViewer" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms,Version=11.0.0.0,Culture=neutral,PublicKeyToken=89845dcd8080cc91"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server">
            <Scripts>
                <asp:ScriptReference Path="~/scripts/jquery-1.7.2.js" />
                <asp:ScriptReference Path="~/scripts/fixReportViewer.js" />
            </Scripts>
        </asp:ScriptManager>

        <div>
            This is the report viewer page...
        </div>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server"></rsweb:ReportViewer>
    </form>
</body>
</html>

显示报告的代码是：

protected void Page_Load(object sender,EventArgs e)
{
    this.ReportViewer1.ServerReport.reportserverUrl = ConfigurationFacade.reportserverUri;
    this.ReportViewer1.ServerReport.ReportPath = { path to report name };
    this.ReportViewer1.ServerReport.reportserverCredentials = new reportserverCredentials(); // custom class implementing IreportserverCredentials as described in varIoUs places around the web,including SO
    this.ReportViewer1.ServerReport.Refresh();
}

我的web.config文件根据需要配置HttpHandler：

<system.web>
    <!-- abbreviated... -->
    <httpHandlers>
        <add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler,Microsoft.ReportViewer.WebForms,PublicKeyToken=89845dcd8080cc91" validate="false" />
    </httpHandlers>
</system.web>

和：

<system.webServer>
    <!-- abbreviated... -->
    <handlers>
        <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler,PublicKeyToken=89845dcd8080cc91" />
    </handlers>
</system.webServer>

服务器运行Windows 2008和sql Server 2008 R2。

我正在使用sql Server 2012版本的查看器，因为我们正在将我们的环境更新到2012。

我已经反复验证报告可以从ReportManager访问，没有任何问题。

我试图在IE9中访问这个，看到与其他浏览器一起说明的各种问题。

我目前(仅用于测试)传递我的凭据作为报表服务器凭据。我是Reporting Services管理员，也是服务器上的服务器管理员组成员。

我已经检查了事件日志和reportserverService日志，并没有发现任何错误。

更新：看起来像将AsyncRendering更改为false，并确保我不尝试使用空集合“SetParameters”，这主要被清除：

this.ReportViewer1.AsyncRendering = false;

我在配置/代码中缺少什么？

解决方法

我解决这个问题的方法是将报表查看器的高度设置为100％。没有报告显示。将高度更改为px值(即900像素)可使报表查看器工作。

今天的关于SQL isset且未显示空白“单元格”的分享已经结束，谢谢您的关注，如果想了解更多关于android – 保存后未显示的配置文件图像(它只显示空白屏幕)、angularjs select 选择默认显示空白以及第一行空白的解决方法、arcgis server开发中，地图控件显示空白，不显示地图怎么解决呢？？？、asp.net – 报表查看器控件(Web)显示空白报告的相关知识，请在本站进行查询。

本文标签：